The Customer listing Report allows you to see a list of of your customers and their orders for papers and magazines as well as their current balance.
Generating the Report
- On the top menu bar of Retailer, click on Reports -> Customer -> Customer Listing.
- Select which customer categories you wish to run the report for. Click here for help setting up customer categories.
- Choose the order you wish to view the report in, it can be viewed by Customer Number, Surname, Street Key, Company Name
- Select the start and end customer number, leave the settings as they are to run it for all customers.
- Exclude All Order Details will remove the order details from the report and only display the customer address and balance.
Reading the Report
The Customer Listing Report has several columns which give you information about the customers orders.
Each Customer is identified by their Customer Number and Address on the first line, their phone number is also displayed on the second line.
The other columns are explained below:
- Title - Identifies which magazine or paper the customer has on order.
- Start - The start date of the customers order.
- Days of the Week - Shows what day of the week a customer receives a title and how many they get on each day.
- Del/Put - Identifies if a title is a Put-away order or a Delivery Order
The balance columns below are highlighted in blue in the picture below to help identify the columns they refer too.
- Current - The current balance on the customers account
- 30-60 - Any amount more than 30 days in arrears
- 60-90 - Any amount more than 60 days in arrears
- 90+ - Any amount more than 90 days in arrears
The Ch/Pap columns below are highlighted in green in the picture below to help identify the columns they refer too.
- Ch/Pap - Charge Paper identifies whether the order is being charged or not.
- Column - Identifies the price column the order uses from the stock screen for that item. This allows for separate pricing structures for the same item.
- Delivery Fee - Identifies what delivery fee is being charged for the title.