i.03 DiP3 Monitoring Monthly

• Already checked by interface team
  Before starting the checks, be sure that the dynamic import is finished.
• Horizon Rotation is ok (Shifted to the correct month)

If not → wait until it end

Monthly stocks are coming from file EOMSTOCK, and keep in mind plant transcodifications are in place.

Check data consistency of the most important data : 

I500 - Imported stock datas (day) > I500 Initial Inventory (MD04 +MB5B for movements)

      =>For SILICA => Homologated inventory
      plant 7528 in SI DIP = plant 7525 in SAP

I402 End of month unrestricted Inventory (MB5B with last day of the previous month in date)

I402 - Actual Shipped at GI - site dim (MB51 from beginning to end of last month movement 601)
(Attention for Silica: in case of inconsistency, you might check the movements 633; because the movement is from shipped to consignment. Also movements 643 for cross company ) 

Check Actual production (a completer) (MB51 from beginning to end of last month movement 101&102 and also 131). Gaps can match by verifying that the movements from the last day of the previous month are taken into account in the current month.

For examples on 0278, 7525 

I400 - Intransit inventory in receipt date (MB5T) : Attention, not to check the shipto for this datafield; only for intersites. 

I400 Firm Shipment in shipping (MD04 customer order + Deliveries) : check the "MRP element" 

You need to compare with SAP or DP data to be sure that everything is ok.
In DP, user "DIP" can be used. 

1.1>> Simulation of user MGBA6210

1.2>> Workspace: CS - A2 SOP Planning

*key material 322098, 10455, 315600 (according to Patrick Mgba)

1.3>> Find a SKUs as example and check the following data:

• Initial inventory = between DIP and SAP (MB5B)  
• Firm independent requirement= between DIP and SAP (MD04 - MRP type = CusOrd/CusOrd for external, Ord.DS for internal)  
• Firm planned order = between DIP and SAP (MD04)  
• Intransit (In-Transit) = between DIP and SAP (MD04)  
• Forecast = between DP and DIP (Final Forecast ETD WS=A9) (ex of DFU: 98673R@55099R)  
• External purchase from SAP = between DIP and SAP (MD04 - MRP type = ShpgNt)  
• Firm receipt ETA = between DIP and SAP (MD04)  

Check the projected inventory calculated by the DRP is correct (month with qty = 0, or lower quantities than actuals...)

Check that the final demand after netting seems ok.

Check that export to BW batch has run without error (SBS technical view)

Screenshots:

• Initial inventory = between DIP and SAP (MB5B)  

• Firm independent requirement= between DIP and SAP (MD04 - MRP type = CusOrd/CusOrd for external, Ord.DS for internal)  

*Try to dill down to find out the related material code.

*To compare the data in SAP

• Firm planned order = between DIP and SAP (MD04)  

• Intransit = between DIP and SAP (MD04)  

• Forecast = between DP and DIP (Final Forecast ETD WS=A9) (ex of DFU: 98673R@55099R)  

DiP3

DP3

• External purchase from SAP = between DIP and SAP (MD04 - MRP type = ShpgNt)  

• Firm receipt ETA = between DIP and SAP (MD04)  

Check the projected inventory calculated by the DRP is correct (month with qty = 0, or lower quantities than actuals...)

Check that the final demand after netting seems ok.

Check that export to BW batch has run without error (SBS technical view)

Check between SAP and Dynasys the Forecast exported

=> Take 3 SKUs PW as examples by BU

> Novecare : in DIP, Final Demand after netting (last validated) in CS model

!!! Please take examples from Sites where forecast export is activated!!!

!!! Please take examples when forecast is different from 1 month to another !!!

(U01 - NOVECARE Z800 - S&OP Reference datas -->S&OP Validated - Final Demand ETD Sourced)

You can use this specific Grid view to help the monitoring ( <Make sure you have disconnect user right simulation>)

In MD63, please fill the Plant/Material and the month to check.

to:    sco-dynasysusersdip3@syensqo.com

title : DynaSys monthly update CS

Text :

Dear All, 

The monthly update is done. You can now connect into DIP.

SAP data will not be updated until the end of the netting process on the 4th of the current month. → Verify the date each month ! => corresponds to the Netting day

Next SAP data update takes place after S&OP validation on the 11th of the current month.  → Verify the date each month ! => corresponds to the day after validation

The remaining SAP data updates will take place every Saturday until the end of the current month.

Regards.

DynaSys - 2024 SOP Calendar => 

Example for Nov 2024,

Email Example,

• Check if the archiving is done correctly => to create a view with the date of archiving (calculation to be added in the sequence)

 Z800 should be equal to S&OP Validation  of Month M for M+1