Browse By Tags

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

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…

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…

Project and Job Costing (Job related) PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found.". All other PO receipts have no issues. Please help us to solve this issue. Our Version is Sage 300 ERP 2019 and Database is Sql server…

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…

In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…

When I try to load the sample data into Sage 300 database setup, an error message appears saying "Error creating system DB entry. OrgTbl32.exe". What does this mean and how to fix it?

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…

Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…

Hi, I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…

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?

We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…

We using Sage 300ERP V.6.0 PU2. The error message when day end is show "Transaction History. Database error (Operatin=INSERT) (Error=824). Please advise, what happen and how we can solve this problem.

Timeslips 2012 When using transport.xfr I get the following error message. I tried a DATA VERIFICATION on both machines and have NO errors. I can exchange clients and professionals but NOT tasks or expenses - tried each separately. Any help would…

I'm an admin for a law office and we use Timeslips 2008 for our billing. Only yesterday, when I went to edit a slip, I received the following error: "Directory in use by earlier version of Paradox.(13314) Area: Database Code: 4 Address: Exception…