Print Invoice-to Business Partner Aging Analysis (tfacr2420m000)

Use this session to print an aging analysis for the invoice-to business partners.

The aging analysis is printed for the period until the As on Date/Month field on the Options tab. This is the aging analysis date.

On the first tab, you must define your selection range.

On the second tab, you must:

  • Set several options to control the way the aging analysis is performed and printed.
  • Define the period range.
  • Specify the documents you want to include in the aging analysis. For example, doubtful invoices, fully paid invoices, or anticipated receipts.

You can print the transaction amount in the invoice currency if you select the Print Amounts in Invoice Currency also check box.

If a receipt schedule is linked to invoice, LN prints each receipt schedule line on a separate line.

Field Information

Selection
Settings
Home Currency

The home currency. Click the View Other Currencies command to change currencies.

Note: If you print the data for a range of companies, you can rotate currency only if the currency system of the group company to which your company belongs, is Independent.
Reporting Currency Group

reporting currency group

If this check box is selected, LN prints the amounts in invoice currency also.

If this check box is selected, LN also prints any documents that are linked to the invoices.

Use Euro Instead of EMU Currencies

If this check box is selected, amounts in EMU currencies are printed in euros.

Options
Options
Aging Analysis Code

Select the aging analysis code.

Default value

The aging analysis code selected in the ACR Parameters (tfacr0100s000) session.

Based on

The date on which the aging analysis is based.

Document Date

The document date of the invoice.

Due Date

The due date of the invoice.

Selection By

The basis on which the invoices are selected for the report.

Document Date

The printed balance is based on the document date, the date on which the invoice is created.

Fiscal Period

The printed balance is based on the fiscal period.

Documents to be included

If this check box is selected, the aging analysis includes all regular invoices.

Doubtful Invoices

If this check box is selected, the aging analysis includes doubtful invoices.

Additional options
Print Summary Only

If this check box is selected, only the subtotals appear in the aging analysis.

If this check box is selected, the aging analysis includes fully paid invoices.

Include Anticipated Receipts in Invoice Balance

If this check box is selected, anticipated payments are included in the appropriate purchase invoice balances, provided they belong to the specified selection.

Note: To print anticipated receipts, select Anticipated Receipts under Other Documents to be Printed.
Include Trade Notes in Invoice Balance

If this check box is selected, trade notes are included in the appropriate purchase invoice balances, provided they belong to the specified selection.

Note: 
  • This option refers to trade notes that do not have the Replace Invoice by Trade Note check box selected in the Trade Note Types (tfcmg0516m000) session. Trade notes with Replace Invoice by Trade Note selected are included in balances and printed on reports by default.
  • To print trade notes, select Trade Notes under Other Documents to be Printed.
From Which Receipt Procedure Step

If either Include Anticipated Receipts in Invoice Balance or Include Trade Notes in Invoice Balance is selected, indicate the procedure step starting from which the anticipated payments or trade notes must be included in the invoice balance.

Non-Due Documents

If this check box is selected, the aging analysis includes documents whose due dates are outside the aging analysis periods.

Other documents to be printed

If this check box is selected, the aging analysis includes advance receipts.

If this check box is selected, the aging analysis includes unallocated receipts.

If this check box is selected, the aging analysis includes anticipated receipts.

If this check box is selected, the aging analysis includes trade notes.

Note: This option refers to trade notes that do not have the Replace Invoice by Trade Note check box selected in the Trade Note Types (tfcmg0516m000) session. Trade notes with Replace Invoice by Trade Note selected are included in balances and printed on reports by default.
From Which Receipt Procedure Step

Select the Include Anticipated Receipts check box, to indicate the receipt procedure for the aging analysis report.

Allowed values

You can only select one of the following procedure steps:

  • Document Received
  • Document Accepted/Sent
Dates and Periods
As on Date/Month

Specify the aging analysis date. This is the date on which the aging analysis is based.

As on Date/Month

The year of the financial period in which the aging analysis is performed.

Period Separator

The separator between the year and the period.

As on Date/Month

The financial period in which the aging analysis is performed.

Last Invoice Date/Period

You must specify the last invoice date for the aging analysis if you have selected the Document Date option in the Selection By field.

The aging analysis is performed until the specified date.

Last Invoice Date/Period

You must specify the last invoice financial year if you select the Fiscal Period option in the Selection By field.

The aging analysis is performed until the end of the year.

Last Invoice Date/Period

You must specify the last invoice financial period if you select the Fiscal Period option in the Selection By field.

The aging analysis is performed until the end of the period.

Last Receipt Date/Period

You must specify the last invoice date for the aging analysis if you have selected the Document Date option in the Selection By field.

The aging analysis is performed up to and including this date.

Last Receipt Date/Period

If you selected Fiscal Period in the Selection By field, you can now specify the last receipt of the financial year in this field. The aging analysis is performed until the end of the period in the year that you specify in the Last Receipt Date/Period field.

Last Receipt Date/Period

If you selected Fiscal Period in the Selection By field, you can now specify the last invoice financial period in this field. The aging analysis is performed until the end of the period in the year that you specify in the Last Invoice Date/Period field.

Dimensions
Dimension Ranges
Dimension

If this check box is selected, you can specify the dimension range.

Sort By
Dimension Type

Select the dimension type by which the report must be sorted.