By using this website, you agree to our Terms of Use (click here)
Hi Everyone,
I am working on a project for a client who has to export data out of Acumatica to their mothership who is running Oracle Essbase. They need their trial balance numbers and need them to be formatted extremely specifically in order to be compatible with Essbase. The easiest way I have found to accomplish this is by creating a GI that has the fields formatted the way they need them and then creating an export scenario to give us the CSV file with the correct delimiters.
However, I have run into a problem. For whatever reason, my GI is only showing accounts that have transactions for that month so not all accounts are represented even if they have an ending balance. If anyone has some tips, that would be great. I am putting screenshots of my GI as well as my tables/joins in case the problem could be fixed there.
Additionally, if you know whether or not it is possible to run an export scenario using a report, that may be an easier way to accomplish this. I have tried but have not had luck.
Thank you in advance!
