Skip to main content

SL Statements

Updated over a week ago

Enter Statements

AR Enter Statement - Select Customer allows you to add or remove invoices from a customer’s statement, (for example, invoices that have been cleared since the previous statement).

  1. Navigate to Accounts Receivable > Cash Receipts > Enter Statements.

    Enter Statements browse

  2. Select the link in the Customer Account column for the customer to whom you want to send a statement.

    A screen will be shown displaying all outstanding credit notes and invoices.

    Credit notes and invoices

Field

Description

Internal Reference

Your internal reference number. This field links to: Sales Ledger Invoice Details

Invoice

The invoice number.

Invoice Date

The date of the invoice.

Due Date

The date the payment is due by.
Coins ERP+ calculates the default due date from the settings on the customer record.

Description

The invoice description.

Gross

The gross amount of the invoice.

Balance

The unpaid amount of the invoice. This takes into account any unposted allocations.

Statement

Whether this line will appear on the customer's statement.

Even if this is ticked, invoices with zero balance will only show if the statement document is configured to show zero balances.

3. To remove an invoice from a statement, locate the invoice to be removed and click Open.

4. Deselect the Statement tickbox.

5. Click Save.


Print Statements

You can print a statement for one or more customers, either by selecting which customers to print for, or by specifying a statement cycle. You can include future amounts (that is, the total of outstanding invoices whose due date is later than the ageing date).

  1. Navigate to Accounts Receivable > Cash Receipts > Print Statements.

    Print Statements

Field

Description

Form

Select the document form to use for this print job.

Documents are set up using Reporting and BI > Document Designer > Document Designer

Email Template

If emailing statements, select the email template to use.

Statement Date

The date to appear on the statement. The default is today.

Ageing Date

The date against which aged debts are to be calculated

Statement Cycle

To print statements for customers belonging to one statement cycle only, enter the statement cycle code. To print statements for all selected customers, leave blank

Statement By

Whether to print the statement by customer or contract:

Customer - Coins ERP+ prints a single statement for each customer.
Contract - Coins ERP+ prints statements for each customer, for each contract on a separate page.
Sector - Coins ERP+ prints statements for each customer, for each sector on a separate page. This option is only available if parameter SL/SECSTMT is set to Y

Date Sequence

Choose to produce statement by Invoice date or by Due date

Include Non-Contract

Whether to show Accounts Payable invoices that do not have a Contract Analysis on the invoice header. For example, invoices which have an Overhead Department assigned.

Include Customers in Credit?

Choose whether or not to include customers whose balance less than 0 on the statement

Include Zero Balance Invoices

Choose whether or not to include zero balance invoices.

There is the similar option Show Zero Balance Invoices on the tab Extras of SL Statements print forms. If the option Include Zero Balance Invoices is ticked on the Statement Screen, invoices with zero balance will be printed in spite of value of the option Show Zero Balance Invoices of the tab Extras. If the option Include Zero Balance Invoices is unticked on the Statement Screen, value of the option Show Zero Balance Invoices of the tab Extras will be analysed, and if it’s ticked, invoices with zero balance will be printed.

Include Contract Related Invoices

Whether to include contract-related invoices.

If the option is ticked and CSCERT form is defined on a SL Print Statements form, contract-related data will be printed.

Cleared Payments after

If you are showing cleared cheques on the statement, only cheques dated after this date will be included.

Exclude Statements with Balances less than

Stop statements with a minimal balance from printing by entering a value here. This is intended to reduce the number of physical statements mailed to clients.

Select Sector

The code for the sector to which the transaction belongs.

Customer Print Methods

If you tick "Email", Coins ERP+ will email the invoices to:

  • All the customers whose default print method is EMAIL.

  • All the customers whose default print method is blank but who have an email address.

If you tick "Fax", Coins ERP+ will fax the remittances to:

  • All the customers whose default print method is FAX.

  • All the customers whose default print method is blank, and who have no email address but have a FAX number.

If you tick "Print", Coins ERP+ will print the remittances for:

  • All the customers whose default print method is PRINT.

  • All the customers whose default print method is blank and who have no FAX number or email address.

  1. Select the Customer Selection tab to select statements for printing.

    Customer Selection tab

  2. Use the lookups in the From and To fields to select a range of invoices by Customer, Status Code, Currency or Customer Name.

  3. To print invoices for specific Customers, Status Codes, Currency or Customer Name use the lookup in the Matches field.

    If you chose Statements by Contract, you will also be offered a contract selection tab.

    Contract Selection tab

  4. Select the Contract Selection tab to select the statement printing using a variety of different criteria relating to the contract.

  5. Select the Output Options tab.

    Output Options tab

  6. Enter a name in the Title field to easily locate it.

  7. Select the output type required.

  8. Click Next.

This report will be available to view in the Report Status workbench.

Did this answer your question?