Customer Credit Order Balance

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

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

Part of: Financial Reports


This report produces a mini statement showing the order balance for a customer. 

Crystal report name Customer Credit Order Balance 4

The summary version does not include individual order and payment transactions.

Selection Criteria

Run time choices, user selectable.

  • Customer Surname

Wild cards of * may be used

  • Group by Branch

    • Yes / No

  • Group by Salesperson

    • Yes / No

  • Format

    • Detailed / Summary

  • Restricted Sales Location(s)

Print Sequence

As indicated by blue numbered squares in the report example.

1 Sales Location (If Selected)

2 Salesperson (If Selected)

3 Customer ID

4 Order Number

Report Totals

As indicated by yellow numbered squares in the report example.

1 Customer ID

Printed Fields

Fields printed on the report.

  • Purchase Invoices

  • Sales Location (If Selected)

  • Salesperson (If Selected)

  • Customer’s Full Name

  • Customer Number

  • Order Total

  • Payments

  • Approved Finance

  • Unapproved Finance

  • Unfulfilled (Left to deliver)

  • Delivered Value

  • Customer To Pay Balance

  • Ageing (less than 30 days / 30 to 60 / 60 to 120 and over 120 days)

  • Last payment Date

  • Allocated Payment Total

  • Approved Payment Total

  • Approved Finance Total

  • Payment Total

  • Unallocated Payment Balance

  • Unapproved Finance

  • Balance to Pay

Detailed Format Extras

  • Sales Order - Pad Reference

  • Order Date

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