• BWGAccess

    How do I obtain BWGAccess? Does it come standard as part of the BusinessWorks kit or is it a separate paid for application?
  • Table Mapping

    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)
  • ODBC Connections and Intergrations with Business Works

    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? …
  • Export Component List

    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…
  • FYI - Microsoft announced that Office 2019 and Office ProPlus will default to 64 bit for new installs MC171479 - Jan 2019

    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…
  • Any data file changes from BW v2013 to BW v2015, v2017, v2018

    FormerMember
    FormerMember
    I use access to run a bunch of custom reports via odbc for a client of mine. the reports pull from G/L, A/P and Job cost. I want to bring them to v2015 or v2017, but I need to know first if the data file names, field names, etc. have changed? Thanks…
  • ([Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The application cannot find the key value (Btrieve error 5))

    i have not closed Journal entries in G/L for 12months, so while posting it indicates that i cannot post for more than 12months without closing for the months. i decided to go back and close, then this error appeared.while closing G/L For month of June…
  • SQL and dates in BW

    Does anyone know how to use code to get a date range... I've tried using SQL code to get a specific date and it continues to come back as an error. I know dates are tricky things to work with in SQL.
  • Job Transaction Report

    I need to know what table the Job Transaction Report pulls from. I am trying to create a custom report and I need all the data, but I need to know where the data from the Reference field is stored so that I can include it in my report. How do I go about…
  • where is the odbc created in a Win 7 x64 machine?

    Hi, I'm running BW in a Win7 x46 machine without problem, I tried to create an ODBC with the "Create DSN Utility" and it seems that it did it, I seelected the company, double click on it and the connection was succesful. But when I click "Create DSN…
  • Employee List Reports

    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…
  • How can i get Tickets out of Sage using ODBC/SQL

    Hello, How can i get Sage 50 Tickets out of sage using SQL and PHP. i can grab records from ticket" table but i could see all the information's like Customer name, Item Info Thank you
  • Where is sales order Date in the table using ODBC

    I'm using some third party reports I wrote where I'm trying to track sales orders entered per day. I am having trouble using activation date, and also using convert from quote date. I would really just like to find the date that an order was entered…
  • Can you create an ODBC connection to the BW tables without installing BW on the machine you will run reports?

    I have Crystal Reports on a machine here. I do not need to run Business Works on it as it is not for that. However, I would like to use Crystal Reports on it to run needed BW reports for internal use. I went to create my ODBC connection and reasonably…
  • Problems authenticating via ODBC

    Yesterday I upgraded from BusinessWorks 2012 to BusinessWorks 2013. I also reinstalled Windows on the UPS Worldship computer. That computer previously connected to BW via ODBC. Sage KB #17817 covered using the CreateDSN tool and now within Windows Vista…
  • Sage Businessworks 2013 Install Problem for 64-bit Computers

    From what I'm seeing, the Client Setup program is making a mistake during the installation when it comes to 64-bit computers. The 64-bit version of Windows actually maintains two sections: a 64-bit section and a section that maintains compatibility with…
  • ODBC Tables and Reporting

    I use Microsoft Access to automatically generate pick tickets from BW based on available inventory. My problem is I cannot get the line items to "sort" correctly to match how they print on BW Invoices and Sales Orders. How does BW sort order the line…