I have a Function that receives a json dataset and creates Sales Orders. One of the steps is to calculate Tax via Avalara, which is done by toggling the ReadyToCalc field and calling a MasterUpdate: [image] Basically this is the same thing we do in the UI… Checking the box and saving automatical…

Yep, #BeforeImage strikes again! Lol I can’t believe I forgot the golden rule… when in doubt use BufferCopy. Are you guys just BufferCopy’ing everything by default these days? I feel like I should just start doing that. Here is the working snippet for anyone interested: [image] Thank you Kevi…

My guess is that it’s a combination of things: You are setting ReadyToCalc == true but your OrderRel table doesn’t have any updated rows (Taxes are added to order releases) You aren’t calling SalesOrderSvc.SetReadyToCalc(iOrderNum, ref ts), which adds and updated row to the TsSalesOrder.TaxConnect…

I think if you add this bit below to your code after you set the rowHed.ReadyToCalc = true;, it will work without the misc charge: foreach (var rowTax in TsSalesOrder.TaxConnectStatus) { rowTax.RowMod = "U"; rowTax.ETCOffline = false; TCStatus = true; } P.S. what is your code editor th…

Do you have an unmodified row and a modified row?

If he’s getting the TableSet using GetByID, it should only have one row, so setting the RowMod to “U” should be fine. Your point is well taken though, if that throws an error it might need to use the BufferCopy trick.

Not if he changes a field. Tom, try copying the row, and change the copy.

#BeforeImage [image] Uplifting Code from C# to Function Kinetic ERP Its actually an OLD OLD Progress term Open Edge Progress DBMS has something called a Before Image The Before Image file(s) stores information about every transaction which makes a change to the databa…

[image] josecgomez: #BeforeImage [doctor guys GIF]

[image] kve: calling SalesOrderSvc.SetReadyToCalc(iOrderNum, ref ts), I had tried that too but got the same behavior before fixing issue with BufferCopy. I may still throw that method call in for good measure though. Still weird that the original code worked if a freight misc charge was adde…

[image] TomAlexander: Are you guys just BufferCopy’ing everything by default these days? I feel like I should just start doing that. Honestly we always should we are lazy but Epicor expects every server side call to come with a BI for any modified datasets

Stumped on SalesOrder.MasterUpdate and calculating Tax

Kinetic ERP

josecgomez (Jose C Gomez) May 20, 2025, 12:43am 7

#BeforeImage