Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP(ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting. New visitors, please click here!
I have written a basic report from APOBL that resembles Aged Payables or vendor transactions. Reason behind being a requirement for local tax authorities with added columns like 2/3 of vat, 1/3 of vat. Subtotal plus 1/3 of vat etc
My question being how do I suppress a vendor from printing when document total is zero. E.g Invoice 100 Payment -100 Total 0.00
Just like the aged Payables I would like a formula to prevent this vendor from printing. I tried looking at the apvtrn01.rpt but it's not straight forward
I must have been smoking something. That works. Thank you. However the swpaid switch is playing tricks on me. 1 seems to mean paid and 0 not paid. Some vendors show a balance with swpaid =0 yet when I print aged Payables nothing prints as everything is fully paid. When I remove the swpaid filter the sum is zero
I feared the joins issue so I ended up with APOBL & APVEN only. Not all records have 1. For example I have a Prepayment of 100 SWPAID =0, Invoice 100 SWPAID = 0, then invoice of 120 SWPAID = 0. The vendor balance is 120 last invoice. When I pull all records vendor balance is zero as there is a payment of 120 SWPAID = 1. Due to my suppression formula it's not printed. But the other vendors becomes a mess as I see all the paid docs.
As you mentioned, that's a serious data integrity issue.