Slide 1

Slide notes: In this tutorial we will consider the AP Creditors Ageing Report options.

 

 

 

Slide 2

Slide notes:

 

 

 

Slide 3

Slide notes: We select it from Reports at the Creditors menu.

 

 

 

Slide 4

Slide notes: First, we look at the About information. It is important to understand that the AP Creditors Ageing is always performed in real-time.

 

 

 

Slide 5

Slide notes: There are Actual and Accrual options, and also an Open Item Detail option. Ageing is best performed at the appropriate time. In other words, when we want an accurate Ageing View for December 2009, then it should be performed at the end of that Period or immediately thereafter. If we need this information for later use, then it should be published in the Report Warehouse to preserve the view for future use. Although the system will allow Ageing Summaries to be performed for prior Periods, and will have the Balances accurately presented, it cannot produce the Ageing Open Item Detail accurately at a later date if some matching has been performed in the meantime.

 

 

 

 

Slide 6

Slide notes:

 

 

 

Slide 7

Slide notes: Next, we look at the Ageing Summary Options.

 

 

 

Slide 8

Slide notes: There are 2 primary Ageing Summary format options. We can perform the Ageing on the Actual basis or on the Accrual basis. Accrual means that the "Committed" column is present and is included in the final Balance.

 

 

 

Slide 9

Slide notes:

 

 

 

Slide 10

Slide notes:

 

 

 

Slide 11

Slide notes: So for this example, we will use the Accrual basis.

 

 

 

Slide 12

Slide notes: We can include only Local Currency Accounts, or only selected Forex Accounts, or a mix of these in the same Report.

 

 

 

Slide 13

Slide notes:

 

 

 

Slide 14

Slide notes: The Period will default to the current Period, and although this can be changed to a prior Period, we note that any matching that has been performed since that Prior Period will impact on the results of the Ageing.

 

 

 

Slide 15

Slide notes: The base date is defaulted to today, and the correct date to select should normally be the last day of the Period that we have selected.

 

 

 

Slide 16

Slide notes: The standard Ageing indicators can be changed if necessary, and will be applied for the current execution of the Report.

 

 

 

Slide 17

Slide notes:

 

 

 

Slide 18

Slide notes: Next, we can still select a specific Account Range, or else use the wild card indicators to select all Accounts from the Group we selected, i.e. from Local, Forex or a mix of Accounts.

 

 

 

Slide 19

Slide notes:

 

 

 

Slide 20

Slide notes: Note that the Accrual basis starts with the Committed column before listing the Ageing columns.

 

 

 

Slide 21

Slide notes:

 

 

 

Slide 22

Slide notes: And the final column is the Accrual Balance.

 

 

 

Slide 23

Slide notes:

 

 

 

Slide 24

Slide notes: The detail of the Ageing Open Items are available for Accounts managed on the 'open item' basis, whereas Accounts managed on the 'balance forward' basis may only list a balance entry.

 

 

 

Slide 25

Slide notes: When producing the Open Item Detail Report, we can select an Account Range, and we can also select specific Currency types.

 

 

 

Slide 26

Slide notes: To select Accounts of a specific Currency, we can state that Currency, or we can use the wildcards for all Currencies.

 

 

 

Slide 27

Slide notes: For Local Currency only, we may state "local]" but it is important to include the closing wildcard to correctly select the standard Local Currency Accounts.

 

 

 

Slide 28

Slide notes:

 

 

 

Slide 29

Slide notes: The Open Item detail includes the Committed and Actual balances, plus the Open Amounts that represent the Actual Balance. Invoice and Purchase Order numbers are indicated as well.

 

 

 

Slide 30

Slide notes: