We have a customization for this, but it functions very poorly. Let's assume an operator consumed all the correct raw materials but forgot to record 1 tag/batch of material; making each other finished goods cost proportionally higher than expected:
The better process in 2012R3 I use is to first dump to excel the transactions and manually mock up what they should have looked like including all raw material, labor, finished goods, etc and calculate proper financials for each transaction that should have taken place.
Under Inventory Management>Periodic>Closing and Adjustment, select Adjustment at the top and click Transactions. On this screen, click Select and apply a filter that ties directly to the order in question. In my environment, I had to modify the base query on this screen to include "Inventory transactions originator" so that I can filter on the 'Number' field and key off the production order number in the criteria.Click OK and you should get an adjustment screen for that specific order; you may need to further personalize this screen under Inventory>Dimensions display at the top to get inventory tag level information to verify you are adjusting the correct lines.
Subtract the necessary values in the 'edit now' column to match up with what was manually calculated in excel and click Post; you'll be given a confirmation screen with a note field to explain why you're making the edit. Then under Inventory Management > Journals > Inventory Adjustment (or Movement, depending on your organizational requirements) Click new, pick the corresponding Journal type 'name', add a description ie 'correction for missing goods on order123', click Lines, and fill out the necessary fields for the adjustment journal. Assign the value in this journal to also match what was calculated in excel and post this as well.
It sounds much more complicated than it truly is, but grants you control to manually correct errors like these. We have a ton of customizations in our environment, but I believe these instructions work under base functionality.
Hope this helps! If necessary I can put together an example of this process on video.------------------------------Jeremy McBrideOscar Winski Company, IncLafayette IN------------------------------
If you've found this thread useful, dive deeper into User Group community content by role