The Pipe Ordering and Inventory Management System was created by Presence Consulting for Astoundry Inc.,
a technical service provider that works closely with companies in the oil industry.
The application manages data across the inventory control, sales and marketing departments. Application users
include inventory managers, sales and customer service representatives.
Application users can view the Sales Order page to review orders and corresponding quotes.
The Pipe Ordering and Inventory Management System has several focuses.
 |
The application’s Quote interface allows sales representatives to create customer-requested price quotes and convert them into sales orders.
|
|
The Sales Order interface lets users preview inventory to determine where to send the document next. The order, or a portion of the order, may be directed to the inventory business unit or to outside suppliers.
|
|
Purchase orders are automatically generated by the application, and are then routed to the appropriate persons.
|
|
The tracking function follows as supplies come in and products are shipped out, as well as tracking order fulfillment and client invoices.
|
|
There is also a reporting function for management.
|
The Pipe Ordering and Inventory Management System keeps track of the size, weight and grade of pipes in the
inventory system. When sales people receive a customer request, they login to the system to locate inventory
and verify availability. Sales people can also generate price quotes and purchase orders for inventory managers
and outside suppliers.
The custom Inventory user control allows application users to glance at supplies in stock. Once the desired products are selected, sales representatives can click on "Order from Inventory" or "Order from Supplier" to add rows into the Sales Order Details page.
The system delivers purchase orders directly to inventory managers who determine the next steps. In some cases,
the pipe may need threading, painting or a variety of other services before it is delivered to the customer.
The system calculates the incremental cost of the product throughout the process. Products are flagged when
they are complete and the application shows product detail in real-time. Once inventory is ready to ship to
the customer, users generate invoices and review a series of reports that the system automatically generates
for managers.
The Inventory Cost page was created for company managers. It allows them to view incremental cost increases on pipes that have already been sold. This page includes a balance column on the right which specifies any additional costs associated with a pipe and then calculates the average cost over time.
|
