• Data import export?

    Is it possible to export\import data from Sage50 CA to 3rd party app?

    Like export Vendor once it's created?

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

  • Exporting sales invoices to .IMP file

    I have been tasked to make an .IMP file from custom made "one of a kind" software, for import of Sales Invoice data into Sage 50, Desktop version 2021.1.1.  As far as I can tell, from reading the import file structure guides, both in .Pdf format…

  • importing employee expenses and external invoices into Sage 50


    I'm new to Sage 50 and I am currently looking into automating uploads for employee expenses and external invoices.  From what I have seen so far online I under that this can be done from a CSV or text file.  However, when looking at various resources…

  • Direct DB Connections via Connection Manager | Changing Port #s

    Hi folks,

    I have a client that uses Sage 50 (2018.1 + Connection Manager v7.0).  They host Sage on a MS Azure server.  They have 6 Companies (DBs) that I'd like to be able to connect to so that I can pull some high-level data into a custom reporting tool…

  • EFT Direct Deposit through Credit Union

    I'm working on setting up my EFT Direct Deposit through Sage, and my Credit Union bank. 

    The bank has set me up with CAFT and a username and password combo to upload my payroll EFT file too, however, Sage does not let me create any EFT references.…

  • Does imp file allow automatic import of item ?

    Even when the code are ok it ask for confirmation (the correct item is selected) for each detail line. Is there anyway to avoid this confirmation and import the invoice without confirmation ?
    Thank you

  • Need to import a huge volume of Sales Invoices into Sage 50 - 2017 - Canadian Edition. The SI Data is currently in excel

    Can someone please advise on the best method to import a sales invoice. Is the .imp specification the only way to import into Sage 50 - 2017 Canadian? Is there an excel template that I can map my excel data to and then save as a .CSV for importing into…

  • 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


    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…

  • How to properly import tax information for sales invoices using .imp file

    I'm trying to import sales invoices using the .imp format but I'm confused about how I should be importing the tax.

    The sales invoices I'm trying to import are for a shipping order so my information is as follows:

    Order No: 6000

    Invoice No…

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

  • Sage 50 2016 Export to csv or open in excel data is not numeric

    I'm using Excel 2016, and just upgraded to Sage 50 Pro Accounting 2016 because the Sage sales guy said that it was compatible with Excel 2016.  However, when doing "Open in Excel", it only shows the option of  Excel 97 - 2007.  After saving…

  • RE: importing inventory into Sage 50 Quantum -

    GMLane said:
    The import file does not contain a compatible country type." 

    The top part of the file above the line detail should have all that information.  If you open the file in Notepad, it should look like:

  • how avoid ask for item service in the timeslip importing proccess


    I'm trying to import timeslips but always ask the item service match for every employee record, is there a way to avoid this?. 

    Thanks anyway

  • Any body out there know what is required to import from Concur, our expense provider?

    Anybody know of an easy way to import expense items from a Concur file export?

    Alternatively would anyone know how I can export GL strings for each company managed in Sage?



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

  • RE: Clearing outstanding payables from several years ago

    Hi there here are two alternative solutions to remove outstanding payables from the database:

    1. You can first process negative invoices for each vendor’s outstanding invoice. Second in Payments you can pay positive against negative invoices. The total in…
  • Problem exporting PDF reports

    I have a client who is suddenly having problems exporting reports as PDF since he upgraded to Sage 50 2014 (latest version).

    When he exports as a PDF, he gets the error:

    "Error opening this file for exporting check to see if any other application is using…