Hello D365 Experts _ F&O
I’m working on an interesting business requirement for one-time item creation in Dynamics 365. As you know, once an item is created and used in a transaction, it becomes very difficult to delete that item due to the existing transaction history.
Business Scenario:
Our customer deals with steel plates and other custom-sized plates that they purchase and stock. These plates can have n-number of possible combinations (e.g., 1.1x1.1x1.1, 1.2x1.2x1.2, and so on). While there are standard plate sizes that we treat as regular products, the challenge arises with custom sizes.
Creating individual item masters for every custom size is not practical, as it could result in 50,000 to 100,000 new items annually. This would negatively impact system performance and data maintenance.
Key Requirements:
- Avoid cluttering the product master with too many items.
- Track inventory for custom plate sizes effectively.
- Maintain the ability to report how many units of each configuration are in stock.
- Allow easy configuration of sizes at the time of receiving or ordering.
Possible Solutions We Are Considering:
-
Constraint-Based Configuration Model:
- Can we use constraint-based configuration models to handle these plate sizes dynamically without creating individual items for every configuration?
- How feasible is it to use these models for purchase orders and receiving custom-sized inventory?
-
Batch Number Tracking:
- Another idea is to create a generic product for custom plates and use batch numbers to record the dimensions (e.g., batch number = 1.1x1.2x0.5).
- Would this approach be suitable for inventory tracking and reporting?
Questions for the Community:
- Has anyone implemented one-time item creation solutions successfully in D365? What challenges did you face?
- Which approach would you recommend for our scenario? Constraint-based configuration or batch number tracking, or is there a better solution we haven’t considered?
- How does batch tracking for dimensions impact inventory visibility and operations in D365?
Looking forward to your thoughts and insights!
