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 just upgraded from an older version of MAS 90 / Providex to Sage 2023 100 Premium. It appears that all of the NULL values in our company tables have been converted to empty data, with the exception maybe of the date fields. This is causing…

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

I am trying to setup Power BI to be able to view data from Sage 50 Canadian Premium. I can access data tables, and specifically tproject using an ODBC connector. dStrExpBal (starting balance) for a project is correct, which is up to and including LAST…

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

Hello, I am trying to get data about transactions made per account between dates and get information about related documents with transactions. Payable and receivable. So I need Purchase Orders and Sales Orders documents etc. What I know / discovered…

Sage 50 is not allowing me to go in new year and shows the message to check the data integrity through Advance database check. While following the message, it shows the message "sage 50 database verification tool has found a problem in your company file…

I've just started supporting a Sage FAS Network install, and am working out how to make cold backups. When I go to the backup utility, I find that we have 20-ish databases, each with only one company. Did my predecessor set things up weird, or is there…

Hello everyone, I am trying to import items into a database. I have exported them into a CSV file within Sage Estimating, but I can not find out where you can import them. I was trying to merge 2 databases with the database editor, but they have different…

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.

AP_TRANSACTIONS.REF_NO has a 25 character field limit, however the use of this field has been limited in the BusinessVision front end GUI to 10 characters. It appears that this is because the cheque number field in system setup is limited to 10 characters…

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…

Hello all, I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this. I'm a student, using cloudpaging…

Hi Sage City community, I am currently working with Sage 300 ERP 2023 and trying to access general ledger account balances programmatically. I need to retrieve this data for a custom integration that I am doing. Could anyone guide me on which specific…

I’m trying to determine what table & field name lies behind the field in the yellow box below? Looks like I’ve got to drive some conditional logic with it for a report, but I can’t find it in the database. You get to it by clicking the Item/Tax button…

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?

A general and important question When you insert a item into the estimate from the database the change date is the current date. What I want to know can a column for the data base change date be visible in the estimate file. This would make it easier…

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. I am looking for the Column that store the deposit date of AR Receipt Batch. But ARBTA does not have Deposit Date column. Then I go to ARPJH and update the column DATEDEPST (Deposit Date), but the new value does not reflect on the AR Receipt…

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…

Azure SQL Elastic Pools is heavens-send for a lot of partners and customers who are looking for an affordable, yet scalable SQL Database service for their Sage X3 projects. Making sure you are compliant with Microsoft's rather complicated SQL licensing…