Dynamics Community Forum Thread Details

Discontinued items should not flow to store database

Hi All,

I would like to understand. how can i achieve of removing all discontinued items from store database whereas the item should be exist in HQ database. here is my scenario.

I have opened my fashion store in 2015. each item considering as each PLU (not following any dimension mechanism). over the years, new trends are coming and new PLUs getting added. to be frank am not selling the items that are added in 2015. after 5 years of time, my assortment list and relevant item list are gradually increasing. currently am holding 20000 SKUs only whereas overall 1 lakh of SKUs are there in the system. over 80k PLUs are discontinued. still these discontinued items are showing in my Retail POS while selling.

what is the setup do i need to follow in order to keep only 20k records in assortments, pricedisc and other item related tables.

Hi Rassal,

If you want to discontinued items from store database, you need to stop the item from selling in all legal entities. in the assortment processing, the product will be excluded from the assortment and table retailassortmentlookup hence pricedisctable . we used retailassortmentlookup to join with Pricedisctable when we sync sales prices.

Below is the setup required :

In AX, this property can be found under Products > Manage Inventory > Default Order Settings > Sales