When using the functionality provided by Process Manufacturing by ToIncrease occasionally we get the following error when running inventory close and adjustments.

You can’t have unallocated cost on a planning item

The error always occurs when it is trying to pass an adjustment through a production order (“Batch order”).  Every other month we encounter this issue so we customized it to tell us the production order number.  In ClassesInventCostItemDim.addFormulaKeyAdjustment() add “info(_inventTrans.TransRefId);” just before “throw error(“@PRO997”);“.

Through experience we have found that either the co/by product allocation does not total to 100% and the ProdBOM.pmfAllocationPct needs updating or that the received or purchased transactions for the production order were somehow set to value closed when they should still be open.  Running a SQL statement similar to this will set the value to open, allowing the adjustment to pass to those transactions.

update InventTrans
set ValueOpen = 1
where dataAreaId = ‘510’
and TransRefID = ‘W0018583’
and StatusReceipt = 1