Versions Compared

Version Old Version 13 New Version 14
Changes made by

Gracia Surialim

Farah S Noshirwani (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Expand
titleCI-01 Sales Report by Customer Property

Image Removed

Image Removed

Expand
titleCI-02 Sales Report by Customer (Summary)

Image Removed

  • Select Branch
  • Select Date Range
  • Click Customer Creation Type → date range is for Customer Creation Type
  • Select Customer Type → deselect will generate All type

Image Removed

Notes:

  • Sorting by Customer Pkid is available → click the customer pkid column

Image Removed

  • Click on printable page for print the current tables
  • Click on Export Excel or CSV or export the current table
  • Click on Export Large CSV to export the current table → without empty column
Expand
titleCI-03 Detailed Transaction Records by Customer

Image Removed

Image Removed

Note: 

This report is a heavy intensity report, therefore it is recommended to generate small range of data, if you wish to generate for all customer please generate in off peak hours to avoid server to hang. 

Expand
titleCI-04 Sales Report by Customer Code

Image Removed

Image Removed



Report Code Report Name Step By Step Guide Description / Usage / Benefits
CI-01 Sales Report By Customer Code1. Set Branch or All Branches.
2. Enter Date Range - To and From.
3. Customer Code Range - Customer Code can be obtained from Customer Listing. Or leave it blank to view all Customer Codes.		In this report, Customer Code means the Property 1-5 in Create Customer Account. Basically, this report categorizes customers based on the Geographical Area entered when creating the Customer Account. It summarizes the Sales, Sales Return and CM into one lump sum for each area.
CI-02  Sales Summary By Customer (Summary)1. Set Branch or All Branches.
2. Enter Date Range - To and From.
3. Click 'Generate Report Now'.		Almost similar to Sales Report by Customer Code, except that it lists down ALL the customers individually. This report is useful for checking how regular the customer is to your business. The higher the Net Sales, the more loyal the customer is. Apart from the value of sales and sales return, this report also shows the Count - number of invoices and sales.
  • Invoice - Sales Return = Net Sales
CI-03 Detailed Sales Records By Customer Check out Detailed Transaction Records.This report allow users to generate the detailed transactions for specific customers. With this report, users will be able to see exactly how much gross profit has been generated from each customer from the transaction history. Primarily, it includes Invoice, Sales Return and Credit Memo. 
  • Filters :
    • Salesman - Choose a salesman name to view only his / her customer records.
    • Customer From / To - To view customers from one PKID to another, like a customer code range.
    • Display Format - Default, Group by Salesman (Details), Group by Salesman (Summary 1), Group by Salesman (Summary 2). Each of these formats differentiates between the columns and how it's displayed.
  • Columns :
    • Standard Price - List Price in Add Item.
    • Discount
    • GP% = GP / Standard Price x 100%


Expand
titleCI-01 Sales Report by Customer Property

Image Added

Image Added


Expand
titleCI-02 Sales Report by Customer (Summary)

Image Added

  • Select Branch
  • Select Date Range
  • Click Customer Creation Type → date range is for Customer Creation Type
  • Select Customer Type → deselect will generate All type

Image Added

Notes:

  • Sorting by Customer Pkid is available → click the customer pkid column

Image Added

  • Click on printable page for print the current tables
  • Click on Export Excel or CSV or export the current table
  • Click on Export Large CSV to export the current table → without empty column


Expand
titleCI-03 Detailed Transaction Records by Customer

Image Added

Image Added

Note: 

This report is a heavy intensity report, therefore it is recommended to generate small range of data, if you wish to generate for all customer please generate in off peak hours to avoid server to hang. 


Expand
titleCI-04 Sales Report by Customer Code

Image Added

Image Added