x Want to participate? Join the group to interact

  • Sage 50 CA Error with SDK "Customer Ofen pay late. see the advice topic Handling Overdue accounts" for suggestion

    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

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

  • Data import export?

    Is it possible to export\import data from Sage50 CA to 3rd party app? Like export Vendor once it's created?

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

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

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

  • Hi there I am trying to help someone import journal transactions from a POS systems in a CSV format and I cannot find a record layout anywhere.

    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…

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

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

  • Is it possible to import employee pay into Sage using the SDK?

    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…

  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    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…

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

  • What is the process to create Purchase Orders or Sales Orders via uploading a .csv file?

    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.

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

  • Interface issue with Sage 50 2016

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

  • Any body out there know what is required to import from Concur, our expense provider?

    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

  • Easy way to enter data

    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…

  • Importing hours worked without time slips

    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…

  • RE: Sage 50 Migration Tools

    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…

  • RE: Importing A/R and A/P from excel

    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…

  • Importing additional inventory data

    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…

  • RE: JIRA / Project Management - Tempo/Timesheet

    Hi, For your information, this is the link to download the latest SDK. https://sagena.thruinc.net/ExDn.aspx?id=045BRXUVI6D Hope this helps.

  • RE: excel

    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…

*Community Hub is the new name for Sage City