Monday, 25 November 2019

How to upload delivery status of article using ZMOEXCELUPLOAD

SHARE
Department has now provided with one T-Code for updating delivery information of those articles which was not updated due to some reasons. 

Following points may please be noted before proceeding to the steps for updation.

T-Code used is ZMOEXCELUPLOAD
Those article for which delivery status was failed to update only should be included.
This T-Code should not be used to update COD and VP articles.
Excel file should be prepared separately for each date.
This will update only those articles for which information is available in DPMS.
After doing this article in deposit should be same as the articles physically available with office
Procedure for using ZMOEXCELUPLOAD
Prepare separate excel file for each date as given below
upload delivery status of article using ZMOEXCELUPLOAD
Login to SAP 
Give T- Code - ZMOEXCELUPLOAD 
Following screen will appear

upload delivery status of article using ZMOEXCELUPLOAD




Facility Id, Facility description (Office name) and pincode will automatically come

Select Batch ID as BATCH1 and Shift No as GEN2.
Change date to the date for which data is going to upload

Note: Selecting this date is important as the articles updated will be shown as delivered on the date selected.

Delivery remark will automatically come as Delivered.

upload delivery status of article using ZMOEXCELUPLOAD

In select file we can select the excel file prepared in the format mentioned above. 

After selecting the excel file click on Execute button to update the status of article.
SHARE

Author: verified_user