• ODBC Database tproject dSExpBalNY entries not matching Job Allocation Expense reports.

    I am trying to setup Power BI to be able to view data from Sage 50 Canadian Premium. I can access data tables, and specifically tproject using an ODBC connector. dStrExpBal (starting balance) for a project is correct, which is up to and including LAST…
  • SAGE 50 Canada ODBC 32 Bit MySQL read/write Connection restarts Sage

    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…
  • ODBC Connection Using MS Access

    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!
  • Trial Balance data through tables

    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
  • Microsoft Access 365 / ODBC / Sage 50 Quantum Accounting (Release 2023.1)

    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…
  • ODBC credentials reset every time after closing Sage 50

    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

    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…
  • Looking for field controlling "Don’t show corrections"

    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…
  • update utility

    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…
  • Sage 50 ODBC Connection

    I try to connect MS Excel to Sage file via ODBC. I got following message: Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)" I am using Windows 10 64-bit. MS…
  • Finding the relationship between purchase order and Projects

    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…
  • How do I connect to a Sage 50 Quantum Accounting Release 2019.2 multi-user server from my laptop with ODBC?

    FormerMember
    FormerMember
    The mysqld daemons are 32-bit. The ODBC driver is 32 bit. The userid id and password are valid. But I always get.
  • ODBC Connection - Office 365 / SA50v2016

    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…
  • SQL Tables / Invoice Payment / Journal Entries for Current & Past FYs

    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. …
  • Determine if Vendor Invoice has been paid - SDK

    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…
  • Scrambled data exported when using ODBC data connection in Excel for Vendor Banking information table (tVenDP)

    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…
  • OpenDataBase always return DBS_LOCKED Error

    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…
  • ODBC SQL query for monthly Trial Balance data.

    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…
  • table tSalOrdr ...does it have a flag for the latest copy of the order?

    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…
  • Need assistance interfacing using (CAN) .NET SDK... Need to create customers & invoices. Experienced help welcome ($)

    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…
  • Vacation Pay Rate Data

    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.
  • Is it possible to import employee pay into Sage using the SDK?

    Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…
  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    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…
  • Importing info in Sage to Excel using ODBC

    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.
  • Which tables and fields show the relationship between payments holder and Projects

    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…