E9.2 Clicking a Row Exit for each detail row in a form recordngs array

[JohnDanter2]

Hi folks

I have an orchestration that creates SOs for multiple lines and it's working fine and dandy but one of the recorded actions in the SO detail screen is to click SOE Additional Information and update the delivery address.
If I have 3 lines in my SO it's only doing this for the last line.
any ideas how I get this to kick off for each SO line in the array



My recording only added 1 line, should I maybe do the recording again but maybe see how it looks with 2 lines.
I'm sure I am missing somehting simple and this will be fine for single line SOs, but I need to update the delivery address on ALL lines, not just the last

Thanks

John

 

[DaveWagoner]

A few thoughts here:

1. "There's an Enhancement Request for that" - https://cloudnnf.questoraclecommunity.org/questenhancementtool/ViewEnhancement.aspx?id=15640
2. How are you calling this form request component? Are you iterating?
3. There's a good chance you'd want to "pull out" the inner-iterate into its own form request, if it's at all possible to enter the order first, then go back in and update each detail line with the SOE Additional Information.
4. Unrelated to your issue, Kill those default values in your FR. I ALWAYS get burned by leaving those in.

 

[Kevin Long]

Hi John,

When you paste in an array of data into a grid, it is going to do that first and take your row exit after. The easy way to do this is to create the sales order in one form request and then have a second form request update the deliver address of a SO detail line. Then you can iterate over your array of detail lines and update the delivery address on each line. This is not very efficient if you have large sales orders because you have to open and close the sales order for each update.

The other way to do this is to use the appstack api. With the appstack api, you can create json using a custom request to add a detail line and then update the delivery address as you go. This option is way more efficient, but more work to implement.

Kevin

 

[JohnDanter2]

A few thoughts here:

1. "There's an Enhancement Request for that" - https://cloudnnf.questoraclecommunity.org/questenhancementtool/ViewEnhancement.aspx?id=15640
2. How are you calling this form request component? Are you iterating?
3. There's a good chance you'd want to "pull out" the inner-iterate into its own form request, if it's at all possible to enter the order first, then go back in and update each detail line with the SOE Additional Information.
4. Unrelated to your issue, Kill those default values in your FR. I ALWAYS get burned by leaving those in.

1 Typical! Glad I'm not alone
2 Kevins awesome excel plug in
3 Good idea
4 Yep, just for testing to help me track my inout data for now

 

[JohnDanter2]

Hi John,

When you paste in an array of data into a grid, it is going to do that first and take your row exit after. The easy way to do this is to create the sales order in one form request and then have a second form request update the deliver address of a SO detail line. Then you can iterate over your array of detail lines and update the delivery address on each line. This is not very efficient if you have large sales orders because you have to open and close the sales order for each update.

The other way to do this is to use the appstack api. With the appstack api, you can create json using a custom request to add a detail line and then update the delivery address as you go. This option is way more efficient, but more work to implement.

Kevin

Thank you Kevin
This did cross my mind, same as Dave above but I was hoping it was a lot simpler than this.
This will be used by your plug in when it's all done and dusted

 

[JohnDanter2]

On a functional level......

Does anyone know if this can be done at a header level and have it affect all SO detail lines

 

[JohnDanter2]

I may create another ORCH to get akl the SO lines, then loop throug and do a select and filter on the SO lines, much I like with update foregin price a while back
I may see if I can use B4202070 for each line

 

[ChrisPa]

Depends on the system you are using, P4210 or P42101. THe former, once you are in Line Entry, will permit exit Form > Order Address and the latter has a clickable link for Order Address. Both will call P4006 which is an address override for the order at header level, I believe

 

[JasonDorough]

John,
I think the solution you decided on, creating a separate ORCH to iterate for the address update, is best. I prefer having many form requests that perform a single task rather than a single form request that performs a complicated process. You can use a form request that creates an order in many other orchestrations, but one that creates and order and updates address information most likely will only serve a single purpose. Simple components enhance modularity.

 

[arrozpegao]

hi all, i'm dealing with similiar issue. i have an array to create a sales order, and each element of the array has its own TAX1 .
Then, to add TAX1 but line, you need to select the line, menu row -> SOE Header , add TAX1 , click ok
How can i do this for multiple lines? there's not a while/if statement in form request

As i read, one solution could be create order, and with another form request, iterate one by one , for each elements of the array, and update TAX1 for each line. Problem here is now exactly the line number to filter just that record. (i'll think about it)

But any other way to do this just in one step?
Because main problem here is how P4210 manage update over TAX1 at line level. It's not in main grid line, and needs "select line" , menu row, etc.....
Another solution could be a form extension with this fields in grid, and update it in one shot. ( i'll try it)

Any other ideas?


Thanks in advance

 

[JasonDorough]

hi all, i'm dealing with similiar issue. i have an array to create a sales order, and each element of the array has its own TAX1 .
Then, to add TAX1 but line, you need to select the line, menu row -> SOE Header , add TAX1 , click ok
How can i do this for multiple lines? there's not a while/if statement in form request

As i read, one solution could be create order, and with another form request, iterate one by one , for each elements of the array, and update TAX1 for each line. Problem here is now exactly the line number to filter just that record. (i'll think about it)

But any other way to do this just in one step?
Because main problem here is how P4210 manage update over TAX1 at line level. It's not in main grid line, and needs "select line" , menu row, etc.....
Another solution could be a form extension with this fields in grid, and update it in one shot. ( i'll try it)

Any other ideas?


Thanks in advance

Hello, I would start with a custom request that would add a new key/value pair to each element of the array - something like "rowNumber": 1 so each element is sequentially numbered. I would then use 2 separate form requests, one to enter the order and lines, the other that performs the TAX1 update using the rowNumber value for each element to select the correct order line. This will leave you with a re-usable form request that enters sales orders, a custom request that adds a key/value pair to an array (useful as a template for when you need to do something similar again) and another form request for the TAX1 update. Separating the steps out keeps it simple and lends to re-usable components. I think of components like lego building blocks, you do not want a single lego that is a house, you want many small blocks so you can build a house or a boat, car or anything else you can think of.

 

[DaveWagoner]

I think of components like lego building blocks, you do not want a single lego that is a house, you want many small blocks so you can build a house or a boat, car or anything else you can think of.

Brilliant, I will probably end up stealing this