Page Comparison

This report allow user/Manager to monitor daily/weekly/monthly/yearly Net Sales and Collection generated by Branch

• Select Branch
• Select Date Range 
• Select Customer Type from the drop down list → deselect will generate ALL types
• Select Details → Company Name or Contact Person and Company Name
• Tick Display Columns → if needed

• Tick Options → Show Receipt with 0 amount
• Click Generate Report
• Click Printable Page → to print current columns or tables
• Click Printable Page without Salesman → to print current columns or tables without salesman column
• Click Printable Page with Branch Running Number → to print current columns or tables with Branch Running Number

• Click Printable Page with Customer Invoice Listing → to print without Payment Method, Terms, Trade In, Disc, Tax and User

• Click Printabe Page with Signature → to print current columns or table with signature

• Click Printable Page with Vehicle → to print current columns or table with vehicle information

NOTES:

• This Column will ONLY shown current transaction amount instead of the entire transaction amount. 

Advantages of SR-03:

• To calculate salesman commission manually (if applicable)
• Allow user to generate/monitor sales report by "Category Grouping" in the inventory features
• Ease of decision making for marketing strategy, increase sale performance by: re-grouping inventory category by sale performance

• Select Branch → base on Manager Reports (Permission)
• Key in From Date and To Date
• Select Salesman → leave blank for all salesman
• Select Customer Type → base on Drop Down List
• Select Inventory Category → base on Item Categories
• Click 'Generate Report'

• Click Printable Page → to print current table or column
• Click Export to CSV → to export current table or column

Tips:

This report allows users to do comparison between 2 or more months on Sales for each Item Code. This report will give informations on the sales quantity which might help to analyze the stock ordering management. 

• Select Branch → controlled by permission
• Key In Specific Item Code or Item Fuzzy Search for desciption or select the Item Category
• Select Item Status, Item Category and item Type → for additional filter
• Select Salesman
• Select the Calculate Base On → controlled by permission to view replacement cost or MA cost by company
• Select Customer Type from the drop down list → deselect will generate ALL types
• Select Date Range → by month, week or day
• Tick Group by →  Item level, branch or do not group; refer below as sample.

Item Level → categorized by item level

Branch → categorized by branch

Do not Group → indicate the whole company performance

• Click on Printable Page → to prunt print current columns or tables
• Click Printable Page 2 → to print by group
• Click Export Excel or CSV → to export current tables or columns

NOTES:

• GP column will shown regardless the user only allowed to see specific cost (replacement cost or MA cost) → calculation is based on the "calculate base on' column

Image Added

• Select Company and click 'Change'
• Select Location
• Select Date Range
• Key in specific Item Code or click 'Item Code Fuzzy Search' for search function
• Key in Item Code Range → if any
• Select Item Status → default is active
• Select Item Type → deselect all will generate ALL types
• Select Group By → item category under Item Categories
• Tick Options → default will tick all options 
• Click "Generate Report" 

Image Added

• Click Printable Page → to print current columns or tables
• Click Export Excel xls File → to export current tables or columns to excel file
• Click Export CSV → to export current tables or columns to CSV file

Tips

• Stock Balance = Acc Inv Value in SBR-05 for the selected location, as of the selected Date To

Image Added

• Stock Turn Ratio = Stock Balance / Cost
• Last Purchase = last GRN for the selected location