• Sage 50 Sales Invoice Columns

    I am importing data into Sage from a 3rd party software. Each of the transactions has a BOL# associated to it. When the data is imported, the quantity, product, price, etc. all import correctly - but I am unable to find a field in Sage 50 for a transaction…
  • How to import Credit notes in Sage 50

    Hi, I have 800 credit notes to enter in Sage50 Canadian Edition , i want to know if it is possible to import them? i already know how to import sales invoices through an .IMP file, i want to know if it is possible to do the same for credit notes, if…
  • Why do we only own this product for 1 year even when we purchase it outright?

    My business purchased 2018 Sage 50 Canadian Edition. I used it happily into 2019. I needed to revisit the files but found the program had been lost through time. I just spoke to "technical support" and was told they "don't have the 2018 version anymore…
  • What happened to the import function for inventory items?

    Last year I created 500+ new items and prices in spreadsheets and imported them with no problems. I want to do the same thing again, but with version 2020.2 the Import Records option only has "Updated price lists" and "Updated account budgets". It appears…
  • New Chart of Accounts for an existing Company

    I created our registered charity in SAGE but I skipped the step to import or use the default chart of accounts when using the Wizard. Now it appears that I have to create every account individually or create a new company to be able to use the Wizard…
  • Mass import shipping addresses

    Good day, Fairly new to Sage, even more so to this community. Tried researching but couldn't find a suitable answer, sorry if this is considered a duplicate. Q: We signed a new supplier with 437 point of sales. I would like to import the 437 shipping…
  • importing Records from Accounting version

    Hi All, I have been in business since 2016 but have just recently purchase Sage 50 Accounting - Canadian Edition and completed the Level 2 Accounting Modules e-learnings. My current accounting firm uses Sage - Accounting version however they will not…
  • Journal Import Template

    Hi, Im new in Sage 50 Accounting - Canadian Edition and would like to import journals but I can't find any function to somehow export an existing journal so I can have a template to use for import. Can somebody help me to provide the journal import…
  • Help with Import issues

    Hi, I am posting this on behalf of a client who is a Sage 50 user. We have generated an .IMP file from our software for them to import into Sage 50, and they have been getting a variety of errors that are very hard to troubleshoot - maybe one of you…
  • RE: How to enter transactions effectively if I need to enter the same transactions in both company?

    Sage 50 does have this functionality... sort of. You can export a Transaction (General Journal) report as a CSV file, but the format is not exactly the same as the import format. And it's possible to set other accounts, beside bank accounts, for reconciliation…
  • RE: Modifying customer records and/or invoices with .IMP format

    fryshaun said: Is there a way to modify existing records using this format? No, importing customers will fail on each line for an existing customer. To actually modify the record you would have to either: 1. Use the Sage 50 SDK to locate and update…
  • RE: Import sales invoice CSV file to Sage 50 canadian

    Sage 50 has a built in import utility, that basically takes a CSV formatted header plus the data, and can dump it into an invoice. If you want to see the format, one easy way is to open the sample test file, set up a customer as using Sage 50 and having…