Creating 'Open Item' Statement of Account for a Customer/Payer

This document explains how to create an 'open item' statement of account for one or more payers or customers according to user-defined selection criteria.

The term 'open item' refers to the fact that the statement only shows invoices that were unpaid or partially paid when the statement was created.

For information on the 'Balance Brought Forward' statement of account that can be created in 'AR Statement of Account. Print Detailed' (ARS510), refer to See Also.

Outcome

An 'open item' statement of account is created and printed, showing all unpaid accounts receivable invoices, including credit invoices, per payer or customer and currency. Recorded customer drafts are also included, depending on the selection criteria.

An age distribution of invoices that fall due within the period ranges you have defined can also be printed in 'buckets' along with totals.

You can display the invoices per statement of account number in 'Accounts Receivable. Display Additional Information' (ARS250) even after the statement of account itself is deleted in 'AR Statement of Account. Open' (ARS140).

You can send the statement of account to the payer(s) to help them reconcile their own account ledgers.

No new transactions are created. The statement of account has status 9 and cannot be processed further. It is saved in the following statement tables: FSTMT1 (listing name and status of all statements), FSTMT2 (listing payers), and FSTMT3 (listing invoices).

The statement of account automatically receives information category number 206 and is saved under its statement number.

The block or delete options, used to prevent specific invoices or payers from being included in the printed statement, only apply to the statement in question. Consequently, if you create a new statement of account based on the same selection criteria, invoices blocked or deleted in another statement will be included.

Before you start

Follow These Steps

  1. Create and Verify Statement of Account Proposal

    Create a proposal by defining a set of optional selection criteria in 'AR Statement of Account. Open' (ARS140). Review the proposal to make sure that the records are correct.

  2. Adjust Statement of Account Proposal

    If necessary, adjust the proposal by blocking or deleting payers or invoices in subprograms (ARS145) and (ARS146). This prevents them from being included in the final statement.

    You can also add or adjust text to be printed before and after the statement of account, or use user-defined comments that are automatically proposed. Enter or select the text in subprogram (ARS145).

  3. Create the Final Statement of Account

    After you have reviewed and adjusted the proposal, create and print the final statement of account by confirming the proposal in (ARS140).

  4. Send Statement of Account to the Payer

Related topics