We shipped a raw material on a SO which had no Product Group, so the inventory account credited but no COGS accounts were debited. The fix would normally be to RMA the part to offset the transaction then reship with the Product Group set right. We have tried this, however the original shipment occurred on 3-27 and the RMA return receipt on 3-31, so now the WIP capture from both dates are imbalanced in opposite directions and it still won’t post, even though the WIP recon report is balanced overall for all unposted transactions.
How can we set the return posting date to the same as the original shipment date so the offsetting transactions truly offset within the same date?
We had a dickens of a time when we tried to close Jan25. Our consultants helped us get through it. Had to run InvWIP for unposted transactions by transaction type to isolate it. In our case we were missing GL settings for returns (COGS/sales) on a particular part group. I think we ended up deleting the Review Journal entry that was in error, fixed the missing GL settings, ran the WIP capture again and it cleared.
You can set default GL controls at the company level so any parts missing a product group will still post. Our company has these defaults set to a suspense account so that it’s obvious when something posts there and triggers our team to fix the part settings.