Hi,
We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations.
We have a few questions:
Can we use SQL to set up an ODBC connection? …
Using Sage 100 ERP v2017. I am trying to run a very basic MS Excel query in order to build a database for our new website. Literally, all I am trying to get is the product part number, description and the name of the item image. My query is as follows…
I have the following Graphical query, the two tables are BPCUST AND SINVOICE.
How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018.
When I search for this its outputting all the invoices and duplicating…
Well, this has proven to be a bit of a wild goose chase so far!
I've had a few offline discussions with Richard Ridings as well, and I now have a query that works fine (thanks Richard!) - as long as it is run manually. I can run all three - manually…
I would like to construct an SQL query, which dumps to Excel, an analysis of the job costing for a range of jobs across three different organizations. All have virtually identical structures and naming conventions. There is not a ton of data to grab,…