Hello
I am in the process of building an account hierarchy in NSAW so one can drill from
L1 Account Area (e.g. P&L or Balance Sheet)
L2 Main Account Area (e.g. Gross Profit or Asset)
L3 Account Type (e.g. Income or Fixed Asset)
L4 Parent Account
L5 Account
I could build derived columns for L1 and L2 using Semantic Model Extension
With Data Augmentation I could bring in Parent account
It works, but it brings in the Account ID, which is not very user friendly
I could not see any option to bring in the account name
In NetSuite it is a standard field, pointing to the Account record
Is there a way in NSAW that one can either update the data augmentation to bring in the Parent Account name or add another field which is the parent account name?
The only way I can think of is adding a custom field in NetSuite that stores the parent account name and use Workflow to update this field. Then pull in this field using Data Augmentation.
Happy to hear if there is a better way
