Anaplan formula to Lookup Balance Sheet description from mapping table module
Hi Anaplan Community
Please see email attachment with all details for my question.
I have an “Account Major Properties” module with a line item of “B/S Line Item” where I want to populate the valid Balance Sheet line name, from the list “Balance Sheet Lines – NEW”, based on the Account Major (e.g. GL Account) contained in Line Item “Account Code”.
This line item is formatted with a list called “Balance Sheet Lines – NEW”
I also have a module called “Mapping: B/S Mapping” where I could pick up the B/S Line Item name based on the B/S Account Major line item.
My question is, what formula should I write in the line item “B/S Line Item” within the “Account Major Properties” module, to return the required Balance Sheet description (e.g. Bank, Petty Cash etc).