Level 2 sprint 3 - INV01 inventory ordering Grid

Highlighted
Occasional Contributor

Level 2 sprint 3 - INV01 inventory ordering Grid

there is an error detected in the highlighted cell

please advice how to get this corrected

11 REPLIES 11
Highlighted
Frequent Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

Hi @Donna Marie,

 

You just need to get data from DEM03 Demand Forecast and line item Final Forecast

 

Panji_0-1586138635409.png

 

Regard,

 

Panji

 

Highlighted
Occasional Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

I am already using this formula 'DEM03 Demand Forecast'.Final Forecast

 

the data seems fine for the entire row except for the cell highlighted

Highlighted
Frequent Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

Hi,

 

I think you should check formula in 'DEM03 Demand Forecast' maybe you miss something in a some line item, or can you give a screenshoot modul DEM03 with formula so i can identify to corrected

 

 

Regard,

 

Panji

 

 

 

Highlighted
Occasional Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

please find attached screen shot of the formulas used in DEM03 Demand Forecast module

Highlighted
Frequent Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

HI,

Thankyou for file attached, i think you need check data in week 1 - week 4 have same amount like this

 

Panji_0-1586148635935.png

note: in week 2 candyate im overide to  62

 

if not the same you can check in DAT03 Historical, if not same too maybe you need re-upload file volumes to DAT03 Historical

 

Panji_1-1586148753945.png

 

Thanks

 

Highlighted
Occasional Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

yeah that cell is not showing the same number as the rest

 

shall I reload data historic volumes. csv into Data hub DAT 03 Historical

Highlighted
Frequent Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

Hi,

 

Yes you need to re-import Historic Volumes into Data hub DAT03 Historic Volume and after that you need check data has been the same with excel or not, if same you can import from datahub to Level 2 model.

 

Regard,

 

Panji

Highlighted
Occasional Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

the dat03 historical volumes are showing these for FY20

please see attached

 

should I reload the csv file into DAT03?

Highlighted
Frequent Contributor

Re: Level 2 sprint 3 - INV01 inventory ordering Grid

No, because data historical only have FY19. you dont need import to FY20