Unallocated Payments by Customer

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

Part of: Financial Reports

The report details all unallocated payments grouped by location where the transaction was processed, showing the SwanFRS customer number and value. 

This report is for use when operating with multi-companies.

It is possible for a customer to appear in more than one location.  Running the report for all locations consolidates the values into one per customer, making it easier to obtain a true picture of unallocated payments.

Alongside the unallocated value, the report details other unallocated funds and the location of the transaction to assist with reconciliation.

Selection Criteria

Run time choices, user selectable.

• Process To Date Time

• Date Usage

  • Accounting / Transaction

• Group by Location

  • Yes / No

• Restricted Location(s)

• Company

Print Sequence

As indicated by blue numbered squares in the report example.

1 Customer ID

Report Totals

As indicated by yellow numbered squares in the report example.

1 Report

Printed Fields

Fields printed on the report.

• Company

• Customer ID

• Customer’s Full Name

• Unallocated Funds Value

• Unallocated Funds Location if grouped by location

• Unallocated Funds Value in other location if grouped by location,

Attachments (1)

image-20230626-081925.png
29.1 KB