Solved

QTY Missing from Inventory Valuation Export to Excel

  • 16 November 2023
  • 4 replies
  • 41 views
peter92
Rank
Userlevel 2
Badge

When pulling a Inventory Valuation report the “QTY on Hand” appears on the report but when exporting that to Excel the QTY is missing.  Anyone have a trick to make the QTY on Hand appear on the exported version?

icon

Best answer by StevenRatner 16 November 2023, 17:30

View original
PETER MILLER

4 replies

StevenRatner
Rank
Userlevel 5
Badge

@peter92 - The issue sounds like the field called “Qty on Hand” isn’t mapped in the report to be set out to excel.  This will require you to open the report designer and check to make sure the field is mapped correctly.  See my screen shot below,

 

Steve - Klear Systems
manikantad18
Rank
Userlevel 7
Badge +12

Hi @peter92 Please  adjust Excel export settings in the field properties within the Report Designer.

 

Acumatica Functional Consultant
peter92
Rank
Userlevel 2
Badge

@StevenRatner  - Thanks for the response…..that worked like a charm!

PETER MILLER
StevenRatner
Rank
Userlevel 5
Badge

@peter92 - Thanks for the update.  Could you please mark the response as “Best Answer”.

Steve - Klear Systems

Reply


Terms & ConditionsCookie settings
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