Sage BusinessWorks

I am importing an Accounts Payable Vendor to BusinessWorks. The file is a comma delimited file. The definition says to send city and state abbreviation a City, ST for example Hastings, MN. When importing, this adds the city as "Hastings" and the Zip code…

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…

SMUSERTASKS - if this is too technical of a question we can ignore it(delete). As a BW user for 28 years our file SMUSERTASKS has grown to nearly 10MB and takes 4 to 5 minutes to backup or restore (SYSTEM backup) . Should this file be this large and…

We have a user who created a backup without choosing a specific directory. It allowed her to complete the backups without any errors, but now we can't find the backup zip file.

Does Sage Business Works work well for 52 53 weeks financial statements. Taking inventory on Sunday nights is optimum. Using the features of reversing journal entries and report groups is important.

I need to clean up our vendor database and would like to run an export, make my changes and then import those changes back into BW. I have looked at the articles available for vendor import, but they do not address any changes in status. I have over 500…

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…

I import journal entries (JE) into the General Ledger module, some of which affect cash accounts. However, they do not depict on the Cash Account Register in the Cash Management module. I have to manually re-enter the JEs via the "Enter Bank Transaction…

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…

After a few days ago our workstartions frozen after 2-3 minutes , and came up errors about database connection , such this ones: Unable to get Database Names count (7004: Failes to connect to the named server and/or database) And derive to…

We've been gradually adding images for our inventory parts, and now the database seems to be slowing down, particularly for part lookups. Anyone with experience with the part photos? Could they be causing the slowdown or should I look elsewhere? If…

All, We are in the process of moving from BW 2010 to the latest version of BW 2013. The former admin did no upgrades and in turn no favors to this company. I am tasked with doing all of the upgrades for the software as well as migrating to the latest…