INTEGRATED FINANCIAL &
STOCK MANAGEMENT SYSTEM

Hills Transplants have been using custom databases for the complex scheduling and management of millions of seedlings for over 20 years. In 2006 it was identified that a new system could greatly improve the efficiency of their management and administration. Key goals of the system were to:

  • Bring all aspects of the business together into one unified system, and thus reduce the need for manual transfer of data
  • Prevent data corruption by having strong validation, full multi-user capabilities and an appropriate level permission system
  • Create an intuitive interface and help system so that a new employee can pick up the system with minimal training
  • Provide a seamless transition from the old system, included importing all relevant historical data
  • Ensure long term system performance

Datalive Software were given the opportunity to develop the system, and over the following 2 years the following modules were delivered, integrated and started in operation one at a time. This allowed critical problem areas to be addressed first and allowed feedback and refinements of each section to be completed before moving on to the next. When completed we were then able to go back over the whole system and provide new capabilities that had previously not been possible.

KEY GOALS

  • Prevent data corruption
  • Create an intuitive interface
  • Reduce the need for manual transfer of data
  • Full multi-user capabilities
  • Seamless transition from old to new system
  • Fast system performance

TECHNOLOGY

  • Microsoft .NET 2.0¬†(Windows Client Application)
  • SQL Server 2005 (Database Server)
  • Screen Casting (Help System)
  • Excel Spreadsheet Generation¬†(Advanced Reporting)

DATABASE MODULES

The system is comprised of five main modules:

Hills Sales Chart

Accounting

  • Chart of Accounts
  • Budget
  • Transaction Journal
  • General Journal
  • Bank Reconciliation
  • Reports
    • Profit & Loss
    • Cash Statement
    • Balance Sheet
    • Trial Balance
    • GST Report
    • General Ledger
    • Sales Charts

Hills Invoicing Docket

Invoicing

  • Clients
  • Sales
  • Receipts
  • Tray Returns
  • Banking
  • Print / Email
    • Invoices
    • Statements
    • Summaries
    • Aged Debtors

Nursery management moduleNursery Manager

  • Item File
  • Houses
  • Orders
  • Seed Inventory
  • Tray Tags
  • Transfers
  • Reports

 

Purchasing

  • Suppliers
  • Purchases
  • Payments
  • Reports
    • Summaries
    • GST
    • Aged Payables

Payroll ModulePayroll

  • Employees
  • Activities
  • Payroll Entry
  • Options
    • Tax Rates
    • Pay Categories
    • Superannuation

Hills Transplants
Hills Transplants
is a wholesale seedling nursery based in Don, Tasmania. Datalive Software has developed a fully integrated financial and stock management system that allows them to operate more efficiently than ever before

Photo by EyeintheSky