Has anyone created an updatable BAQ that can add and delete Sales Reps from an invoice head for E10?
If so, would you mind sharing how you have done it? Every time I update the sales rep list in the BAQ, it acts as if it updated the row, but the sales rep list remains the same. am I doing anything wrong? Everything but the sales rep list updates properly.
I made messages at each part of the update method to show me the sales rep list string in pre,base, and post processing of the updatable baq directive. For some reason the sales rep list is showing the updated part and then adding a semicolon and the original string. sales rep list. Does anyone know why?
pre = PHO~UAT~~"semicolon"PHO~~~~
BASE = PHO~UAT~~"semicolon"PHO~~~~
Post = PHO~~~~
I believe you need to update everything for the commission piece. So that would include the SalesRepList, SalesRepCode1, SalesRepName1, RepRate1, and RepSplit1.
I believe those are all the fields. Just include all of them in the BAQ (also the 2-5 fields) and clear/enter in them as needed.
Thank you John. The odd thing is that all of those fields were updating just fine, it was just the salesreplist that was not updating. In the end I found that there was a preprocessing BPM on the updatable BAQ and it was looping through the results table from the BAQ. I found that even though the baq returned only one row, when it updated it was calling the BPM twice. The first time through held the updated values and the second time through had the original values. Because of this, the sales rep list was always being set back to its original value. There is also a BASE method directive that is generated from the BAQ itself and I assume that the BASE method was the reason that the fields you mentioned were updating. There was something strange about the sales rep list field. Thanks again for your response.
