Our problem is similar to the following Forms (but not the same) -
Our problem is as below -
We have a folder which contains a no. of excel files.
In each file, there are two columns “PO no.” & " PO Item".
We would like to automatically read & copy the PO no. & PO item one-by-one within the file, and then paste each PO no. to SAP PO Doc. (i.e. TCode ME22N) to maintain the PO Doc.
After inputting the PO no. in TCode ME22N of SAP, will also locate the “PO item” to input something under the PO item level, e.g. check the checkbox “Acknowl.Reqd” under “Item - Confirmations” view, as below -
After completing the above step 3-4, will read and copy the next “PO no.” & “PO item” in the file and then paste to SAP to repeatedly proceed the above steps 3-4 until all of the records have been proceeded within the file.
After completing to proceed one file, will continue to proceed the next file and repeat the above steps 3-4 under all of the files have been proceeded under the folder.
For your info., before the above steps 1-6, we have an action to sent the above excel files and then move these sent files into a temp folder in the above step 1, e.g. named as “Sent”. After completing the above steps 1-6, the folder of the above step 1 will then be renamed as the sent record, e.g. “Sent_ddMMyyhhmm”. We can setup for this process.
However, we don’t know on how to setup for the above steps 1-6 to integrate with SAP. Could you advise whether the above steps 1-6 is possible to setup ? and How to implement to setup for the above steps 1-6 ?
It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.
First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.
You can check out some of our resources directly, see below:
Always search first. It is the best way to quickly find your answer. Check out the icon for that.
Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.
Topic that contains most common solutions with example project files can be found here.
Read our official documentation where you can find a lot of information and instructions about each of our products:
Meet us and our users on our Community Slack and ask your question there.
Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.
Thank you for helping us build our UiPath Community!
