Solved

Inventory Summary out of balance versus PO Lines

  • 11 July 2022
  • 9 replies
  • 132 views

Userlevel 4
Badge +1

The quantity open on PO per the inventory summary is overstated. One PO (PO001122) line is duplicated in the summary and the MRP detail inquiry, but is correct on the PO line inquiry and the actual PO. The promised date was changed for a couple items on this PO (supply chain issues) but only one line is being duplicated.

We have run “Recalculate Inventory” and the error did not resolve. Also tried editing both the PO and the line but the duplicate is not clearing. Below are screen prints showing the discrepancy:

We’re at a loss to figure out why this discrepancy occurred and how to resolve it. Any thoughts or suggestions would be appreciated. Thanks!

icon

Best answer by alicezyks51 10 August 2022, 15:11

View original

9 replies

Userlevel 5
Badge +2

When you did Recalc. Inventory did you tick the Rebuild Item History box?

Looks like a data corruption otherwise - might need to report it to Acumatica.

 

Userlevel 4
Badge +1

Acumatica support has moved this up to R&D level but have not resolved the issue. In the meantime, the VAR found that the PO line had a duplicate record in the INItemPlan table. It was the only duplicate record in the table, so this may have been a on time anomaly versus a bug but that’s for R&D to figure out.

Duplicate record in INItemPlan table

The VAR deleted the extra record, reran “Recalculate Inventory” and the Inventory Summary and Allocation Details are now correct.

Corrected Allocation Details

 

Userlevel 4
Badge +1

First and only time it happened to the best of our knowledge.

Userlevel 7
Badge +15

Thank you! I was curious as I’ve never seen it. Hope they resolve it quickly for you!

Userlevel 7
Badge +15

HI @alicezyks51 

Has anything been changed on the availability calculation rules for this item?

 

Userlevel 4
Badge +1

Yes, I did tick the Rebuild Item History box.

I will forward to our VAR for submission to support. Thanks!

Userlevel 7
Badge +15

Acumatica support has moved this up to R&D level but have not resolved the issue. In the meantime, the VAR found that the PO line had a duplicate record in the INItemPlan table. It was the only duplicate record in the table, so this may have been a on time anomaly versus a bug but that’s for R&D to figure out.

Duplicate record in INItemPlan table

The VAR deleted the extra record, reran “Recalculate Inventory” and the Inventory Summary and Allocation Details are now correct.

Corrected Allocation Details

 

Is this the first time it has happened or is it a continuing error?

Userlevel 4
Badge +1

No - we have not changed our Availability Calculation Rules since we went live in 2020 and the same rule is used for virtually all inventory items.

 

Userlevel 7
Badge

Hi @alicezyks51 - were you able to find a solution for your issue? Thank you!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved