Bill Wise Detail Report
In Reports we are adding a new report type named as Bill Wise Detail Report.
In this report the user can see the full details of the bill along with the bill number.
The Screen will contain The Select location, Select POS, Data, Add Bill, Clear Bills Generate Excel.
If the user enables the Date Button then a selection of date field display. Please the below mock screen 3 for reference.
The Add bill and Clear buttons will not display if the Date button is On.
If the Date button is enabled then no need to enter the bill numbers.
The below is the screen if the user Generate the Excel by entering the bill numbers.
The Excel sheet will contain the following columns: Location, Bill Type, Pos Number, Bill Number, Sku Code, Sku Long name, Sold Qty, Sale Price, Refund Qty, Discount Amount, Price Over ride, net sales.
The below is the screen if the user Generate the Excel by selecting the Date.
The Excel sheet will contain the following columns: Location, Bill Type, Pos Number, Bill Number, Sku Code, Sku Long name, Sold Qty, Sale Price, Refund Qty, Discount Amount, Price Over ride, net sales.
Location: Here the user can select only one location at a time, the report will generate for the selected location only.
POS Number: Here also the user can select one or more than one POS at a time, the report will generate for the selected pos number only.
Add Bill: In the Field near the Add Bill, the user must enter the respective bill number and click on the Add bill then it will add in the below box.
Date: If the user wants to generate the report of one day then on the button of Date then a field will display to select the date.
Clear Bill: If the user wants to delete the entered bills from the grid the user needs to click on the Clear bill button.
Generate Bill: After entering all the above info, then click on generate excel to get the excel sheet.
