Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jolene Bettle]

Hi Everyone,

We are looking for some guidance with the fixed asset locations field in D365. We were recommended to not use the locations field since is would be duplicating maintenance efforts. (Our locations are a combination of two of our financial dimensions) Our concern is the implications with Power BI reporting that does use location, if we don’t populate the field then how easy is it to determine what location the fixed asset is in through the dimensions.

Any advice on this would be great. Do you use the location field, is it beneficial, not beneficial? 
Thanks.

——————————
Jolene Bettle
Process Documentation Finance
Kent Building Supplies
Saint John NB
——————————

[Ludwig Reinhard]

Hi,
You mentioned that your locations are a combination of two of our financial dimensions.
Do you use multiple books/value models?
I am asking this because the financial dimensions are setup at the book/value model level whereas the location is specified at the fixed asset record level.
If you use multiple books/value models and have different financial dimensions assigned to those books/value models you will have multiple locations for the same asset, right?
Have not seen a setup so far that uses a combination of financial dimensions for the location.
Would be interesting to know more details why this setup is made.
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Jolene Bettle]

We are a retail business with stores, properties, and various other operating units. Our fixed asset locations could be any of these. In our financial dimensions we were advised by our implementation partners that our retail stores should be in the retail channel dimension and the rest of our “locations” would need to be in a separate business unit dimension.

One fixed asset would only have either a retail channel or a business unit associated with it in the financial dimensions. We were also advised by our partners to no have locations in fixed assets because we can get the information detail from the financial dimensions. We are just concerned that we won’t be able to pull reports of all our fixed assets by financial dimension (location) without populating the location field on the fixed asset register.

Thanks.

——————————
Jolene Bettle
Process Documentation Finance
Kent Building Supplies
Saint John NB
——————————
——————————————-

[Ludwig Reinhard]

Hi,
To my knowledge, the fixed asset reports do not show financial dimensions by default unless they are modified.
I do not know whether those modifications have been made and what instrument (SSRS reports, BI cubes, …) you use for your fixed asset reporting.
I guess the best thing is talking to your implementation partner again to explain you in more detail what they envisioned for the fixed asset reporting.
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Zvika Rimalt]

As a very broad answer as I do not know the specifics of your implementation I would say that:

1. it’s probably not a great idea to identify a location of an asset by 2 separate fields where just one of them is ever filled . it will forever complicate your reporting.

2. One can imagine situations where you will want to have, in your location flag, different resolution than simply a “store” (and a store dimension) – let’s say if you have a “bulk storage” area in the store, a “retail area” and “office area” – you may find yourself in a situation where you want to be more specific about an asset location and not simply say “store X”

3. You mentioned you populate both “retail channel” and “business unit”  – are both getting stamped into ledger transactions resulting from the FA module (depreciation by business unit?, possibly asset value by business unit?) – answering this question can help you figure out if you really need 2 financial dimensions set for each asset book.
As Dr. Ludwig mentioned, there can be multiple books per asset hence can complicate your attempt to track asset physical location using financial dimensions

——————————
Zvika Rimalt
BSA Finance
Vancouver BC
——————————
——————————————-