530
Users here sometimes Report as Finished more than they have actually produced. If the Production Order is Ended, I cannot undo this.
What I need is to be able to remove the produced items from stock, and add the components back into stock.
Is there a simple way to do this - the only way I can think is to manually add each BOM line item to a movement journal, which is a pain.
*This post is locked for comments
You may want to check with your cost accountant on those negative BOM journals and have them follow the trail through the GL. We tried that method and found the BOM Report As Finished was not designed to handle negative numbers correctly (per MS). It did not correctly reverse the dollars back to the correct accounts. We had to actually create a mod to the system to reverse the journal posting directly for an Ended production order.
You can reduce the stock on hand and restore the component items to inventory by using the BOM Report As Finished function from the Item Table Form. click the BOM button and choose Report As Finished. Enter a negative quantity to be removed from inventory and set explosion as Never. This will do a one level, reverse bom explosion. (I know it is a little late for you, but maybe I can help the next guy!)
stupid me !!! you are right. I didn't end production order.
Hi Texaspete,
You can post a reverse report finished journal on a Ended production order. Infact i did it on my system the same way.
Hi Bob Bobby,
Thanks for the idea. I have tried it - creating a dummy production order, and doing a negative RaF. AX won't allow me to add the components back to stock during BOM consumption:
'Quantity returned exceeds updated physical and financial quantity'
I guess I am not allowed to negative RaF an amount more than has been already RaF on the production order.
The Production Orders are being ended correctly at month end before our Stock Close - it just takes the guys in the warehouse a while to see that they haven't physically got something that AX thinks they have.
Hi,
You have to create another Production order and post a negative RAF.
Who is ending your production orders? If its the shop floor guys I would suggest not allowing them to do this.
Regards.
Hi Texaspete,
To reverse/reduce you can also use the "Report as finished" journal available from Journals -> Report finished in Production form. When you report a quantity in negative then it reverses the corresponding quantity. It also automatically reduces the corresponding BOM Lines so you may not need to type everything line by line. Just one line that says how much you want to reduce from the actual that was report finished would be fine.
additionally If your users are reporting more than the actual, then you can ensure that the "Accept error" flag in the General tab of posting is checked. If it is unchecked then it gives you a warning when you report as finished quantity exceeds the starting quantity.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (