Sage 50 Canada

I am new to using Sage 50 CA edition. Just wanted to know if there is any way to import data using ODBC to excel into a format that I wanted? Would really appreciate if there is a step by step guide available out there.

Hello everyone, I'm going to create a report using Crystal report that shows payment info for each purchase invoice including cheque#, payment date, invoice#, Project name I know that Payment info stored in tPmtHdr and was able to almost create the…

I am a new user of Sage 50. I am trying to figure out how to create Purchase Orders or Sales Orders in Sage 50 via uploading an excel file (or CSV). Any help would be appreciated.

I'm working through an export from Simply Accounting into a BI Package. I have a basic query written that flushes out the journal entry - but the debits and credits for the journal entry are not 'netting' zero because of the positive/negative sign.…

After all these years the one thing still missing is being able to show customer/remind that there are OTHER invoices still outstanding WHILE entering the receipt which you have to do anyway when funds are received - with NO EXTRA STEP to produce and…

Just as it says. Exact scenario is that the client is switching from Sage50 to an industry specific software and would like to bring in all their transactional history. This is definitely going to require an SQL query across multiple tables and I have…

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…

I just installed Sage 50 2015 Pro. Until now I have been using Sage 2012 Pro. I'm having problems using my existing company file in the new version: It seems that Sage 50 2015 Pro is having problems connecting to the 2012 Pro version's company file…

Hey Guys, Any update on this issue iv been looking all over the internet for a solution to this issue. I have .net 4.5.2 installed on my machine and the target framework set to 4.5.2 to no avail any other suggestion would be greatly appreciated thanks…

I'm trying to query a Sage 50 database ("corpname.sai") from MS Query. I'm on a laptop, so local - no other users. This database has never been on the laptop before, but I seem unable to connect to it for any of a number of reasons. I wouldn't think…

Est-ce qu'il est possible d'exporter les informations de l'onglet Débit pré-autorisé de SAGE 50 vers EFT 2015? La connexion avec la compagnie se fait correctement pour les clients; fournisseurs et employés. SAUF que l'information du compte bancaire…

is there any complete example about how to create or update a customer and assign the Tax. as it seems to not be possible with the sdk and only with a direct access to Sage 50 Mysql Database Thanks

Is there a way to use the SDK to create or drop a table? I'd like to create a temporary table, then drop it directly in the Sage database.

I'm writing an application in VB.NET to run custom queries against the Sage 50 database. I've gone through the SDK manuals, but have some additional questions while walking through the sample code. We run the connection manager on the server and install…

Does any one remember Sage Entrepreneur Edition? I am trying to find it for a client.

I have never used the inventory feature of Sage as I've never had a client that needed it. Now one of my existing clients opened up a small shop. I took all the invoices of the items she purchased and entered the quantity & value of the goods on the history…

Hello, I am using MS Access to connect to the Sage 50 tables via ODBC. Prior to the latest update 2014.1 the ODBC connection worked but now it no longer works. I noticed the MySQL Connector has a different layout now and the Port number is now 13541…