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.
*This post is locked for comments