Skip to content


Select GL account based on MEM entity

Carolyn asked 4 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?
Ethan Sorenson Staff answered 4 years ago
SmartConnect has two ways of doing this.

  1. setup a Translation Table

  2. setup a Calculated Column using an if..else statement.


If you would like to submit an answer or comment, please sign in to the eOne portal.