Discontinued items should not flow to store database

(0) Share

Report

Posted on by Razal

200

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.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Shaimaa Abo Gabal Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Code behind sync prices to PriceDisctable in channel side

Please noted that items must be marked as stopped in all LEs to be removed from the lookup tables

This feature introduced in version CU13 and addressed by this fix Details for issue 3795806 (dynamics.com).

Was this reply helpful? Yes No