Browse By Tags

Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…

We are new to X3 and I watched the process of getting all the stuff installed. Our partner called in experts from each vendor to install their parts. We have x3, Datalinx, SEI with MSSQL. The total install time we were billed for exceeded 20 hours…

I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…

Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?

Hello all, I have updated a company's Sage software to a new version. When I try to restore the company by selecting a back up file, the file will not enter the set up wizard. What I mean is, 1) I enter the restoration set up wizard, 2) select the…

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…

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…

I have now had THREE clients in the past 2 weeks report an inability to run manual backups due to a DYNAZIP error 18. Three different companies, at three different locations, with three different IT support companies troubleshooting this. All have followed…

Anyone else have an issue with backups that have been « saved » and then actually being unable to find those backups or they don’t exist in the computer? I have been using Sage/Peachtree for over 20 years, this is the first time I am having this problem…

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…

Hi all, On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below. I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible. Anyone know…

I have a need to restore a backup from the end of 2021 into a new company in Sage 300 CRE. What would the process be to do that, without effecting the current production company. thanks v

A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…

Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…

Hello! I am fairly new to Sage-- I have taken over the billing position at a small business and have been doing things as per the instructions of my predecessor. She had a system of doing a backup once per week, and it looks like there are backup files…

We are using System Administrator to do scheduled, nightly backups of Sage 300 CRE. However, they are failing intermittently, seemingly because some people forget to close Sage applications on their desktops every night. As I'm sure any IT professional…

I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…

Hello, Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank

Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V