Payables Invoices report from smart list showing account type

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Victoria Yudin 22,768 on at

Like (0)

Report

Re: Re: Payables Invoices report from smart list showing account type

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/.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Re: Payables Invoices report from smart list showing account type

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: Payables Invoices report from smart list showing account type

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

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

Re: Payables Invoices report from smart list showing account type

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.

Was this reply helpful? Yes No