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).
Navigate to Accounts Receivable > Cash Receipts > Enter Statements.
Enter Statements browse
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. |
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).
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. |
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:
If you tick "Fax", Coins ERP+ will fax the remittances to:
If you tick "Print", Coins ERP+ will print the remittances for:
|
Select the Customer Selection tab to select statements for printing.
Customer Selection tab
Use the lookups in the From and To fields to select a range of invoices by Customer, Status Code, Currency or Customer Name.
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
Select the Contract Selection tab to select the statement printing using a variety of different criteria relating to the contract.
Select the Output Options tab.
Output Options tab
Enter a name in the Title field to easily locate it.
Select the output type required.
Click Next.
This report will be available to view in the Report Status workbench.






