03333 445950
Home
Up
Developers
Tables - Fields

                                

 

Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Line 50 custom integration link

Bespoke Integrations from a standard application 

Do you find yourselves re-keying data? Do you sit there thinking this is a waste of time? 

"All I need to do is to get it from here to there." Well, we can do that for you with a bespoke link into Sage Line 50.

If have to re-key data into Sage Line 50 then Custom Integration offers a link to Sage Line 50, a way to vastly improve efficiency without expensive custom programming.

If you are a developer, not only can we provide a really cost effective and pretty slick link from your application to Sage Line 50, but, we can integrate your product with all the current and (we expect) all future windows versions of Sage Line 50 with one unchanging interface from your point of view.  

So if this is a one-off need to integrate to Sage Line 50 or a whole new market for you we can provide a solution for you.  You don't have to buy the SDK and maintain lots of different versions of code to integrate with Sage Line 50. 

By using a standard application at the core of our integration link, we can develop links rapidly and at low cost, we can offer, compatibility with all current releases of Sage Line 50 and can normally offer access to the latest versions of Sage Line 50 within weeks of the new releases.  

How to link your application to Sage Line 50?

You need to get the data out of your application and into a machine readable form so that we can use it to create transactions in Line 50.

At the most crude level this could be a report printed to a text file.  We would prefer something a little more manageable, a csv or xml would be great, we can also use tables from ODBC accessible databases.

You need to get the data to a location where we can access it, this could be an agreed directory path, a location on an ftp server or a pop3 email account.

You need to provide us with a clear specification of the data you are producing and what you expect the integration to do.

For example you could provide us with a two column csv file of account numbers and product codes.  You could ask us to produce invoices from these, using "todays" date a quantity of 1 and to pick up the price from sage, apply discounts, and so on in the same way the sage user interface would. 

We are happy to help you through the parts you needs to do, we can help you get your data out, and workout which bits of your data go where in Sage Line 50.

Types of integration:

Batch integration
Single Transaction integration

Ways to trigger the integration process:

  1. Periodic execution.  the integration process is run as a scheduled task
  2. User initiation. The user could use a desktop shortcut to start the integration process.
  3. GUI initiation. The user can use the GUI interface to run the integration.
  4. Application initiation, single transaction.  The integration can be initiated form another application, through the use of a shell call, it returns an errorlevel indicating the success of the transaction. We can switch off all user interaction for this kind of integration, so that the user does not see anything.
  5. Application initiation, batch transaction. As above the transaction is initiated by the application (this could be as simple as some VBA in an excel spreadsheet) we still switch off most of the user interface except dialogues and progress bars which can be customised with your own wording.

What modules can we integrate with?

Customers
Suppliers
Nominal Ledger
Purchase orders 
Purchase Invoices
Sales Orders
Sales Invoicing 
Sales invoices
Journals
Bank Payments
Bank Receipts
Allocation of payments/receipts
Stock Records
Stock Transactions
Price Lists 

What sort of applications is it suitable for?

Just about anything, we can take data from a unix EPOS system, off a .net ecommerce web site and everything in between.  We have not found anything we can not integrate into Sage Line 50. If you have access to source code then that makes life easier and gives you a slicker integration and extra controls, however, we do work very successfully without it. 

Have a look at our examples and see not only the range of applications, but also how we have been able to make applications like Back to Back ordering, and purchase ore requirements without any third party products by integrating Sage Line 50 with itself!.

What about accessing data from Sage Line 50 - a reverse integration link?

We can feed data back to you from Sage Line 50 in csv, xml, or directly into tables in a database. Generally we do this to confirm processing of data, but potentially could be done for other purposes.

What are the pitfalls of the Sage Line 50 integration link?

The pitfalls are that the data can get lost, skipped or duplicated.  We, wherever possible, design out these pitfalls.  In really slick integrations, we feed back to the application advising them what has been transferred, so as to eliminate skipped data and prevent duplications. We have some good in between solutions to.  However, if all you can get out of your application is a printed text file, then you will need to make sure you do not export the same data twice or miss out any. (if we can we will prevent duplication, for example if you have invoice numbers in your data, we will not add the same number twice) 

What does it cost?

As you can imagine, the cost of configuring the integration link software and getting it to perform is variable.  The complexity of the task, the number of tasks we need to do, numbers of users, numbers of data sets and so on.   The vast majority of customers get a solution for under £600.  

Can I have a trial, custom software on sale-or-return?

Yes, no problem

What if I upgrade to a newer version of Sage Line 50

Providing you have maintained upgrade eligibility with us there is no cost, you just download and install the new version, you may need to request a new licence.

What about Quick Books, Sage 200, Pegasus?

Sorry we only do Sage Line 50, the UK's most popular accounting package

Any Other Questions?

want to have a go?

Call us on 03333 445950

 


Home Main site Contact Terms

Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!

This Sage 50 import website is copyright © Making I.T. Happen 2017