Browse By Tags

I've just started supporting a Sage FAS Network install, and am working out how to make cold backups. When I go to the backup utility, I find that we have 20-ish databases, each with only one company. Did my predecessor set things up weird, or is there…

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

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…

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 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.

SMUSERTASKS - if this is too technical of a question we can ignore it(delete). As a BW user for 28 years our file SMUSERTASKS has grown to nearly 10MB and takes 4 to 5 minutes to backup or restore (SYSTEM backup) . Should this file be this large and…

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…

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…

Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…

Hello, Long story short I am purging closed clients and it's going unbelievably slowly. I am trying to purge the database from everything from our closed clients. When I run the purge, I select "Closed" clients and nothing else, no other filters…

I accidentally created multiple new databases based on our existing database. I have deleted the .FDB files but the deleted databases still show up in the dialog box when I select "File>Open Database." How can I delete them from showing up in the…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, kindly advise me ANY BODY HERE TO HELP OUT MY…

I would like to know if there is a way or a tool that can be use to reduce Sage300 database. I have a company database of 90GB size with data since 2000.

So, I have been experimenting with Backup-Restore functions of the SQL databases. I was able to restore backup files from my primary workstation with its own SQL Instance to the emergency workstation with its own Instance of SQL Server. It went well enough…

Here's a new problem after installing 17.1.8 update (not a problem with 17.1.7): Common Tasks - Tools - File Tools - Backup The "ts.ctl" file is in use when we try to use file tools to backup our data. The knowledgebase leads you to various methods…

Our company MAS 500 server crashed, very hard no recover. The DB was backed up to another server and I am able to restore the DB from the BAK file. The data is there, but we need to access reports and stuff. We no longer have the MAS500 server software…

Hi, While i'm creating a record due to some issue i lost the data in table maintenance ,can any one help me out to get lost data?

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

How does one access Business Vision files from earlier years? The program does not seem to follow Windows convention that clicking on the word File on the upper ribbon does not give an option to locate and load a file.

The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.

Hello Sagers, I was trying to connect Sage x3 to a virtual database ( always on ) and this virtual SQL database is pointing to two other Physical SQL database instances this to have online hot swappable database recovery. But the console is not seeing…

Hello, how can my client share thier "sage 50 pro" data file with me (I have the accountant edition of sage 50), so i can work on thier file remotely? And simultaneously? Also, is there a link and/or video that discusses the information to show the client…

Bonjour, Je suis dans ma première année financière. J'ai inscrit dans SAGE le 31 août comme date de fin d'année alors que cela aurait dû être le 31 juillet. Ma date de session est le 31 août. J'ai fait des écritures en août dont les paies. Que dois…

Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…