Microsoft Dynamics AX (Archived)

insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

(0) Share

Report

Posted on by prij

325

Dear All,

We are getting the below mentioned error while posting the retail statement.

Error: insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

can anybody give the root cause and solution for the same.

Thanks in advance

Regards

Siva

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Brandt Fundak 2,007 on at

Like (0)

Report
Copy link

Link copied!

On a technical level, this error occurs when the summed Issue Quantity of all of the InventTrans records you are querying is greater than the physical amount available when the InventUpd_Physical class was instantiated.

We don't use the retail module, but my experience with this kind of error usually has to do with Output Orders being associated with Sales orders. Unfortunately I don't have an easy fix for you--we had to modify several classes in order to get the Output orders to play nice with the reservation process.

Sorry, I can't give you anything better than that.

Brandt

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Agreed with what Brandt said, it is because of insufficient inventory for consumption. You can check the on-hand and verify.

With retail, it is highly advisable to us physical and financial -ve inventory, because of high volumes of transactions and delay in posting of inventory and consumption from multiple stores!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

any one has an idea about the matter above?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear Sive

its depends on how many times you created picking list.

can you tell me about ur inventory and picking lists?

Was this reply helpful? Yes No
Suggested answer

Rahul B 30 on at

Like (0)

Report
Copy link

Link copied!

I had the same issue When I go to the sales order then from sales order line select one item then go to Inventory and Transaction to see the related transaction for this item. sometimes it happens that there is no inventory transaction for it and this is one of the problems.
I cleared the statement and deleted that sales order and calculated and then posted again. It worked.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello, I have similar problem in posting the Sales Statement and not able to clear. Hello Rahul, if I delete all the Sales lines, how will I again calculate as the clear statement is disabled. Please explain whether I have to re-synchronise again ?

Was this reply helpful? Yes No
Suggested answer

Mohd irfan mehdi 956 on at

Like (0)

Report
Copy link

Link copied!

Hi,

there is one solution is the clear button is showing disable on retail form,

you can go to RetailTransactionTable and in the field there is one field named as calculate date and time, simply you can set this date and time zero and saved it and close the table.

you can see the clear button will enable after doing this activity but if invoiceId number is updated on RetailTransactionTable and RetailTransactionSalesTrans Table than dont do this activity.

Was this reply helpful? Yes No