Supply chain | Supply Chain Management, Commerce

'Financial Inventory' option at Storage dimension groups

(1) Share

Report

Posted on by bansaripandya

Dear community,

What is the impact in overall Dynamics 365 F&O system, when enable or disable 'Financial Inventory' tick at Storage dimension group?

Thanks!!

Categories:

Dynamics 365 Supply Chain Management

All responses (3)

Answers (0)

André Arnaud de Cal... 291,431 Super User 2024 Season 2 on at

Like (0)

Report
'Financial Inventory' option at Storage dimension groups

Hi Bansaripandya,

In addition to the replies which should give you understanding of the primary function of the Financial inventory field, it has some more impact:

It determines if there will be accounting entries created when using a transfer journal. E.g. if the Financial inventory is not enabled for warehouse, it will not create accounting entries in case there is a movement of goods from one warehouse to the other in the same site.

It determines on what level you can use the cost on the Inventory value reports.
Suggested answer

sagar_patil 506 on at

Like (0)

Report
'Financial Inventory' option at Storage dimension groups

Financial Inventory means tracking and valuing inventory not just physically (like counting items in a warehouse) but also financially—tracking the money tied up in those items. It helps businesses understand the cost value of their inventory when selling, invoicing, or closing accounts.

If you enable the Financial Inventory checkbox, the system treats this dimension (like size, color, or warehouse) as important for calculating costs, profits, and other financial metrics.

Imagine you own a business selling t-shirts in two warehouses—one in Mumbai and one in Delhi.

Without Financial Inventory:
The system only tracks how many t-shirts you have (say, 100 in Mumbai and 50 in Delhi). It doesn’t care if t-shirts in Mumbai cost ₹200 each and in Delhi cost ₹250 each. All t-shirts are treated as if they cost the same.

With Financial Inventory:
The system tracks both the quantity and the cost per warehouse. So, when you sell 10 t-shirts from Delhi, the cost is calculated as ₹250 per t-shirt, not ₹200 (like Mumbai).

I hope this answer your question.

Note: Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.
Suggested answer

Danny Bilodeau 4,119 Super User 2024 Season 1 on at

Like (0)

Report

'Financial Inventory' option at Storage dimension groups

Hi,

It affects how granular you want to be in tracking financial inventory. For example in an moving average cost scenario, do you want to calculate the average cost at the warehouse level or is averaging at the Site level sufficient? If only Site is enabled, receipt of POs and issues to SOs in all warehouses are going to be averaged at the Site level and the average cost will be the same no matter which warehouse. On the other hand, if warehouse is enable for financial inventory, the same item will have a different average cost for each warehouses.

Hope that helps!