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
- Invoice 1 as -100% profit
- Invoice 2 as 200% profit
@jgiese.wci WIP expert! any insights.
If it’s costed then your kind of stuck, sometimes when you complete the Job and then cost it, it tends to iron out the costs (spread them out).