Browse By Tags

Will inactivating or deleting assets help make the program run smoother/faster? Our database has a significant number of fixed/intangible assets and running reports sometime takes a long time and I am sometimes booted out of the program. Our program…

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…

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…

Dear Experts, we have a strange problem. Sage X3 is allocating only one core for tasks launched from each of the terminals. The system is running in a VM with a 4x4 (4 Physical each with 4 logical cores) configuration. But while creating a big report…

We have many customers that require we treat their various ship tos as bill to's. So, despite the customer locations having a common owner, the billing and account maintenance of each location must be treated as it's own entity. Since MAS90 (sage 100c…

Hello, We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…

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…

Hi, We have been having issues in SAGE2016 (we recently installed the May updates to see if it would help) when entering items on Sales Orders. The last suggestion we got from support seems to help alleviate the problem. The suggestion was to run…

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…

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…

Hi Support, We are using Sage 300 ERP 6.0 for our group of 3 companies. At present, we have one application server and multiple DB's and Terminal server for other 2 companies. One of the sister companies will be implementing Orion POS in the near future…

Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…