To view and analyze a customer’s purchase history (and account payment history for your charge customers) in Excel, Paladin has two report options.
Instructions on viewing these reports are provided in:
Report Detail
This option gives line item details for each item purchased by the customer, including:
- Part Number
- Description
- Invoice #
- Price Sold
- Qty Sold
- Date Sold
- Current SOH
- Current Price
Figure 1: Report Detail Excel report
Report Summary
This option gives a summary of the items (the total quantity and price spread of each item) a customer recently bought, including:
- Part Number
- Description
- Qty Sold
- Current SOH
- Lowest Price
- Highest Price
This report groups individual purchases of the same item. For example, if a customer bought 1 of item (part number) P7890 in one purchase, and then later purchased 50 of the same item, the Report Summary will show a quantity sold value of 51 and gives the price spread across both purchases.
Figure 2: Report Summary Excel report
Figure 1 shows the prior Report Detail representing the same sales in Figure 2. Compare them to see the differences between these reports.
Figure 3: Figures 1 and 2 for comparison
You can access these reports in Paladin’s Invoice/Quote module when you select a customer and then view their invoice history in the Advanced Lookup window.
Figure 4: Invoice/Quote module/History tab/Report Summary and Report Detail options
The following table shows the values contained in each report.
Sale information by item | Appears in Report Summary | Appears in Report Detail |
Part Number | X | X |
Description | X | X |
Invoice # | X | |
Price Sold | X | |
Qty Sold | X (total for all invoices) | X (per purchase) |
Date Sold | X | |
Current SOH | X | X |
Current Price | X | |
Lowest Price | X | |
Highest Price | X |
How to view Report Summary and Report Details
- In Paladin, on the top ribbon, select the Invoice/Quote module.
- Select or enter a customer account in the Customers list.
- On the bottom ribbon of the module, click F1 Advanced Lookup.
- In the Advanced Lookup window, click the History tab.
- When the History tab opens, keep the default settings, then click Find to view the customer’s purchase history.
- Choose a report option:
- To create an Excel spreadsheet a summary of the items a customer recently bought, including the total quantity and price spread of each item, click Report Summary.
- To create an Excel spreadsheet of line item details for each item purchased by the customer, including the purchase date, invoice number, item quantity and price, click Report Details.
If you have questions or suggestions about this information, contact support@paladinpos.com.