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,
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,
Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank.
Could someone share…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
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…
Deductions for 1/1/2020 - How will you make a mass update to HRMS if you haven't been tracking deductions in HRMS?
We have HRMS and Timberline. We use a 3rd party for Benefits Open Enrollment and monthly maintenance and enrollment.
Every year we have…
Hi,
I know that the Sage 50 US edition 2019 works currently with SAP Crystal reports, but I just want to confirm if SAP Crystal Reports can also work with Sage 50 CA 2019?
I saw in SAP Crystal reports knowledgebase that they can work with data source…
Hi all,
I don't have experience with sage, but am tasked with writing some automation for exporting sage 300 construction service manager data into salesforce. I'm here to ask mostly about the best way to export the data out of service manager - I've…
Hello Everyone,
I am having trouble figuring out how to import and export to and from Sage 50 Quantum using the US SDK. I have gone through several of the sample apps and I am just not seeing how things are transacting. I want to import CSV files in…
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,
A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.
We are trying to create POs, Time records, and add Cost Codes to the DB.
Reading…
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…
Hi All,
I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…
Hi,
I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…
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 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?
I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).
Here is the information that…
I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax:
Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True)
But I do not know how to capture the data you are going to select in a DataTable. I´m Working…
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
Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?