FileMaker Database Project Case Study

Processing Orders with an Enterprise Purchasing System

The lack of integration with an enterprise purchasing system bogged down processing orders for a biology lab at a university. Each order needed to be properly coded to ensure that the costs associated with orders were distributed accurately among the appropriate accounts (cost objects).

Data was entered into the biology department’s ordering system, paper printouts were produced, cost coding was hand-written on the printouts and the paper-work was submitted to accounting where it was re-entered into the enterprise purchasing system. Emails would go back and forth to resolve discrepancies in the accounting.

Using a well constructed FileMaker database the biology department integrated the processing of orders seamlessly with the enterprise purchasing system, eliminating the need for double entry, extra work and reconciliation of accounting discrepancies.