Exact Globe+

Excel Add-in: explanation of the CRD_OUTSTAN_ALL function

Introduction

With the [CRD_OUTSTAN_ALL (crd_nr;days;co;curr_code;outstan_type;check_on_curr;value)] function you can find all the outstanding items that are outstanding less then the number of days you specify.

Explanation of the fields

Company
Select the administration from which you want to retrieve the Exact data. If you select 'Default', the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.

The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.

Function
Select the function you want to use. In this case "CRD_OUTSTAN_ALL".

Creditor number
Select the creditor you want to have displayed in the report.

Days
Select the number of days outstanding for which you want the outstanding items to be displayed. If you fill in 30, for example, only the outstanding items that are less than 31 days old will be displayed. This is calculated as of the invoice date, rather than the due date.

Currency code
Select the currency in which you want the outstanding items displayed.

Type
Select which value you want to have displayed in the report. You have the following options:

Currency check
Indicate which value you want to have displayed in the report. You have the following options:

• Only items with the correct currency code (1).
• All outstanding items regardless of the currency code (2).
• All outstanding items converted to the specified currency code (3).

Value
Indicate the value you want to have displayed in the report. You have the following options:

• Debit (1): the total of the amounts debited
• Credit (2): the total of the amounts credited
• Balance (3): the balance of the total debit and total credit amounts
• Positive (4): same as the balance, but only positive amounts will be displayed
• Negative (5): same as the balance, but only negative amounts will be displayed (as positive values)

Example

CRD_OUTSTAN_ALL(1010;30;17;"USD";4;3;3)

The worksheet displays the balances after processing of all the outstanding items for creditor 1010 with 'USD' currency that have been outstanding for fewer than 30 days.