Report Financing Settlement Status
(Settlement Report)
Access
This report, which is produced following settlement completion, may also be run on demand using this menu option. Only data that has been updated with settlement information will be available for reporting. Selection for the report includes the option to report on a specific settlement result - "rejected" for example. The report is sorted by batch number, settlement results, payment type, location and order number. Report breaks occur for payment types, settlement results and batch numbers.
The detail section of the report prints the store location used during the entry process, order or reference number for the item, batch date (date deposit/invoice was posted to FR), customer name associated with the order/reference #, store payment type used for authorization, account number assigned to the customer by the finance provider, transaction code (SALE, CREDIT, PAYMENT), dollar amount being settled, authorization number received from the finance provider, acknowledgement date (date settlement response was returned), and a description of the returned response from the provider (if manually closed, any comments added will print).
A recap report prints following the detail portion. This recap provides totals for each settlement result type along with counts (numbers of transactions) and dollar amounts. Approved transactions will be separated into sales, credits and payments. The total for approved will be calculated by subtracting the credits and payments from the sales.
The run-time options for this report are:
Finance ProviderIndicate the finance provider for which the report will be run. A drop-down list of active providers is available at this field . Entry in this field is mandatory.
Merchant NumberThis field will only be active for providers who use the TCP (real time) settlement type. Entry at this field is not required. A Finance Merchant number may be selected from the drop-down list or the field may be left blank to report on all merchants.
Batch NumberA specific (closed) batch number to report on may be selected from the drop-down list, or the field may be left blank to report all closed batches.
Transmit Dates
Date CodeClick on the Arrow button to view a list of date codes, then select the code that best indicates the time period on which to base your report.
Start DateIf you select CUS at the Date Code field, you activate this field. Use this field to specify the start date of the custom date range for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.
If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.
End DateIf you select CUS at the Date Code field, you activate this field. Use this field to specify the end date of the custom date range for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.
If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.
Settlement ResultsThis option will allow items to be reported based on settlement results. The settlement results options include: leave blank for All Results, PND to report pending only, APP to report approved only, REJ to report rejected only, ADJ to report provider adjustments only, and REV to report review items only.
Send Output toThe output destination of the report displays. To change the output destination, click on the Actions button and select Output Settings.
Export PathIf you select either the Personal Report Viewer (PRV), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.
Once the run-time options have been selected, choose Run to produce the report.