The following document will help you to learn the PR Creation Steps using App Connect - RPA.
Please download the attached excel sheet for "General PR Upload" and "Service PR Upload" and fill the necessary information as per the below given instructions.
- Before filling excel template if prompted as below, we need click on Enable content (to run macros)
2. Make sure macros are enabled (File->Options->Trust center->Trust center settings-> Macro Settings->Enable all macros->OK)
3. Please fill required fields to create a PR in the excel template.
a) Normal PR
b) Service PR
4. If there are multiple items to be created please copy paste from first row above item, then edit.
a) Normal PR
------- Update Material Group--------
b) Service PR: If you want to add main line item, such as ‘I’ row then copy ‘I’ Row and paste.
------Update Material Group ------
c) Service PR: If you want to add sub-item, such as ‘S’ row then copy ‘S’ row and paste
------------- Update "unit of measure" ------------------
5. After filling the template click on "Validate Sheet" button to validate the excel. If there are any errors, respective fields will be in RED colour.
6. Refer to the 'Error List' tabs for detail error descriptions pointing to the cell.
7. Correct all errors and click on Validate Sheet again till there are no fields with RED.
8. No particular naming convention for the PR Creation excel template needs to be followed
9. Send the excel file as an attachment to '[email protected]' with subject 'PR Creation'. Please do not attach multiple file in one email.
10. You will receive an automatic confirmation email along with the PR Number, similar to the following one.
11. If any error reply will be as below
### Please do not change master worksheet and tab names