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
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!
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
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.
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 (