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 ...

    • Not able to receive a Stock Transfer in SAPB1 ErrorMessage: Not enough data

      Environment : iVend 6.6 with SAP B1 Problem Statement : Not able to receive a Stock Transfer in SAPB1 ErrorMessage "Not enough data" Symptom: Specific computer are not able to receive the stock transfer in SAP. Resolution/Work Around : Clear the junk ...

    • 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 ...

    • 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 ...