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

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

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

  • Sage 2019.2 - Get Open Invoices using Query?

    Hello would like to know if it's possible to get a list of all open invoices using  SDKDatabaseUtility RunSelectQuery command?

    I've looked around here and also the DataDict but can't really find what tables I need to link to get this data.  Any…

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

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

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

    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.

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

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

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

  • How to find log in credentials for Sage 50 database

    I am trying to go through some of the code examples in the SDK, obviously one of the first functions that runs is the database connection function. I have tried sysadmin with various passwords but I can never successfully connect to the database to try…

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

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

  • sdk 2014

    Does anyone know how to get, or have access to sdk 2014.0.  Sage link is broken.