Change “All Rows” to “Changed Rows”.

Updated to “Changed Rows” but still the customer comments is not visible in the Sales order comments field

Then there is something likely wrong with the query.

As a test, try just having the BPM write “Test” or something and see if it works. Then you’d know if your query was off.

Its a very simple query I am using to get the customer comments from customer table. [image]

If that is really your query, that will not work, as you do not have a join to the current ttOrderhed table in your query. Or if you do not want to use the ttOrderhed table for your join, then you would at least need a WHERE clause against the CustNum argument. Can you post an image of your Query t…

The ChangeCustomer should have a variable you are using to filter the Customer table so you get the single customer’s comment. If the variable does not exist, join to your ttOrderHed table and include the company and custnum in your join.

Sure Rick [image] I do not know how to design

This is returning EVERY customer. Likely the first one in the list has an empty comment. You MUST filter the query for the customer you need.

For the Update Table By Query widget to work you need to have fields that define the relationship between your query results and the ttOrderhed (temporary table) so it knows what to update. One way to do this would be to add the ‘ttOrderhed’ table to your query and define the relationship between t…

BPM - Trying to map customer comments to Sales order comments field. But it is not working

Epicor ERP 10

A.Baeisa (Al) August 28, 2019, 12:34pm 21

Topic		Replies	Views
Trying to link Customer.Comment to UD Field on Sales Order Entry Epicor ERP 10 ud , ud-field	5	1194	February 5, 2024
Update By Table - copy SO comments to PO Epicor ERP 10 epicor , bpm	10	1219	April 23, 2021
Using BPM to populate Comment Section of PO Kinetic ERP bpm	24	1059	March 21, 2024
BPM condition only working on first save Epicor ERP 10 bpm	10	2118	May 19, 2022
BPM for copying comments Epicor ERP 10 e10 , bpm	2	907	September 18, 2020

BPM - Trying to map customer comments to Sales order comments field. But it is not working

Related topics