Exact Globe+

Excel Add-in: explanation function DEB_OUTSTANDING

Introduction

With the [DEB_OUTSTANDING (deb_nr;entry_nr;co;outstan_type;value)] function you can include the information from a specific outstanding item in the worksheet.

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

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

Entry number
Enter the entry number of the outstanding item.

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

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

DEB_OUTSTANDING("1200";"108";17;6;3)

The result displayed in the worksheet is the balance of the original amount of the outstanding item with entry number 108, for debtor 1200 in company 17.