Update QuoteClosed from updatable BAQ

Kinetic ERP
1

I have a bunch of old quotes I want to close out. I made a simple updatable BAQ, but if I mark off “closed” and hit update it gives me the error “Quote is closed, unable to update.” – yet its not actually closed. I can close them by hand. Whats the trick? My hunch is I have to close via a BO method and not by setting the boolean for some reason :frowning:

2

You know what’s coming…

trace :rofl:

3

I almost have this working but I am missing some little part. When I had it check QuoteHed_QuoteClosed, it would close them like I wanted, but the BAQ still reported the error. I figured that was because I am still changing the field. So I just switched over to a calculated field, but that broke it… This is on the preprocessing for the BAQ update method. Can you not use a calculated field this way?


var qouteBO = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.QuoteSvcContract>(Db);

foreach(var q in queryResultDataset.Results.Where(x => x.Calculated_CloseMe == true))
{
  qouteBO.OpenCloseQuote(q.QuoteHed_QuoteNum,true);
}
4

Is that field set to updatable?

5

Yes

6

Did you try to DMT a few? Maybe it will work that way?

Use the BAQ to create the list to be updated via DMT.

1 Like
7

I suppose I can just switch my bpm back and ignore the error message, but I thought I should have been able to use the calculated field

8

Is that all the code in the UBAQ BPM?

9

Is this a regular update or an advanced bpm update?

I would switch to advanced BPM update, your error may be in the base doing
something it doesn’t like.

10

That works.