Skip to main content
Question

Pivot Table Showing Double

  • February 20, 2026
  • 1 reply
  • 0 views
J
Freshman I

I recently created a pivot table off a GI that shows unit inventory and sales. The inventory piece is a bit challenging in that the Qty Available is correct, but on some lines it’s showing up as two separate numbers - always double what the actual available amount is.

I’ve checked the GI and it shows the correct value, so I’m wondering why it’s doubling in the pivot table.

not all records are like this. only a few. see below. 

Is there something wrong with the inquiry or is this a bug in the system?

thanks!

Joseph

    1 reply

    J
    Freshman I
    • JHuang
    • Author
    • Freshman I
    • February 21, 2026

    I recently created a pivot table off a GI that shows unit inventory and sales. The inventory piece is a bit challenging in that the Qty Available is correct, but on some lines it’s showing up as two separate numbers - always double what the actual available amount is.

    I’ve checked the GI and it shows the correct value, so I’m wondering why it’s doubling in the pivot table.

    not all records are like this. only a few. see below. 

    Is there something wrong with the inquiry or is this a bug in the system?

    thanks!

    Joseph

     

    Apologies, some extra information. this only shows up in the pivot view. one of the lines is the correct amount. the other is the doubled value amount. Not sure why that is as it’s not every item showing this.

    Terms & ConditionsCookie settingsAccessibility statement
    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