How to fix production 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."&a

(0) Share

Report

Posted on by Community Member

Hi,

We have postponed live going a couple of times now. We struggle a lot with the production module in combination with the new WHS module on AX 2013 R2 CU9.

We have material on our production locations but for some reasons the reported as finished does not reserve and post the materials. The lines on the BOM indicate picked (and) changing them manually to physically reservered fixed the item reservations, but there are numerous of items and adding picking manually is a pain.

We have the feeling we do something structurally wrong, but what?

We get a lot of times that no inventory can be reserved on back flushing principle. We get:

"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."

Is there a tutorial on how to use this module by people like me (smart but too stupid to understand what goes wrong)? Or how to avoid these errors?

*This post is locked for comments

I have the same question (0)

All responses (21)

Answers (1)

Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report

There are no guides for this, but there are forums and blogs that can help you once you're stuck. Try and fail. Then you'll learn. We all go crashing many a time. Especially when new features are launched...

For your issue: Try going to the BOM and look at the reservations and markings.

Good luck.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I am looking into the Prod-BOM reservations, but if you have thousands of items, it is not done to reserve every item manually one by one. And in the end, I am after hours at the last item - to find out what the cause is -. I find that one item is reserved physically but still it throws the warning. Only for that item. It is not even shown at 'critical inventory' where I would expect that item. but it is not. On the production location there are exactly the amount of items as that must be reserved for that production orders. But it is not a go.

I will try to add 1 item to that location. If it can be reserved than, I am for sure we have a bug here.

And that it is not workable to do 1000 lines by hand to update their reservation...what automation is this?

J.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

You will need to look at the Output order and why it is reserved to a different order to the one you are trying to consume. If you are automating the backflush to post on completion without negative stock activated (not that I am recommending this) you need to ensure your processes mirror the system requirement - meaning the stock is moved into the place where AX wants to backflush it from. You are reserving at pick I am guessing from your description, but if stock is not there you dont want to stop production, the key is getting that stock in AX into the location where AX wants to consume it from. Your message however implies a slightly different issue which is there are items you want to flush but cannot, and then you need to look at the process and understand what is happening related to what you want to happen. There is a data and processing issue at play here. Are you using planning and using extended marking? What processes are reserving the stock that you dont want to? Are you juggling orders in real life and not reflecting this in the system but expecting the system to adjust?

There is no shortcut to this even with 1000's of BOM lines, but that is not the future, understand the issue in relation to the process and then decide what to do. There is nothing wrong with stock being marked against other orders depending upon your processes, however with that you cannot use it on another order automatically, you have to tell AX you are doing this.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hello all,

The solution is,

1. Please go to output order of that particular line, end the output order.

2. Go to line delivery reminder and cancel the remaining quantity.

thanks,

Danish.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have same error. Some people suggest removing the output order, which is also what came to my mind. But in my case there is no output order, so that is ont a solution. Same with you or did that help?

(note: we are on CU8)

Was this reply helpful? Yes No
Verified answer

ColbyGallagher 3,666 on at

Like (3)

Report

Go to your production order -> BOM / Formula -> select a component line -> Inventory -> Picking.

If you have records that are in Issue Status "Picked" click "Add Picking List update" at the top of the form, then click "Add" at the bottom of the form. Your issue status should change from "Picked" to "Reserved physical".

If you don't see anything on this form, go find your production picking list journal that may be created, select a row -> Inventory -> Picking. Same process as above.

Tip: these forms are dyna-linked, so you can leave the "Pick" form open beside the Bom / Picking list journal and it will update as you select different rows in the BOM form.

Once you get everything back to issue status reserved physical, you can re-set status on the production order back to created.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Mathias,

I have recently seen a couple of examples of this error in relation to production orders. This thread is not particularly clear about what action is causing the error to appear, and you do not mention it. What are you doing to a production order to trigger this message? End, Report as Finished, Reset, something else....

Was this reply helpful? Yes No
RLutia 15 on at

Like (0)

Report

Hi guys,

Did you find a solution to this until now?

We try to switch now from R2 to R3 in order to be able to use WMS but we are facing the same issue.

I got the same message in 3 modules - purchase order, production order and inventory adjustment journal. , so I'm pretty sure this is not related to BOM, as sugested.

I can tell that when using a non-traced by batch item everything is fine.

Message shows up when:

1. Purchase : after receiving less than ordered and trying to cancel remaining qty

2. Production: when trying to reset status to created

3. Inventory adjustment : when trying to decrease a consumption (like -100 instead of -1000) on a saved line.

Was this reply helpful? Yes No
ColbyGallagher 3,666 on at

Like (0)

Report

Rlutia, this is an old thread and your issue seems slightly different. Please raise a new question.

Make sure to include information like:

-What is your item model group settings: IE is registration required, what is your costing method?

-What are your tracking dimensions for the item in question (sounds like batch is enabled)?

-If a batch tracked item, what are your settings on the batch number group assigned to the item?

Was this reply helpful? Yes No
Rana Abdul Rahman 45 on at

Like (0)

Report

worked for me :), Thank you Danish Khan.

Was this reply helpful? Yes No