Sage 300

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…

Every now and then I have Sage freeze and lock everyone from doing anything. It commonly happens in the payment batch list during heavy usage around month end, but it can happen other times as well. The system during the working day is under heavy usage…

Are there any best practices or caveats for re-indexing Sage 300 Databases using Microsoft SQL Server's maintenance plans? Thank you in advance for any suggestions!

Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…

Hello, Can someone recommend a product to audit the update process for transactions? We need to know who does modifications. Ty.

When running Verify in Database Setup for a System Database, it returns the following error message: ARADV: Table does not exist. Cannot continue verification, a database error occured (error=60001). How do we resolve this error?

Sage 300 2021 PU5 - SQL 2016 I think I know the answer to this (no) but can the System DB be a different collation method than the company DB? I ask since a new company is being brought onboard from an old Sage version environment where the company…

My customer is replacing their server which is running Sage 300 relatively current version with MS SQL 2014. As long as we are moving we want to upgrade to MS SQL 2019. The customer purchased MS SQL CALs on subscription from Sage with the original purchase…

Hi All. I have error when i want connect new PC from sql. Cannot Access Database 49153, it means the PC cannot read the sql server. No issued with another PC, only problem from this PC. But if i create ODBC, connection is sucsessfull, and change…

Hi, Everyone How Can I check or clarify SQL server is runtime edition version. Please help me. Thank you so much

Hello, I am new to the forum and need some help. Please where can I find the Sage 300 2104 data dictionary?

Hi, we have 2 invoices that can be seen though SQL in the APIBH file but are not displayed in the vendor activity window. Has anyone encountered this before? Ty.

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…

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…

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…

Hi When I imported one transaction to see how reconciliation works, i got the below error. It says 1 updated but It does not reconcile that transaction, please could someone throw some light ?

Hi, I want to import bank statements into Sage 300 - I am not sure what the below fields do and what their exact column name would be for my import file. Could someone please help ? Cleared Y/N - Integer (Column Name ?) Used Y/N - Boolean (Column…

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,

We care trying to copy the production database to a new test database and receive a database error (ec=60256). Has anyone seen this error and how do we resolve. Thanks,

I have a few clients with Large Databases and in one case a Client with Multiple Companies with Large Databases. For Example the Job Cost Transactions table for 1 year of Payroll entries generates 300,000 Records. I created a SQL Query to get the…

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

Hello there I have noticed that for a given invoice in my SalesHistory table (OESHDT) the QtySold=110. But then when I go to my PostingJournal (OEAUDD) for that invoice I only have a QtyShipped = 98. So am I correct in thinking: 1. When I sell something…

Hi there, I will be so thankful if my thinking is correct here as it would be wonderfully simple :).. Am I correct that the table ICILOC has a complete stock list of all my items in all the different locatiosn they can be held in? Thank you once…