Grampian DRAMS – Distillery Records and Management System Header Image

Distillery Records and Management System

Grampian DRAMS – Distillery Records and Management System, is used to control bulk stocks of spirit from the initial filling or receipt until it is dispatched either as a straight sale or into a blending or bottling operation. Grampian DRAMS covers all types of spirit and provides control over a multi-location, multi-warehouse environment where stocks may belong to the holding company or customers. New modules are now available to control the stock of Cased Goods and Dry Goods

Grampian DRAMS has over 30 years experience of working with the Whisky Industry in Scotland. DRAMS has been designed in consultation with HMR&C and meets the standards required for official approval.

The Grampian DRAMS package is used to record and control bulk stocks of spirit from the initial filling or receipt until it is dispatched either as a straight sale or into a blending or bottling operation. Grampian DRAMS covers all types of spirit and provides control over a multi-location, multi-warehouse environment where stocks may belong to the holding company or customers.

The system records all stock movements in casks or in bulk and provides the W1 schedule as required by HMC&E. It has been designed in consultation with HMC&E and meets the standards required for official approval. The recent development of a Windows based package ensures that the software is modern and easy-to-use while providing the controls necessary in this industry.

Stock Movements Blending Warehouse Rents
• Fillings
- casks or bulk
• Receipts
- casks or bulk
• Transfer of Ownership
• Transfer of Location
• Dispatches
- sales
- into blending
 • Recipe Creation
and Maintenance
• Blend Requests
• Calling Forward
- consignment notes
• Picking Lists 		• Calculation of Rent by:
- Customer
- Location
- Age of Spirit
• Production of Invoices
- annual and on removal
• Accrued Rent Calculation
Documentation Reporting Enquiries
• Filling Invoices
• Rent Invoices
• Transfer Certificates
• Stock Certificates
• Specifications

 • Schedule of Receipts
• Insurance Valuation
• Schedule of Deliveries
• Audit Trails
• W1 Schedule
• Filling Analysis		 • Stock by:
- Spirit Type
- Location
- Customer
- Age
• Parcel Enquiry
• History

Proposed Developments

  • Warehouse Vacuity
  • Barcode Interface
  • Stock Requirement Forecasting

Technical Background

Originally designed and developed in the mid 1970s in conjunction with a number of whisky producers, Grampian DRAMS has evolved over the years with the advance in technology while retaining the principals of security and control necessary in this environment. The system has recently been redeveloped in the Progress 4GL and relational database providing a Windows user interface and integration with Microsoft desktop products.

Progress allows the software to be deployed in a number of environments from a standalone PC to a local or wide area network with a Unix or NT central server.