Sage 300

I have a client working with Sage 300 2012. Does a field exist that provides the expected delivery date? If so, what table/field would contain that?

Installed sage 300 on sql server all working On TS did wstation setup When opening accpac it is not seeing the databases why - these are created on sql server Pathing shared data and programs is correct did a test odbc to sql server also failing…

Where can I find a listing of all the SQL Tables & their definitions? I use to use this website: http://sageaom.kcsvar.com/AOM2012/Advantage.xml . But, now the site seems to be down. Thanks in advance for your help. -Kartik

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

Hello Everyone, I am currently learning Sage 300 2019. I did install all the software and setup the database as seen on the textbook Using Sage 300 by 2017 Christine A. Heaney. After I setup the database in SQL Server Management Studio, for two database…

Hi my client is running Sage 300 2018 on MS SQL 2012. They want to upgrade the MS SQL from 2012 to 2016, keeping the same hostname/IP. What is the impact doing so? i would just need to recheck/redo the ODBC and load the latest dump? any other factor…

Can we use Azure SQL managed instance rather than dedicated SQL server in Azure? I know the documentation does list as officially supported but did anyone using it in prod ? Having good success ? Thank you,

Hi All, From where i can found the AP Pending Document? Any Table to record this?

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 ---------…

Hello Everyone, I thought I would find at least one question about compatibility with SQL Server 2019 but nothing. SAGE 300 v2019 compatibility guide lists SQL Server version up to v2017. Is anyone out there running SAGE 300 v2019 with SQL Server…

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?

Currently Sage 300 2017 is configured with SQL 2016 version. IT want to upgrade SQL 2016 to 2019 version. Is it supported?

What is the correct method of permanently removing a company from Sage 300? I found the "Database Setup" utility, where it appears I could delete the two databases (data and system) associated with the company. Is that the "right" way? If yes, does…

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…

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,…

Hi I have had three sites all running Sage 2014 in the last week ring and say that Sage stopped working and that they get "You do not have a license to use this product". None of them using drive mappings, licences all valid, all working fine previously…

We are getting this error frequently when running a macro that was created to insert transactions automatically. We recently upgraded to 2017, before the upgrade we didn't have this problem. "Error connecting to database." We can log in to the company…

Where is the "entered by" information stored in the PO tables? TIA.

Hi all, When I do portal set up in database set up, i am getting error that "Invalid Input. Connot connect to the server. You may have specified an incorrect server name and server port". But i have checked my server name and portal is correct.Please…

Is there a Data Dictionary documentation available to print/review Sage 300 tables/fields used in all system?

Our client experiences slowness in sage 300 when there is a large number of transaction especially during month end. in the SQL database it causes blocking and locks and user screens stop responding until the locks have been released. how best can…

I'm looking for the Sage 300 retail (RMS) tables layout, like the one for Sage 300 ( http://www.acstra.com/content/AOMv2012/Advantage.xml )