![ArnoldWillems](/community/data/avatars/m/63/63808.jpg?1707909279)
ArnoldWillems
Member
Hello everyone!
Working in JDE tools release: EnterpriseOne 9.2.5.6
I am currently working on a project in JDE Orchestrator that automates the setup of item cross-references P4104 for the EDI processes P47010.
The following Orchestration is activated when there's a "Column exit & Changed" event on the EDI line. It initiates a DREQ into the Item Cross-Reference table, using criteria such as [Address Number, Customer/Supplier Item Number, 2nd Item Number, Expired Date, Effective Date]. If no valid match is found, it generates a Cross Ref with the FREQ.
Everything is functioning smoothly, but I'm encountering a challenge when attempting to assist users with prepopulating grid rows as a follow-up step.
Suppose we have multiple lines in the EDI order, and the user has just created a Cross Reference for line 1 based on the [Customer/Supplier Item Number] provided by the Customer and the [2nd Item Number] that the user populated themselves. Now, when the user moves to another line of the same EDI order and the [2nd Item Number] is empty, I'd like to trigger another Orchestration. This Orchestration would perform a lookup against the P4104 with available [Address Number, Customer/Supplier Item Number] and then return the [2nd Item Number] to populate the line.
My question is: I can achieve this functionality in the backend with the FREQ, but I want the lines to be populated live on the user's screen, similar to a field change. I've watched a video on the web showing this, but I can't find any explanation of how to do this.
I've already attempted to set the outputs on the Orchestration, but when a user enters a row and triggers a Column Exit or uses a Button Clicked, nothing happens on the screen.
Furthermore, I hope someone has an idea on how to approach this. If you need any more information/screenshots, please don't hesitate to ask.
Thanks in advance!
Working in JDE tools release: EnterpriseOne 9.2.5.6
I am currently working on a project in JDE Orchestrator that automates the setup of item cross-references P4104 for the EDI processes P47010.
P4104 = Customer & Supplier Xreference - Work With Item Cross Reference
P47010 = Review Inbound Orders - Inbound EDI Order Revisions
The following Orchestration is activated when there's a "Column exit & Changed" event on the EDI line. It initiates a DREQ into the Item Cross-Reference table, using criteria such as [Address Number, Customer/Supplier Item Number, 2nd Item Number, Expired Date, Effective Date]. If no valid match is found, it generates a Cross Ref with the FREQ.
![1707914432677.png 1707914432677.png](https://www.jdelist.com/community/data/attachments/5/5291-78de08b40d6458c84e2a3fa008ff8703.jpg)
Everything is functioning smoothly, but I'm encountering a challenge when attempting to assist users with prepopulating grid rows as a follow-up step.
Suppose we have multiple lines in the EDI order, and the user has just created a Cross Reference for line 1 based on the [Customer/Supplier Item Number] provided by the Customer and the [2nd Item Number] that the user populated themselves. Now, when the user moves to another line of the same EDI order and the [2nd Item Number] is empty, I'd like to trigger another Orchestration. This Orchestration would perform a lookup against the P4104 with available [Address Number, Customer/Supplier Item Number] and then return the [2nd Item Number] to populate the line.
My question is: I can achieve this functionality in the backend with the FREQ, but I want the lines to be populated live on the user's screen, similar to a field change. I've watched a video on the web showing this, but I can't find any explanation of how to do this.
I've already attempted to set the outputs on the Orchestration, but when a user enters a row and triggers a Column Exit or uses a Button Clicked, nothing happens on the screen.
Furthermore, I hope someone has an idea on how to approach this. If you need any more information/screenshots, please don't hesitate to ask.
Thanks in advance!