Vendor Spend and Open Commitments
Requirement
Monthly view of committed, invoiced and open spend by vendor and plant, in one reporting currency, with aging of open orders and drill-down to the order.
Outcome
48 vendors, 12 months, 576 vendor-period rows: 9.81M USD committed, 3.12M USD open, 1.41M USD open over 90 days. Four currencies at month-end rates; a blocked invoice shows as blocked, not as paid.