Correcting Duplicate WIP Posting on a Work Order

Symptoms

The Total Material WIP and Capacity WIP on the Work Order do not match the total Work in Process (WIP) posted to the General Ledger.

In rare cases, when posting the last step Production Journal for a Work Order, the system may create duplicate entries in:

• Item Ledger Entries
• General Ledger Entries

This causes the Work Order WIP to become out of balance with the General Ledger and prevents the Work Order from being finished.

Resolution

The solution is to unpost the Production Journal, then repost it.

The exact steps depend on whether the finished item has already been used.

Scenario 1 – Output Has Not Been Consumed

If the finished item has not been consumed, shipped, or otherwise used:

1. Navigate to the Production Journal.
2. Unpost the Production Journal.
3. Post the Production Journal again.
4. Verify that:
   • Item Ledger Entries are correct.
   • General Ledger Entries are correct.
   • Total Material WIP and Capacity WIP match the WIP posted to the General Ledger.

Scenario 2 – Output Has Already Been Consumed

If the output Item Ledger Entry has already been consumed:

1. Navigate to Item Application Entries for the Output Item Ledger Entries.
2. Open the Outbound Item Ledger Entry. 
3. Locate the Item Journal that consumed the output. 
4. Unpost the consuming Production Journal. 
5. If the related Work Order has already been Finished, reopen the Work Order before unposting the consuming Production Journal. 
6. Unpost the Production Journal that contains the duplicate postings. 
7. Repost the Production Journal to recreate the correct entries. 
8. Repost the consuming Production Journal.

Scenario 3 – Output Has Already Been Shipped

If the finished item has already been shipped:

1. Navigate to Item Application Entries for the Output Item Ledger Entries.
2. Open the Outbound Item Ledger Entry. 
3. Locate the Warehouse Shipment that shipped the output. 
4. Unpost the Warehouse Shipment.
5. If the shipment has already been invoiced:
   • Unpost the Sales Invoice first.
   • Then unpost the Warehouse Shipment.
6. Unpost the Production Journal that contains the duplicate postings. 
7. Repost the Production Journal to recreate the correct entries. 
8. Repost the Warehouse Shipment.
9. Repost the Sales Invoice if applicable.

Verification

After completing the correction, verify that:

• Total Material WIP equals Capacity WIP.
• The Work Order WIP matches the WIP balance in the General Ledger.
• There are no duplicate Item Ledger Entries.
• There are no duplicate General Ledger Entries.

Important: Because this process may require unposting inventory, warehouse, and accounting transactions, perform the steps in reverse chronological order. Any downstream transactions (consumption, shipment, or invoicing) must be unposted before the Production Journal can be corrected.