Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
PO20 inventory items & MMDIST
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
176
Members:
0
Total:
176
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
PO20 inventory items & MMDIST
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
NatalieD
Veteran Member
Posts: 53
2/13/2019 7:10 PM
Hello All - Wondering if any of you have and experience pulling the accounting information for PO20 lines for inventory items. We have always used MMDIST - as referenced on the PO20 lines MMD-ACCOUNT, etc. Recently realized that some items in our custom query were not pulling.
In chat with Infor, they stated that all PO lines account and accounting unit fields referencing MMD on the PO20 screen will be in MMDIST except for inventory items. They referenced IC04 for the IC12 to get the correct accounting information.
Based on what you know, is this true? I'm still working through my samples to see if that is how it works - since all the documentation on MMDIST I can find do not mention not including "i" type items.
Thanks much!
Jeff N
Advanced Member
Posts: 32
2/14/2019 8:05 PM
I don't think MMDIST has "I" items. If you are building a report you could probably build a formula to put in the balance sheet accounts.
Kat V
Veteran Member
Posts: 1020
12/14/2020 4:34 PM
Today I learned the Lawson Logic* behind this.
When adding an inventory item to PO - this is a future quantity and not a GL transaction- the accounting unit information is not editable nor is it actually on MMDIST. It's a display from the IC04ICCategory table. I think of it like the manufacturer name appearing on IC11 from manufacturer. For I type items, PO cannot change accounting information.
PO Line and MMDIST are for expenses and to Lawson an I type item is a quantity transaction. So the accounting unit info is a display only and to get to it - you need to if/then or case/when - when the POLine item type is I then use iccategory.acct-unit, iccategory.account, iccategory.sub-acct. For all other item types - use mmdist.
The PO receipt then hits ICTrans table and it is NOW that the quantity needs account info. The next IC130 posts it to GL from that table. So it *never* hits MMDIST - which is where my brain keeps breaking.
This setup is why you cannot change account information for I type items on PO. It's not actually there. But you can charge other item types to a balance sheet - or event he same inventory account and they will show on MMDIST. It's not the account - it's the item type that PO Line cares about.
*Lawson Logic may occasionally sound like human logic, but they are very, very different.
You are not authorized to post a reply.