Reference Attribute values in Mapping Script
SummaryReference Attribute values in Mapping Script
Loading GL balances data using a file into FCCS. I want to flip the sign of Liability (L), Owner's Equity (O) and Revenue (R) amounts. The Account Type is stored in Attribute1 field. How can I achieve this using Data Management?
I tried the "change sign" on Account Dimension mapping, but this doesn't seem to work. Seems like it works if you are pulling data directly from ERP cloud. Can I reference the Attribute 1 column in the mapping script? And flip the amount sign by checking if Attribute1 in ('L','R','O')?