Database Developments by
Amrelan
The following are examples of some of our
database developments:
Stock management
database
 Avoids unnecessary purchase of products already available in
stock, potentially saving thousands of pounds.
Provides target stock figures for multiple
branches/warehouses based on historical sales trends.
Creates re-distribution lists for branches with
excess stock, re-allocating to those branches who have a requirement for
the excess.
Features sophisticated stock control and excess
stock redistribution algorithms.
Return to
Top
Integrated management system
database
Features secure centralised management of
residential care services.
Allocation of admissions to residences, detailed
client/patient records, medical conditions, medications etc, staffing
records, training, IPRs, sickness/holidays etc.
Provides client/patient careplans, reports,
multiple allocation of key workers accross residences, updating
facilties of all client and staffing records.
Easy to use report generation
utility.
Return to
Top
IT asset management
database
Keeps track of valuable IT
equipment
Computers
Peripheral devices
Serial numbers
Sites and locations
Software and licences
Software service packs
Suppliers maintenance contracts
IP addresses
Return to
Top
Product/price/customer look up
system
Complex special terms pricing
matrix.
Allows price/product information distribution to
clients in an easy to use and secure
environment.
Return to
Top
Job logging and invoice production
database
Order entry, tracking and invoicing system with
the facility to enter both cost and sales values.
Review turnover and profit margin for any period
easily and quickly with a couple of mouse clicks.
Invoice production with the ability to batch by
customer.
User definable variable VAT rates with the
ability to set a default for new orders – future proof against
government or EU policy changes.
Review customer orders by current, by
printed/non printed invoices or by all orders including
archived.
Easy to use report generation
utility.
Return to
Top | 
