In 2022.1 we created a BPM that would set the Ship by Date to the Need By date when opening Capable to promise. This is because we found that if the ship by date is not set on the sales order Capable to promise would not work. In our business process Sales does not set the Ship by date, planning does. So Sales sets the Need by date per the customer and Planning uses CTP to determine the ship by date.
But we then added addition calculations to setting the Ship by date for CTP by added two days and other things they wanted to buffer things… regardless, this BPM has worked fine for the last 2 years, but now that we have upgraded it throws the error ‘The table result.CapPromiseDtl has more than one record’
OK, nothing new, I’ve seen that before, but usually just when I was trying to set a single row value and I failed to check for multiple rows. But in this case I want to update all rows and in the BPM we are using the ‘Update Table by Query’ which has a built in qualifier for which rows to update, so I don’t know why I would need to specify additional qualifiers or a foreach loop… So what gives? what is the best way to correct this?
Expression for the configured mapping of the ReqDate field:
