Páginas filhas
  • FINR133 - Aging

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

FINR133 - Aging

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:

  1. In the Financial Module menu, select Reports > Accounts Receivable > Aging.
  2. To configure the data to be printed in the report, select Other Actions > Parameters.
  3.  Upon selection, the system displays a screen with fields for selecting data.
  4.  Fill out the parameters according to the field help instructions and confirm them.
  5. 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

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="

1

" ac:macro-id="8cd949c2-5192-4488-82a5-66c68e77f7f9"><ac:plain-text-body><![CDATA[

1

From customer ?

[Blank]

Initial customer code. Choose based on the bills customer code.

2

To Customer ?

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="9c0dca32-194f-49a9-b748-23f7eafec5fe"><ac:plain-text-body><![CDATA[

2

To Customer ?

[ZZZZZZ]

Final customer code. Choose based on the bills customer code.

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="a3432747-551e-43b3-9dac-79ee9bf93762"><ac:plain-text-body><![CDATA[

3

From Issue Date?

[ _//_ ]

Start issue date. Choose based on the bills issue date.

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="38cabc23-a5b4-45cd-9840-2e5d66616466"><ac:plain-text-body><![CDATA[

4

[ZZZZZZ]

Final customer code. Choose based on the bills customer code.

3

From

To

Issue Date?

[ _//_ ]

End

Start issue date. Choose based on the bills issue date.

4

To Issue Date?

]]></ac:plain-text-body></ac:structured-macro>

[ _//_ ]

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<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d99b02ff-d7c9-44bf-ab8d-94b328020ae0"><ac:plain-text-body><![CDATA[

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".

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f78296ed-8390-4b7b-9b2b-0662718235a7"><ac:plain-text-body><![CDATA[

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.

]]></ac:plain-text-body></ac:structured-macro>

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.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2b0b8e03-b206-48e2-8299-ebd0ab6e76da"><ac:plain-text-body><![CDATA[

9

Interval ?

[ZERO]

If the content of field 8 is other than "Entered", and this field's content is greater

than zero,
]]></ac:plain-text-body></ac:structured-macro>

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:

/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

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

1

000001

NF

01/1/2015

03

01/1/2015

03

01/1/2015

100.00

0.00

04

02

01

TST

000001

4

2

000001

NF

01/1/2015

04

02/1/2015

04

02/1/2015

100.00

0.00

05

03

01

TST

000001

5

3

000001

NF

01/1/2015

05

03/1/2015

05

03/1/2015

100.00

0.00

06

04

01

TST

000001

6

4

000001

NF

01/1/2015

06

04/1/2015

06

04/1/2015

100.00

0.00

07

05

01

TST

000002

000001

1

5

000002

000001

NF

07

01/1/2015

07

05/1/2015

_

05/1/

___

2015

100.00

100

0.00

08

06

01

TST

000002

000001

2

6

000002

000001

NF

07

01/1/2015

08

06/1/2015

_

06/1/

___

2015

100.00

100

0.00

09

07

01

TST

000002

3

1

000002

NF

07/1/2015

09

07/1/2015

_//___

100.00

100.00

10

08

01

TST

000002

4

2

000002

NF

07/1/2015

10

08/1/2015

_//___

100.00

100.00

11

09

02

01

TST

000001

000002

1

3

000001

000002

NF

07/1/2015

07

09/1/2015

_//___

100.00

100.00

12

10

03

01

TST

000001

000002

1

4

000001

000002

NF

07/1/2015

07

10/1/2015

_//___

100.00

100

.00

 

 

 

 

 

 

 

 

 

Totals

1,200

.00

600

100.00

...

11

Sequence

02

Question

TST

Answer

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b9734485-9424-4d54-942e-1c976038c881"><ac:plain-text-body><![CDATA[

1

From customer ?

[Blank]

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="3d96e35f-e340-4e1d-a391-521fa9bdef6e"><ac:plain-text-body><![CDATA[

2

To Customer ?

[ZZZZZZ]

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="944742b1-0d22-42d3-852f-17f6366f0258"><ac:plain-text-body><![CDATA[

3

From Issue Date?

[7/1/2015]

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="1724c05c-e2de-4390-b322-e132422a4c2a"><ac:plain-text-body><![CDATA[

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]

]]></ac:plain-text-body></ac:structured-macro>

5

Report ?

1 = Detailed

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d486951c-3258-47d9-9f44-49e7d3124db2"><ac:plain-text-body><![CDATA[

1 = Detailed

6

Reference Date?

[7/01/2015]

]]></ac:plain-text-body></ac:structured-macro>

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

10/2/2015
A
11/1/2015

11/2/2015
A
12/1/2015

12/2/2015
A
01/1/2016

01/2/2016
A
02/1/2016

02/2/2016
A
03/1/2016

03/2/2016
A
04/1/2016

04/2/2016
A
05/1/2016


Subsequent
05/2/2016

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

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

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

100.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.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".
Image Removed