Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Amanda Harris]

?Hey Guys-

We’re running 2012 R3 and I received a help request from a user that I can’t quite resolve. They issued a PO for 4 cases of an item that is set up with a unit conversion of 100 each / case. An initial delivery of 2 cases arrived and was received in the system. The vendor invoiced us for the first 2 cases and AP put the invoice through AX. The second delivery arrived and was received in the system, and again the vendor invoiced us for 2 cases. This time when AP went to put the invoice through they received an error message that stated: PO#17085 Item # 81010 Insufficient inventory transactions with status Purchased. Item 81010: Compare purchase order and invoice values. I went to the General tab of the PO and checked the line quantity to see what might be going on. it looks like the initial invoice was put through as 2 cases = 2 eaches because the invoiced quantity shows as 2 cases on the top of the screen, but the invoice remainder on the bottom of the screen shows up as 398 eaches. I suspect that error with the first invoice is what’s causing the error when trying to put through the second invoice, but I have no idea how they got the invoice to go through that way or how to fix it. Any help would be greatly appreciated.



Thanks,
Amanda
??

——————————
Amanda Creedon
IT Project Manager
Kayem Foods Inc.
Chelsea MA
——————————

[Sarah Gabriel]

Hi! 
Are you using the mobile device to receive items? Maybe the user selected a different unit of measure when registering the items. 
Also look at the released products. If you are using advance warehouse, review the unit sequence group ID on the warehouse management fast tab. 

Good Luck!

——————————
Sarah Gabriel
Operations Business Analyst
Kai USA Ltd
Tualatin OR
——————————
——————————————-

[Amanda Harris]

?Hey Sarah!

Thanks so much for your reply. yes we are using advanced warehousing, and yes the unit sequence group ID is set as Each to Case with case selected as the default unit for purchase and transfer. My initial thought was the same as yours: that the receiver must’ve selected the wrong unit of measure when receiving because that happens frequently, but I reviewed the work transactions and the License Plate numbers assigned to the inventory quantities, and the two lines for the 198 eaches and the 2 eaches that I showed in my inventory transaction screen shot above are both on the same LP, meaning something happened when the invoice was posted- I think they’re only showing on 2 separate lines because of the different Receipt statuses assigned to those quantities. When AP posts an invoice, there is a step to Match Product Receipts and that screen has an option to change the unit of measure. I’m guessing that the AP clerk changed the unit of measure there, making the original invoice post for 2 cases = 2 eaches, although I’m not 100% sure that’s what happened. Either way though, regardless of what caused the issue, the more important thing is how to fix it, and how to post the 2nd invoice without getting the error that there are “insufficient inventory transactions with status purchased.” Any ideas?

Thanks,
Amanda

——————————
Amanda Creedon
IT Project Manager
Kayem Foods Inc.
Chelsea MA
——————————
——————————————-