Browse By Tags

We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.

Hello! We process our payroll in Sage BusinessWorks. After printing checks, we print out the Check Register report. We had no problems last week; however, after printing checks and attempting to open the register report today, we got the following error…

I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?

Hi ClarkM and Erzsi_I I see that that a similar question was posted by slacka 6 months ago, and remains unfixed. I don't understand why this issue hasn't been taken seriously. This seems to be a critical issue in the way a client is able to, or in…

I turned my timeslips 2017 and the main.db was missing. i now can't find it to access my data. can someone please call me at 310-556-1001 or refer me to someone who can find it? I found my tseg.fdb file but that is it.

Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you

Anyone have any experience with using an excel or csv data base spreadsheet to import employee maintenance info into Sage 100? Looking to save some time for a large client. Name, Address, SSN.. Thanks!

After installation of the latest tax table update, the above message appears along with:A error has occured during the process of T4A extraction. The error returned was 1142. The operation being performed was a viewPut call to paper T4A information. Create…

I have completed the newest version of Sage 100 Contractor YE proceedures. I have a clean PR audit. Updated and done every item the instructions say. Yet when I try to Archive 2023 PR "Unable to remove payroll company database, the archive company has…

The answer is yes! Let me explain, I followed the year-end guide. I ran the audit, I repaired the errors listed in the audit, I ran the audit again to check for errors. There was zip, zero, zilch errors reported. I proceeded to close 2023 payroll. Everything…

How do I import payroll data from an outside 3rd party (Foundation) into Sage 300 CRE?

Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.

Hi there, Our sage has multiple data inconsistencies due to high turnover in the office and having office staff attempt the bookkeeping. Due to this, i'd assume many incorrect entries have been made to cause so many inconsistencies. TOTAL DEBITS Data…

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

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?

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 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…

I'm getting the error that is attached when I run the Sage Payroll Archive for 2022. It seems there's a file already there, however when I checked I don't see it. Any thoughts? Thanks!

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, Mistakenly updated Sage 100 Contractor to the wrong update version without the payroll year closed. I rolled back the program on the computers which is fine. It now states the tax table for this year. Do I need to roll back on the server…

We have at least a couple hundred payroll records where PTO (sick time) was used while we were running the broken version 24.2.103 of Sage. The process for fixing these, listed as the resolution to defect # 39917 is a manual process for each individual…