Home
Login
Sign Up
Profile Options
Tools
Edit Profile
Manage all aspects of your profile here including demographics, emails, notification settings, etc...
Change Password
Begin the password change process
Email Subscriptions
Manage your opt-in/opt-out email subscriptions
View Profile
View your profile - what other's see
Sign-out
Sign out of this community
1-800-819-1190
Contact support line
Smart Connect
Connect with others and manage various member options
View QR Code
View your profile QR Code - Connect and or share your contact information
Tour Page
Take an interactive tour of this page
Knowledge Base
Visit the knowledge base for more info
Insights
Member reporting and analysis
Terms of Use
Cookies
Privacy Policy
Contact Us
Help
 
 

Site Menu

Welcome to Infor M3 User Community

762 Members
342 Posts
9 Online
750 Discussions
84 Questions
46 Events

Online

Join us in Myrtle Beach!

Latest Blogs

Infor AI: Serving solutions for Food & Beverage businesses
Infor AI, embedded into Infor CloudSuite, is revolutionizing the food & beverage industry—from farm to fork. Smarter demand planning, reduced waste, o...
Wednesday, February 12th, 2025
Blog: Fortude
Author: Fortude
How low-code solutions are accelerating digital transformation
Friday, February 7th, 2025
Blog: Fortude
Author: Fortude
The Power of Collective Action
Friday, February 14th, 2025
Blog: WorkOutLoud
Author: Loring Kaveney
Community Conversations
Thursday, February 20th, 2025
Blog: WorkOutLoud
Author: Loring Kaveney
See All »

Latest Media

Voices From Community with David Rapacz, Infor
Monday, February 17th, 2025
Group: WorkOutLoud
Encore- Free up IT Resources and Empower Business Users
Monday, February 17th, 2025
Group: Vince
Mastering Segregation of Duties, Vince Security for Infor M3.
Monday, February 17th, 2025
Group: Vince
Fortude Feburary
Monday, February 17th, 2025
Group: Fortude
See All »

Events

See All »

Latest Feed

John Panzenhagen On Prem to Cloud
Announcement
BC:
We had a great conversation on our discussion group call yesterday. If you missed it, you can find the recording at https://m3uga.workoutloud.com/cloud/81852. Mike Wolfe with Engis shared about a new third party ETL tool that his company is using to move data from Data Lake into their data warehouse. Arun Kumar from Oldcastle did a quick show-and-tell on how they are using In-Context widgets and Enterprise Search to expand  Read more...the functionality of list panels. Both of these were ad hoc conversations in response to comments or questions made during the call. Your voice is needed ... and heard!

On that note, I am looking for ideas or topics for our upcoming calls. If you have any questions or topics you would like to see discussed, please email me at JPanzenhagen@UnitedRadio.com.I will do my best to find someone familiar with the topic to participate in the call.

Finally, we will not be having a call during the month of March. Instead, I look forward to meeting you all at the M3UGA conference in Myrtle Beach the 17th through 19th. We will be picking up our calls again in April with a presentation on MT Cloud Service Tiers, so keep an eye out for that announcement.  Show less...
Delivered Read
Uncategorized
Infor M3 User Community
m3uga.workoutloud.com
Load Item Text Using SQL Insert and update
Sam Haidar *MUGA
BC:

Question:

Article:

Load Item Text Using SQL Insert and update

Categorized as:

master data
M3
Test Category Technical

This maybe a bit confusing, please hang in there. I am trying to migrate Item Master records from one M3 to another. Lots of those records have text. So, I loaded the Header text in MSYTXH and text lines in MSYTXL based on the last TXID on those tables. Lastly, I updated the MITMAS/MMTXID accordingly in the Item Master for each Item number. The problem I am having is when I open the Item in MMS001, it shows that it has text (Paper Clip on the text icon) but I also see an Exclamation Mark  Read more...on the Action menu. When I open text, it is empty. When I step out of text, the Paper clip is gone. When I check the tables after that, MMTXID is 0, MSYTXH record is gone and MSYTXL are still there.  Show less...
Delivered Read
master data
M3
Test Category Technical
Group: *MUGA
1
Latest msg: Sam, I've run into the same issue but I still can't tell you exactly what the fix is. I believe it's something along the lines of you trying to inheri... from Jeremy Bull, on 02/21/2025
Foreign Exchange Variance is getting comingled with Pure Purchase Price Variance
Rafael Uribe *MUGA
BC:

Question:

Article:

Foreign Exchange Variance is getting comingled with Pure Purchase Price Variance

Categorized as:

Cost Accounting
Foreign Exchange
Finance
Accounting Rules

Hi All!!

I was wondering if I could get some assistance reviewing this enhancement request.

At CTOS we have Distribution Orders that cross borders to and from the US and Canada. When we ship product from the US to Canada the Goods in Transit gets hit at one Foreign Exchange (FX) rate and another FX rate when the order is received into inventory.

For varying reasons the base standard cost is not always the same from facility to facility. Thus, Purchase  Read more...Price Variance (PPV) will exist at an intercompany level. Because M3 does not have a set of accounting rules that trigger Pure PPV and FX Variance separately, they both get booked to the same account by default.

The impact to the business is significant because it presents challenges when trying to analyze true cost and using our findings for procurement and standard cost maintenance. The other side of the transaction is the difficulty getting to the value of the FX variance.

We are seeking an Infor Enhancement to create the appropriate Accounting rules that separate Foreign Exchange Variance from the total variance. Show less...
Delivered Read
Cost Accounting
Foreign Exchange
Finance
Accounting Rules
Group: *MUGA
See All »

Leader Board

Name
60 Days
Lifetime
555
3,425
205
500
195
195
190
1,030
170
2,085
150
605
140
140
135
420
135
630
130
155

Would you like to learn more about how points work? Click here »

See All »