Welcome to the Sage 50 Canada Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
Quick blog update on how to import data into Sage 50. The first and easiest method is to import information via csv file (a common format openable with Excel). This sort of import allows you to pull data into Sage 50 like customers, employees, vendors…
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: ---------------------------------------…
We have an interface which connect with Sage 50. The interface is written in VB.NET. It worked fine before sage 50 upgrade to 2016. The random crash would happen when exporting invoice to Sage 50 2016. There is no error message left. I tried add try.…
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
So we usually get orders in a excel spreadsheet and an order might have 40 or 50 items. So to add to an invoice or quote you have to type in each number then quantity.
Is there an easier way?
The best would be if Sage 50 worked like the rest of windows…
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…
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…
Hi there here are two alternative solutions to remove outstanding payables from the database:
You can first process negative invoices for each vendor’s outstanding invoice. Second in Payments you can pay positive against negative invoices. The total…
Sage 50 Canadian can import G/L, Order, and Invoice text files, if they are formatted in the particular way that the system requires.
Does the external payroll service provide you with a properly formatted file that is specific to Sage 50 Canadian,…
Hi
Is it possible to import hours worked by employees, without time slips?
I have a third party program that creates a file with employee and their hours in many revenue line, such as regular hours, overtime hours, cooking hours, housekeeping hours…
Hi Aaron,
Sorry to inform you that we do not have experience using this migration tools to import data.
Written below is the import format if you want to import data to Sage 50. This is for your reference.
10187 How to import data into Sage 50—Canadian…
Yes.
With Sage 50 "out of the box" you can import Sales Invoices one at a time, in the .IMP format.
It will choose the customer if it exists, import the invoice number and date, and for details can import an item number, price, sales tax. The format…
so the background is that Simply 2010 was installed on a new Windows 8 PC end of June or so, I have read that there are known compatibility issues with Simply 2010 and Win 8. previously, user was using a laptop with Windows 7 and Simply 2010, I can only…
Hello,
So I we are transitioning from an older accounting software to Sage 50 and have all our data exported into .csv files. I have used the help documents relating to Importing Inventory and Services and Importing Price Lists to sort out the data…
Good Afternoon:
Our company runs on a pretty small budget. I have been reading "How to Import Sales Invoices from external format". I need a third party developer to write this file for me. The actual import seems pretty straightforward after that.…
Hi Kjbiz,
You can follow the link below to import the employee record as a .csv file Exporting and importing employees data using CSV format with Sage 50-Canadian Edition - KB10122
Please note that no transaction or any numbers can be imported. This…
Hi OFPA,
For your information, if you need to import journal entries to Sage 50, you will need to create a text file and follow certain format.
Please follow the link below for the test file format.
Importing miscellaneous transactions from a text…
I have a client that lives in a different city and has started a new business. I have created the Sage company in its entirety and I want to send it to them so they can run everything at their end.
How do I transfer everything to them? Also, how do…
Hi F.S. Sciences,
The following Knowledge Base articles may give you some suggestions: Error "Sage 50 Accounting 2013 stopped working" when I try to import online bank statement KB-10566
Why am I receiving an error from the bank when importing an…
Hi Gustavo,
You can follow the link below for steps to import the .imp file to Sage 50:
How to import purchase invoices, purchase quotes, sales invoices and sales orders?
Hope this helps
Hi Janetf,
If you need to import data from another software (in your case, it is Accpacc) to Sage 50, the import file needs to be in a format which is accepted by Sage 50. If the import file is not in that format, you will have to adjust it.
The link…
Hi Snowrabbit,
Since you are using simply accounting 2011, as per the KB article I gave you, the version number is 18001, not 20101, which is for Sage 50 2013. For country code, please refer the the following list:
Canada Country Code = 1
USA…
Hi guys, I'm trying to import some sale invoice in sage and I what to import the account code for each sale entries too...
Is there a way to do this. this is the code I use now, but when I import it, It ask me the account code for every entries. Is…
