Browse By Tags

It looks like this question has been asked before, but I am not finding a current answer to my question. Is there an API to connect to Sage 300 CRE Job Cost files?

I am attempting to create a Power BI report with some of the data from Sage. It needs to pull data about the job checklist items. However, for some reason the Checklist_12 item is not updating in the replicator database (The one we use to push Sage data…

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.

Why is Timberscan and Sage not matching in the units column after a Commitment CO?

We started experiencing this issue 2 days ago and it seems that we are unable to get past the error. When trying to make a payment in Sage AP, my user gets the following error when trying to submit: This program is about to close. See the journal in the…

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

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

I am getting this error when trying to update Job Custom fields through ODBC. Has anyone seen this or know how to determine what the error is? Michelle Outler

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! I have a new contract with 195 cost codes and values. Is it possible to upload a list of cost codes with the name and the budget instead of manually keying it in via a CN module?

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…

Does Sage prevent creating one vendor with multiple accounts if you enter a duplicate EIN number? I have two companies that have the same name except one is an LLC at the end and one is an INC. They are two different companies, but it brought up the importance…

Hi all - we are trying to pull data directly from our current transaction tables and see that it only has transactions from 30 days prior. We have look at the new and batch transaction tables and those records are not there. Any idea on where this data…

When I enter contract values in Job Central and then click 'Finish' I get the attached error. I'm unable to save any changes. Please advise. I'm on Windows 11 if that matters.

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?

Is there a way to import revenue rates in the equipment module?

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…

When trying to use Power BI to connect to the Sage 300 CRE (22.2) do I select SQL server, MySQL, BI Connector or something else?

Does Sage 300 CRE permit upload of batches of payable invoices from either Excel or CSV upload templates? Can an upload tool be built to import multiple supplier expense invoices at a time with a template?

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…