Hi
I am trying to get a report from GP or smartlist that shows the account type and account number the transaction went too. example: you do up an invoices in payables and the distribution shows you account number and type I would like a report to show me the invoice and what account and type where used for that transaction.
Thank you for your help
Pat
*This post is locked for comments
Here is a link to a SQL view that you can use with SmartList Builder that will show all the GL distribution accounts and types for payables transactions: http://victoriayudin.com/2008/11/28/sql-view-to-show-all-gl-distributions-for-ap-transactions/.
Hi Pat,
I think the information you need is in the PM Distribution WORK OPEN table (PM10100) or the PM Distribution History table (PM30600), depending on the status of the payable. In SmartList Builder you may want to use the 'Matched Table' option to combine information from both tables. I think by 'type' you mean the distribution type field on the distribution window. If you look at the table in SQL this is a numeric field DISSTYPE.
Kind regards,
Leslie
Hi Richard
thank you for your reply, I appreciate it.
I do have smartlist builder I have tried and tried to extract data but each time I add account tye all I get is posting account. I need to see the account type and the account along with customer vendor at the same time.
again thank you
Pat
You will need SmartList Builder or another report writer (SRS, Crystal, Excel Reports Builder) that can link the Payables Distribution table to the Accounts Table. Then this data can easily be extracted.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (