web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Retail Statement Posti...
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"

(0) ShareShare
ReportReport
Posted on by pratik varia 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

  • Mustafa-Chohan Profile Picture
    Mustafa-Chohan on at

    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans