This means it returns the sum of the balances for 100.1, 100.2 etc. It evaluates only map numbers matching the mapping mask of the map number provided.
ACT("AR:ADJF","121") returns the reclassifying adjustments-only forecast balance for account 121.ACT("AN:ADJB","114") returns the normal adjustments-only budget balance for account 114.You can use an ADJ modifier element to return only the adjustments value for the balance type selected. MAP("BR:OBA","102") includes the other basis adjustments in the balance for account 102.MAP("AB","102") returns the other basis adjustment only for account 102.MAP("AN:YR0","111") returns the total of normal adjusting journal entries to map number 111.MAP("YR2","111") returns the consolidated balance because the TYPE element was not specified.MAP("BA:YR2","111") returns the adjusted balance.U, A, R, or C may be used to specify the adjustment type, meaning the BBU element would link to the unadjusted balance budget, or BFA would link to the normal adjusted forecast balance. Note: Functionality of the BB and BF elements are further modifiable with a third letter to specify the adjustment type, similar to the standard balance. If a type is not specified, the default balance used is "BC" (consolidated balance). The element representing the type of balance or adjustment to use.īalance consolidated (normal+ reclassifying + eliminating)īalance consolidated + "Tax - Federal Adjustments"īalance consolidated + "Tax - State Adjustments"īalance consolidated + "Tax - City Adjustments" ACT("BR:PER4:YR0","200") returns the balance report for period 4 of the current year for account 200.The following value consists of the TYPE, PERIOD, and YEAR elements: The syntax is as follows:įUNCTION("Sign","Value","Account Number") It can consist of several elements separated by colons. You are here: Features > Calculations > Values > Values Values
0 kommentar(er)
