Select GL account based on MEM entity
Carolyn asked 3 years ago
What is the best way to handle the following sceanrio for an AP transaction integration for a MEM environment:
I would like to include a condition to use a specific GL account for the distribution based on the entity. The entity is in the source document. Is there a way to look at the source file and add a conditional statement that if entity = 1001 then account = 1001-xxxxx Else, account = 1002-xxxxx?
I would like to include a condition to use a specific GL account for the distribution based on the entity. The entity is in the source document. Is there a way to look at the source file and add a conditional statement that if entity = 1001 then account = 1001-xxxxx Else, account = 1002-xxxxx?
Answers
Ethan Sorenson Staff answered 3 years ago
Carolyn,
SmartConnect has two ways of doing this.
SmartConnect has two ways of doing this.
- setup a Translation Table
- setup a Calculated Column using an if..else statement.