• Pervasive PSQL Server Engine (64-bit) & Pervasive ODBC Engine Interface (64-bit) for Sage BusinessWorks 2019

    Ultimately, I need help getting Pervasive ODBC Engine Interface (64-bit). I also see that Pervasive PSQL v10 SP3 Server Engine (32-bit) may not be the latest available. Can I upgrade to a newer Pervasive PSQL Server Engine that's 64-bit. Ideally…
  • Default location of businessworks backups

    FormerMember
    FormerMember
    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.
  • inventory

    I put an item from a vendor in the wrong part number/ID. How Do I remove it from one to a different one?
  • Software after Sale of Business

    FormerMember
    FormerMember
    My client is selling her company, and the licensed copy of Sage Business Works installed on their server will be the property of the new company. My client will still need to handle Payroll until the end of February. We can export the database and copy…
  • automatic backup at end of day

    Can anyone direct me to how to perform an automatic end of day backup say to the C: drive or OneDrive? 2018 version BW
  • server crash

    had a server crash-have crashplan backup of businessworks 2018 data-have moved all data to new server, have new copy of bw2018 installed, just need to put the data into the bw 2018 program-what is the procedure?
  • 52 53 Weeks

    FormerMember
    FormerMember
    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.
  • Software validation

    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…
  • How do I clear someone off the Network Status who isn't online?

    FormerMember
    FormerMember
    I can't backup because the someone is showing up as in the system who isn't. His machine is turned off.
  • Template needed for import vendor w/ status field

    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…
  • sage business works 50 accounting version 6.0 since 2005. exporting question

    FormerMember
    FormerMember
    I have sage business works 50 accounting version 6.0 since 2005. Can not figure out on how to export customers, chart of accounts,vendors ect. My version does not have File-export option
  • OurOrderNumber field is not populating on Custom Exports

    Hello Again! It appears that our column for order number is not appearing on the export. I have tried an export in both the OE and AR modules, and it does not seem to be saved. Where does this information live? Specifically I am trying to get the…
  • Customer Account

    FormerMember
    FormerMember
    A have a customer account with a balance due but when I printed statements it shows a negative balance due. I have attached the statement, the customers account and the statement selection page
  • Error when Importing Sales Orders

    Hello All, I am trying to import sales orders created from a third party. All works as it should, except when adding a discount to a line item. I get an error that says " ERROR: Line item extended price must be equal to line item unit price times line…
  • Error when trying import ARP

    FormerMember
    FormerMember
    I get an error when trying import Payment (ARP) where I point payment method like a credit card. For this, I create CSV file and use code "-1" (from the documentation) and get the error: "Invalid payment check number". Example CSV: /P,customer100…
  • Urgently need assistance with a Business works 2011 data corruption

    I have a client who I just started with. They are seeing lots of issues which look like bad data corruption. The previous guy recommended they reboot the server whenever things hung up, so I think whole batches of data have been lost. BW still functions…
  • Is there any APIs, webservice Or tools for Import/Export data?

    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
  • ([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…
  • Importing Journal Entries

    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?
  • ODBC customer ID

    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…
  • Importing ACA Information

    While manually entering information into the ACA Preparer, I noticed when I right-clicked one of the column headers an import from CSV file option appeared. I was unaware this was an option. We already track all of our ACA information in an Excel spreadsheet…
  • Unit Cost Import Help

    I've followed the steps in KB 18720 and continue to have issues. Unit Cost will not populate regardless of how I structure the source file. Has anyone had any experience with this? I'm currently running BW 2015 SP10. I've tried from 2 different computers…
  • PO posted / Part posting inconsistency

    I have a part that shows negative and when I went digging, I found a PO for the part that shows fully received in; however in the part transaction the PO is most definitely not there. I figured the IC module had an error and so I performed a backup and…
  • Has anyone found a way to export data from Business Works to Reynolds EraLink?

    I need to get data in Business Works exported in to Reynolds EraLink. Has anyone found a way to do this other than manual data entry?
  • 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.