Tuesday, October 21, 2008

Totaling Line Items

You can display a total of the G/L line items according to certain criteria.

  • You have two ways of doing this: From the G/L account: Display Line Items: Basic List screen, place the cursor on a line item in a column (such as document type) and choose Edit
  • ® Totalling.... The system totals the items according to a field you entered (for example, the document type).
  • To total line items using other fields, first place the cursor outside the line items and then select Edit
  • ® Summarize. A dialog box appears, and here you can select a summary variant (for example, Document type - posting key). To sort the items in descending order, select the field Descending.

You can also add a possible summary variant or change the possible summary variants. For additional information, read the FI System Administration Guide.

To add a variant, choose Options ® Customizing ® Totals variants.

When you select a totals variant, the system displays line item subtotals for the first field of the variant. You can then proceed as follows:

  • Select a specific set of line items in the first list level (totals by first field of variant) by clicking on the line in the screen. The next list level is displayed.

For example, if the totals variant is Document type - posting key, select the line for AB (general document) and choose Goto ® Next list level. The system then displays the subtotals for all documents based on the posting key within the document type AB.

  • To display debit or credit amounts of a sub total, choose Settings
  • ® Debit/credit on/off. To display the posted document in a different currency, choose Settings ® Display currency.... The system is able to display the document currency, the local currency, and possibly the additional local as defined for the company code. If you have selected the local currency or the group currency as an additional local currency, you can use this method to display the posted totals.
  • To go back to a previous level, choose Goto
  • ® Back.
  • To go directly from the totals screen to the list of line items, choose Goto
  • ® Line items from the menu bar. When you want to display subtotals of line items, choose Goto ® Line items+subtotal.

No comments:

Archive