Plus Community - for users of ACCPAC & Adagio accounting software

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!

Page 1 of 1 1
Topic Options
#53018 - 04/19/17 04:45 PM Suppressing vendors
Mr Mayor
Member


Registered: 04/22/09
Posts: 428
Loc: Zimbabwe
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

Top
#53019 - 04/19/17 04:47 PM Re: Suppressing vendors [Re: Mr Mayor]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7472
Loc: Location, Location
Crystal Group Selection formula
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53020 - 04/19/17 05:37 PM Re: Suppressing vendors [Re: Jay Converse]
Mr Mayor
Member


Registered: 04/22/09
Posts: 428
Loc: Zimbabwe
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'm wondering if APOBL is the best table to use.

Top
#53021 - 04/19/17 05:39 PM Re: Suppressing vendors [Re: Mr Mayor]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7472
Loc: Location, Location
Yes, 1 means paid, 0 means not paid. If you're seeing a balance and all APOBL records have SWPAID=1, then you have a huge data integrity problem, or the joins in your report are incorrect.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53022 - 04/19/17 06:21 PM Re: Suppressing vendors [Re: Jay Converse]
Mr Mayor
Member


Registered: 04/22/09
Posts: 428
Loc: Zimbabwe
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.

Top
#53023 - 04/19/17 06:23 PM Re: Suppressing vendors [Re: Mr Mayor]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7472
Loc: Location, Location
Run Data Integrity Check for AP. If it's clean, then your report has problems.
_________________________
Jay Converse
Sage 300 Whisperer

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: