Sage, IT, small business and networking bullets of wisdom.

This is the fourth in my series of blog posts highlighting add-on products which tackle regularly requested extra functionality to improve your Sage 50 experience.

When companies start to use Sage 50 for their accounting, they quite often already have well established routines and systems for creating customer invoices, and it is not always appropriate to change their system in order to utilise Sage’s invoice-raising tools and templates.  If this is the case, you still need to move your invoices into Sage in order to keep a complete financial record, so a direct import of these invoices is often the best option, removing the need to re-key in large quantities of data, and also reducing the chance of user error.

The Sage 50 Invoice CSV Import tool allows you to import invoices into the Sage 50 invoice module from a CSV file.  This is different from the import options that comes as standard in Sage, as these just allow transactions to be imported into the ledgers, by-passing the invoice module totally.

The column headings in the CSV file are used to define the fields into which the data can be imported,  and multi line data can be imported into the Service Text field if required.  The CSV file contents are displayed before the import takes place, along with any error messages, to help with error checking and to ensure that you end up with a clean import.  New template CSV files can be created by selecting fields from a list of available field names, to help ease the set-up process.

The program works with Sage 50 versions 8 to 18 (2012) and costs £99 + VAT for a company-wide licence. If you want to take a look for yourself, request a free trial of the software.

To see the other posts in my Sage 50 Add On series, take a look at the posts tagged with Sage Add-On.

This is the second in my series of blog posts highlighting add-on products which tackle regularly requested extra functionality to improve your Sage 50 experience.

Many companies don’t keep stock of the items they sell, but take orders but then arrange for the goods to be shipped direct to the customer when an order is received.  I had a request to allow a sales order to be taken in Sage, but then to create a purchase order from it to send to the supplier, with pertinent information transferred from the sales order to the purchase order.  Creating these purchase orders manually can cause room for errors and feels like duplication.

The Adept Back to Back Ordering program allows you to select from a list of sales orders or sales invoices and create the purchase orders needed to satisfy the customer’s requirements.  The customer’s delivery address is carried over seamlessly and then the sales order or invoice is marked as ‘processed’, to prevent attempts to process the same order twice.

This prevents the need for manual duplication and keying in errors, and if a product is always purchased from the same supplier you can indicate this, with the preferred suppliers being listed on product codes.

The program works with Sage 50 Pro and Financial Controller versions 8 to 18 (2012) and costs £199 + VAT for a company-wide license. To take a look for yourself then request a free trial of the software.