Show TOC

Procedure documentationWorking with the Account Balance

Procedure

You want to:

Proceed as follows:

Important information:

See which items are still open

Select open items only, for example, sorted by due date.

See which items are cleared

Select cleared items only.

Cleared items must already be activated. Data from the archive is not displayed.

See the remaining amount of a receivable

Include the Open Residual Amount field (OBETH) next to the Total Amount field (GBETH) in the line layout.

See partial payments

Include the Partial Payment Number field (OPUPZ) in the line layout variant and specify that this variant is a line item variant

Even when only open items are to be selected, partial payments are read as well so that the original total amount of the item can be displayed unchanged.

See which invoices were cleared by which payments

Select open and cleared items. Use a variant with the field Clearing Document Number (AUGBL) and sort or total according to this field.

The total of all invoices and clearings with the same clearing document number is zero.

Display payment data

Choose a list type with the With Cleared Items indicator.

A clearing item is simulated and displayed for each paid item. These items do not physically exist. The payment document does not have business partner items. These items are indicated in the Clearing field (XZAHL) if you include it in the variant.

Display zero clearing

Set the parameter 820 (Zero Clearing) in the user parameters. This integrates zero clearing into the basic list as standard.

Choose the function Start of the navigation path Settings Next navigation step Zero Clearing Next navigation step Hide/Show End of the navigation path.

As standard, zero clearing is hidden.

Hide reversals

Choose Start of the navigation path Settings Next navigation step Hide End of the navigation path in the menu for account balance display.

This allows you to hide all reversed documents and the corresponding reversal documents. This only applies to line layout variants of the type line item variant.

Display debit and credit amounts in different columns

Select the Debit Local Currency (SBTRH) field or similar fields for credit entries in the line layout variant.

Define a hierarchy of line layout variants.

Define the totals variants with follow-on variants.

Example Example

S10 Partner/account

S11 Partner/account/due date

S12 Partner/account/due date/document

End of the example.

If you set parameter 812, the variant hierarchy will appear in the upper part of the list. This allows you to skip variants in a totals variant hierarchy that has more than two levels. If you set parameter 810, the last active tab page is given as the default the next time the transaction is chosen.

In the line layout, you can define a Pointer field (POINT) as the first field of the variant. Click on this field to display the items of the selected lines in the next lowest variant.

Show the clearing history of an item which could not be collected despite multiple attempts

Define a variant with the field Document Number. To display the clearings for this item, position the cursor and choose Clearing History. If returns have occurred, you can include the data from the returns history in the line layout. The system displays the data for the last return.

Choose Start of the navigation path Environment Next navigation step Returns History End of the navigation path to access the general display of all returns for the business partner or contract account (not document-specific).

See which items were originally paid by a payment that was reversed

Switch from the account balance to the document display. In document display choose Items Cleared Earlier.

Show bank data for a payment

If the payment was entered with a payment lot or payment run, you can branch to the payment lot item or payment run data by choosing Start of the navigation path Environment Next navigation step Bank Data End of the navigation path.

Show payment transactions

Choose the Payment List tab page.

Display a chronological list of transactions for the account

Choose the Chronology tab page.

Display which other accounts the business partner has

Choose Navigation.

Display archived items

To display items from the archive, select the With Archive parameter in the Further Selections group box on the account balance initial screen.

To be able to show archived items in the display, you have to choose a line layout variant that contains the Item Archived (XARCH) field. (See Customizing for Contract Accounts Receivable and Payable under Start of the navigation path Basic Functions Next navigation step Account Balance Display Next navigation step Define Line Layout Variants for Account Balance End of the navigation path).

Send a payment form to a business partner

From the menu in the account balance display choose Start of the navigation path Environment Next navigation step Create Payment Form End of the navigation path. A dialog box appears in which you can change the amount. As standard the amount field contains the total of the open items displayed. You can also debit the business partner with charges for sending correspondence.

The system creates the correspondence type payment form (0022). You can either print all displayed items individually or as a total. For more information, see Creating Payment Forms from the Account Balance

Display the archived document/SD billing document for an SD document

Place the cursor on the SD document in account balance display. Choose Invoice.

If the SD document has been optically archived in SAP ArchiveLink, the archived document is displayed. If the document does not exist in SAP ArchiveLink or the archived document cannot be displayed, the system displays the SD billing document (transaction VF03).

Display the original document from the Accounting interface for any FI-CA document

Place the cursor on the corresponding document in account balance display. Choose Invoice.

If an original document exists for the selected document, the system displays it.

In case of expiring currencies, display the transaction currency amounts of the document items in the successor currency

In Customizing for Contract Accounts Receivable and Payable under Start of the navigation path Business Transactions Next navigation step Define Alternative Currencies End of the navigation path, specify the successor currency for the company code group <SPACE> and for the process Account Balance as the alternative currency (successor currency) as of a certain date. The comparison value for this date is the current date.

In addition, by setting the SPA/GPA parameter 8XC, you can have the system display a checkbox field on the initial screen of the account balance that you can use to switch the currency translation on and off. If you add the parameter in the user master record with the value SPACE, then the checkbox field becomes visible and by default, the checkbox is not selected. If you add the parameter in the user master record with the value X, then the checkbox field becomes visible and by default, the checkbox is selected. If you deselect the checkbox, you can display the document amounts in the original currency they were posted in.

The system converts business partner items and G/L items into the successor currency.

Note Note

The Display -> Change function is inactive if the amounts are displayed in the successor currency.

End of the note.

Information About Installment Plans

You want to:

Proceed as follows:

Important information:

Display installment plan items for a specific installment plan

On the initial screen, enter the installment plan and choose a list type that has the indicator Installment Plan Item in the area Statistical Items.

Display the source receivables for an installment plan

Place the cursor on the display of the installment plan items and choose Start of the navigation path Environment Next navigation step Original Receivables End of the navigation path. Or, on the initial screen, in the list type choose the document type Original Item for Installment Plans and specify the installment plan number.

Original receivables are normally not displayed in the account balance. In the totals section, the original receivables do not form part of the open receivables. The original receivables are displayed with the line layout that you defined in the default values for the account balance under the caller SAPLFKL9 and the RATPL function (see Customizing for Contract Accounts Receivable and Payable under Start of the navigation path Basic Functions Next navigation step Account Balance Display Next navigation step Define Proposal for Line Layout End of the navigation path).

Information About Collective Bills

You want to:

Proceed as follows:

Important information:

Display the line items of a collective bill

Enter the collective bill.

The original receivables are displayed with the line layout that you defined in the default values for the account balance under the caller SAPLFKL9 and the SAMMR function (see Customizing for Contract Accounts Receivable and Payable under Start of the navigation path Basic Functions Next navigation step Account Balance Display Next navigation step Define Proposal for Line Layout End of the navigation path).

Display the original receivables for a collective bill

Position the cursor on the relevant item in the collective bill item display and choose Start of the navigation path Environment Next navigation step Original receivables for collective bills End of the navigation path