One moment please...
 
 
Exact Financials (v3)   
 

CRD_OUTSTAN_ALL

CRD_OUTSTAN_ALL (crd_nr,days,co,curr_code,outstan_type,check_on_curr,value)

Using this function you can include all outstanding items for which the number of outstanding days are more than a specified number of days.

Example

CRD_OUTSTAN_ALL(1010,30,100,USD,4,3,3)

As a result of the above function, the balances of all posted outstanding items of creditor 1010, older than 30 days with currency 'USD' are included.

Parameters

Description Explanation Value
Outstan_type Amount after entry in default currency. 1
Amount after posting in default currency. 2
Amount after entry in outstanding item currency. 3
Amount after posting in outstanding item currency. 4
Total of the credit surcharge/discount. 5
Original amount outstanding item. 6
Sum of exchange rates of the outstanding items. 7
Number of outstanding items. 8
Check_on_curr Only items with the currency code you entered in curr_code. 1
All items regardless of currency code. 2
All items recalculated according to the currency code you entered in curr_code. 3
Value The debit total. 1
The credit total. 2
The balance. 3
The total of values is only shown when it is positive. 4
The total of values is only shown when it is negative. 5
The amount (entered on the outstanding item)is shown. 6


Excel Add-In contents | Alphabetical overview parameters

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 01.206.759
 Assortment:  Date: 11-03-2005
 Release:  Attachment:
 Disclaimer