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.
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…
This weekend i upgraded our systems from BW 2021sp14 to BW 2023 sp2.
But how long did it take?
My system is network of 15 desktops running Win 10 and Win11, on Server 2016 ( Dell T550 with RAIDed SSD drives ) all gigabit network connections
Our…
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)
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!
We recently discovered the remote back-up system we use has only been doing incremental back-ups of Businessworks. We have been told that full back-ups are necessary if we need to restore BW at some point. How are other users handling doing full back…
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…
Hello, I've been working on a custom export where I need a list of employees that have worked over 500 hours for 2019. While testing, I run the report in my current year company and everything is great. I go back to my 2019 company file to run the custom…
We are in the medical device industry and use BusinessWorks 2018. A new regulation requires that software being used (whether for accounting purposes or operation purposes) has to be validated to assure the software performs as stated. Does anyone know…
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…
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…
I am the volunteer treasurer of a non-profit org using BW 12.3. Our bookkeeper of many years is very ill, and will not be able to continue. I am trying to learn BW well enough to keep things going until we hire a replacement. I was a cpa many years ago…
