Missing InventTrans Record for the Sales Order

(0) Share

Report

Posted on by Ludmila

145

The Customer has a Sales order, that has been partially invoiced, but the delivery remainder quantity is not reflected anywhere in inventory transactions.
The below screenshot illustrates the status.

Sales line qty: 112
Invoiced qty: 104
Sales line reservation method: Automatic
The inventory transaction for the delivery remainder 8 Qty is missing , but that is wrong.

3108.q1.png

The customer wants to cancel the delivery remainder, but the Update delivery remainder job will throw an error because of the missing transaction.
It is not possible either to manually fix the sales line qty, because of the same error.
I have executed the Consistency check job, but it did not fix the transaction.
This issue is not reproducible anymore.

Which is the safest way to fix this issue?
I was thinking to create the missing InventTrans for the remaining 8 qty, after that the Update delivery remainder can cancel the remaining qty.

Which is the safest way to create a missing InventTrans record?

I have the same question (0)

All responses (6)

Answers (0)

Ahmed Shaalan Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Ludmila,

I assume this is related to Dynamics F&O or AX - hence need to be moved to correct forum

Thanks

Ahmed

Was this reply helpful? Yes No
Ludmila 145 on at

Like (0)

Report
Copy link

Link copied!

Hi Ahmed,

I apology for not having specified.

This is Ax 2012.

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Ludmila,

What error does system throw?

Could you please check if the remaining quantity field in packing slip journal line is blank?

You can create a new line with 8 quantity in the invoiced SO.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Ludmila,

Did somebody manipulate the item setup after the first 104 pcs were posted?

Another thing that you can check and possibly share are the quantities (ordered, received, invoiced) of this sales order. I cannot identify those quantities from your screenshots. Also having some information about what is shown in the delivery remainder would help.

Best regards,

Ludwig

Was this reply helpful? Yes No
Ludmila 145 on at

Like (0)

Report
Copy link

Link copied!

Hi Dr. Reinhard.

Thank you for the reply.

The item setup was not changed.

Ordered qty =0;

Physical reserved = 0;

Invoiced = 104;

Sales qty

Delivery remainder = 8

Inventory qty

Delivery remainder = 8

Was this reply helpful? Yes No
Ludmila 145 on at

Like (0)

Report
Copy link

Link copied!

Hi MATTGUO .

Thank you for the reply.

Remaining qty in Packing slip journal is 8.

The error is: "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."

But there are no any open output orders, production orders, or markings for this sales line. Debugging shows that it is thrown because of the missing InventTrans record.

The Customer does not require to create another line with 8 qty, but he needs to cancel the Deliver remainder (=8) qty. Cancelation fails because of the missing inventory transaction with the status Ordered/Reserved physical.

Was this reply helpful? Yes No