BeyondERP.Newsletter
Menu

Setup step on the Consistency check page · System administration

Run a consistency check on confirmed corruption

Check, and only then fix, inconsistent data for as few items as possible.

Business process
Administer system features
Menu item
action:SysConsistencyCheckBase
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic job that checks the data of a selected module for inconsistencies, first in Check mode and then, if errors are found, in Fix error mode.
What you do hereUse this task to check the data of a selected module for inconsistencies and, if errors are found, to correct them. For inventory on-hand data, run it only when you have confirmed corruption, ideally limited to the affected items.
ExampleFor example, run the On-hand check for one item, or as few items as possible, when its on-hand quantity looks wrong.
Consistency check page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen you have confirmed data corruption, for example on-hand that doesn't match the inventory transactions or an inventory close that fails on negative on-hand. Don't run it as routine maintenance.
How oftenOn demand only. Don't schedule it as a recurring batch job.
Batch settingsRun the Fix error pass in batch outside business hours, because it locks on-hand records for every item in scope.
What the output showsMessages in the Action center that list the inconsistencies found by each selected check; in Fix error mode the on-hand tables are rebuilt from the inventory transactions. Run time grows with the transaction history of the items in scope, not with their current quantity.

Source: Microsoft Learn

Setup steps on this page

Run a consistency check on confirmed corruption

Check, and only then fix, inconsistent data for as few items as possible.

Steps from Microsoft

  1. Go to System administration > Periodic tasks > Database > Consistency check.
  2. Set Module to the area to check, for example Inventory management, expand the tree and select only the checks you need, such as On-hand.
  3. Select the text of the row, open the More menu and select Dialog, and filter the run to the affected items; running on all items is rarely the right choice.
  4. Set Check/Fix to Check, run it, and review the messages in the Action center.
  5. Only if errors are confirmed, run again with Check/Fix set to Fix error, as a batch job outside business hours.
  6. Open the On-hand list for the items again and confirm that the original error is gone.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Check/FixCheck only reports problems; Fix error corrects them.Microsoft Learn Check first, Fix error only after errors are confirmed

Common errors and fixes

MessageWhat to do
On-hand clean up is failed for item <Item> in consistency checkThis is a warning. The recalculation for the item still finished; only the cleanup step was skipped. Run the on-hand cleanup jobs separately if you need those rows removed. Microsoft Learn

Test checklist

  1. The Check run reports no remaining errors for the items.
  2. On-hand quantities match the sum of the inventory transactions.
  3. Inventory close or recalculation no longer fails for the items.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run a consistency check on confirmed corruptionCheck mode first, filtered to the affected items; Fix error only after errors are confirmed, in batch outside business hoursLearn: the on-hand fix rebuilds on-hand from inventory transactions for the items in scope and, by default, deletes zero-quantity on-hand rows some reports use.How wide is the consistency check?Running Fix error for all items as routine maintenance; it locks on-hand for every item and removes rows historical reports need.Test: The fix repairs only the affected item

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager and Rental manager. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyRuns on the module and checks you select in the tree, limited to the items you filter in the dialog; nothing outside that selection is checked or fixed. Microsoft Learn
Can it be undoneNo: The fix is set-based and not easily reversed.
If you change it laterIn Fix error mode it rebuilds on-hand data from inventory transactions for the items in scope and, by default, also deletes zero-quantity on-hand rows that some historical reports use. Microsoft Learn
Technical architect

6Technical

Menu itemaction:SysConsistencyCheckBase Checked in Dynamics 365
Roles to set it up and use itTo use itInformation technology manager SysServerITManagerRental manager RentalManagerGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:SysConsistencyCheckBase
Data migrationLoad order: Consistency check has no data entity in Data management, so it can't be loaded from a file or a configuration template. It is an on-demand check with no data of its own.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SA-JOB-860, Run a consistency check on confirmed corruption. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SA-JOB-860