Customer Account Balance Detail Report

From FloristWiki

You can print the Customer Account Balance Detail report by clicking Print in the Customer Account Balance Detail window. This report is printed to the printer configured for General Printing on your FTD Mercury system.

The report includes the following information:

• Customer Account Type (balance forward or open item)
• Starting Delivery Date (the date selected in the search)
• Account Number
• Account Balance
• Customer Name
• Primary Address
• Phone Information
• Customer Status (active or inactive)
• Last Purchase Date
• Last Payment Date
• Last Statement Date
• Customer Notes

A table of individual sales starting on the specified delivery date for the store(s) is then provided (dates before the specified date are not included). Transactions are listed in chronological order, with the oldest first. Each sale includes the following information:

Column	Description
Sale #	The sale ID of the transaction.
Selling Store	The store where the transaction occurred.
Sale Date	The date of the transaction.
Delivery Date	The delivery date for orders. If the transaction was for something other than the order, this date will be the same as the Sale Date.
Sale Type	The transaction type. This can be a sale type (Local Delivery, Carry Out, Wire Out, etc.), or a transaction type (Payment, Finance Charge, etc.).
Recipient/Reference	The name of the recipient for orders.
Charge Amount	The transaction amount. If this is payment, the amount is negative.
Remaining Balance	The remaining balance on the ticket. For Balance Forward accounts, once the balance has been paid, this amount will be $0.00; prior to payment, this amount will be the same amount as the Amt Charged. If partial payment was received, this will be the unpaid balance. For Open Item accounts, this will be the remaining balance on that particular ticket. Payments may have a remaining balance if the payment has not yet been allocated.
Account Balance	The running account balance, including the Charge Amount.