Edit

Share via


FA_BALANCE ER function

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The FA_BALANCE function returns a Container (record) value that consists of data for the fixed asset balance for the specified fixed asset item, value model code, reporting year, and reporting date.

Syntax

FA_BALANCE (fixed asset code, value model code, reporting year, reporting 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.

reporting year: Enumeration value

An enumeration value of the AssetYear application enumeration that defines a period for the balance calculation.

reporting date: Date

A Date value that defines a date for the balance calculation.

Return values

Container (record)

The resulting record value.

Example

FA_ BALANCE ("COMP-000001", "Current", AxEnumAssetYear.ThisYear, SESSIONTODAY ()) returns the data container of balances for fixed asset COMP-000001 that has been prepared for the Current value model on the current application session date.

Additional resources

Other (business domain–specific) functions