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
#53812 - 12/03/18 01:15 PM Remove Invoice from Vendor Activity
jnsimex
Member


Registered: 11/27/05
Posts: 388
Loc: Canada
I have a vendor who's invoices have been paid, payment batch is posted and so has the corresponding GL batch.

Vendor activity shows the 2 invoices as outstanding with a 0 balance and when I run the aged payable, the invoices show on the report.

Basically, I need to get make these 2 invoices disappear and the only way i can think of is by using SQL. what are my options here?

Top
#53813 - 12/03/18 01:18 PM Re: Remove Invoice from Vendor Activity [Re: jnsimex]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7710
Loc: Location, Location
AROBL.SWPAID = 1
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53814 - 12/03/18 01:19 PM Re: Remove Invoice from Vendor Activity [Re: Jay Converse]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7710
Loc: Location, Location
Oops, APOBL.SWPAID
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53815 - 12/03/18 01:31 PM Re: Remove Invoice from Vendor Activity [Re: Jay Converse]
jnsimex
Member


Registered: 11/27/05
Posts: 388
Loc: Canada
BINGO!
Top
#53816 - 12/03/18 02:07 PM Re: Remove Invoice from Vendor Activity [Re: jnsimex]
jnsimex
Member


Registered: 11/27/05
Posts: 388
Loc: Canada
oh just saw your signature..so true!
Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: