Able to use an IF statement in Integration Manager?

[35mph]

We have a file of GL journal entries (for Payroll transactions) that will have an account number that does not exist in our GL... oddly enough, this is by design.

Is there a way in Integration Manager to have it ask: "If the account number = xxx, then skip this record, then keep on going..."?

We don't really want it to simply skip any invalid account numbers because we would like it to validate as much data as possible.... we just need it to skip this one record that we know will be in the data file to be imported.

TIA...

 

[klewis10367]

Just allow for errors. Set your errors to 1. It will not import the invalid account, but it will allow for the integration to continue.

 

[35mph]

Sounds good... and simple. Thanks, we'll give that a try.