Sales Orders

The Sales Order model analyzes the customer order process such as invoiced and not invoiced orders, and value or quantity by status.

The ability to analyze by different statuses enables the company to analyze open orders. An open order is an order that is not yet completed. Open orders occur when the customer has not yet paid outstanding invoices or when the company has not yet delivered the ordered goods.

Products, warehouse, and customer trends can be analyzed by using this model. The facts in this model can be analyzed by the order date.

Source information

The Sales Order model is based on sales performed using Customer Order Module (OIS) in M3 BE. Its main source is the transactional table customer order lines, OOLINE. There are two fact tables in this model, one based on order lines and the other based on order header data. All order lines regardless of status are captured.