HI, We created a “paymaster” company to handle all AP Billing for various branches.
We now need aging report to show which branch is responsible for vendor payments.
I’ve added APTran table to the report designer, to get the correct branch information and it seems to work, until there is a partial payment made against the bill. the result there multplies the balance against the number of transactions, and then subtracts the original bill total.
I have used ApTran“lineNbr” 1 to limit the lines to a single record and that works UNITL we have a bill that does not have a linenbr 1.
Any thoughts on how to limit the result to a single row of APtransaction(s).
...or a better way to do this?