Sales Data

• In this report we can get the Sales data based on the selection of the Parameters. We have ten Parameters i.e., Location wise, Vendor wise, Hierarchy-1(Department) wise, Hierarchy-2(Category) wise, Hierarchy-3(Subcategory), Hierarchy-4(Size), Hierarchy-5(Attribute), Brand wise, User Wise and POS wise.

• After selecting the Parameters, select the date range and if wants the reports day wise then enable the button Day Wise.

• If the user wants the headings should be print in the vertical column, then select the Cross Tab.

• Then click on Generate Excel a excel sheet will get downloaded with the selected Parameters.

• The Location is the default, it’s necessary to select.



• All the Parameters are Multi selection, that a user can select one or more than one item or all the checkboxes.

• The Common columns for all the parameters in reports are: Location Code, Location Name, SKU Code, SKU Long Name, Promo Code, Net Sales, Refund Value, Refund Quantity, Discount Amount, Sale Quantity, CGST Value, CGST Value, IGST Value, CESS Value, Total Sales.

• If the user selects only one parameter, then selected one only generate in the report.

• Example: The user selects only the locations the in the report only the location data along the common columns it will generate, Find below Excel sheet.

Parameter type Location:



• The user selects only the Vendor the in the report only the Vendor data along the common columns it will generate, Find below Excel sheet.

Parameter type Vendor:



• If the user selects all the parameters, then all the selected data will get downloaded. Please Find the below excel sheet.



• If the user enables Day Wise button, then in the excel sheet the Bill Date column will Add.



• If the user enables Cross Tab button, then all the selected location names will display in row and along with the cross-tab user selected the day wise PG.6 button the date column will also update.