Excel Add-in: explanation function DEB_OUTSTAN_ALL

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

Debtor number
Select the debtor you want to have displayed in the report.

Days
Fill in the number of days for which you want to retrieve the outstanding items If you fill in 30, for example, only the outstanding items that have been outstanding for fewer than 31 days will be displayed. This is calculated as of the invoice date and not the due date.

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

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

Currency check
Select the value you want to have displayed. 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
Select the value you want to have displayed. 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

DEB_OUTSTAN_ALL(1200;30;17;"USD";4;3;3)

the results displayed in the worksheet are the balances the amounts older than 30 days for debtor 1200 in company 17. The balance is converted to US dollars.