Hi - I have a client that would like to export A/R data from Sage 300 (specifically the Aged Trial Balance report) and upload it to my server (we are a SaaS provider). They have nearly 100 "companies" in Sage that they would like to do this for, and doing it manually would take an enormous amount of time and is not feasible, especially since this will be a recurring export (once a week, maybe). 

I'm trying to use the AccPacCOMAPI in a .bat file to automate the process of running that report for each company and saving it to XLSX. The problem is that I am in NY, and the client is in Singapore, so writing the script, testing it, tweaking it, etc. is getting really difficult due primarily to the time difference.

Is there anyone here who can help me? I would be willing to pay. Here are two potential ways that you could help:

1. If you have Sage 300 installed, and you are in NY (or near NY), I would love to spend some time on one of your PCs to test out my export script and try to perfect it. 

2. If you have a lot of experience with automating Sage 300, and you know how to use the AccPacCOMAPI from outside of Sage 300 (NOT in their macro - either in VB Script, or Powershell, or something else), then I would love for you to help me finalize the export script. you would need to have Sage 300 installed so that you can test it and confirm that it works.

Thanks!

Zach