Case Study: Database development for Northern Freight

Office Objects developed a database solution for Northern Freight Services (a family run company providing a quality distribution and warehousing service from their base in North East England). The database development involved detailed consultation with our managerial, office and warehousing staff.

NFWarehouseDatabaseDevelopment

Office Objects reviewed our existing warehousing, stock, orders and invoicing systems and together we designed a database solution to simplify and streamline our existing processes for both goods received and deliveries..

Office Objects provided us with a database development which replaced the spreadsheets we previously used which were more labour intensive and required double entry of some customer, product and warehouse information. The database solution now enforces our requirement for one product only to a location which has also stopped duplications when entering data. The database stores information on the Batch that products belong to and the Containers in which they are delivered in order to ensure traceability. Another advantage of the database is that Stock taking is now simplified and integral part of the new system.

The database system captures Customer reference information and orders, warehouse location, pallet calculation and stock data to provide an integrated solution which was both more efficient and user friendly to operate and provided us with an accurate and simple to use Reporting facility which enables us retrieve details of goods received and deliveries by Date, Batch, Container and Product codes search

The database development has allowed us to tailor our staffing requirements to the more streamlined process which enables us to hold all the key business information in one central easily accessible
location.

Bill Giles
DirectorNFDistributionDatabaseDevelopment
Northern Freight

If you have a requirement for a database for a Stock and Warehousing – then let us know.

More about Northern Freight:

Based in Peterlee Northern Freight offer their customers 180,000 square foot of internal warehouse space, along with 9 acres of external storage space, the site is covered by 24hr security and has full internal / external CCTV.
In terms of distribution, haulage and fleet resources Northern Freight have a mixed fleet of some 48 vehicles ranging from small vans to 44 ton articulated units & double deck trailers, all vehicles are fitted with tracking systems.