Why Archive Plan Summary inserts records in MSC_ITEM_INVENTORY_F table as order date on Sat and Sun
Why Archive Plan Summary inserts records in MSC_ITEM_INVENTORY_F table as order date on Sat and Sun .
We are facing issue in BI reporting , that we can see Safety Stock quantity on Saturday and Sunday only.
After archiving ASCP Plan data , then running Archive Plan Summary request , inserts data into MSC_Item_Inventory_F table.
SS calculated on Days bucket.
for E.g.
SS on
MON --- 150000
TUE --- 150000
WED--- 150000
THU--- 150000
FRI--- 150000
We observed that data has inserted with order date only on saturday and sunday. two records each day SS.
SAT---- 150000
SAT---- 150000
SAT---- 150000
SAT---- 150000
SAT---- 150000
SUN--- 150000
SUN--- 150000