• Sage import for multiple company codes

    I import a CSV file for daily deposits. I import for over 30 different companies. The company codes consist of all numbers, all letters or a combination of letters and numbers. Our current code is for company codes that have numbers only: sComp…
  • 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…
  • Data import export?

    Is it possible to export\import data from Sage50 CA to 3rd party app? Like export Vendor once it's created?
  • 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 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…
  • 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…
  • 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? …
  • 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 à…
  • 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", , , , "1", "", "CIT4", "05-11-2017", "0", "", "34,00", "0,00", "PST"…
  • 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…
  • 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…
  • 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…
  • 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…
  • 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…
  • I imported all my inventory, but now how to I import opening balances

    Hey Everyone, I'm sure this was answered in the past but I can't find the post, maybe someone can help me out. I have Sage 50 2015 Canadian edition, I imported over 16,000 items (yes, 16,000) as we are moving from DacEasy 9.0 to Sage. All my items are…