This document explains how you create an "open item" statement of account proposal for one or more payers or customers.
A proposal for a statement of account is created, listing all open invoices and drafts per currency for the selected payers/customers. The following information is presented: Invoice number, invoice date, due date, currency, currency amount, recorded amount, outstanding currency amount, and outstanding recorded amount.
Review and adjust the proposal in 'Statement of Account. Open' (ARS140) before printing the final statement of account.
No transactions are generated. A statement of account proposal is created and saved for further processing.
Start 'AR Statement of Account. Open' (ARS140).
The B panel is displayed, listing previous statements of accounts and proposals, their generation dates, created by, and status. The following statuses are used:
0 = The statement of account proposal is created and can be processed
1 = The statement of account proposal is being created
2 = The statement of account or the proposal is being used by another user
4 = The statement of account or the proposal is being deleted
6 = The statement of account is being printed or created
9 = The statement of account has been printed. It cannot be changed, but can be printed again.
Create a new statement of account proposal and give it a name. Press Enter.
The Name field may be left blank on this panel, but if you leave it blank here, you must enter it on the E panel.
On panel (ARS141/E), enter the end date of the range the statement will cover.
Enter a range of remittance statuses for drafts and invoices sent for factoring or direct debiting (optional).
If you created the proposal as a central user, select the division or divisions to include (mandatory). Also, select whether or not to break the printout up per division in the 'Page break' check box.
Please note: If you select page breaks per division, M3 will first search for local customer exceptions in 'Customer. Open Local Exceptions' (MFS610). If you do not select page breaks per division, M3 will only search for customers and payers in the customer master file—'Customer. Open' (CRS610).
Enter the method by which you want to group records in the printout:
Enter any of the following ranges (optional): Accounting dimension 2, salesperson, customer group, district, country, postal code (ZIP code), payer, customer number, currency, invoice number, and remittance status for drafts to be selected.
Enter the minimum outstanding amount for a customer to be included in the statement (optional).
Enter the report text to be printed on the proposal (optional).
Press Enter to create a proposal for the new statement of account and to return to panel (ARS140/B).
The proposal is listed if any invoices matching the selection criteria were found.
Review the proposal and make notes on which invoices you do not want to include in the final statement of account.
For example, if a payment has already been received as a check but has not been allocated to the invoice yet.
To check dubious records, select 'Accounts Receivable. Display' (ARS200) to see the original invoices and the transactions included.
(ARS200) can also be used to change parameters such as due date and payment method for each invoice. Note that the proposal is not automatically updated, so if you adjust invoices, you must create a new proposal in (ARS140).