E9.2 Loop on Grid record using Orchestrator

[Puthran]

Hi,

I am trying to update a Customer Master Record using Orchestrator. I have 3 rows for a customer in the P03013|W03013A screen and I want to update the Hold Invoice Flag for each LOB record. How do I get the system to loop on the grid record to achieve this? The Customer Master screen grid does not have Multiple Select turned on.

Regards
NP

 

[BetoJDE]

Hi @Puthran, consider do a Data request to F03012 and return AN8 and CO (PK from Customer Master), then iterate in P03013 with each AN8 and CO.

Some like this

 

[Puthran]

Hi @Puthran, consider do a Data request to F03012 and return AN8 and CO (PK from Customer Master), then iterate in P03013 with each AN8 and CO.

Some like this

View attachment 19353

View attachment 19354

Thank you so much..I was able to get it working.

 

[Jeff George]

This looks like something I am trying to accomplish (see recent thread I created).

Where does this fit into the flow of the orchestration? I already have a Data Request to pull the records I wish to work on from the table. Do I need to create another Data Request that pulls just the field I want to iterate on and place that before my existing Data Request? How do I make the Orchestration continue to run through each 'subgroup' of records instead of just processing the first group (iteration) and then stopping?