Bill of Materials Adjustments

BOM Adjustments for BC Items (packaging and ingredients)

Posted consumption of BC items, related to production, may sometimes need to be adjusted afterwards due to inaccurate Bill-Of-Materials (BOM), quality issues or other incidental reasons.  The recommended process in Wisefish for such adjustments is described in this document.

Example:

A FG Item with the item no. 02-004 has an assigned Wisefish Production BOM.

The BOM includes Item BOX as a BOM Component that is consumed automatically when the parent item 02-004 is produced.

Notice that the required quantity is 0,05 - i.e. for each one unit of item 002-004 produced, the system consumes one single unit of the BOM component.

Production lot 100 shows that 10.000 units (KG) have been produced of the parent item 02-004. The output of the parent item results in automatic flushing of the BOM Component item BOX.

In this example the BOM Component consumption was 500 units and value 6.000 LCY as seen on the value entries for the lot 100:

To adjust, start by opening the Lot Card.

Run action "Create Physical Jnl. for Std. Consumption Items" on the ribbon.

Select a "Journal Batch Name", and then run ribbon action "Create Physical Consumption Journal".

The system Navigates the Production Lot for posted Item Ledger Entries (ILE) for Std. BC items for packaging and ingredients, and creates "WiseFish BOM Consumption Correction Journal" lines. All fields in the journal are non-editable, except for field "Qty. (Actual Consumption)".

If the actual consumption should have been 400 units, instead of 500 units, then enter 400 in field "Qty. (Actual Consumption)". Notice that field "Quantity" is updated automatically - this is the actual quantity that the system will post as an adjustment.

When the lines have been adjusted, then click Post

Now the consumption has been reduced on the Lot card; the value goes from 6.000 to 4.800 and the Quantity from 500 to 400 units.

The last step in the process is to "Distribute Contribution" again to update the value of the output product 02-004 to reflect the changed value from the adjusted consumption.

💡 In case the adjustment needs to be reversed, then run ribbon action "Create Physical Jnl. for Std. Consumption Items" again, the same way as described above. To neutralize the adjustment entry only set field "Qty. (Actual Consumption)" on the adjustment entry to zero, and post the journal.