Saturn: a purchase order system for agricultural products

The problem

The client was a start-up business sourcing agriculture chemicals, fertilisers and agronomy to to corporate farming enterprises throughout Australia.

The company's medium-term plans involved installing a full e-commerce system to handle orders via the Internet. In the short-term they required a relatively simple computerised system to manage orders and forecasts of orders from customers, consolidate those orders, produce purchase orders to their suppliers, produce delivery notes for the carrier, and print other reports for internal control.

The solution

DI Management was commissioned to create the system, called "Saturn" after the Roman god of agriculture.

The system was written in Microsoft Access 97 and designed to be used by a few users on a local area network. It was supplied with a full help menu.

Later, we added a web-based forecast entry system to enable the larger clients to be able to change and review their own forecasts directly on line.

The system carried out the following functions:

• Forecasts: Stored future estimates of products required by farm and date
• Customer Orders: Confirmed orders from customers.
• Purchase Orders: Consolidated purchase order to supplier or manufacturer.
• Deliveries: Produced delivery note for carrier to deliver goods from pickup point to farm.

The Products were classified by both their trade name and by their active chemical. Their costs were stored for each manufacturer that supplied them.

A full help menu was supplied for users:

For more information Contact DI Management.    Return to Projects Summary.    [Top]