DataBase Application Development by David Nye

David Nye Bonded Warehouse Example

Scope

Client:Bonded warehouse and drinks wholesales, based in London, UK.
Size:3 users.
Objective:User friendly and cost effective management of bonded warehouse stock control, integrated with full order processing and bonded warehouse storage rental. Approved by HMCE..

Stock Control

  • Standard stock control functions
  • Additional data for Excise reporting
  • Automatic assignment of rotation (batch) numbers and pallet labelling
  • Drill down to source transactions

Tracking

  • Tracking of stock movements by consignment or AAD number
  • Audit trail of changes to stock records
  • AAD document control

Duty Reporting

  • Automatic generation of Excise documentation; forms W1 and W5D in HMCE approved format.
  • Automatic application of new duty rates on date effective.