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

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