Sage Line 50 tutorial is designed for book-keeping software, in this blog we will teach you how to use this software. In sage line 50 blog you will learn about how to install and operate Sage Line 50 and how to install on network.

Sage 50 to mySQL

I am getting alot of requests lately in exporting data from Sage to mySQL as an automatic process. I now have a beta running and would like to invite anyone who needs this functionality to please get in touch. This will extract all Sage 50 data on a schedule you determine. This will enable you to export the data to either a local/network or even Internet hosted copy of mySQL.


The reason for doing this is two-fold;


I have customers with large datasets starting to encounter performance issues (they are on the verge of outgrowing Sage 50)


There were customers having issues getting the server part of the Sage 50 for iPhone solution configured. Now there will be a central secure repository (at remotediscovery.com) where this application will export your data and the iphone app will connect to this site with your credentials to allow you to view your Sage data on the go.


Of course with the data in a full relational database there are all sorts of possibilites in terms of integration/customisation!


Just send an email to mysqlbeta at domorewith.com

Sage mySQL no more…

For those of you that we aware Sage have been working on a version of Sage 50 which uses the open, standard database engine, mySQL, codenamed Sage 100. This was a supposed to improve performance for those customers running large volumes of data through Sage 50 (yes I know who you are…..I’ve seen those 7000 customers on your sales ledger ;) ) but a very recent announcement from Sage has stated that development has stopped.


Reasons aren’t entirely clear, my thinking was that if it didnt offer the ability to talk the database across the WAN (i.e. Internet) as well as the LAN then its not *that* much of a forward leap. My experience is that customers move from Sage 50 not due to data volumes but for functionality, things like multi-location stock.


Of course this isn’t the first time they’ve done a U-turn, last year the very poor and buggy Sage Live was almost drowned at birth. The SaaS offering never really got started before being shelved and allowing all the SaaS boys to further strengthen their offerings and increase market share.

Sage 50 or Sage 200 data online?

I’ve been working on a couple of projects to extract data via scheduled jobs to place on remote servers of late. It was something I was mulling over as the one big sticking point with the iPhone connect for Sage 50 application is for a user being able to configure their firewall to allow external access. My thinking is to charge a nominal monthly fee (and no upfront cost) for a tool which extracts your Sage 50 or Sage 200 (in an extremely efficient manner!), uploads it to a secure site where you will able to view/filter and report on your Sage data.


What I don’t know is how much do you, the great Sage using population, want the ability to do this? It means not only can you easily deploy your information company wide but also to home workers and it would tie up nicely with the iphone app. Now phase 1 would be read-only but later phases would look at altering the online data and via some other tool allowing those changes to be written back to your data.


If it is something even of passing interest then please email here.

Chasing Your Tail or Chasing Your Money?

Getting paid on time is a constant frustration for any business. Seven years ago I developed an add-on for Sage 50 (and Instant) that automatically sends email reminders to customers with overdue invoices. At the time it had limited success due mainly to lack of email addresses being held in the system.


Fast forward 11 years and many organisations are try to do everything electronically to be kind to the environment and streamline processes. Perhaps now eCredit the automated credit control tool can help your business, you can read more here.

Coming Soon….Dashboard+

Dashboard+ is coming soon….


What is Dashboard+? Dashboard+ builds on the principles of the free dashboard product by giving you instant access to key data within your Sage 50 or Sage Instant accounting system. But Dashboard+ adds a host of new features such as;

Drag and drop design of new dashboard widgetsCreate new dashboard ‘tabs’ so you organise the display how ‘you’ wantAbility to create new key performance indicators (KPIs)Web based interfaceCentral KPI repository, as new KPIs get added and requested they are available to ALL subscribers

Dashboard+ will be available on a subscription basis where you receive the product, updates and full support on an ongoing basis. Don’t know SQL to create your own KPIs? Your subscription includes full SQL support, if you want a specific KPI that can be derived from your Sage data we will create it!

Alerts and Notifications

Following on from the resurrection of eCredit the automated credit control tool I had a conversation with a client who was enquiring about being able to have an event or a change in the Sage data trigger an automatic email to one or more customers. This got me thinking about a generic alerts system where a user can define some parameters and when a value or status changes have an automatic email or even SMS sent to one or more external recipients or to internal staff.

Now something like this does exist in the guise of BPM (Business Process Modelling) or workflow. These solutions are typically expensive and need alot of configuration. My thinking is that you have something that is simpler and user friendly but acheives the same end goal. If this is something of interest please get in touch.

Category: Sage 200, Sage 50


View the original article here

The Business Growth Fund, plugging the lending gap

It was hailed as the answer to British firms’ long-term lending problems – a billion-pound pot of bank-backed equity that could bridge the financial gap for hundreds of companies. But as it prepares to launch this year, experts are wondering just how effective the Business Growth Fund (BGF) is really going to be.

The innovative new body has already promised to make more than £1.5 billion available for small to medium-sized companies in 2011. But despite the hype, commentators and industry are already divided about how well the equity system, backed by the high street banks, will work and what it can realistically achieve.

What is the Business Growth Fund?

So what exactly is it and how will it work? Why might it be so important for kick-starting expansion for businesses and the economy as a whole? And why are critics urging caution?

The idea of a bank-sponsored BGF was first raised last year, by then Chancellor, Alastair Darling, in response to the general downturn in lending. With net lending down six per cent in the last 12 months, he hoped making funds available in this way would stimulate future growth – and have a lasting, positive effect on the economy.

Darling proposed working with the major high street banks to establish an investment fund for small and medium-sized businesses to tap into. Signing up Lloyds, Santander and Clydesdale, Darling created a £200 million resource that aimed to reach £500 million of capital. Other banks were less keen to get involved – saying that civil servants’ preference for distributing monies to existing venture capital firms would not build capacity in the market.

Then in July, while coming under political pressure to increase business lending from the new Coalition Government, the major banks took on the project for themselves.

What’s the thinking behind it?

Explaining the thinking behind it Chancellor, George Osborne, and Business Secretary, Vince Cable explained: “This government has always insisted that banks need to increase lending to our essential small businesses, in order to support economic growth, while also restoring customer trust.”

So, which banks have signed up?

The new fund, backed by Barclays, HSBC, Lloyds, Royal Bank of Scotland, Santander and Standard Chartered, aims to invest in individual companies with a turnover of between £10 million and £100 million, in return for an equity stake of at least ten per cent.

Managed by an independent investment company based in London and a range of regional offices, banks will put £350 million into the pot over the next two years – spreading the rest of the total £1.5 billion contribution between now and 2020.

As Fund Chairman and Barclays Chief Executive, John Varley, explains: “As banks we have an obligation to help the UK economy return to growth. The private sector will play a key role in the recovery and it’s our job to help viable firms to be successful.”

What can the fund achieve?

But Angela Knight, chief executive of the British Bankers Association, says and her members are still cautious about how much the fund can achieve – and says its scope could be limited.

“The anticipation at the moment is it will do about 75 companies a year, a bit like where 3i (an international investment company) used to be when it was in this sector,” she explained. “That figure will also depend on what businesses want and we are hopeful that others will come in and commit to the fund.”

The BBC’s Business Editor, Robert Peston, agrees – urging a seasoned, measured view of what the BGF can hope to achieve.

“It is important not to get too carried away,” he says. “I calculate that it will be able to provide risk capital to around 250 middling companies over a number of years (based on the banks’ assertion that they’ll provide £1.5 billion of equity finance in individual lumps of between £2m and £10m).

“That will be seen as a useful contribution to the growth potential of a segment of the economy that has typically found it hard to raise capital. But it won’t be transformative.”

It may not be the cure-all solution that the Coalition originally hoped for but with such a large amount to invest, the BGF’s contribution will at the very least represent step in the right direction.

Steve Porter, Accountants Division

Share/Bookmark

View the original article here

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | JCpenney Printable Coupons