You’re offline. This is a read only version of the page.
I'm in MS GP Smartlist, under Payables Transactions - Transactions by Vendor
I filter to a Specific Vendor, I now want to add a Column i.e. the Field "Distribution Reference" that is populated on entering a Payables Invoice (sometimes left blank, which is GP's default, but not mine!). I can't see this field in the Smartlist section I'm in, should I not see it? Seems pretty basic to have access to a Description of the Payables Invoice in the Smartlist
Anyone any input?
*This post is locked for comments
I have the same question (0)Hi,
You do not see the Distribution Reference because that field is part of the GL account distributions. The Payables transaction SmartList shows what is essentially the 'header' table, it does not show the GL accounts that were used by the transaction. The distribution reference isn't a description of the Payables Invoice it is a description for one line of the journal entry created by the transaction. You have a one-to-many relationship between the transaction table and the distribution table. You can build a SmartList that contains this information, but the out-of-the-box SmartList does not.
Kind regards,
Leslie
Share
Report
All responses (
Answers (
65,271
