Provide assistance to Arvin on the IAS-EOM sales for September.
Steps:
1. Extract On-hand quantity per department from INVBAL
2. Extract arrivals from Sept 1-30 from POMRCH,POMRCH and INVAUD. Findings shows that there are no arrivals for Sept.
3. Extract sales from Sept 1-30 from CSHDET. No extracted sales for September
4. Send extracted data to Arvin for validation versus extracted report in  IAS.. Findings shows that JDA and IAS are tally in terms of ONHAND quantity but has variance in terms of INTRANSIT quantity.
5. Re-extract On-hand quantity again around 2pm and notice that the value extracted versus the extracted data in the morning has changed. An additional variance of 959 in terms of quantity was added to the total onhand.
6. Query INVAUD table to check if there were adjustments in the afternoon but there was none.. Validation is ongoing to check the cause of the variance.