@Clarisa De Torres-Oracle yes. The last formula worked great. Any insight how to write the formula to reverse the sign for the Income Accounts but not for Expense Accounts as Customer is now looking for a P&L (including both Income, COGS and Expense Accounts).

@Clarisa De Torres-Oracle Thanks for that SuiteAnswer. I hadn't come across it previously, however, I am getting an error when I use the formula as written: MULTIPLY({transactionlines. accountingimpact.debit# CURRENCY_CONSOLIDATED}, -1) expecting STRING/CURRENCY/CURRENCY_HIGH_ PRECISION/PERCENT/DURATION/KEY as argument #1,…

Is this an Enhancement request or can we create one?

Either is fine, really. Not all assets will need a transaction, so I was trying to use a native translation functionality within the Name field, but didn't see any way to do that. If a separate field is the way to get this done, we can make that Custom field but I would rather use a translation, if possible.