Browse By Tags

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

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

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…

Looking for someone who knows their SQL tables here. How can I use SQL to identify the active fiscal period? I see the CSFSC table but what is the best way to determine which fiscal period start date to use? Looking at BGNDATE1, BGNDATE2, BGNDATE3,…

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…

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

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

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…