Sage BusinessWorks

I can import new Sales Orders however is it possible to leverage the import function to update existing sales orders? If so, where can I find information on how to accomplish? Any insight would be greatly appreciated!

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…

I see how to create a CSV file to import invoices, but it seems to only import a total value. Is it possible to import an invoice with multiple line items?

In trying to develop an Invoice Import template for our production environment, I have been testing it in our Sample Company in Bus Works (2019). I can't seem to get past a "unknown sales tax id" exception. I have attached the csv file and an image of…

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…

Hi All, Is there any APIs, webservice Or tools for Import/Export data? Please, anyone can share knowledge about it? Thanks for your help in Advance, SF

Is there a better way to import journal entries into Sage BusinessWorks 2015? Like directly from Excel. Or a faster way of creating CSV file of many records from Excel, readying it for import?

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…

I have tried looking into the Enter global Global price changes and global part change and it only give me Base, Line, and Margin, but Not Absolute option. I have 200+ items I need to change to Absolute so that I can import pricing on them. any ideas…