Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

(0) Share

Report

Posted on by Community Member

Hello Ax Experts,

I need a help for the issue "Cannot receive quantity [number] because inventory transactions with status Ordered, Arrived or Registered are insufficient"

I have a 'Sales order' type sales order invoiced (first print), a 'Return order' (RMA) with item line registered and status Open (second print) and when I try to generate a invoice of the 'Returned order' the system notice me the error message (third print).

Anyone could please help me with ideas, please?

Thanks in advanced

*This post is locked for comments

All responses (9)

Answers (1)

Suggested answer

Trilok Mohnani 107 on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

Hello Pablo,

Just did my findings and hence posting here.

1. Find the pertaining PO and check if the quantity matches the item "On Order" which is the case of error.

2. Ask you DB admin to update the quantity of status ordered from the backend tables, i.e. below

update dbo.INVENTTRANS set QTY = 7.0000000000000000 where INVENTTRANSORIGIN = 'xxxxxxx0987';

3. Refresh the quantity on the frontend and check if it is matching now.

Regards,
BAIBOY 40 on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

Hi Richardson,

I got the same error of Pablo but the difference is I am trying to Post the journal in Production Order but it cannot be post. Anyone can please help me with this one?
Community Member on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

Hello Richardson,

Yes, I verified the transactions without problems occurs and the order was invoiced.

Thanks for your advice

Best regards
Community Member on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

Hello Fidei Defensor,

Like Richardson Rodrigues says ´Be careful when you change transactions in the inventTrans table'. The better way is reproduce the error in a non productive system.

Maybe there are many ways to reach the right line, in my case I filtered by the ItemId and DateInvent fields in InventTrans table. I captured this values in /Sales and marketing/Common/Return orders/All return orders by the RMA number. In line I caught (ItemId) and in Line Details General tab I caught date and time (DateInvent).

Best regards.
Community Member on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

Hi Pablo.

Do you've verified the transactions after this change? Does items are with their status "purchased" after posting the invoice of the sales return? Only change the line status in inventTrans table shouldn't update the transactions.

Be careful when you change transactions in the inventTrans table.

Best Regards,

Richardson
Fidei Defensor on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

Hi Pablo,

Could you please send the whole procedure step by step? I'm getting the same issue here and I'd like to know how did you manage to get your hands on the right line

Thank you
Verified answer

Community Member on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

In AOT at 'InventTrans' table through the 'RecId' you can change the column 'StatusReceipt' to "Ordered, Arrived or Registered" like print below.

Maybe the user changed this status in the UpdateLine/Registration at Registration Form and closed without reverse the status, this save. The only way that I solved was changing this status via AOT.
Community Member on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

Hello Fredrik,

Thanks for your help but the parameter Receiving requirements from Item model groups is not checked like you can see below.

Inventory management/Setup/Inventory/Item model groups

There are another items with same item model group that works fine in 'Return Orders'.

The problem keep.
Fredrik Sætre 12,644 on at

Like (0)

Report

RE: Cannot receive quantity x because inventory transactions with status Ordered, Arrived or Registered are insufficient

In your inventory model group for this item, you've probably checked the requirement for shipping to be posted. I believe you have to receive the items. Return orders follow the requirements for the outbound process as they are handled through the sales order form.