When customizing the item master in Dynamics 365
Finance and Operations (D365FO), one common question is:
Should I extend InventTable or EcoResProduct?
Here’s a WorthKnowing guide to help you decide:
1. InventTable
- Purpose:
Holds inventory-specific data for released products.
- Scope:
Company-specific (per legal entity).
- Use
When:
You need to add fields related to: - Inventory
management
- Warehousing
- Sales
or purchasing
- Any
data that varies by company
- Examples:
Item group, inventory dimensions, default warehouse, sales price.
2. EcoResProduct
- Purpose:
Stores the core product definition (product master).
- Scope:
Shared across all companies (global).
- Use
When:
You need to add fields related to: - Product
identity
- Technical
specifications
- Data
that should be consistent across all legal entities
- Examples:
Product name, product type, product number, technical specs.
Knowing the difference between these two tables can save you
time and ensure your customizations align with D365FO’s architecture. Choose
wisely based on the scope and nature of your data.