Skip to main content
Solved

QTY Missing from Inventory Valuation Export to Excel

  • November 16, 2023
  • 4 replies
  • 117 views
peter92
Jr Varsity III
Forum|alt.badge.img

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?

Best answer by StevenRatner

@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,

 

PETER MILLER

4 replies

StevenRatner
Varsity I
Forum|alt.badge.img
  • StevenRatner
  • Varsity I
  • Answer
  • November 16, 2023

@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
    Manikanta Dhulipudi
    Captain II
    Forum|alt.badge.img+16

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

     

    Acumatica Functional Consultant & Customer Experience Supervisor
      peter92
      Jr Varsity III
      Forum|alt.badge.img
      • peter92
      • Author
      • Jr Varsity III
      • November 16, 2023

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

      PETER MILLER
        StevenRatner
        Varsity I
        Forum|alt.badge.img
        • StevenRatner
        • Varsity I
        • November 17, 2023

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

        Steve - Klear Systems
          Terms & ConditionsAccessibility 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