• Transaction Data Import

    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…
  • SDK invoice 0 $

    Hi, I import invoices with a c# program that I made using the SDK. It's working fine, but time to time I need to create an invoice with 0$ total. I'm able to create a sales order and manually transform the sales order to an invoice. Is there a way to…
  • Export data from Sage 50 CA using SDK

    Hi all, Is there anyone has an idea to export the data from Sage 50 CA? I was looking at the method w the class "CustomerLedger" but it has only the Save method it does not have the get method, Please let me know if you have any idea of hints to solve…
  • Simply Accounting Cannot Connect to Connection Manager

    FormerMember
    FormerMember
    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
  • How can I create a receipt with simplySDK

    Hi I would like to know if it is possible to create a receipt for an invoice with simply SDK without using an sql Query I looked at all the documentation that came with the SDK and I could not find a way thanks in advance.
  • Sharing data file simultaneously

    FormerMember
    FormerMember
    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…
  • ODBC Connection Access Denied (Password error)

    Since we installed the latest upgrade for Sage 50 to Version 2018.0, we are unable to connect to the simply database with our third party software using a ODBC Connection. Over the past 10 years I have always managed to make the appropriate adjustments…
  • Retour à une date de session antérieure

    Bonjour, 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…
  • Needing to correct an error made in previous year after entering 2 months of data in our new year

    FormerMember
    FormerMember
    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…
  • 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…
  • 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…
  • 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.
  • Add payments to invoices added through the SalesJournal?

    I am using the .NET SDK (C#) to export invoices and payments of those invoices from my own database into Sage50. I managed to create invoices (payment type = pay later) in the Sage50 db using the SalesJournal class. I now need to add payments for…
  • SDKInstanceManager.Instance.OpenDatabase() always return false

    Hello, Suddenly today our software was not able to have a successful call to SDKInstanceManager.Instance.OpenDatabase. Since were still running on SDK 2016.2, we decided to updated the Sage 50 “Simple Comptable” , the Connexion Manager on the server…
  • How do I know if the connection to the database is open ?

    I´m working with sage 50 CA 2016 SDK, and i have a problem with database connection. When I run this code in a console application successfully opens the connection, but when I run the same code in a Winform application , does not open the connection…
  • SDKInstanceManager.Instance.OpenDatabase always returning false with no reason why or error message

    I have a C# application that executes a call to SDKInstanceManager.Instance.OpenDatabase to open the data file but it keeps returning false, and it does not give any error message as to why. I have the proper parameters sent because this same data file…
  • Where payment terms are stored for the customer in Sage 50 CA Edition?

    I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table). Here is the information that…
  • How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

    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…
  • Error when opening Sage Pro 2012 Database in Sage 50 Pro 2015

    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…
  • How do we export invoice transactions to sage 50 Quantum (Can) for multiple depots?

    Our client is running a custom SQL solution for billing and exporting the Sales Ledger postings to sage 50 Quantum (Can). Their SDK does not have a field for branch or depot location. Is there a way to export the transactions with the appropriate branch…
  • EFT 2015 versus SAGE 50 2015.3

    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…
  • Sage 50 SDK Canadian Edition

    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