Hi there, Just wondering if anyone has built a database task or chain that runs daily that checks if the current date is the accounting period end date? If it is, I want to calculate an average currency rate.
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.
Looking for a bit of guidance here, my company is utilizing External File Template to upload our travel expenses made with company credit cards to the Credit Card Transactions in Aurena. Recently, we’ve come across a few transactions that contain a comma in them, which creates an error when trying to upload via External File Assistant. I would like to accomplish this using a Detail function for the column. I’ve included the problem transaction for reference - Cleared,1/3/2024,"ONLINE PAYMENT, THANK YOU",-500Error we’re getting - Would like to remove or skip comma from string utilizing one of these - I would appreciate any help or guidance on this.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.