Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

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

Posted on by 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

  • Suggested answer
    Mohd irfan mehdi Profile Picture
    Mohd irfan mehdi 956 on at
    RE: insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

    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 ?

  • Suggested answer
    Rahul B Profile Picture
    Rahul B 30 on at
    RE: insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

    Dear Sive

    its depends on how many times you created picking list.

    can you tell me about ur inventory and picking lists?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

    any one has an idea about the matter above?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

    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!

  • Brandt Fundak Profile Picture
    Brandt Fundak 2,005 on at
    RE: insufficient inventory transactions with status on order reserved ordered and reserved physical and picked

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans