Browse By Tags

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…

Hi, Im triying to update Contacts using the API and Im getting the next error: "validation" : { "errors" : [ { "field" : "tax_number", "message" : "must be blank" }, { "field" : "tax_number", "message" : "Format must match '123456789XX1234 (15 characters…

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…

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…

We are using Sage 100 Standard ERP 2013 (Version 5.00.4.0) / SAGE 100 ERP Issue detail: when I click on Work Order -> Work Order Transaction Entry (Snapshot 1) -> it asks for the date and once I enter the date and click OK -> I get an Update Interrupted…

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…

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…

Hello everyone I am a new IT person to involve with sage50 I want connect to database by using 3rd party application such as Excel, Access, Power bi through ODBC to create real time and interactive report by power BI, I following this article https…

I have a couple of issues with importing: I have imported all the purged slips from my backups for the fiscal year (5/1 thru 4/30) into a separate archive database, so that we can run certain reports based on those slips. Most of the backups imported…

I have a client that purchased a new laptop and installed Sage50 Quantum 2020 on it. When they try to open their data from Sage 50 2016, they get an error that an older version of the Actian Zen database is already running and requires a newer version…

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…

When opening Common Services->Company Profile, the following error is occurring: Damaged data. Company Profile. Data dictionary is inconsistent. Error occurred when opening view CS0001. View 'CS0001' is not a valid View ID. Error occurred when activating…

When opening a company, it shows the following error: Cannot alter table CSCOM error = 211. To try to resolve, I installed Sage 300 on a new machine and loaded a dump of the data. The error appears in the new installation also. I also tried replacing…

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

We are in the process of moving to Arcoro HR and I have been building imports for this. Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…

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…

Sage 50 2022.2, I have cleared all past years historical data, restored backup made in early Nov. (before installing 2022 upgrade) will advance to Jan. 1,2022 but backups made after 2022 upgrade will not. Advance Database Check gives an error and the…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…