SAP Business One. Can I determine Last Evaluated Price?

[yaonianyang27]

Hi experts,

To accurately reflect the situation in our warehouse, we use two codes for certain materials: (1) "pcs" for individual pieces and (2) "Box" for boxes of materials. This helps us track how many boxes and individual pieces of a material we have in stock.

For example, we have item code A001 for a screw and another item code B001 for a box of screws, where each box contains 1000 screws. The Bill of Materials (BOM) for B001 is 1000 units of A001. Since A001 costs $0.2 per screw, the cost of B001 is $200 ($0.2 x 1000).

When we run out of individual screws, we execute a disassembly production order to "unpack" a box of screws. This means we disassemble 1 unit of B001 to obtain 1000 units of A001 in SAP, allowing workers to access 1000 individual screws from our warehouse.

However, a problem arises when we use the moving average method to evaluate stock. When we disassemble a B001, the increased count of 1000 A001 units does not always equal $200 in total value. We understand that this discrepancy may be due to errors in the past or rounding issues, but it consistently results in residuals in the Work in Progress (WIP) account. We attempted to clear out old stock in SAP before introducing new stock, but the system continues to produce inaccurate values.

Is there any way for me to determine the value when executing a disassembly production order, or any method to ensure that the value of A001 equals one-thousandth of B001's value?

Thank you very much!

Francis

[BattleshipCobra]

From my experience you should just use a single item code with a multi-UoM group with base EACH.  Especially since you have the desire to keep a linear relationship with the individual screws (from your example).

If you have 5552 screws in a single item and it's actually contained in 5 x 1,000 count boxes, then one box with 552 left but the cost is correct, why is this an issue?

Remove the disassembly steps, just let users pull the inventory as they need it.  Then you will also get the added benefit of a single item code where you can see your total stock properly.

With multi-UoM you can still have the 1,000 count boxes to purchase or sell, but fundamentally you are storing the item at "EACH" for the sake of seeing the total stock.

What do you think?

M