Unable to Export "Top Item Sales By Quantity or Price" data in Microsoft Excel

Unable to Export "Top Item Sales By Quantity or Price" data in Microsoft Excel

Problem statement

Unable to Export “Top Item Sales By Quantity or Price” data in Microsoft Excel.

Environment  

iVend 6.6 7825 SAP B1 9.3 PL 14


Symptoms

The problem was related with Microsoft Export Setting configuration.

 
Resolution/Work Around

Need to uncheck “Data Only” check box on Microsoft Export Setting window, and then save file. Check below for the reference.


Recommendations /Suggestion

While exporting the summarized report “Data Only” check box should be unchecking.

    • Related Articles

    • Unable to Export sale report Excel format

      Environment-   Ivend 6.6 Problem statement –   Unable to Export "Sales by transaction type with a detailed report." data in Microsoft Excel format Symptoms: The problem was related with Microsoft Excel Export Setting configuration. Resolution/Work ...
    • Unable to import Excel file with UDF

      Environment: iVend 6.6 with SAP B1 9.2 Problem Statement: Product Masterfile unable to re-import with user defined field (UDF) Symptoms: On exporting the product master from iVend from Export Data functionality, after making changes in the exported ...
    • Unable to import Excel file with UDF

      Environment: iVend 6.6 with SAP B1 9.2 Problem Statement: Product Masterfile unable to re-import with user defined field (UDF) Symptoms: On exporting the product master from iVend from Export Data functionality, after making changes in the exported ...
    • How to export stock in each store in Excel

      Environment: iVend 6.6 and SAP Business One Product Query: How to export stock in each store in Excel Resolution/Work Around: You can export the stock of each store by following below steps on iVend Management Console: Go to MC ->report->inventory ...
    • Unable to Validate Item Matrix template

      Introduction: This article will demonstrate how to resolve the issue of upload templates of Item Matrix in SAP by using the initialization tool, where maybe we can face the below error. Case Study: The below example is a case study where we are ...