BeyondERP.Newsletter
Menu

Setup page · Cost 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 pathCost management › Ledger integration policies setup › 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.

Steps from Microsoft

  1. Go to Cost management > Ledger integration policies setup > Linked dimension update.
  2. Make sure each site has a financial dimension value and that the link is active.
  3. Select Lock link.
  4. In the Linked dimension update dialog, select OK to update all open transactions.

Source: Microsoft Learn

Test checklist

  1. Check every site has a value for the linked dimension.
  2. From Dimension link select Lock link and select OK in the Linked dimension update dialog.
  3. Open an open sales or purchase line and check its linked dimension now equals the site value.
  4. Check Current status shows Dimension link is locked.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneHard to reverse: The Linked dimension update runs when you activate or lock the site dimension link. Locking updates all open transactions to the site's dimension value; unlocking or deactivating the link later doesn't put the old values 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 LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorRental sales manager RentalSalesManagerRental purchasing manager RentalPurchasingManagerRental manager RentalManagerGive 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