Excel Add-in: explanation of the CRD_OUTSTANDING function

Introduction

With this function [CRD_OUTSTANDING (crd_nr;entry_nr;co;outstan_type;value)] you can enter the information for a specific outstanding item on 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 "CRD_OUTSTANDING".

Vendor
Select the creditor whose information you want to enter.

Entry number
Enter the entry number for the outstanding item.

Type
Indicate which value you want displayed. You have the following options:

• Amount 'after entry' in default currency (1).
• Amount after processing in default currency (2). 
• Amount 'after entry' in currency of the outstanding item (3).
• Amount after processing in currency of the outstanding item (4).
• Amount credit limit/discount (5).
• Original amount outstanding item (6).
• Exchange rate of the outstanding item (7).
• Number of outstanding items (8).
• Amount 'after entry' in secondary currency (9).
• Amount after processing in secondary currency (10).

Value
Indicate which value you want displayed. You have the following options:

• Debit (1): the total of the amounts entered as debit
• Credit (2): the total of the amounts entered as credit
• Balance (3): the balance of the debit total and credit total
• Positive (4): equal to the balance, but only positive values are displayed
• Negative (5): equal to the balance, but only negative values are displayed (as positive values) 
• Number (6): The total (as entered) is displayed

Example

CRD_OUTSTANDING("1010";"108";17;1;3)

This will result in display of the balance of the amount after entry in default currency of the outstanding item for creditor 1010 with entry number 108 from company 17.