Automate

Hi to all members, 

I would need your help on how to create condition. 
Below table is from ABNA transaction, I would like to create a condition to ask winshuttle to look for the last column which is Crcy with USD and make changes to all USD field to amount 150. 
Kindly advise how can I do that?
As I have other entity with different row of USD, that's why I need to know how to create condition.

Thanks in advance. 

------------------------------
Celeste Ling | Accountant
Intel Corporation | 60172380166
------------------------------

Hi Celeste

Are the same depreciation areas always the same currency?  If so, you can use gui scripting or a bapi (example attached to update only specific depreciation areas) to update them, since there aren't ways to position to a row.  However if you always have the same depreciation areas in the same order, you can just record each cell.

If the depreciation areas are not always the same currency, you'd want to do a query on a range of assets based on the currency key.

Hope that gives you some ideas,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------