How does the 'Order List Financial (WIP)' dashboard work?

Target Audience

• Controllers
• Management

Where in MKG?

1. Open the My Company module.
2. If the dashboard is not displayed immediately: click on the hamburger icon in the top right of the button bar and select the 'Forms' » 'Dashboard' option.
3. Click the Views button and select Order List Financial (WIP) (8003).

Main Components

• Overview of sales orders with order value, invoicing, and work in progress.
• Analysis of sales order lines.
• Analysis of linked production orders.
• Summary per sales group.
• Summary per production group.
• Filters on sales group, production group, and debtor.

Display and Usage

At the top, filters are displayed for period, sales group, production group, and debtor. The dashboard contains a tab with detailed information and a tab with summaries. In the detail tab, you see sales orders, sales order lines, and linked production orders including financial values and percentages. In the summary tab, the same data is grouped by sales group and production group. This allows you to analyze both detailed and aggregated financial information.

Parameters

• Period: the period up to which financial data is displayed. Possible values: 1 to 13 and 99.
• LinkDateCheck: enables or disables the check on linking dates.

Particularities

• If MKG is set up with an extensive financial setup, the 'Order List Financial' connects to the following sub-administrations: Invoiced terms, Pre-invoiced revenue on WIP, WIP man, WIP machine, WIP material, and WIP outsourcing. Read more about the financial setup of MKG here.
• The administration setting 'Revenue via balance' must be checked. This can also be enabled if there is no extensive setup.

Administration Settings Financial » Processes » Automatic Entries

Technical Explanation

Primary Data Source

• WIP value substantiation (saleohw)

Indirectly Consulted Data Sources

• Debtors (debi), Sales Orders (vorh), Sales Order Lines (vorr), Sales Groups (vrkg), Production Order Semi-finished Products (prdr), Production Orders (prdh), Production Groups (prdg)

Data Source Filtering

• No filter is defined on the primary data source.
• The Period parameter is used for dataset selection and display of financial data up to a selected period.
• Dashboard filters are available for sales group, production group, and debtor.
• The Linked production orders section contains an item filter that only shows records with a linked production order (Not IsNullOrEmpty([prdh_num])).

Calculated Fields

• Period: contains the selected period.
  Calculation: uses parameter Period.
• Debtor name: shows the company name of the debtor or an indication for stock.
  Calculation: shows stock when no sales order is present, otherwise debi_naam.
• WIP total: calculates the total work in progress amount.
  Calculation: sums bdr_ohw_mach, bdr_ohw_man, bdr_ohw_mat, and bdr_ohw_uitb.
• Sales line description: shows a description of the sales order line.
  Calculation: uses prdr_oms_1, the text Term, or vorr_oms_1 depending on the situation.
• WIP %: shows the percentage of work in progress relative to invoicing.
  Calculation: divides the sum of WIP total by the sum of Invoice total.
• Invoiced %: shows the invoicing percentage relative to the order value.
  Calculation: divides the sum of Invoice total by the sum of bdr_order.
• Sales group: shows the sales group including code.
  Calculation: combines data from vrkg_num and vrkg_oms or shows a default value when no sales group is present.
• Production group: shows the production group including code.
  Calculation: determines the production group based on linked production data and combines code and description.
• MKGDataDashboardTitle: contains a dashboard title.
  Calculation: contains an empty text value.
• OHW type: classifies the type of work in progress.
  Calculation: determines a type code based on the relationship between production orders and subassemblies.
• Invoice total: calculates the total invoiced amount.
  Calculation: sums bdr_termijn, bdr_omzet, and bdr_resultaat.
• Spacer: used as a separator field in the dashboard.
  Calculation: contains no value.
• WIP type description: shows a description of the type of work in progress.
  Calculation: translates the value of OHW type to final assembly, subassembly, or material.
• Debtor: shows the debtor including debtor number.
  Calculation: combines debi_naam and debi_num or shows inventory when no debtor is present.
• Financially ready: indicates whether reporting financially ready is possible.
  Calculation: shows an indication when kan_fin_gereed_gemeld is true.
• On AC: indicates whether a line is on actual costs.
  Calculation: shows an indication when vorr_op_nacalculatie is true.