Open Forum

Like what you see? Discover the benefits of the D365UG/AXUG Community. Learn More

Topic: Ending Production orders

  • AX 2012 R2

1.  Ending Production orders

Posted 10 days ago
​While attempting to end several production orders I am getting the following error, "The quantity cannot be reduced. The number of inventory transactions on order is too low because the quantity or part of it is referenced by an output order or a production order or is marked against other transactions".  Does anyone know where to start with correcting these so they will end?  I don't see any referenced output orders and I have removed all markings and production order referencing, but still get the error.  Thanks.

------------------------------
Trent Aschliman
Business Analyst
Fort Wayne Metals
Fort Wayne IN
------------------------------


2.  RE: Ending Production orders

Posted 7 days ago
​I have ran into that error as well.  In doing research on it I found it could have been a number of things but in my case it was other production orders that were started but not completed using the same components.  The issue is with timing as other production orders using the same components have reservations on the inventory even though you have systematically already used those components to create this production order.

The solution for us was to figure out which other Production Orders had the same components as the one in question and then to reset those Production orders back to created status which in turn, removes the reservations on the components allowing the Production Order with the error to be Ended.  Then you can simple start the other production orders again.


*This may not work for you but in my experience this is what solved this error for us.

------------------------------
Daniel Walter
Business Analyst
New Sunshine LLC
Indianapolis IN
------------------------------



3.  RE: Ending Production orders

Posted 6 days ago
​Daniel,

Thank you very much for the suggestion.  Unfortunately, this didn't work for my situation.  I think we are seeing the issue when the picking lists on a production order are inadvertently deleted on an actual posted picking list which is throwing the total quantities off at backflush.  This is just a theory, but again, I don't know how to fix it if this is truly what is happening.  We have seen this on both Sales orders and Production orders, which makes me think we are doing something wrong with our reservations and markings as well.  It seems to be a combination of things with this error.  Thanks again.


------------------------------
Trent Aschliman
Business Analyst
Fort Wayne Metals
Fort Wayne IN
------------------------------



4.  RE: Ending Production orders

Posted 6 days ago
Hi Trent -

Looks like the code (\Classes\InventUpd_Estimated) reaches this comment...

// try to delete extra quantity from transactions selected on this step

Fails test (Qty to Delete equals zero)

Comes here...

if (qtyToDelete != 0)
{
throw error("The quantity cannot be reduced. The number of inventory transactions on order is too low because the quantity or part of it is referenced by an output order or a production order or is marked against other transactions");
}

Were there some changes made to these orders once production began?  Were the order re Estimated if changes were made?

Thanks....Dave

------------------------------
Dave Phillips
MSFT Senior PFE
Microsoft
Fargo ND
------------------------------



5.  RE: Ending Production orders

Posted 6 days ago
​Thanks Dave,

I'm noticing that there are return transactions that may be throwing off the BOM calculations.  I'm going to look into this a little further, thanks for the direction.  I may not have noticed this otherwise.

To answer your questions, I do believe there is a high likelihood that orders are being changed.  Re-estimating is in the procedure, but I can't guarantee it is being followed 100%.  We have about 15 schedulers that use this process.

------------------------------
Trent Aschliman
Business Analyst
Fort Wayne Metals
Fort Wayne IN
------------------------------



6.  RE: Ending Production orders

Posted 6 days ago
​It sounds like it is trying to delete InventTrans records associated with the order, and is not finding InventTrans records to delete.  It would be looking for InventTrans records associated with the open quantity on the production order header, the remaining quantity on the production BOM lines, or the open quantity on the co/by-products list.  I've used SQL in the past to insert InventTrans records so that the order could be ended.  It's a bit tricky, but if done right, the records you insert are deleted by the process of ending the order.

------------------------------
Kevin McLean
Strategic Solutions NW, LLC
Beaverton OR
------------------------------



'