Hello -
Our AP team received the error "Insufficient inventory transactions with status picked" when trying to post an invoice from a sales order. The packing slip is posted and there is sufficient on-hand quantity for this item.
Any suggestions for how to proceed are appreciated.
*This post is locked for comments
Hi Emasterson,
Please check item model groups of all items in this sales order to see if any of them have "Picking requirements" checkbox ticked.
If so, please check inventory transactions of this sales order with status issue either picked or deducted. You must have picked or deducted quantities equal to or more than your invoice quantity to succeed the invoice update. This parameter basicly stops transactions to be invoiced before they get picked. If that's the issue then you can check this link for more details: Item model groups (form)
Then next is to check inventrans for orphaned records. Go to the sales order then from sales order line select one item then go to inventory and transaction to see the related transactions (if any) for this item and the status.
Also check for hotfixes there have been several to cure similar problems
Also check whether there was any marking between sales order and purchase order
This is an AR transaction - posting a customer invoice from a sales order. The packing slip only contains letter and number characters as assigned by AX.
AP or AR?
As mentioned before its often down to a comma or other ascii character in the packing slip number. If so then you can try a simialr workaround to this. https://axhowto.wordpress.com/2014/04/02/insufficient-inventory-transactions-with-status-recieved/
Check the inventory transaction for this item by using Inventory > Transactions for open transactions which need to be invoiced
This is R3.
Hi,
Hope this seems to be an known bug. The below threads has the same question with AP section
community.dynamics.com/.../50878.
What's the application version that you use.
Best,
Uday.
#1
André Arnaud de Cal...
292,865
Super User 2025 Season 1
#2
Martin Dráb
231,723
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (