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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156