Sales Order Processing and Claims System

Description: This system improved the quality and speed of post-shipping business transactions and captured associated data for future analysis. The project team utilized the full Artech life cycle from foundation through rollout. It:

  • Created new types of sales orders
  • Tracked orders
  • Managed full life cycle of claims
  • Handles claim notification and processing
  • Handled accounts receivable deductions
  • Shared data with financial systems

Business Benefits:

  • Improved claims processing by nearly 75 %, resulting in the potential consignment of fresh produce for resale
  • Tracked and managed millions of dollars worth of fresh produce annually
  • Saved millions annually
  • Resolved problems associated with incorrect billing, adjustments to revenues and receivables, order reversals
  • Responded to changes in pricing due to market price fluctuations

Technical Architecture:

  • Multi-tier client/server solution, utilizing a GUI client interface and accessing an Oracle database (DB) over a wide area network (WAN)
  • HP Unix server
  • Microsoft Windows NT networking
  • ERWIN data modeling
  • Oracle packages and procedures
  • Power Builder