90
Using Smartlist, How can I populate the account numbers associated with all of my payment transactions.
-I have tried going into the payables transaction module and adding columns for the purchases and payables account numbers but when I run the search nothing happens??
Thanks,
Stephan
*This post is locked for comments
Some of the scripts on this page might give you a good starting point:
Frank got it close.
The only accounts associated with payments are cash (or the bank account used to make the payment) and Accounts Payable. If you want to drill back to the actual purchases, you have several issues as payments can partial pay invoices and invoices can be for several different expenses. Say an invoice is for office supplies ($100) and inventory ($300). Later, you send a payment for $200. Did you pay the office supplies and part of inventory? part of inventory and no office supplies? proportional distribution? What if there was a dispute?
Payments always pay AP against cash. People growing out of a checkbook in my pocket to true accounting seldom understand the difference. The expense it taken when the payable is accrued, not when the payment is made.
Of course, if you are using purchase orders, your expense is taken during the receiving process. At that point, the account numbers associated with the receipt are the expense account and the receiving accrual. Later when the invoice is received, the receiving accrual is moved to payables.
So, if you are using POP, the expense accounts are found associated with the receiving transactions.
If you are not using POP or have other transactions not using POP, those payables transactions will have an expense account associated with them.
Smartlist, even with SmartList Builder is too simple a report generator to drill down from the payment all the way back to the purchase receipt and stop at the correct level to deliver the expense account(s) for a payment. You will need SSRB or Crysal and a GOOD report developer.
Thanks Frank :)
You can't Stephan, without creating a special SmartList with SmartList Builder. The purchases and payables account numbers you see in the Payables SmartList are the accounts set in the vendor card (if they've been setup there).
Hope this helps,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
