Statement of Account

Unpaid Invoice Statement

SPM documentation v4.5.0.0 - March 24th 2010 – Written by Rémi Equoy - Updated December 6th 2011

Introduction

The Statement of Account enables to list invoices not settled (ie not payed) or a list of invoices when Unpaid invoices is not ticked:

The Unpaid invoices option (ticked by default) enables to extract a statement with only unpaid invoices.

The From the site only option (ticked by default) enables to computes results by using only site's documents.

The From and To enables to define a period of analysis.

Invoicing address and Print note tab enables to parameterize printing.

Follow-up enables to follow customers' payment in standby. This filed is saved automatically when closing.

Currency conversion are done with the day's exchange rate.

Results are computed with all invoices from status Waiting validation. Invoices In Creation status are listed but Print check bow will be not ticked.

When a customer is a Site, only invoices issued by the Site will be included in the calculation.

Print - Enables to discard a line (printing and total computing)
Document - Invoice document number (Doc#)
Invoice date
Payment due - Invoice's due date
Payment date - Last payment received (invoice must be at least closed).
Customer ref - Customer reference located into the customer order( Requisition, Repair Requisition or Exchange Requisition) - Available only if the invoice is linked to one order else *** will be displayed.
Ship date - The most older shipment linked to the invoice.
Total Incl. Tax. - Invoice's Total amount (including taxes)
Total paid - Sum of all allocated payment(s).
Total due = [Total Incl. Tax.] - [Total paid]
Over due = Total due when invoice's payment due date exceeded.

Delay field computes something different function of the Unpaid invoices option

Delay - Number of delay days of past due or Number of delay days of payment

Currency - Invoice's currency or selected currency.
Total due - Sum of all dues.
Total over due - Sum of all Over dues.
Credit - Customer available Credit. Tick the check box to use it. Credit amount may be modified by the user.
Net balance over due = [Total over due] - [Credit], if Credit is active.
Credit limit - Credit limit defined into the Customer form.
Credit Available = [Credit Limit] - [Total due]

Mail to...

Send mail directly to your customers:

Once the statement have been exported and if you use Microsoft Outlook as mail reader, a mail may be sent directly by using [Mail to...] button located in the print preview toolbar form.

To mail to more than one customer, a mailing command is available into the Customer Balance (see mailing)

Created with the Freeware Edition of HelpNDoc: Full featured multi-format Help generator