We have a significant number of products in a lifecycle state of "Inactive": these are retired or obsolete item numbers. We have even more product variants that are inactive--although many of the parent Released Products are still active, so I need to exclude not parent Released Products but distinct inactive variants. We are on Standard Cost with Predefined Variant configurations.
I want to significantly reduce the time required to run a cost calculation and activation in our system but haven't found a good set of filters that will allow me to exclude inactive variants, specifically. Filtering Released Products by their lifecycle state is easy--but expanding that criterion to variants is not. Succeeding here would reduce our calculation effort from 96,000 unique records to almost 50,000.
I've tested any reasonable combination of table joins that I can think of: from Items to Released product variants or CDS Released Distinct Products, from Items to Items then again to Released product variants, etc. I also tried reverse logic on each attempt (using "is active" instead of "not inactive").
Any help is greatly appreciated!
32
Share
Report
All responses (
Answers (
