Report to show Payables Ageing with multiple AP accounts

(0) Share

Report

Posted on by Community Member

We enter AP transactions with multiple AP (PAY) accounts in the distribution. The smartlist for Cash requirements does not show the multiple accounts that have been hit in the distribution window. It only shows the one Payables Account from the Vendor. Is there a report/smartlist to get this breakup.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi - that smartlist displays the Payables GL Account attached to the Vendor Record - not the account[s] used on the Transaction.

You have two requirements that are not catered for in that smartlist:

1. Generate a line for every payables distribution

2. Display the actual GL account used and not the default Vendor one.

You should use Smartlis builder / Excel reports - to get the data you need. Start with the PM Distribution tables and work back to the transaction tables. - ie select distribution lines where the type is 'PAY' and include the due datyes / credit terms from the invoice record.

Ian.

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

Like (0)

Report

Hi Deepesh,

The SmartList doesn't care which account the payable was posted to. Have you looked at control account management? This might give you what you are looking for. I'm not confident that I know your requirements, but most folks do not even know Control Account Management exists.

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Deepesh, have a look at Victoria's query here - victoriayudin.com/.../sql-view-to-show-all-gl-distributions-for-ap-transactions. You can create a SQL view with it and use that in your SmartList Builder SmartList.

Good luck!

Was this reply helpful? Yes No