Pivot table not showing the text values for "Inventory ID" or "Transaction Description".

  • 19 July 2023
  • 2 replies

While trying to get the Inventory ID and transaction description on the pivot table, we noticed that when the fields are added to the Values section, they are displayed as numbers in the pivot table.  



The fields work fine in the other sections of the table except for that particular one. Any thoughts? 



Best answer by miguel80 1 August 2023, 00:46

View original

2 replies

Userlevel 4
Badge +1

The values section is an aggregate / summary - I would guess that the pivot table is ‘counting’ the available records and displaying a number.


The “Properties” box (example below) should give you a hint about how the number is calculating.


Userlevel 5
Badge +1

The InventoryID value is a number. It’s generally translated in the UI to the InventoryCD value for better reading. I guess that when it comes to Pivot Tables it’s taking the original numerical value.

Try joining your current GI with InventoryItem using the InventoryID field. And then use the InventoryItem.InventoryCD field for the results grid.


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