BeyondERP.Newsletter
Menu

Job page · Inventory management

Linked dimension update

A periodic job that updates open transactions with the financial dimension value linked to each site when the site dimension link is locked.

Business process
Maintain inventory levels
Menu item
action:InventSiteDimensionUpdate
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 updates open transactions with the financial dimension value linked to each site when the site dimension link is locked.
What you do hereUse this periodic task to bring open transactions in line with the financial dimension values set for sites, so that profit and loss can be calculated per site.
Linked dimension update 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 processMaintain inventory levels
Menu pathInventory management › Periodic tasks › Linked dimension update
Set up firstDimension link Microsoft Learn Sites Microsoft Learn
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 lock the financial dimension link to sites, so open transactions carry the dimension value of their site.
How oftenOnce, when you lock the link, and again each time you lock it after unlocking.
What the output showsOpen transactions that use both inventory and financial dimensions get the linked dimension value of their site, and Current status shows the link is locked. Postings then fail when the dimension value doesn't match the site.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Linked dimension update.
  2. Go to Inventory management > Setup > Posting > Dimension link and make sure the financial dimension is linked to the Site storage dimension and each site has a financial dimension value.
  3. Select Activate link if the link isn't active yet.
  4. Select Lock link. In the Linked dimension update dialog, select OK to update all open transactions with the value set for each site.
  5. Check that the Current status field shows that the dimension link is locked.

Source: Microsoft Learn

Test checklist

  1. Current status shows the link is locked.
  2. An open transaction for a site carries that site's dimension value.
  3. A posting with a different dimension value for the site is blocked.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undonePartly: You can unlock or deactivate the link afterwards, which lets you change dimension values on open transactions and sites again. Values already written to transactions aren't put back. Microsoft Learn
If you change it laterOnce the link is locked, transactions can be posted only when the linked dimension value matches the site, and the value set for a site can't be changed until you unlock the link. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventSiteDimensionUpdate Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itAccounting manager LedgerAccountingManagerRental sales manager RentalSalesManagerRental manager RentalManagerRental purchasing manager RentalPurchasingManagerAccounting supervisor LedgerAccountingSupervisorGive people one of these roles. On this system, 5 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources