I am integrating an application with QuickBooks Enterprise 2016. I'm using the CData ADO.net provider component to handle the majority of the integration. This component does NOT support running the Available Serial Numbers report in QuickBooks (Reports > Inventory > Serial Numbers in Stock). I need to be able to run this report programmatically, on demand.
Examples solutions may be:
1) Using the QBSDK to run the report
2) Using a command line command to run the report and export to CSV
3) Some other technique
This job consists of finding a working solution to run the report and export the results to CSV file. The use of screen manipulation tools will be acceptable only if they use Windows messages or other win32 handle/message solution (i.e. no XY automated mouse clicks). A first-class solution using support methods (e.g. SDK, command line, plugin, etc.) are preferred over macro hacks.
Optionally, I may want to have you implement the solution as a durable, highly reliable application that can listen for requests from clients (nothing requiring IIS or http - sockets or similar only), handle the request (i.e. invoke the report, save to local disk, digest CSV file) and return to calling application. QuickBooks will be running in a Windows Server 2012 session on a terminal server. To prove you have actually read this job description be sure to start your response with the magic word: eclectic. There will be an auto-logged on AD user session to host QuickBooks (it cannot be run as a service). Any solution needs to work in this environment to be viable.