Sage 300

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

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…

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…

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…

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?

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

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…