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.
hi all,
I am getting this error while importing Orders. can anyone suggest how to resolve it??
Sage 50 CA Error with SDK "Customer Ofen pay late. see the advice topic Handling Overdue accounts" for suggestion
Thanks,
SF
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…
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…
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…
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…
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?
…
We were finally able to get by all of the errors but upon (what we thought was a successful completion),we could not locate the transactions. This is the format I was able to get the furthest with: Its in Excel below but saved as CSV
Date
Reference…
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
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 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…
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…
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…
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.
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…
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…
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…
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…
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…