Skip to main content

← All solutions

Dynamics 365 historical reporting: reconstruct past business positions

· 5 min read
Calum Miller
Director

Dynamics 365 historical reporting asks what the business looked like at an earlier reporting date, using the information available at an agreed cut-off. Today's order status, customer mapping or forecast amount may have changed since the original management pack was approved.

An independent data warehouse can retain captured changes and publication snapshots, allowing finance and operations to reproduce a past position and explain the movement to the current one.

Why a current report can change the historical picture​

A September order can be fulfilled in October. A salesperson can revise a closing date, and a corrected transaction can arrive after a report has been issued. Filtering today's extract by creation date does not recreate all the values that applied before those changes.

Dynamics 365 is a family of applications. An open-order history in Finance and Supply Chain Management, an opportunity history in Sales, and an order history in Business Central need different source records and extraction designs. Specify the application, environment and legal entity before promising that a historical position can be reproduced.

For Sales and other Dataverse applications, auditing can retain selected record and field changes when configured. Coverage, permissions and retention policies need checking. Audit evidence can contribute to reconstruction, but it is not automatically a complete reporting snapshot. Read Microsoft's Dataverse auditing guidance.

For Finance and Supply Chain Management, validate the available transaction evidence and captured changes for every required table or entity. A current-state export alone cannot establish every previous status or relationship.

Real-world example: Poloplast connected planning and operations​

Microsoft's Poloplast story describes moving from a legacy AS/400 ERP to Dynamics 365 Finance and Supply Chain Management, connecting demand planning, financial processes and operational insights. Read the Poloplast story.

That connected planning context makes historical evidence useful: teams may need to explain which demand and order information informed an earlier decision. The snapshot scenario below is illustrative; the published story does not claim Poloplast uses this warehouse design.

Worked scenario: an £800,000 order book becomes £560,000​

Consider an illustrative distributor whose approved 30 September report shows £800,000 of remaining confirmed order value, before tax, in one reporting currency. The next few days bring legitimate business activity.

EventChange in open valueRemaining order book
Approved 30 September snapshotOpening position£800,000
October fulfilments−£150,000£650,000
October cancellations−£60,000£590,000
October price or quantity amendments−£30,000£560,000

Assume the events apply after September and the reductions do not overlap. The current order book is £560,000, but the original September report remains £800,000. The £240,000 movement can be traced to fulfilments, cancellations and amendments.

A later correction effective in September requires a separately identified corrected view. Retain the original snapshot and the evidence explaining the revision, rather than silently replacing the previously issued figure.

Why has September’s order book changed. Approved historical order book: £800,000; Later October activity: −£240,000; Current remaining order value: £560,000. Preserve the £800,000 snapshot and explain the movement. Illustrative scenario, not client results. (opens the full-size image in a new tab)

What to retain in a historical Dynamics 365 model​

Keep source application, environment and company or legal-entity identifiers together with transaction and line identities. A Dynamics 365 Sales account represents a customer organisation; it is not interchangeable with a Finance legal entity. Retain quantities, statuses, currencies, prices and links to fulfilments, invoices and credits. Use source change timestamps and warehouse capture timestamps where available.

Customer hierarchies and product mappings need versions too. Applying today's customer-group structure to every earlier period can change a comparison even if the underlying orders have not moved.

Snapshots preserve observed states. Event and audit history can explain changes between them. A daily extract may miss an amendment made and reversed within the day, so the capture method must match the required reporting resolution.

A practical first engagement​

  1. Select one company or legal entity, one reporting period and an agreed open-order definition.
  2. Reconcile a retained extract to the approved source report.
  3. Capture the changes and related documents that affect that position.
  4. Reproduce the approved snapshot after subsequent operational activity.
  5. Demonstrate a supported movement bridge and a separate correction process.

Measure the time needed to retrieve an old balance and the proportion of differences that can be explained from retained evidence. Preserve the transformation version and parameters used for each publication.

Keep history usable when the ERP changes​

An independent warehouse can retain permitted records, snapshots, mappings and calculation logic under your organisation's control. Test that a historical pack can be rebuilt without a live source query before an ERP migration or subscription change. Continued source updates still require an authorised, functioning connection.

Frequently asked questions​

Does an independent warehouse replace Dynamics 365 audit trails?​

No. It can incorporate available audit evidence and add cross-system reporting history. Source audit controls remain important for operational accountability.

Can we recover history that was never captured?​

Only to the extent that trustworthy evidence survives in source history, backups or retained reports. Agree the limitations before promising a historical reconstruction.

Continue exploring Dynamics 365 reporting​

Back to the independent Dynamics 365 data warehouse overview.

Make your Dynamics 365 reporting explainable

Talk to Millersoft about a focused Data Vault Engine & Studio pilot using your permitted source data, reporting definitions and retention requirements.

Discuss your Dynamics 365 reporting challenge

Microsoft and Dynamics 365 are trademarks of the Microsoft group of companies. Millersoft is not affiliated with or endorsed by Microsoft.