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