Browse By Tags

We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.

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

A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

History of Question: * The SAGE 100 Con database had over 30 companies in it and performance was "sluggish." * Backups were made of all companies and copied to another server for safekeeping. * A 2nd SQL instance was created and all companies between…

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…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

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…

Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks

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…

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, but in sql server all data is avail able. kindly…

Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…

Sage X3 Version 6.5 Patch 29 We have done a server migration. Installed Sage X3 v 6.5 on new server. Imported the folders +svg from old server On the new server when we log on to Sage we get the error message below. “@X3.TRT/TRTLIC$adx…

Sage 100 Contractor nightly back up has failed every night since we did our archive of prior year general ledger. How do find out what the problem is so that we can get the backups performing successfully again?

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…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

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.

I have a challenge...can someone familiar with the Sage 300 database tables give me some advice? I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…

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…

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…