Insufficient inventory transactions with status picked

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (0)

udaY-ch 5,128 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is R3.

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
guk1964 10,888 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

fatihgork 3,817 on at

Like (0)

Report

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)

Was this reply helpful? Yes No