Browse By Tags

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

Azure SQL Elastic Pools is heavens-send for a lot of partners and customers who are looking for an affordable, yet scalable SQL Database service for their Sage X3 projects. Making sure you are compliant with Microsoft's rather complicated SQL licensing…

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…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

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…

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…

Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…

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?

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…

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…

We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…

Can someone please tell me what table/column will give me the current fiscal period for a company?

Hello, I was hoping someone might be able to assist me. I am trying to create a report using the Sage 300 2014 database. I need to see the date that a user was created in the system and also need to know what type of license the user is assigned to…

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…

Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks

Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?

MS SQL server 2012, Sage 300 2014 PU 3 I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors…

When I go to Item number change and processing I have an error message: Cannot open database "ccs.net.ccscom" requested by the login.The login failed. Any idea

Is there an AOM for the AH61C module? I have not been able to find anything in the KB or the online documentation after installing.

Hello, Is there a way to import Vendor Price lists from excel so that the prices are updated for existing products and so that new products are added into inventory? Thanks, Dave