Welcome to the Sage BusinessWorks Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
What is the link between the OESalesOrder table and OELineItem. I'm pulling the data via ODBC and trying to identify the key between the two tables. Any insight or documentation you can direct me towards would be greatly appreciated! (BW 2019)
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? …
I am trying to export the component list for parts within Business Works. There is no way to do this through the program, but was told you can do this through a query in excel. Does anyone have experience with this? Can someone provide steps to query…
I did some searching on your site and see that KB 39468 may assist in resolving this issue but cannot locate where your KB's are stored. And, if someone has insight into this error, please advise. Is this a firewall error or possible port issue?
FYI - Microsoft Office 2019 will default to 64 bit install unless specified.
I think BW still needs office in the 32bit for the integration?
https://support.office.com/en-us/article/choose-between-the-64-bit-or-32-bit-version-of-office-2dee7807…
I am making an ODBC connection from UPS WorldShip to BusinessWorks 2013. I am able to map most of the WorldShip values to BusinessWorks values in the ARInvoice table. I want to link the BW customer ID or number to UPS.
1. Does one of the values in…
I am customizing the Employee 401K List Report (it has been renamed but no fields have been deleted, just made invisible) and I am having trouble with adding a database field for selection. I get the message "The SQL statement that you have provided is…
