BeyondERP.Newsletter
Menu

Job page · Inventory management

Inventory journal data correction

A periodic job that deletes on-order or ordered inventory transactions that point to posted or missing inventory journals.

Business process
Manage data
Menu item
action:InventJournalDataManualCorrection
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic job that deletes on-order or ordered inventory transactions that point to posted or missing inventory journals.
What you do hereUse this periodic task to clean up leftover inventory transactions from journals, with the option to also remove unposted transactions that have no journal lines.
Inventory journal data correction 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

Business processManage data
Menu pathInventory management › Periodic tasks › Clean up › Inventory journal data correction
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 on-order or ordered inventory transactions are left behind by inventory journals that are already posted or no longer exist, and only with a good reason.
How oftenRarely, on demand, after testing in a test environment.
What the output showsNo report and no log. On-order and ordered transactions that link to posted or missing journals in the current company are deleted, plus orphan unposted ones if you chose that. Wrong on-order figures that remain usually come from another source.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Clean up > Inventory journal data correction.
  2. Read the warning under Parameters: the transactions are deleted for good, no alert or database log is created, and Microsoft advises testing carefully before you run it in production.
  3. Set Clean up orphan unposted inventory transactions to Yes to also delete unposted transactions that have no journal lines, or No to delete only on-order and ordered transactions that point to posted or missing journals.
  4. Use Records to include to limit which transactions are included, and set batch options under Run in the background.
  5. Afterwards, open the on-order and ordered quantities of affected items: leftover transactions from posted or deleted journals no longer add to them.

Source: Microsoft Learn

Test checklist

  1. On-order and ordered quantities no longer include the leftover transactions.
  2. Transactions of open journals are untouched.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted inventory transactions can't be restored and no log is kept. Test carefully before you run it in production. Microsoft Learn
If you change it laterThe transactions are deleted for good and no log is kept, so test carefully before running the job in production. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventJournalDataManualCorrection Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=action:InventJournalDataManualCorrection
Everyone

7Sources