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
#53297 - 11/02/17 01:06 PM negatives on IC aging
Mr Mayor
Member


Registered: 04/22/09
Posts: 445
Loc: Zimbabwe
im looking for ways to do away with negative quantities on IC aging, mainly caused by Sales and Internal Usage. the system does not allow negatives

e.g in Jan Receipts 5, sales 10 the aging for January is -5
February issue 3 and aging in 31-60 shows -3

even though the total is correct, because it adds these up and have net effects, have best can i have these net effects per selected months or per aging of periods.

Top
#53299 - 11/02/17 01:09 PM Re: negatives on IC aging [Re: Mr Mayor]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7549
Loc: Location, Location
The totals are correct, therefore you ignore the negatives.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53300 - 11/02/17 01:18 PM Re: negatives on IC aging [Re: Jay Converse]
Mr Mayor
Member


Registered: 04/22/09
Posts: 445
Loc: Zimbabwe
for me i wouldn't mind but the client on their packs they have stock aging in this format
1-30 and totals
31-60 and totals
61-90 and totals

let's say the 61-90 they didn't receive stock but sold stock, the totals come in as negative, and hence the question that the stock did not age negatively. that is more of movement not aging. they would want to see whats remaining not what moved

Top
#53301 - 11/02/17 01:20 PM Re: negatives on IC aging [Re: Mr Mayor]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7549
Loc: Location, Location
Then use a different report. FWIW, none of my clients use that report.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53302 - 11/02/17 01:33 PM Re: negatives on IC aging [Re: Jay Converse]
Mr Mayor
Member


Registered: 04/22/09
Posts: 445
Loc: Zimbabwe
true i have always hated this report since the black&white TV days :-)
alternatively what are you using

Top
#53305 - 11/02/17 04:13 PM Re: negatives on IC aging [Re: Mr Mayor]
Ettienne
Member


Registered: 06/28/02
Posts: 3616
Loc: Orlando, Florida USA
Write your own report, the standard report is useless.
_________________________
Sage 300 ERP Certified Consultant

Top
#53306 - 11/02/17 04:27 PM Re: negatives on IC aging [Re: Ettienne]
Mr Mayor
Member


Registered: 04/22/09
Posts: 445
Loc: Zimbabwe
i will give it a try especially on the aging parameters part
Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: