Sage 300

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

Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?

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…

A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed. sage 300 has detected module update inconsistencies that requires activation. The…

Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

Hi, I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…

We are upgrading to Sage 300 in a small environment aka 3 people. Or reseller is saying we need 32G RAM. The only document I found that might relate to this shows 3 deployment scenarios of Standard, Advanced and Premium. It doesn't elaborate as to what…

Hi, I installed a fresh copy of SAGE 300 2018 and loaded sample data. It is fine with everything. But after loading customer earlier version data and upgraded, I am missing with Administrative services (except data activation) and GL account folder. I…

Currently, SAGE is running on Windows server 2014 and IT is planning to upgrade the version 2016. This updates will not require any installation and uninstallation, It is straight forward version update. Does it have any impact with current running SAGE…

Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…

Can someone please tell me what table/column will give me the current fiscal period for a company?

Hi there, After upgrading to sage 2016, we are losing the Users and have to enter them manually. Once they are entered the permissions reappear. Is it normal and is there a way to make sure the users upgrade as well? Thanks

Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks

Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?

We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions? We're also looking at the possibility of using server 2016. Is there any chance…

Hi, 1) Will the new Sage 300 2016 allow upgrade from older version ? eg: Accpac 5.5? 2) What about the Database, will it help to migrate Data from AccPac 5.x, PSQL, to MS-SQL ? 3) The Database Dump & Load Application, does not work for different…