Production Order Cannot Be Updated

(1) Share

Report

Posted on by Community Member

6787.Capture.PNG

"Quantity cannot be updated with inventory reference Prod. reported as finished journal because inventory transactions with status Ordered, Arrived, or Registered are insufficient."

I'm receiving this error when a specific production order is attempted to be reported as finished. The inventory transactions on the production order is empty. Also when I look at InventTrans, InventTransOrigin, and InventTransOriginProd, there is no record of this production order. However, I am able to find the component items related to the item on this production order on InventTransOrigin but not the item itself.

Does anyone have any idea what could be happening?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Weaveriski 23,616 Moderator on at

Like (0)

Report

RE: Production Order Cannot Be Updated

I suggest posting a new thread, or answering the previous questions relating to customisations, importing etc.

Was this reply helpful? Yes No
Mateusz G 50 on at

Like (0)

Report

RE: Production Order Cannot Be Updated

Does InventTrans to this production order exists?

Was this reply helpful? Yes No
Khawaja Muhammad Bilal 269 on at

Like (0)

Report

RE: Production Order Cannot Be Updated

Hello guys,

Facing Same Error, is there any solution?

Was this reply helpful? Yes No
Mateusz G 50 on at

Like (0)

Report

RE: Production Order Cannot Be Updated

Hi, Has anybody resolve this issue? I have similar problem. I found a couple of prod orders without InventTrans and InventTransOrigin InventTransType Production. Normaly Should be transaction Ordered after creating Prod Order. When I estimate, release, I don't get any error, but status doesn't change.

Is it any solution to reproduce missing transaction and finally orders normally?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Production Order Cannot Be Updated

Okay, thanks for the info and reply. I haven't noticed any other production orders with this error, but I will keep that in mind about our imports. The joining transactions on the aforementioned tables (InventTrans, InventTransOrigin, and InventTransOriginProdTable), you mean?

Was this reply helpful? Yes No
Fredrik Sætre 12,644 on at

Like (1)

Report

RE: Production Order Cannot Be Updated

Chances are that this is related to an import. A manually entered production order should invoke the necessary business logic and should not create this mistake. That is, if you haven't broken standard logic with customizations.

Further more... Creating the joining transactions should make you able to power through.

Good luck.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Production Order Cannot Be Updated

Most of our production orders are imported, but the timing of this one leads me to believe it was entered manually. I'll have to check with our production manager to be certain.

Since the transactions are missing, would the solution in this case be to recreate the record in InventTrans, InventTransOrigin, and InventTransOriginProdTable?

Was this reply helpful? Yes No
André Arnaud de Cal... 298,655 Super User 2025 Season 2 on at

Like (1)

Report

RE: Production Order Cannot Be Updated

Hi bsarge,

The transactions are missing. That is indeed causing the issue. Can you indicate if there are customizations to create production orders or has Data Import Export Framework being used to import production orders?

Or someone has deleted some records in the table (by accident).

Was this reply helpful? Yes No