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.