tools123
20th November 2002, 23:56
For a typical item with Purchase,Inventory and Sales transactions
(No operation costs,no surcharges etc) what drives the change
in the standard cost?
I understand that with each receipt,the stanadard cost is recalculated and the receipts table gets updated and also the history tables.
When you choose to use the Baan standard session to update costs for a particular item based on say top down approach,where
does the process look at for the new standard cost? Does this specifically look at one table ready with the new cost or this gets calculated based on a set of logic at this time?
Thanks in advance.
Paul P
21st November 2002, 03:46
Dear tools123,
The change on std cost of purchased items itself may be based on several factors:
changes in average purchase price. Average purchase price is calculated for every new purchase receipt, but std cost isn't. Std cost can only be updated using session "Calculate" ticpr2210m000. However, depending on how you set up your default price calculation code, the main purchase price considered may not be average purchase price, but rather current, latest, or simulated purchase price
changes in surcharges
Standard costs can only be updated through the "Calculate" session, ticpr2210m000 (unless you're in B5, where you can update the std cost in the Item Costing Data session, provided that you don't have any stock for the item yet). Everytime it runs, it follows a set logic on determining the current std cost, so it doesn't look for any "temp" tables. It will, however, consult the last active std cost to see if there's any difference with the newly calculated one. If there's difference, the new std cost is recorded, otherwise no.
Rgds,
Paul
tools123
21st November 2002, 05:50
Dear Paul,
Thank you for the explanation.
I Think the Standard cost field in thr receipts table gets filled in based on the Item standard cost at that time.The Recalculation
actually may happen for the average Purchase price each time there is a receipt and this may be posted to Item Master.Agree?
The Set logic looks at what tables? Inventory values and Item Average Purchase prices to arrive at the new standard costs? or
is it more than that?
What happens if there are variants for the same item in the inventory as long as they are considered same items?
If a cost was assigned to them based on some characteristic,
would the Logic sum up all values???
Thanks again for the reply.