Hi all, 

I’m currently working on uploading bank reconciliation to IFS via External File Template and have run into an issue with selecting selecting the appropriate debit/credit value based on which one isn’t null. I had this working for a few weeks, but stopped working altogether yesterday. 

I had these two strings set up to read in the debit and credit values 

Then I had a separate column which would convert to numbers, and pick the appropriate value based on which wasn’t null. 

When I try to upload via External File Assistant, I don’t receive an error and it’s picking up the values for Transaction Info 3 & 4, but isn’t setting a value in the separate column.