This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi, does anyone understand what the `View Type` parameter does in BUILTIN.CONSOLIDATE?

We always use INCOME

```BUILTIN.CONSOLIDATE(
                    transactionAccountingLine.amount,
                    'INCOME',
                    'DEFAULT',
                    'DEFAULT',
                    ${subsidiaryId},
                    transaction.postingPeriod,
                    'DEFAULT'
                  )```

It's undocumented,  some speculation here: <https://www.reddit.com/r/Netsuite/comments/snh4oh/comment/ihbtgco/>

Thanks <@U029A7U3VMM>. I tried creating a workbook in the UI with both consolidated and original currency and exported the SuiteQL. Looks like NetSuite actually uses 'LEDGER' for the consolidated one (and for some reason still uses BUILTIN.CONSOLIDATE but with a target subsidiary of 0 for the original amount)

```/* original amount */

BUILTIN_RESULT.TYPE_CURRENCY(
	BUILTIN.CONSOLIDATE(TransactionAccountingLine.amount, 'INCOME', 'NONE', 'DEFAULT', 0, 0, 'DEFAULT'),
	BUILTIN.CURRENCY(BUILTIN.CONSOLIDATE(TransactionAccountingLine.amount, 'INCOME', 'NONE', 'DEFAULT', 0, 0, 'DEFAULT'))
) AS amount, 

/* consolidated amount */

BUILTIN_RESULT.TYPE_CURRENCY(
	BUILTIN.CONSOLIDATE(TransactionAccountingLine.amount, 'LEDGER', 'DEFAULT', 'DEFAULT', 3, 355, 'DEFAULT'),
	BUILTIN.CURRENCY(BUILTIN.CONSOLIDATE(TransactionAccountingLine.amount, 'LEDGER', 'DEFAULT', 'DEFAULT', 3, 355, 'DEFAULT'))
) AS amount_1```