Access Database for Enhanced ERP Reporting

Posted: 1 year ago
ERP Data Reporting - my customer's ERP system was very old (DOS based) and had only a few reports, none very useful. So I created much better reports, forms and user-friendly searchability to help management see warning signs and high-level summaries, and drive their decisions. I presented the data in several ways, including grouping all associated sales orders, work orders and purchase orders together for every top level order. The report had conditional formatting based on whether orders are close to shipping or already late. I also provided a slick indented BOM report to make sure all the necessary parts for a machine are on order and accounted for.