Sage 50 Canada

Sage 50 Pro ... Win 10 Pro 64b ... Office Pro 2019 32b ... ms Access 32b ... Mysql ODBC 32b ... ODBC connection read-only appears to work fine to retrieve customer data ... however ... any attempt to make a read/write connection to make corrections/changes…

I've created an ODBC connection to my data and linked a few of the tables in an Access database. The data opens fine but every time I try to create and run a query my MS Access will crash, shut down, and try to reopen. Hoping someone can help me!

Hello everyone, if I want to retrieve Trial Balance data through the tables which table do I do to? So I would need the debits and credits as of a particular date for each account number.. Thank you! Marc

Hello everyone, I am using ODBC Data Source Administrator (64-bit) version 10.0.22621.1 to establish connection between Sage 50 Quantum Accounting (Release 2023.1) and Microsoft Excel 365 64bit and it works fine. When I use the ODBC to import tables…

Hello everyone, I am running Sage 50 Quantum Accounting (Release 2023.1) and ODBC Data Source Administrator (64-bit) version 10.0.22621.1. When I setup MySQL Connector/ODBC Data Source Configuration, I enter all the parameters including Data Source…

Microsoft Access query based on linked tables from Sage 50 through ODBC crashing. MS Access just closes with no error messages and proposes to open in save mode next time around. Safe mode also crashes. I am using Sage 50 Quantum Accounting (Release 2023…

Hello everyone, I have exported data from Sage 50 to Microsoft Access through ODBC. In Sage, whenever we produce reports, for example Project Income, we have an option to check or uncheck show "Corrections". Which field controls for this boolean switch…

I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…

Hi there We are running Sage50 Canadian...we got this update utility for stock updates that connect via an ODBC connector and uploads a csv file , and updates the relevant stock in the Company. The last few weeks we have not been able to use this…

Please I cannot start my Simply Accounting Set up. It keep telling me cannot connect to Connection Manager. What should I do. Will Need an URGENT ASSISTANCE

Good Afternoon Sage Guru's! To make a long story short...I have a connection to Sage from MS PowerBI currently and my dashboard is simply a table that is simply being refreshed and updloaded to my dashboard so that I can search on PO, Vendor, or item…

Good Afternoon, I have been reading a lot of posts and I don't think this will exactly duplicate some of those. After a lot of reading on how to connect our Sage50, I have taken the steps to ensure that I have 'third party' access rights, and when…

Working on a report for the AP team to better schedule payments for our vendors. The Sage documentation is quite good – but there are a few gaps I’m struggling with. Vendor Payments: I see that there are two sets of tables for Vendor invoices. …

I need to be able to determine if a vendor invoice has been paid via the SDK. I found this older post, but wanted to see if there was any new information: https://sagecity.na.sage.com/support_communities/sage_50_accounting_ca/f/sage-50-ca-printing-emailing…

When using the Open Database Connectivity ( ODBC ) in Excel to extract banking information of vendors ( table: tVenDP ) from sage data base, couple of fields spits out scrambled data (fields: sBankNo, sTransitNo, and sAccountNo). We think it might be…

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 currently using Sage 50 and here is my problem. I get the connection to work, it returns the host and the port fine but whenever I call the OpenDataBase function, it will always return DBS_LOCKED Error. Username and password are the right…

I have the data dictionary, went through the tables and I'm just wondering if someone already has a SQL Statement to return a Monthly Trial Balance. I'm ok with SQL, so if at least I can have the list of tables you use this will be awesome. Thank…

Is there a flag in the table tSalOrdr which indicates the last saved copy of a sales order. I am using SQL to query a sales order and I am finding duplicates which are related to every instance a sales order was saved. But the high Sales Order unique…

We are using a development software named Windev (similar to VB) and wish to automate the billing process. We basically need to check presence of client info, create new clients, create invoices and e-Mail invoices and account statements. We are looking…

Would anyone be able to tell me which table in the Sage 50 CA data schema contains the vacation pay rate (i.e. 4%, 6% etc.) for an employee (and the name of the column)? I am unable to locate this information through the data dictionary. Thank you.

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.…