Double click on Sales Order line item

[Asitabha_Deb_asitabhad]

Hello,

I have one Sales order with multiple lines item. I would like to double click on the desire line item
and enter into the that line.
I have updated Sales order# & line# in the excel A1 & B1 column.
My requirement is BOT will pick the line item updated in B1 cell.
Please help its urgent.

BR/Deb

[NIVED_NAMBIAR (NIVED N)]

Hi @Asitabha_Deb_asitabhad

welcome to forum

So your requirement is to utilise the line item listed line by line and add into the webpage , is it right?

[Asitabha_Deb_asitabhad]

Hi Nived,

Thanks for reply.
No, my requirement is based on the SO line item I have updated in the excel file B column, BOT will select that line item and double click and enter on that line item and make necessary changes.

For e.g : Column A (SO#) Column B (line item)
xxxxxx 100
YYYYY 200

I hope it can help you.

BR/Deb

[Sudharsan_Ka]

Hi @Asitabha_Deb_asitabhad
Based on the excel you need to click on the line is that right?

[Asitabha_Deb_asitabhad]

Hi @Sudharsan_Ka ,

Yes, exactly.
Thats my requirement. BOT will double click on the particular line no.

BR/Deb

[Sudharsan_Ka]

You can try with these steps in the thread

Please can anyone help on this?

You don’t need to declare new variable as currentrow It is already been created you just can use it Okay , Follow this steps You have created a for each right? Inside that Give Assign activity create new string variable “Demo” = if you type current it will show you the available variables you can choose from that currentrow and try the steps I suggested before

Hope it will helps you

You Need to just change
Assign a default value for Demo = CurrentRow(“The SO Column”).ToString

Regards
Sudharsan

[Asitabha_Deb_asitabhad]

Thank you I will try this.

Anyway, Can you please tell me, How I copy cell value from excel and paste in SAP.
MY working platform is SAP.

BR/Deb

[Sudharsan_Ka]

Refer the thread

Copy cell value from excel 1 and paste the contents of excel to excel 2 , by adding another column in excel 2

@shikharno.7 Yeah I was working on it… That’s why the reply got delayed I thought of sharing a example is better than explaining on the logic would be better… Let know whether this helps… ExcelCopy.xaml (9.8 KB)

Hope it will help you

Regards
Sudharsan