Introduction

The "Aging" report aims to display the bills receivable portfolio divided between periods according to their actual due dates. Bills are selected by issue date, but the calculation displayed in the intervals is by due date. Up to 10 interval periods can be configured.

This report presents the status of the customer's debt based on an interval. The maximum interval is of 360 days, considering 180 days before the reference date, and 180 days after the reference date. The difference between "aging" and account status is that aging shows what was the customer's balance on the due date by checking the bill's posting date.

The entire portfolio of receivables within the chosen issuance period will be analyzed, and its condition is changed daily.

Simple view

Two customers are up to date with their debts. One of them paid the respective debts on due date; the other delayed a few payments. With "aging", it is possible to view the delay of customer 2.

Procedures

To issue the FINR133 - Aging report:

In the Financial Module menu, select Reports > Accounts Receivable > Aging.
To configure the data to be printed in the report, select Other Actions > Parameters.
Upon selection, the system displays a screen with fields for selecting data.
Fill out the parameters according to the field help instructions and confirm them.
Configure the printing and confirm it.

Tables Used

Table	Description
SA1	Customer
SE1	Accounts Receivable
SE5	Bank Transaction

"FIR133" Question Group

Seq	Question	Content	Description
1	From customer ?	[Blank]	Initial customer code. Choose based on the bills customer code.
2	To Customer ?	[ZZZZZZ]	Final customer code. Choose based on the bills customer code.
3	From Issue Date?	[ _//_ ]	Start issue date. Choose based on the bills issue date.
4	To Issue Date?	[ _//_ ]	End issue date. Choose based on the bills issue date. To select bills, the smallest date between the one entered in this field, the base date of the system, or the reference date, is used; this date is called the "End Date".
5	Report ?	1=Detailed;2=Summarized	Select:- Detailed if you want to list the bills- Summarized if you only want to total the bills
6	Reference Date?	[ _//_ ]	Enter the initial reference date of the period to be selected. To select bills, the smallest date between the one entered in this field, the base date of the system, or the date entered in parameter 4, is used; this date is called the "End Date".
7	Previous Period?	[ZERO]	The number of columns before reaching the reference date column.
8	Type of Interval?	1=Days;2=Months;3=Entered	Days = The interval period between the 10 periods will be in days; Months = The interval period between the 10 periods will be in months; Entered = The interval period between the 10 periods will be entered by the user.
9	Interval ?	[ZERO]	If the content of field 8 is other than "Entered", and this field's content is greater than zero, it will be used to define the interval between the 10-period range.
10	Currency?	"Currency 1", "Currency 2", "Currency 3", "Currency 4", or "Currency 5".	Enter the currency of the bills you wish to list.
11	Other currencies?	1=Convert;2=Ignore	Indicate whether you want only bills with the same currency selected in field 10 by choosing "Convert", or bills in any currency using "Ignore".
12	Separate Checks?	1=Yes; 2=No	"Yes" or "No" on whether to separate values referring to checks
13	Convert values by?	1= Rate of the day 2=Trans. rate	The following selection will use the currency defined in field 10 in the following manner: Rate of the day - If chosen, will use the reference date (field 6) for converting valuesTransaction rate - If chosen, will use the existing rate on the bill if it exists, otherwise the currency value on the date of issuance.
14	Select Branches?	1=Yes; 2=No	This defines if the user wishes to select the branches

When parameter 8 (Type of Interval) is set to "Entered", the group of questions "FI133B" is displayed as below:

Sequence	Question	Content
1	Interval Date 01?	_//___
2	Interval Date 02?	_//___
3	Interval Date 03?	_//___
4	Interval Date 04?	_//___
5	Interval Date 05?	_//___
6	Interval Date 06?	_//___
7	Interval Date 07?	_//___
8	Interval Date 08?	_//___
9	Interval Date 09?	_//___
10	Interval Date 10?	_//___
11	Interval Date 11?	_//___

Each content will be used to fill in the editable columns header from Positions 7 to 18.

USE CASES

Base date: 07/01/2015Branch: Company 01 / Branch 01 - Matrix

Bills Receivable:

Sequence	Branch	Pref	Number	Pair	Customer	Tip	Issue date	Actual due date	Posting Dt.	Value (BRL)	Balance (BRL)
01	01	TST	000001	1	000001	NF	01/1/2015	01/1/2015	01/1/2015	100.00	0.00
02	01	TST	000001	2	000001	NF	01/1/2015	02/1/2015	02/1/2015	100.00	0.00
03	01	TST	000001	3	000001	NF	01/1/2015	03/1/2015	03/1/2015	100.00	0.00
04	01	TST	000001	4	000001	NF	01/1/2015	04/1/2015	04/1/2015	100.00	0.00
05	01	TST	000001	5	000001	NF	01/1/2015	05/1/2015	05/1/2015	100.00	0.00
06	01	TST	000001	6	000001	NF	01/1/2015	06/1/2015	06/1/2015	100.00	0.00
07	01	TST	000002	1	000002	NF	07/1/2015	07/1/2015	_//___	100.00	100.00
08	01	TST	000002	2	000002	NF	07/1/2015	08/1/2015	_//___	100.00	100.00
09	01	TST	000002	3	000002	NF	07/1/2015	09/1/2015	_//___	100.00	100.00
10	01	TST	000002	4	000002	NF	07/1/2015	10/1/2015	_//___	100.00	100.00
11	02	TST	000001	1	000001	NF	07/1/2015	07/1/2015	_//___	100.00	100.00
12	03	TST	000001	1	000001	NF	07/1/2015	07/1/2015	_//___	100.00	100.00
									Totals	1,200.00	600.00

Parameters entered:

Sequence	Question	Answer
1	From customer ?	[Blank]
2	To Customer ?	[ZZZZZZ]
3	From Issue Date?	[7/1/2015]
4	To Issue Date?	[7/31/2015]
5	Report ?	1 = Detailed
6	Reference Date?	[7/01/2015]
7	Previous Period?	0
8	Type of Interval?	1=Days
9	Interval ?	1
10	Currency?	Currency 1
11	Other currencies?	1=Convert
12	Separate Checks?	2=No
13	Convert values by?	1= Rate of the day
14	Select Branches?	2=No

Details:

1 and 2 - Is the range of customers, by code (all customers);3 and 4 - Is the range of bills issued (securities issued from 07/01/2015 to 07/31/2015);5 - Detailed Mode will show details of the bills

6,7,8 and 9 - Will shape the header of the columns with dates and the rows with bills values

10 - Set to use "currency 1"11 - Select only the bills with "currency 1".12 - List also the checks 13 - Use the value of "currency 1" on the reference date14 - Select only bills of the current branch (Company 01 / Branch 01)

Check below:

The previous selection will result:

Fixed columns header: Positions (1) Ori Branch, (2) Actual due date, (3) Type, (4) Prefix, (5) Bill No., (6) Installment, (19) Balance, and (20) TPSALDO

Ori Branch	Actual due date	Type	Prefix	Bill No.	Installment	Columns 7...18	Balance	TPSaldo
01	07/1/2015	NF	TST	000002	1	...	0.00	D
01	08/1/2015	NF	TST	000002	2	...	100.00	D
01	09/1/2015	NF	TST	000002	3	...	100.00	D
01	10/1/2015	NF	TST	000002	4	...	100.00	D

Editable columns header: Positions 7 to 18

To 07/1/2015	07/2/2015 A 07/2/2015	07/3/2015 A 07/3/2015	07/4/2015 A 07/4/2015	07/5/2015 A 07/5/2015	07/6/2015 A 07/6/2015	07/7/2015 A 07/7/2015	07/8/2015 A 07/8/2015	07/9/2015 A 07/9/2015	07/10/2015 A 07/10/2015	07/11/2015 A 07/11/2015	Subsequent 07/12/2015
100.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	100.00
0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	100.00
0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	100.00

Explanation:

Parameter 6 ( Reference Date ) equal to 7/01/2015 sets the date to be displayed in the column. The column started on 07/01/2015 because parameter 7 is set to zero.

Note: Parameter 9 can contain 0 or 1. They will both have the same effect, making the interval equal to 1.

Using the parameter 8 for "days" and parameter 7 with different values:

Parameter 6	Parameter 7	Column 7	Parameter 6	Parameter 7	Column 7	Parameter 6	Parameter 7	Column 7
07/1/2015	0	07/1/2015	07/2/2015	07/2/2015	0	07/3/2015	0	07/3/2015
07/1/2015	1	06/30/2015	07/2/2015	07/1/2015	1	07/3/2015	1	07/2/2015
07/1/2015	2	06/29/2015	07/2/2015	06/30/2015	2	07/3/2015	2	07/1/2015
07/1/2015	3	06/28/2015	07/2/2015	06/29/2015	3	07/3/2015	3	06/30/2015
07/1/2015	4	06/27/2015	07/2/2015	06/28/2015	4	07/3/2015	4	06/29/2015
07/1/2015	5	06/26/2015	07/2/2015	06/27/2015	5	07/3/2015	5	06/28/2015
07/1/2015	6	06/25/2015	07/2/2015	06/26/2015	6	07/3/2015	6	06/27/2015
07/1/2015	7	06/24/2015	07/2/2015	06/25/2015	7	07/3/2015	7	06/26/2015
07/1/2015	8	06/23/2015	07/2/2015	06/24/2015	8	07/3/2015	8	06/25/2015
07/1/2015	9	06/22/2015	07/2/2015	06/23/2015	9	07/3/2015	9	06/24/2015
07/1/2015	10	06/21/2015	07/2/2015	06/22/2015	10	07/3/2015	10	06/23/2015

Note: - The maximum value to be considered in parameter 7" is 10. If a number over 10 is selected, it will still consider the value 10.

Using parameter 8 for "months":

Editable columns header: Positions 7 to 18

To 07/1/2015	07/2/2015 A 08/1/2015	08/2/2015 A 09/1/2015	09/2/2015 A 10/1/2015
100.00	0.00	0.00	0.00
0.00	100.00	0.00	0.00
0.00	0.00	100.00	0.00
0.00	0.00	0.00	100.00

Using the parameter 8 for "months" and parameter 7 with different values:

Parameter 6	Parameter 7	Column 7	Parameter 6	Parameter 7	Column 7	Parameter 6	Parameter 7	Column 7
07/1/2015	0	07/1/2015	07/2/2015	07/2/2015	0	07/3/2015	0	07/3/2015
07/1/2015	1	06/1/2015	07/2/2015	06/2/2015	1	07/3/2015	1	06/3/2015
07/1/2015	2	05/1/2015	07/2/2015	05/2/2015	2	07/3/2015	2	05/3/2015
07/1/2015	3	04/1/2015	07/2/2015	04/2/2015	3	07/3/2015	3	04/3/2015
07/1/2015	4	03/1/2015	07/2/2015	03/2/2015	4	07/3/2015	4	03/3/2015
07/1/2015	5	02/1/2015	07/2/2015	02/2/2015	5	07/3/2015	5	02/3/2015
07/1/2015	6	01/1/2015	07/2/2015	01/2/2015	6	07/3/2015	6	01/3/2015
07/1/2015	7	12/1/2014	07/2/2015	12/2/2014	7	07/3/2015	7	12/3/2014
07/1/2015	8	11/1/2014	07/2/2015	11/2/2014	8	07/3/2015	8	11/3/2014
07/1/2015	9	10/1/2014	07/2/2015	10/2/2014	9	07/3/2015	9	10/3/2014
07/1/2015	10	09/1/2014	07/2/2015	09/2/2014	10	07/3/2015	10	09/3/2014

Using parameter 8 as "days" and varying the content of parameter 9 (interval ):

Editable columns header: Positions 7 to 18

Using parameter 9 (Interval) = 5

To 07/1/2015	07/2/2015 A 07/6/2015	07/7/2015 A 07/11/2015	07/12/2015 A 07/16/2015	07/17/2015 A 07/21/2015	07/22/2015 A 07/26/2015	07/27/2015 A 07/31/2015	08/1/2015 A 08/5/2015	08/6/2015 A 08/10/2015	08/11/2015 A 08/15/2015	08/16/2015 A 08/20/2015	Subsequent 08/21/2015

Using parameter 9 (Interval) = 10

To 07/1/2015	07/2/2015 A 07/11/2015	07/12/2015 A 07/21/2015	07/22/2015 A 07/31/2015	08/1/2015 A 08/10/2015	08/11/2015 A 08/20/2015	08/21/2015 A 08/30/2015	08/31/2015 A 09/9/2015	09/10/2015 A 09/19/2015	09/20/2015 A 09/29/2015	09/30/2015 A 10/9/2015	Subsequent 10/10/2015

Using parameter 9 (Interval) = 20

To 07/1/2015	07/2/2015 A 07/21/2015	07/22/2015 A 08/10/2015	08/11/2015 A 08/30/2015	08/31/2015 A 09/19/2015	09/20/2015 A 10/9/2015	10/10/2015 A 10/29/2015	10/30/2015 A 11/18/2015	11/19/2015 A 12/8/2015	12/9/2015 A 12/28/2015	12/29/2015 A 01/17/2016	Subsequent 01/18/2016

Using parameter 8 as "Entered", the system ignores parameter 9 and requests all the dates to be considered.

Sequence	Question	Content
1	Interval Date 01?	07/1/2015
2	Interval Date 02?	07/16/2015
3	Interval Date 03?	08/1/2015
4	Interval Date 04?	08/16/2015
5	Interval Date 05?	09/1/2015
6	Interval Date 06?	09/16/2015
7	Interval Date 07?	10/1/2015
8	Interval Date 08?	10/16/2015
9	Interval Date 09?	11/1/2015
10	Interval Date 10?	11/16/2015
11	Interval Date 11?	12/1/2015

Editable columns header: Positions 7 to 18

To 07/1/2015	07/2/2015 A 07/16/2015	07/17/2015 A 08/1/2015	08/2/2015 A 08/16/2015	08/17/2015 A 09/1/2015	09/2/2015 A 09/16/2015	09/17/2015 A 10/1/2015	10/2/2015 A 10/16/2015	10/17/2015 A 11/1/2015	11/2/2015 A 11/16/2015	11/17/2015 A 12/1/2015	Subsequent 12/2/2015

Note: - It is mandatory that one of the 11 dates is equal to the content of parameter 6 (Reference Date). In this example, it is the "Interval Date 01".

Páginas filhas

FINR133 - Aging

Introduction

Simple view

Bills Receivable: