Customer Statement

Created by Migration Bot, Modified on Fri, 23 Oct at 11:25 AM by Migration Bot

Originally written by John Hardwick, last updated Nov 13, 2023, on the Swan Retail knowledge base (FRS).

Part of: Financial Reports


This report is designed to produce a financial customer statement for a date offering different degrees of information, ageing dates, and control of account balance inclusion.

Crystal report name Customer Statement 8

The overall customer balance displays with red background where the customer owes money.

Green is used to indicate overpayments (credit balances) and white (no background) for zero balances.

Account activity occurring after the specified cut-off date is ignored to ensure traceability. The audit shows the print date and the as at date.

The ‘(Finance)’ following the balance indicates there are outstanding finance values linked to the customer’s account.

Held Orders are highlighted with a yellow background as shown above.

Selection Criteria

Run time choices, user selectable.

  • Format

    • Detail / Summary / Customer Summary

  • Group By Location

    • Yes / No

  • Restricted Location(s)

  • Cut-Off Date

  • Include

    • Any Balance / Outstanding Debt / Credit Balance / Non-Zero Balances

  • Customer ID(s)

  • Ageing

    • 30, 60, 90 / 30, 60, 120

  • New Page Per Customer

    • Yes / No

Print Sequence

As indicated by blue numbered squares in the report example.

1 Location

2 Customer ID

3 Sales Order Number

Report Totals

As indicated by yellow numbered squares in the report example.

1 Sales Order Number

2 Customer ID

3 Location (Where Grouped)

Printed Fields

Fields printed on the report.

All formats

  • Location (where selected)

  • Customer Number

  • Customer’s Full Name

  • Customer Telephone Number

  • Customer’s Daytime Number

  • Customer’s Mobile / Cell Number

  • Customer’s Main Address, including Postcode / Zip code / Eirecode

  • Current Approved Finance Balance

  • Current Unapproved Finance Balance

  • Overall Current Customer Balance

Detailed Only

  • Payment ID / Delivery Stock ID

  • Payment Type / Delivery Invoice Number

  • Delivery Value

  • Age in Days

Summary & Detailed

  • Sales Order Date

  • Selling Location

  • Salesperson

  • Sales Order Number

  • Order Balance

  • Overall Order Balance

  • Payments Received

  • Approved Finance

  • Paid Finance

  • Ageing in 30-60->90 or 30-60->120 Days format

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article