Browse By Tags

Hello. I am new to using Sage and have next to no notes left from my predecessor and no one else on my team seems to have much info, if at all, on the software. I have noticed in some areas (although now I can't find it of course) where it mentions "Asset23…

Error: "Failed to Establish the Vault and Store Databases" During database setup. Above error showed up. New server 2022, new MSSQL 2019, new Sage 300 2024. ODBC tested successfully new install, no Vault/Store in shared data directory mapped…

We have one laptop running Sage 300 version 2023 (Product Update 1) and have error activating New company. After Click Data Activation > Proceed below error pop up. Please advise

I have a very odd issue, in SC100 Database Administrator I can see my companies for tune up, etc., but when I select Archive Company Data, no companies show up in drop down list. Anyone ever seen this? Ideas on a fix? Thx!

Hello all.... I am receiving this error once every few days on every workstation. I have to restart the server and everything is fine. It usually does it in the middle of the night. We recently installed a new server. Any ideas?

I just did the year end update to Sage 100 Contractor from 24.3 to 25.x without realizing that my server was running WS2012. When I try to open Database Admin, it says the machine is capable of being the database server. Is there a way to roll back…

Buenas tardes, disculpen una consulta como puedo conectarme a todas las tablas de sage 50 account, ya que ODBC solo lee los reportes de kristal report atte.

in running the purge data process, how does this affect inventory data view? If I purge 5 years of date, 2010 - 2015, will the inventory history on items still show in the "ALL TRANSACTIONS" view or only the history since 2015? WIll this also change…

The description for Sage 50 says " Desktop accounting software with cloud connectivity". Is my data kept solely on my desktop, or is it in the cloud (or both)??

New to Sage 50 but I have done some Peachtree work years ago, as in 12+ years ago. I am trying to write crystal reports but I would really like to see what is in each table to facilitate this. In my old Macola days, when it used Pervasive (now Actian…

Looking to see if anyone can direct me to a table that houses the details from Product Line entries on ITMMASTER.

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…

above is the error experience when trying to locate the database on sage 300 people

I am currently experiencing an issue where i installed and set up sage 300 application on AWS EC2 instance and connected to RDS SQL for the database Everything works fine besides when i run queries it is really slow and takes 5 mins when it should take…

Moving from the Progress DB to SQL Server version discount percentage type columns are decimal(7,3) but in the old version it is decimal(8,3). Also a lot of other decimal columns went from (16,6) to (15,6). How have people handled this? It is breaking…

New database cannot activate in Sage 300 ERP 2023 with Product Update 1 Computer operating system version MS Windows 11 Display the following message creating the new company. 'User input email password cannot be blank' 'Cannot activate common…

Hoping someone can help. Couldn't find much online and the online resource file layout mentioned the code but no definition on what this code represents. Since upgrading to Sage 100 2022 I am seeing JI codes in inventory transaction history. Those codes…

Hi everyone, A customer that uses Sage 300 2022 more than 1 year ago suddenly when users try to enter they get this error message: No Supported Databases Are Set Up. Not use what happened but since a couple of hours ago they are getting this error…

Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

The link to the Sage 300 2024 Database and Report Changes opens V2023, am I correct in assuming that means there are no changes between 2023 and 2024? cdn.na.sage.com/.../Documentation.htm

Can you run the database admin on a workstation and connect it to the SQL server remotely

Is there no field on the sale order tables that displays the total value of the line? I see the field on the line but I cannot find in either the SORDERQ / SORDERP tables. As is now I do a calculation on reports to get the value but wondering if I'm just…

I am currently running Sage Paperless on SQL 2014 ver 12.0.2269.0 (released 7/14/2015). My internal vulnerability scans have flagged this version as unsupported and it likely contains several security vulnerabilities. What is the process for updating…

2019 Advanced - Sales order history detail has extended into a second partition and MS Access now gets the message "Cannot open Database" when trying to link or import the table. It may not be a database that your application recognizes, or the file…

Does Sage prevent creating one vendor with multiple accounts if you enter a duplicate EIN number? I have two companies that have the same name except one is an LLC at the end and one is an INC. They are two different companies, but it brought up the importance…