BCP for DPMS operations in CSI - Procedure for uploading the delivery data excel file in SAP - ZMOEXCELUPLOAD

Respected Sir (s) / Madam(s),

This is regarding instructions to upload articles delivery information and articles deposit information in to DPMS. 

Instructions may kindly be issued to follow the guidelines below:

1. Prepare the list in excel containing the articles delivered beat-wise (Article numbers only)

2. Prepare the list in excel containing the articles on hold beat-wise (returned by postmen to be kept in deposit for today – Article numbers only)

3. Those articles which are returned to sender may be handled manually today

4. Items as in (1) and (2) may be kept ready for upload CSI-SAP

Procedure for uploading the delivery data excel file in SAP:

Step-1:

a) Use t-code zmoexcelupload

b) Enter the mandatory selections like facility ID and Date of delivery (Actual date of delivery)

c) Upload the entire excel which was prepared on that date both delivered beat-wise and onhold – beatwise first

d) Those records for which data was available in dpms on that date will get updated and a summary will be displayed

Total number of articles in excel,

Total number dated and

Total number not updated

e) Total number not updated is due to non-availability of the article data in the DPMS

f) Through the hyperlink from the summary, copy of the list of articles not updated and then follow step-2

Step-2:

g) In DPMS, received a bag with the bag ID

h) Open the same bag ID ( legacy option)

i) Enter those articles copied as in (f) and treat those articles as received through this bag-ID

j) Then those articles would be available in DPMS

Step-3: 

k) Again repeat the exercise as in step-1 for both delivered and on-hold articles

l) This would update both the delivery information and on-hold information in DPMS

For any further queries and support, instructions may be issued to call DMCC Chennai.

Yours Sincerely,

(V M Sakthivelu)

Deputy Director CEPT