Re: Inventory revaluation in BPCS

The revaluation of Inventory is a task that should be handled manually. The "subsystem" value for the perpetual inventory is the 'current" cost, be it standard or frozen (depending on how you value your inventory in the G/L). The current cost is defined as the cost in the system, whether it be a component cost that is maintained in CST100 or an established rolled-up cost that is created in CST600 times the on-hand balance. BPCS will not post a revaluation entry to the G/L if and when the standard costs change. You have to realize the valuation change via reports and/or queries and book the cost change to the G/L.

Dan Sweeney - Sr Technical Consultant
PHOENIX Business Consulting, Inc.
Cell: 860.490.6712
www.phoenixbcinc.com
 


-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of Michael Perna
Sent: Wednesday, August 19, 2009 2:36 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Inventory revaluation in BPCS

Running BPCS 4.3



Issue:

We are posting inventory transactions to the G/L and there are times when the inventory is off. We've discovered it has to do with the changing of standard costs.

When a user changes the standard cost via CST100, an ITH record is written with a # type and quantity is zero. When posting IN transactions to the G/L it bypasses all records with a quantity of zero.
How does BPCS ever revalue inventory? Also, when the standard cost is generated via CST600, the #record is not written. If the standards for components are changed and the cost gen is run, how does the finished good inventory get revalued?

Thank you all.



Michael Perna

Business Systems Analyst - Finance

t. 310.832.8000 | f. 310.519.2605
P.O. Box 1950 | San Pedro, CA 90733 | USA, Earth
contessa.com <http://www.contessa.com/>