Hey Guy’s i am hoping you can help me with something.
We have a process we run, If a part has not been sold for 12 months it needs to go through a review before it can be resold. My process was to create a new field against the part (Parts are unique to the customer) where the last invoice date is stored which is updated when the invoice is raised.
This works fine.
Step two is to validate the parts and mark those over 12 months on hold.
So what i have done is created a Updateable BAQ which runs on a schedule late at night.
On the Update Getlist i have created a custom BPM which should update all the records linked to ttResult.
When i run the BAQ manually, i can see the fields (OnHold, OnholdDate, OnholdReason) are getting updated in ttResult, but what i am not seeing is the records in Part getting updated. But i am not getting any errors either.
Here is the work flow i have created
My Original query which creates ttResults has Company and PartNum in, so everything is linked by Company and PartNum.
Any Help Appreciated