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

    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…
  • 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:6000…
  • 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…
  • 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 this .xls file…
  • 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? Thanks SonnyS
  • 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…