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.

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

Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…

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

Hi, Can anyone advise how to increase a limit of row level permissions (Parameters --> Users --> Users --> Organisation) in user setup? It is set to 10 in my organisation and I need to be able to add more to some users. Thanks Ania

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.

Sorry if this is stated somewhere, but wanted to know how to configure the Sage Fixed Asset - Premier Depreciation up for SQL Server database mirroring. With most applications this is configured within the DataSource Connection String like this: data…

Hello, I have a Simply Accounting Premium 2008 version. I have recently added another computer to the network (the 2 computers are connected using an Ethernet cable) and I have access to the company data and back up from the second computer (read/write…

Hello All, Can someone explain the reason for these two fields listed in the subject in "Products" screen. I've read the basic break down's from "F1" help, but we are looking for more real world examples and purposes of these two fields. Could either…

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…

Is there a way to set up price lists by the customer's city, zip, or state? Currently I only see the Ship To Address, which is the address code, and not necessarily helpful since this doesn't reference the customers' zip, city, nor state. I'd like to…

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…

Hello everyone, We are trying to merge similar customers in SAGE 100 2020, and we have discovered that ship-to addresses with the same shiptocode are being overwritten by the source shiptocode if they are identical. Is there any way to modify the shiptocode…

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…

Would you kindly let me know the Max. Length of SQL password Sage Intelligence Acceptable? My customer change SQL Password to 64bits length… After change, all Sage300 feature works fine but only Sage Intelligence caused password invalid.

Hello, Can anyone guide me to configure the WDV depreciation method in Sage X3 V12?

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…

Hi everyone, I started using an AP automotation software by Beanworks which is tied to our Sage 300 system. When I view our tax authorities within the Beanworks environment, it shows some tax authorities as inactive but when I go to the tax authorities…

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…

The directions for opening multiple company files is very straight forward. 1. Open the first company. 2. Select File, and then either Open Company or Open Previous Company. 3. At the warning message, select Yes. 4. Select the next company you want…