FA_SUM ER function
The FA_SUM
function returns a Container (record) value that consists of data for the fixed asset amounts for the specified fixed asset item, value model code, and period of dates.
Syntax
FA_SUM (fixed asset code, value model code, start date, end date)
Arguments
fixed asset code
: String
A String value that represents the code of a fixed asset item that the balance is calculated for.
value model code
: String
A String value that represents the code of a value model that the balance is calculated for.
start date
: Date
A Date value that represents the start date of a period that the fixed asset amounts are calculated for.
end date
: Date
A Date value that represents the end date of a period that the fixed asset amounts are calculated for.
Return values
Container (record)
The resulting record value.
Example
FA_SUM ("COMP-000001", "Current", Date1, Date2)
returns the data container for fixed asset COMP-000001 that has been prepared for the Current value model and for a period from Date1 to Date2.