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

  • Simply Accounting Cannot Connect to Connection Manager

    Please I cannot start my Simply Accounting Set up.

    It keep telling me cannot connect to Connection Manager.

    What should I do.


  • 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?

    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:


  • Misleading firewall error was actually Windows update error

    The messaging could be improved here.

    In case in helps someone else, check if the data host has Windows updates pending!

    This is a recurring issue.
    My client's company data files reside on a central Windows computer and the user opens the company with…

  • 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 security…

  • Sharing data file simultaneously

    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…

  • Retour à une date de session antérieure


    Je suis dans ma première année financière. J'ai inscrit dans SAGE le 31 août comme date de fin d'année alors que cela aurait dû être le 31 juillet. Ma date de session est le 31 août. J'ai fait des écritures en août dont les paies. Que dois-je…

  • 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 one…

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


  • Needing to correct an error made in previous year after entering 2 months of data in our new year

    We have completed our year end, moved our systems forward, entered about 2 1/2 months of data into our new year. After this we found we had an error at the end of our previous year that has to be corrected. We went back and corrected the error in the…

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

  • work/access on local sage 50

    Dear all,

    Someone please inform me how  to only access the data (not enter) of my accounting on sage 50  from my local copy , without opening the sage drive, so that connecting with internet is avoided.

    For examples many a times I need only to see the inventory…

  • Sage 50 Canadian SDK - how to do wSDBGetDBVer in c#

    I am trying to use some of the features described in the documentation that came with the SDK. In the doc, dev-progref.pdf, I've read about the methods and they all seem to start with wSDB. I've seen that the wSDB* methods can be called in C++ and VB…

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

  • sage 50 connection manager

    sage microsoft reports uses a reference to 'sage 50 connection manager version x.x'
    and this
        Dim dbclient As New ConnectionManagerServiceClient

    I'm creating an excel worksheet that could be used by clients with different connection managers…

  • linking a table in ms-access

    all the applications (sage/access) are on one computer

    I have small ms-access ACCDB file that uses Sage ODBC to link to the customer table
    after manually linking, I open the table, and I see the records

    if I just leave the table open for about an hour, and…

  • What is the process to create Purchase Orders or Sales Orders via uploading a .csv file?

    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.

  • Querying Journal Entries - Debit/Credit mismatches?

    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…