We ship from directly from jobs. When we ship partials, most of the time the costs that get pulled are a percentage of the quantity shipped vs. the job quantity. They aren’t always a perfect %, but close enough.
However, we recently had a job where all of the material costs were pulled with the 1st shipment.
The job was for 15,000 pcs and we shipped 5,520 pcs, I was able to review Part Transactions for this job to narrow down that all of the material costs were moved to COS.
When looking at the job, there are 3 materials and 2 had the fixed quantity checked. One was for inbound freight for one of the materials (this makes sense to me) but the other should have used Parent/Qty only, but someone took the entire quantity needed for the job and placed it in that field and marked is as a Fixed Quantity. The 3rd material has the most costs on it but was set up correctly.
My first thought was that the system pulled in the fixed quantity material costs with the first shipment, but since the bulk of the costs were in the 3rd material not marked fixed quantity, this logic doesn’t make sense.
Any thoughts on why this would have happened?
For Reference:
Material 1: Qty/Parent - 1496, Fixed Qty, Total Cost - $3,386
Material 2: Qty/Parent - 1; Fixed Qty; Total Cost $202
Material 3: Qty/Parent - 1; Total Cost $8112