Portfolio

Below are some case studies of systems delivered by Blackdown Systems

  Stock Control / Order Processing   Call Centre / Prospects  
     
         
  Data Processing   Dispatch Notes / Invoicing  
     

Stock Control / Order Processing

The client had been using and Access system for some time, but the sheer volume of data in the database was causing performance and reliability issues. Blackdown Systems re-authored this application, with the addition of several time saving features and reports in Java, sitting on an SQL database.

The system takes new client orders directly from Sage, and schedules purchases using a set of supplier specifc lead times. It then generates and submits PO’s to the main suppliers and the goods-in department verifies what was actually shipped when a delivery arrives. It can send reminders where there have been omissions. It then tracks the goods through the factory to the point of dispatch to individual clients. The system is extremely flexible and allows items to be juggled between orders to meet clients shifting deadlines.

Call Centre / Prospects

Blackdown Systems developed a bespoke application that displays product information to sales reps in a call centre. Reps ability to discount can be controlled on a per rep basis. When a sale is agreed the system sends a PO to the client for signing. Upon receipt of the signed PO the order is invoiced and posted into Sage. The system generates the invoice in PDF format and emails it to the client.

Management can add, re-price and manage the product portfolio. There is an array of reports that run off this system; profitability of each the reps, profitability of each product range, finances in terms of sales per period or per product line.

Data Processing

The client has an ecommerce sight through which their retail business operates. However the data is not formatted in a manner that makes it easy to report on, or to extract into other systems.

Blackdown Systems setup database replication and then post processed the data so that detailed reports can be generated and the data cab be readily imported into Sage.

Dispatch Notes / Invoicing

A bespoke system has been developed that allows an automated dispatch note to be generated at the point of manufacture. This is then automatically sent to the accounting offices for import to QuickBooks as an invoice. Slight variations in dispatch note mechanisms are required for the various clients and hauliers.

 
 
Copyright 2010 Blackdown Systems. All rights reserved