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.

Additional resources

Other (business domain–specific) functions