Does anyone know Epicor logic why when you ship multiple partial shipments and then you run WIP Recon or COS/WIP it moves the entire MtlUnitCost up to the first shipment?
In this scenario I shipped 1 and 1 more… different PackSlips, different Invoices and the cost rolled up to the first.
PartTran:
TranNum
PartNum
WareHouseCode
BinNum
TranClass
TranType
InventoryTrans
TranDate
TranQty
UM
MtlUnitCost
3588169
JC Test 5
448-OBD
DOOR01
S
MFG-CUS
0
2021-02-22
1.00000000
ea
23.45250
3588132
JC Test 5
448-OBD
DOOR01
S
MFG-CUS
0
2021-02-22
1.00000000
ea
0.00000
What happens is your Sales Gross Margin will show now
What I’ve seen, is that doing the above would only show the STK-MTL trans, as the MFG-CUS would have both been zero. Not until the 10th was shipped from the job would I see the costs in WIP (from step 3), hit the COS (or AR accrual) account.
This is what we see because we don’t report qty’s
Are you reporting any completed qty’s along the way? Back in your first example (job for qty 2), if you reported 2 being produced, prior to your first shipment, I wouldn’t be surprised if that’s why all costs hit the COS for the first shipment