Objective and Scope
The reason of developing this macro was to update the item prices of a contract massively, since the original transaction to execute these exchanges presents errors most part of the time.
Root cause: Update/Review the prices of contract materials, which might have over 100 lines. The activity does not develops any skill, since it is a mechanical and repetitive activity.
Solution: A VBA Robot which copies the data from macro excel file, looping through the rows which need to have their price updated .
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 can be executed whenever a contract need to have its price updated , the request is sent through a freshdesk ticket.
Paulo Bastos (Data Management Operator) was the main developer and he is responsible to ensure that the macro is running right, with no bugs or errors.
Thiago Carlins, Edison Fontoura and Izabella Casagrande are the backups, responsible to run the macro and correct eventual errors and bugs.
Macro can be used only on WP1 system and the operator needs to have the credentials to access the contract (ME32K).
How to Run
First of all, the WP1 system must be the main one opened.
After that, open the file on “Q:\Paulo Bastos\Contract Update macro”
*Note: Values must be pasted without special characters and a maximum of 2 decimal numbers (Ex: 66930,00)
1 - Insert contract number in Range i1
2 -Press "Clear button" to delete previous content
3 - Fill the blue columns with the Item, Net Value and Per Price Unit
4 - Press "Change Price" Button" and wait
5 - Before saving the contact, certify that the Inserted contract prices and the ones of the sheet are equal, clicking on button "Casting Out Nine".
If it is necessary, change the "False" ones manually.
6 - Save Contract
The macro follows these steps:
Opens transaction ME32K
Copies the contract number to SAP contract field
Search the item on SAP using the column “B” to search the row.
Finds row, clicks on price update button.
Clicks on new validity period.
Updates date
Updates Price
Updates Per
The “casting out nine” needs to be made manually, before saving the contract.
(1) The macro will debug if there is just one line after row 1, sheet “Menu”.
(2) The macro will debug if there are deleted items to be updated.
(3) The macro will debug if the tax jurisdiction is outdated (then it must be updated on massive transaction first).
In case of a problem in the VBA Robot running, the activity must be performed manually.