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

Report Detail Excel report
Figure 1: Report Detail Excel report

Back to Top

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.

Report Summary Excel report
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.

Figures 1 and 2 for comparison
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.

Invoice/Quote module/History tab/Report Summary and Report Detail options
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  

Back to Top

How to view Report Summary and Report Details

  1. In Paladin, on the top ribbon, select the Invoice/Quote module.
  2. Select or enter a customer account in the Customers list.
  3. On the bottom ribbon of the module, click F1 Advanced Lookup.
  4. In the Advanced Lookup window, click the History tab.
  5. When the History tab opens, keep the default settings, then click Find to view the customer’s purchase history.
  6. 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.

Back to Top

If you have questions or suggestions about this information, contact support@paladinpos.com.

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 3/28/24