• Data import export?

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

    Like export Vendor once it's created?

  • Direct deposit File Error

    I sent a "test" direct deposit file to be uploaded to the CAFT system we use for payments. 

    The file came back with 4 errors. I'm not sure what they are or how to fix them.

    Where do I start?

    Thanks!

    1.

    Please ask Client to update the following…

  • Changing Inventory Prices

    We own a manufactoring company which means we import a lot of raw materials. our prices are always changing. is there away to view the last date a price was updated to see if it is the current price? Currently I am tracking down the paper invoice for…

  • Import Excel data into Sage 50 invoice

    Hi there,

    First time poster here. Glad to have found this community Slight smile

    I have a situation where, for a specific client, I need to create quite voluminous sales invoices within Sage 50. Each of those invoices consist of several hundred items, and each of…

  • Accidentally Imported the Wrong Bank Transaction File

    We accidentally imported a bank transaction file for one client, into another client's Sage 50 file.  None of the transactions have been posted but the import shows up in Match Transactions.  Is there a way to delete this import?

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

    Will Need an URGENT ASSISTANCE

  • Account Receivable customer mass update (IMPORT)

    I know there is an Import Record function built in to Sage 50, but I understand that it will only add customers, and not update existing customer information.

    Is this correct?

    I need to update the contact name (and addresses) for 1500 existing customer…

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

  • Importing sales invoices - Import wizard asks for non compulsory data

    Hi all, 

    According to this entry in the KB and the dev-import pdf from the SDK documentation, when importing sales invoices, the Quantity and Price fields are non compulsory, which would mean that I don't have to put them in my .imp file... Right?

    Well…

  • Erreur d'importation employés CSV

    Bonjour, J'essaie d'importer des données d'employé et j'ai toujours le code d'erreur suivant : Le fichier d'importation ne contient pas un type de pays compatible. Est-ce que vous savez ce qui pourrait causer ce code d'erreur? Que j'inscrive 3 ou 1 à…

  • Import csv general journal entries with departments and project allocations

    I'd like to be able to import general journal entries with department and project data. From elsewhere on the site ("Importing miscellaneous transactions from a text file into Sage 50-Canadian Edition") I see

    • Example of importing with departments…
  • 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…

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

  • 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

  • Import Error: Line 1 does not contain compatible tax information

    Hi

    I try to import an imp file looking like this

    <Version>
        "12001", "1"
    </Version>
    <SalInvoice>
    "Digipoint", "0", , "1050 boul. Hamel", "Québec", "Quebec", , "G1M2S3", "Canada", , , ,…

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

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

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

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

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

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

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

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

    Hello,

    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

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