Skip to main content
Answer

I've recalculated inventory since beginning and now in the historical inventory transaction it's not showing some of the transaction and also balance is not matching with inventory register. does someone has any idea

  • May 3, 2025
  • 6 replies
  • 129 views

Forum|alt.badge.img

Hi,

I've recalculated inventory from the beginning, but I'm noticing that some transactions are missing from the historical inventory transactions. Additionally, the balances are not matching the Inventory Register report. Has anyone encountered this issue before or have any suggestions on how to resolve it?

Thanks.

 

 

 

Best answer by nhatnghetinh

Hi ​@pankaj65 

Please try going to the "Release IN Documents" screen to see if there are any warehouse transactions that have not been Released yet?

 

Best Regards,

NNT

6 replies

Forum|alt.badge.img
  • Jr Varsity III
  • May 5, 2025

Hi ​@pankaj65  can you please run Recalculate Inventory once.


Forum|alt.badge.img+1
  • Jr Varsity II
  • May 6, 2025

Hi ​@pankaj65 ,

you can verify all transactions in Inventory Transaction History/Inventory Transaction Details ,

Hope above helps!!


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • May 8, 2025

HI ​@Rakshanda ,

 

Thanks for your respose,

 

I’ve noticed something unusual in the system—within the "Inventory Transaction by Account" inquiry, the warehouse is displayed as "INTR." However, when I open the actual receipt, it shows the correct warehouse.

 

From what I understand, the "INTR" (In-Transit) warehouse is automatically created by Acumatica and is typically hidden from the front end. It is only used during two-step transfer processes.

Given this discrepancy, I believe it may be a system issue and have logged a case with MYOB Acumatica. Let me know if you’ve come across this before or have any insights into it.

 

 


nhatnghetinh
Captain II
Forum|alt.badge.img+11

Hi ​@pankaj65 

According to your information, it seems that you have performed Transfer with 2-Step and have not performed the 2nd step (Receipts). Most reports in Acumatica will reduce inventory as soon as you perform Transfer with 2-Step, but in reality your goods are only In-Transit and not yet lost. This will result in inventory discrepancies between reports. As you can see in the screenshot below of Acumatica reports with inventory discrepancies.

 

We handle this by creating a new report to track the "INTR" warehouse.

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • May 8, 2025

HI ​@nhatnghetinh,


Thanks for your response. However, I’ve checked the actual transaction, and it is not a two-way transfer—it is a Purchase Order receipt entry. Therefore, in the Inventory Transaction by Account inquiry, it should appear under the actual warehouse, not as INTR.

Thanks. 


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • Answer
  • May 8, 2025

Hi ​@pankaj65 

Please try going to the "Release IN Documents" screen to see if there are any warehouse transactions that have not been Released yet?

 

Best Regards,

NNT