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. Open orders occur when the customer has not yet paid outstanding invoices or when the company has not yet delivered the ordered goods.

You can analyze products, warehouse, and customer trends using this model.

Order Date, Planning Date, and Confirmed Delivery Date are used to analyze the facts in this model. See Infor M3 Analytics for M3 CloudSuites Administration Guide for a list of available dates for this model.

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, including the respective header information found in OOHEAD. This model consists of several scripted sources that combine header and line information into one view. You can translate this view into one or more physical fact tables within Birst depending on the grain.