Issued Qty in Job calculating differently to Req Qty (Backflush)

Sorry, it might be a bit of a long one. I am still trying to work out why the unit price works out differently if we book out 1 part or multiple parts. I have an open ticket with Epicor and Development have advised it is the Pull As Assy setting but I am still waiting to find out if they will confirm how this setting affects the calculation as it didn’t seem to make a difference when I changed it in the BOM.

The BOM is structured with some raw materials and 3 phantom parts. Out of the 3 phantom parts one has a part with a manufactured BOM + 3 raw materials. All of the materials in the BOM and the phantom itself use the same UOM (KG). The manufactured part and one of the raw materials is consistently calculating a higher issued quantity in the JobMtl table than is shown in the RequiredQty.

All our parts are set to Backflush and although we currently use Kanban Receipts I do get the same results if I create a job and book using Time & Expense Entry.

I have checked the following:

  • BOM for scrap (against the Operation and Material)
  • Part setup for UOM, Plant and Planning fields

I really don’t know where else to check to understand where this calculation is coming from?

Below is a summary of the standard part costs against the BOM cost report and a manual calculation, and also data from the JobMtl table for a booking of 1 piece v 10 pieces in case it helps show the issue more clearly

After much testing I believe that this is actually related to UOM \ Phantom BOM settings. I did raise that issue on another post and will update there: