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 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
- Print Amounts in Invoice Currency also
-
If this check box is selected, LN prints the amounts in invoice currency also.
- Print Linked Documents 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
-
- Normal Invoices
-
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.
- Fully Paid Invoices
-
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 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 Other Documents to be Printed. under
- 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
-
- Advance Receipts
-
If this check box is selected, the aging analysis includes advance receipts.
- Unallocated Receipts
-
If this check box is selected, the aging analysis includes unallocated receipts.
- Anticipated Receipts
-
If this check box is selected, the aging analysis includes anticipated receipts.
- Trade Notes
-
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.