How does the 'Price Differences Analysis' dashboard work?

Target Audience

• Controllers
• Purchasers

Where in MKG?

1. Open the My Company module.
2. If the dashboard is not displayed directly: click the hamburger icon in the upper right corner of the button bar and select the 'Forms' » 'Dashboard' option.
3. Click the Views button and select Price Differences Analysis (8018).

Main Components

• Analysis of price differences per item.
• Analysis of price differences per transaction moment and per month.
• Comparison between inventory value, price differences, and realized results.
• Financial analysis per inventory group, transaction type, and ledger account.
• Filter options by module, inventory group, and item.

Display and Use

The selected fiscal year and period range are displayed at the top. You can filter by module, inventory group, and item. The 'Price Differences' tab shows detailed information per item, price differences per moment, and price developments per month. The 'Financial' tab shows a breakdown of the financial consequences per inventory group, transaction type, and ledger account, with situations with and without price differences presented separately.

Parameters

• FiscalYearFrom: start fiscal year of the analysis.
• FiscalYearTo: end fiscal year of the analysis.
• PeriodFrom: start period of the analysis. Default value: 1.
• PeriodTo: end period of the analysis. Default value: 99.

Technical Explanation

Primary Data Sources

• Financial transaction (fmut), t_rapport_datum

Indirectly Queried Data Sources

• Items (arti), Ledger Accounts (grbk), Fiscal Years (adbj), Periods (peri), Production Orders (prdh), Production Order Subassemblies (prdr), Purchase Invoices (ifch), Purchase Invoice Lines (ifcr), Inventory Groups (vrdg)

Data Source Filtering

• A filter is active on the primary data source: fmut_subtype In (25,26,27,28,55,56,57,58).
• Only financial transactions within the selected fiscal year range (adbj_boekjaar Between FiscalYearFrom and FiscalYearTo) are processed.
• Only financial transactions within the selected period range (peri_num Between PeriodFrom and PeriodTo) are processed.
• Only transaction types 09 and 16 are included (fmut_type In (9,16)).
• The Details overview shows only records where price differences are present (Price difference = true) and an item is filled (arti_code not empty).
• The financial overviews under “Journal Entries without Price Differences Excluded” show only lines with price differences (Price difference = true).
• The charts “Price Difference per Moment” and “Price Difference per Month” show only records for which a price difference is present.

Calculated Fields

• Header/Line: shows a combined reference to the source line of the transaction.
  Calculation: combines depending on fmut_type the fields prdh_num and prdr_num or ifch_num and ifcr_num.
• Spacer: used as a separator field in the display.
  Calculation: contains an empty text value.
• VVP: calculates the fixed transfer price per piece.
  Calculation: divides the inventory value of transaction types 25 to 28 by fmut_aantal.
• Result per unit: calculates the result including price differences per piece.
  Calculation: adds inventory value and price differences together and divides this by fmut_aantal.
• VVP Mat: calculates the fixed transfer price of material per piece.
  Calculation: uses mutations with subtype 25 divided by fmut_aantal.
• VVP Man: calculates the fixed transfer price of man hours per piece.
  Calculation: uses mutations with subtype 26 divided by fmut_aantal.
• VVP Mach: calculates the fixed transfer price of machine costs per piece.
  Calculation: uses mutations with subtype 27 divided by fmut_aantal.
• VVP Outsourcing: calculates the fixed transfer of outsourcing per piece.
  Calculation: uses mutations with subtype 28 divided by fmut_aantal.
• KPS: shows the cost price system used.
  Calculation: translates arti_code.arti_kostprijssysteem to "FTP", "ATP", "ASP" or "None".
• Price difference: indicates whether a transaction relates to a price difference.
  Calculation: returns true when fmut_subtype belongs to 55, 56, 57, or 58.
• GPR: indicates whether batch registration is active.
  Calculation: shows "CBR" when arti_code.arti_partij = true.
• FiscalYearFrom: contains the selected start fiscal year.
  Calculation: uses parameter FiscalYearFrom.
• FiscalYearTo: contains the selected end fiscal year.
  Calculation: uses parameter FiscalYearTo.
• PeriodFrom: contains the selected start period.
  Calculation: uses parameter PeriodFrom.
• PeriodTo: contains the selected end period.
  Calculation: uses parameter PeriodTo.
• Warning: shows a warning when no fiscal year range is selected.
  Calculation: displays a message when FiscalYearFrom or FiscalYearTo is empty.
• MKGDataDashboardTitle: contains a dashboard title.
  Calculation: contains an empty text value.