uBAQ and Dashboard- Updating multiple POs using BPM

, ,

I have created an updatable BAQ and Dashboard in order to change the promise/due dates at the header and line/release level of open POs as well as the Unit Price. This works by using a updatable BAQ directive that unapproves, makes the changes, and reapproves.

The issues occur when multiple rows are updated at the same time. This error occurs:
“The table ttResults has more than one record
The table ttResults has more than one record
The table ttResults has more than one record
The table ttResults has more than one record
POHeader is not available.
The table ttResults has more than one record”
What is odd is that the PO is unapproved and these changes are made, but the PO is not reapproved. In order to determine where this issue is occurring I attempted to add many different message boxes to see what is being executed.
Here is the directive: Sorry it is so messy and long.

None of these message boxes show up at all. Even the one at the very start. How is this possible and what could be the potential problem?

Ended up being a misuse of the GetByID and Update BO methods that was throwing an exception. Once this was fixed all of the message boxes appeared.

So did you solution to this end up working exactly as you intended? I am trying to do the same thing, but only for the Unit Price, and I keep getting a Null Reference Exception from my Update Method call. What was wrong with your Update BO method and how did you fix it?

Sorry Connor, I cannot recall the solution. I believe I had an unnecessary GetByID and Update BO methods at the end to try and refresh/update the screen. This threw the exceptions and didn’t allow the message boxes to be shown. I ended up just removing these extra methods. Not sure that I can be much help to your question.