Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Retail Statement Posting Error : "A quantity cannot be picked, Insufficient inventory transactions with status On order, reserved ordered, reserved physical & picked"

Posted on by 50

I am facing error as below:

Retail Statement Posting Error : "A quantity cannot be picked, Insufficient inventory transactions with status On order, reserved ordered, reserved physical & picked" when I am posting a retail statement.

Issue : I can clear statement only once or at time the clear statement option is disabled (ideally it can be cleared multiple times) & when I clear the statement & recalculate a Sales Order gets generated with status open order(which is ideally generated with status invoiced when respective Statement is successfully posted). Due to this even if there is sufficient on-hand inventory available for those items it throws above error. Please note that these were cash & carry items

It would be really helpful if someone has faced such situation & let me know how it was resolved.

Version: MS Dynamics Aaxapta 2012 R3

*This post is locked for comments

  • RE: Retail Statement Posting Error : "A quantity cannot be picked, Insufficient inventory transactions with status On order, reserved ordered, reserved physical & picked"

    Hi Pratik,

    Can you please confirm your version is R3 RTM. We are facing this issue too, this usually happens when retail statement posting interrupts because of any error for example insufficient inventory or missing dimensions.

    So what exactly happens posting date field RETAILSTATEMENTTABLE is updated which causes the Clear button to be disabled (KB2996213).

    We are trying to consume BOM on statement posting - this is very simple and straight forward when we invoice the sales order directly. But getting same error 'A quantity cannot be picked, Insufficient inventory transactions with status On order, reserved ordered, reserved physical & picked' when we try to post the Retail Statement.

    Hope above would be helpful for you.

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,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans