A general and important question
When you insert a item into the estimate from the database the change date is the current date.
What I want to know can a column for the data base change date be visible in the estimate file.
This would make it easier…
Hi all,
We're developing a COM-aware .Net assembly that is used in a legacy VB6 app and keep getting the above message when opening a connection via SDKInstanceManager.Instance.OpenDatabase. When we call our method from inside another .Net assembly…
Hi all.
I am looking for the Column that store the deposit date of AR Receipt Batch. But ARBTA does not have Deposit Date column. Then I go to ARPJH and update the column DATEDEPST (Deposit Date), but the new value does not reflect on the AR Receipt…
Hello Everyone, We are in the process of setting up our new server and was wondering if Sage 500 will work in a RAID environment? The SQL Server will be running in a VM and we have 16 1TB SSD drives to "play" with.What RAID configuration would be best…
Azure SQL Elastic Pools is heavens-send for a lot of partners and customers who are looking for an affordable, yet scalable SQL Database service for their Sage X3 projects. Making sure you are compliant with Microsoft's rather complicated SQL licensing…
Hello,
We use Netstock which has a "velocity" identifier that tells you in layman's terms how fast a product sells. It is separated into three main classifications: A, B and C and then three velocities: High (H), Medium (M) and Low (L). I am not sure…
Did you know that Sage 50--U.S Edition version 2020 and later use Actian Zen for the database engine, while versions 2019 and earlier use Pervasive? Head over to our article on how to troubleshoot the installation of your database to find out more!
Hello,
Mistakenly updated Sage 100 Contractor to the wrong update version without the payroll year closed. I rolled back the program on the computers which is fine. It now states the tax table for this year.
Do I need to roll back on the server…
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…
Based on the multiple experiences I'm reading here about 2023, it is clear that there is a flaw with this release. After working with support for almost 10 hours, we've come to the conclusion that it is not our network or environment. The database itself…
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…
Is there any migrating tool for Transfer of Sage 200 Evolution Database into Sage 300 ERP?
I have recently subcribed to Sage 300 ERP (On-Premise) Solution and my old system is Sage 200 EVolution. Is there any tool where all my transactions gets migrated…
Hi all,
During a database load, I have encounter this error. No clear message so I don't know what is the cause and how to solve it. Below is the screenshot.
Can anyone help me please? Thank you.
We have a diverse amount of experience in our estimating department. Our assemblies have always been high level without a ton of details because we sub out 90% of the work. We have many junior estimators that have worked in the subcontracting world and…
Survey: Did you already purchase Sage 2023 because of the "third-party database" issue and are disappointed that the 50% off deal only showed up today - seven months after the issue arose?
We Did.
Unless we missed an email somewhere along the way…
We have a legacy standard database that is set as a 3 digit phase code suffix, example 03000.000. We would like to convert it to a 2 digit suffix, example: 030000.00. I tried to merge a 2 digit and 3 digit but the merge routine rejected the operation;…
I need some contacts for help to repair our Simply Accounting 8.5B database before we proceed to upgrade to the current version of Sage. I spoke to Sage Support and they indicated they have a "Repair for Conversion" service to repair the company file…
Problem:
When opening the Admin module an error “Database could not be opened” appears
Cause:
Incorrect setup or access to the database
Resolution:
Ensure you have you created the System DSN using the 32bit version of the ODBC?
Ensure that…
Hi.
We need help getting our database setup. I did some reading on it and even though I understand technical things pretty well I did not quite get it. As I mentioned in the title this is for a class we are taking in Computerized Accounting and we all…
Client uses Sage 300 2014 & SQL 2012, on separate servers. They have provided 2 new 2019 servers for us to begin the upgrade -- but first, I want to make sure that everything works as it does now, before installing version 2022. The DBA restored the SQL…
It's always the way isn't it? You don't see any articles about creating indexes then several come all at once! Chris Hann recently wrote the article " How to use the Database Optimization function " but what if you want to create a new index which uses…
Hi all,
I have a sql script and previously successfully updated to Sage 200 company database. Now I add the following line
EXECUTE spCreateColumn 'UnprintedInvoice', 'FormNumber', 'bigint', '13', '2', 1, 0, 0, 1, '0', 'None'
EXECUTE spCreateTable…
Hi all,
I have a custom database(not company database) to store information to be retrieve by all companies in a custom form. I am able to query its table using plain query in MSSQL Management Studio.
With Sage 200, I am able to make a connection…
Hi all,
I see there is tblParameter in configuration table, I would like to store my key value such as custom database name, servername, username, and password in tblParameter to be used in my custom form.
In Sage.MMSAdmin.DBSchema.Others, I see there…
