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
#54255 - 03/28/20 06:56 AM ICIVAL vs ICILOC
Mr Mayor

Registered: 04/22/09
Posts: 492
Loc: Zimbabwe
i got stock in shambles

stock valuation differs from inventory movement report but huge variances

for reporting they use item valuation(ICILOC) and for checking transactions breakdown they use movement report which picks from ICIVAL table

is there an easier way to marry the 2. eg
valuation = 63 items
stock inquiries 7 items
physical count 3 items

when you run adjustment end result is -60 o qty on stock transaction inquiries thereby distorting their breakdowns when they want to know movement of that item
If you don’t make it first time, sky diving wasn’t meant for you

#54256 - 03/30/20 08:50 AM Re: ICIVAL vs ICILOC [Re: Mr Mayor]

Registered: 06/28/02
Posts: 3680
Loc: Orlando, Florida USA
In earlier versions there was a bug that inserted incorrect values in ICIVAL, that lead to discrepancies between ICIVAL and ICILOC. The movement report was affected by this also.
So if you see discrepancies then take ICILOC as the correct value.
Sage 300 ERP Certified Consultant

Page 1 of 1 1

Moderator:  Jay Converse 
Hop to: