Skip to content
+1-888-319-3663

COMMUNITY FORUM

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?
 
 
Answers
Ethan Sorenson Staff answered 3 years ago
Carolyn,
 
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.