Create and Verify Statement of Account Proposal for a Payer in (ARS140)

Outcome

A proposal for a statement of account is created, listing all open invoices and drafts per currency for the selected payers/customers. These information are 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.

Before you start

• The starting conditions listed in Creating 'Open Item' Statement of Account for a Customer or Payer in (ARS140) must be met.

Follow these steps

Create Proposal

1. 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. These 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.

2. 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 specify it on the E panel.

3. On (ARS141/E), specify the end date of the range the statement will cover.

4. Specify a range of remittance statuses for drafts and invoices sent for factoring or direct debiting (optional).

5. 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.

   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).

6. Specify the method by which you want to group records in the printout:

   • 1 = Per customer
   • 2 = Per payer

7. Optionally, specify any of these ranges: 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.

8. Optionally, specify the minimum outstanding amount for a customer to be included in the statement.

9. Optionally, specify the report text to be printed on the proposal.

10. 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.

Verify Proposal

1. 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.

2. To check dubious records, select 'Accounts Receivable. Display' (ARS200) to view 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).