Browse By Tags

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?

I am only looking to find specific inventory movements in the STOJOU table and need a way to determine the Type of the Transaction I see the TRSTYP_0 field but cannot find the definition of what those values represent. Can anyone help?

I have successfully upgraded my Sage 300 install from version 2022 PU2 to 2024 PU1. Thus far no problems have been found running it. On the Database Server, in MS SQL Server Management Studio however, multiple new users were created during the install…

Hello, I am trying to get data about transactions made per account between dates and get information about related documents with transactions. Payable and receivable. So I need Purchase Orders and Sales Orders documents etc. What I know / discovered…

Sage 50 is not allowing me to go in new year and shows the message to check the data integrity through Advance database check. While following the message, it shows the message "sage 50 database verification tool has found a problem in your company file…

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…

Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.

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…