Purchase Orders

The Purchase Order model analyzes the purchase order process from planning to fulfillment. The model provides the users the ability to analyze planned purchase orders and purchase orders by status, supplier, and purchase agreements. It also provides analysis on the variances between the requested and confirmed delivery date, purchase price, and quantity, the accuracy of which depends on whether the confirmation process of a purchase order is performed or not.

The facts in this model can be analyzed by these dates:

Order Entry Date
Planning Date
Release Date
Order Date
Confirmed Delivery Date
Requested Delivery Date

Note: Planned purchase orders can only be analyzed using Order Entry Date, Planning Date, Order Date, and Release Date. Purchase orders can be analyzed by all dates except Release Date.

Source information

The Purchase Order model is based on the Procurement module in M3 BE. The model contains information from MPOPLP (Planned Purchase Orders), and MPLINE (Purchase Order Line) including the respective header information (MPHEAD). The model is made up of several scripted sources that combine header and line information into one view. This view can be translated into one or more physical fact tables within Birst depending on the grain.