Sage 300

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

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.

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…

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

I cannot find the Tables names and field description for the Manufacturing module in Sage300. Anyone knows where to get it Something similar to this Thanks

Our bank has not been reconciled in Sage from 2018 onwards because of some issues. Now I want to start reconciling in Sage. Our bank balance is as below and there is a book balance of the below amount in the picture. The question I have is where is the…

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…

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…

Hi, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully. I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…

Hello, Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank

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…

We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…

The questions was asked 5 years ago and the answer (thanks Ettienne) is pretty straight forward: --------------- Clear these fields: ARCUS.IDNATACCT AROBL.IDNATACCT AROBS.IDNATACCT You can delete records from these tables: ARNAT ARNSM ---------…

We are implementing Sage 300 ERP on premises. Due to current situation, implementation taking longer than planned. The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300? Comments…

one of my customers is having missing data from the Tax Tables in both Header and Detail whereas the same is available in AR and AP Tables. What is the best way to update the tax tables so that they can generate the Tax Reports. Any Suggestion?

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, kindly advise me ANY BODY HERE TO HELP OUT MY…

i want to know the user passwords. in which table in the database can i get the information ..and we are using sage 300 ERP

Just wondering if anyone has seen the following error: Error occurred when opening view AS0035 View 'AS0035' is not a valid View ID. Error occurred when activating Sage Accpac Data Source. while trying to do a Data Activation after setting up a new…

I am trying to run some simple queries and use it for audit. In this case I am running an AP register, but for some reason I am getting a syntax error in MS Query that it doesn't like the columns Check or Limit......any work arounds? Thanks,

Hello Everyone, I am currently learning Sage 300 2019 and have download the latest student limited edition of the software along with the SQL Server Management Studio 2017. I did manage to install all the software and setup the database as seen on 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,…

I have a challenge...can someone familiar with the Sage 300 database tables give me some advice? I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…

An existing client Is running Sage 300 ERP 21014 and would like to migrate their SQL from 2008R2 to 2016. Is Sage 300 ERP 2014 compatible with SQL Server 2016? Thanks,

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