Need your help for the following scenario.
I need to enter set of Journal Vouchers (JVs) in a virtual machine (erp system). The data is in excel sheet. In the sheet, i have two tabs, Header & Line. I need to enter line wise information (from line tab) in reference to header information (appearing in header tab), meaning for one header information there can be multiple lines. The common column in both the excel tab is “JV Number”.
I have used the “for each row” and “if” activities, it works in cases where i have one header information and multiple line information. However the automation does not work the moment second header information along with its respective line is added.
Can you please guide on how to iterate line information in reference to header information?
Spirit ERP Automation.xlsx (9.7 KB)