| PLM vs BC vs Actual Consumption Reconciliation Phase 2

Upload Files

Upload PLM, BC, and optionally Production Order Component Lines. Use the Profiles & Setup tab to review column mapping, business rules, and saved configurations before running comparison.
This run will use the default setup unless you choose a saved profile.
Use the normal PLM, BC, and optional Actuals upload flow.
PLM BOM
Drop one or more files here or click to browse
BC BOM
Drop one or more files here or click to browse
ILE / Actuals
Optional Item Ledger Entries or Production Order Lines
Assigned User Mapping
Optional item-to-user mapping for the Assigned User summary
Profiles, column review, business rules, previews, and exception management are in the Profiles & Setup tab so the Current Run view stays focused on upload and output.

Run Configuration

The settings below were applied to this comparison run.

Management Summary

Management summary across PLM, BC, and Actuals / ILE. Interactive reconciliation view.

Overview Detail

Health ▲▼ Bucket ▲▼ Item ▲▼ Description ▲▼ Assigned User ▲▼ PLM ▲▼ BC ▲▼ Actuals ▲▼ PLM / BC Status ▲▼ Actuals Bucket ▲▼ Qty Detailed Status ▲▼ PLM Qty ▲▼ BC Qty ▲▼ Actual Qty ▲▼ Total Cost Diff ▲▼ Unit Cost Status ▲▼ Total Cost Status ▲▼

Positional Alignment

Heuristic investigation view. PLM and BC source order stay unchanged.

Positional Detail

Alignment ▲▼ Detail Known Exception PLM Row ▲▼ PLM Item ▲▼ PLM Qty ▲▼ Level ▲▼ PLM Parent ▲▼ BC Row ▲▼ BC Item ▲▼ BC Qty ▲▼ Root ▲▼ PLM Path ▲▼

Aggregate Summary

Official item-total comparison for reconciliation and costing checks.

Aggregate Item Detail

Status Detail Known Exception Item ▲▼ PLM Qty ▲▼ BC Qty ▲▼ Diff ▲▼ PLM Occ ▲▼ BC Occ ▲▼ Root(s) PLM Path Format Match

Actuals / Consumption

Project + item level comparison only. RPO not available may mean stock existed, so no RPO was required.

Actuals Detail

Status ▲▼ Overlap ▲▼ Item ▲▼ Project ▲▼ BC Qty ▲▼ Planned / Expected Qty ▲▼ Remaining Qty ▲▼ Consumed Qty ▲▼ Open RPOs ▲▼ Open RPO Details ▲▼ BC Avg Unit Cost ▲▼ BC Cost Details ▲▼ Actual Avg Unit Cost ▲▼ Actual Cost Details ▲▼ Unit Cost Diff ▲▼ Planned Total Cost ▲▼ Actual Total Cost ▲▼ Total Cost Diff ▲▼ Cost Status ▲▼ RPO Count ▲▼ RPO Sample ▲▼ BC Roots ▲▼ Raw Material Ref ▲▼

Methodology

What is exact, what is assumed, and how each report should be used. For workflow guidance, use the left help rail or Start Tour.

Interpretation Notes

    Normalization Details

    Profiles & Setup

    Review mapping, project scope, rules, previews, and saved configurations here before running or rerunning a comparison.
    Default setup is active.
    Open the setup editor to confirm detected columns, project scope, and rules from the current uploaded files.

    Selected Profile

    Select a profile, then open its editor to change mappings and business rules before saving.
    Shared profile storage is managed on this server.
    Confirm the detected columns before running comparison. The setup only changes business mappings and project scope; it does not alter the source files.
    Business rules below let you refine the comparison assumptions that may vary between projects or exports without changing the report structure.
    Preview needs the current uploaded files and an opened setup editor. Then it shows how your current setup changes would affect key result counts before rerunning the full comparison.

    Past Runs

    Successful comparisons are archived on this server so files and generated reports can be downloaded again later.
    Successful comparison runs are archived on this server so they can be downloaded again.
    Archived runs are stored on this server and can be downloaded again.

    Guide & Help

    Use this page for workflow guidance, feature context, and report meaning instead of mixing help text into the active run.