The reason to create this macro was to optimize the mass update of clerk’s internet fields for Vendors.
Root cause: Mass transaction is not working for Clerk’s internet update.
Solution: Create a macro which inserts new values on vendor’s correspondence fields for LAM/BR Company Codes.
This Operating Procedure (OP) applies to SBS Curitiba Office, the responsible area is DMO LAM/NAM, though it can be adapted to other regions.
The Macro is executed whenever a mass update needs to be executed to update clerks internet massively.
Paulo Bastos (Data Management Operator) is the main developer.
Thiago Carlins, Edison Fontoura and Izabella Casagrande are the backups responsible to run the macro and correct eventual errors and bugs.
Macro is used in WP1 system, the operator needs to have the credentials the transaction XK02.
How to Run
Open the file Q:\Paulo Bastos\Macro - extração de Clerks\Clerks Internet Macro Update.xlsm
Follow the steps:
1 - Fill the first column with vendor codes:
2 - Fill the Second Column with the company codes
3- Fill the Third column with the clerks internet (email)
After the data is completed, press the button “Update Clerks Internet”
Macro steps:
The macro follows these steps:
Enter transaction xk02.
Fills the VN and company code.
Complete the fields with the informed emails.
Loops through all the filled lines, of the excel sheet.
(1) The macro will debug if the users are wrong.
Contingency
In case of a problem in the VBA Robot running, the activity must be performed manually.