Skip to main content
Answer

Inventory missing under review

  • August 12, 2025
  • 4 replies
  • 74 views

Hello Team,

I have a business case where there is an Purchase Order with 10 items. When doing receive we found out Vendor only send 4 items but already issue invoice for 10 items. 

Question: which record to use in this case to record 6 missing inventory?

Expect Accounting:

  • Record for missing inventory
  Debit Credit
Inventory missing Account  Amount  
Payable Account   Amount
  • Record when Vendor ship 6 items back
  Debit Credit
Inventory Account Amount  
Inventory missing Account     Amount

 

Thank you for your attention

Yên Chi

Best answer by Christine

In my case, I will do receive for 10 items, do all the landed cost allocation and then create an Inventory Adjustment, reason code = PHYSICALCOUNTMISS (already existing on system), qty = negative.

When the goods was shipped back, create another Inventory Adjustment, same reason code, qty = possitive

4 replies

Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • August 12, 2025

@chidao  The purchase receipt should only show 4 items and from the receipt you can create AP Bill to only have a bill for the 4 items.  The Purchase order and receipt will stay open until all items are received which will allow tracking of the 6 missing items.  Is the vendor going to ship the 6 items or are you wanting to close the PO without receiving them?


  • Author
  • August 13, 2025

Hi ​@Heidi Dempsey 

Since the vendor has already issued an invoice for 10 items, I need to record a bill in Acumatica that matches the actual invoice. This means I must record a bill for all 10 items.

The vendor will ship the remaining 6 items in the next shipment.

The challenge in this case is that the vendor's invoice includes a surcharge. I need to allocate the surcharge cost across the 10 items. Therefore, I must receive all 10 items in the system to properly allocate the full cost (including landed cost, surcharge, etc.) related to this shipment. However, I still need to separate the inventory accounting: 4 items should be recorded in the Inventory Account, while the other 6 items should be recorded in the Inventory Missing Account.

Normal case: when Vendor ship 10 items and issue invoice for 10 items, the accounting will be

  Debit Credit
Inventory Account Amount  
Payable Account   Amount

 

My case: Vendor ship 4 items and issue invoice for 10 items, some how i need to record:

  Debit Credit
Inventory Account Amount of 4 items  
Inventory missing Account   Amount of 6 items  
Payable Account   Amount of 10 items

And then when they ship another 6 items, I will record

  Debit Credit
Inventory Account Amount  
Inventory missing Account     Amount

 

 


  • Author
  • Answer
  • August 14, 2025

In my case, I will do receive for 10 items, do all the landed cost allocation and then create an Inventory Adjustment, reason code = PHYSICALCOUNTMISS (already existing on system), qty = negative.

When the goods was shipped back, create another Inventory Adjustment, same reason code, qty = possitive


Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • August 14, 2025

@chidao Thank you for the update.