How to pass values from Order Line to new Complement Order Line?

Kinetic ERP
, ,
1

I’m trying to pass SalesCatID and ProjectID from the Order Line, when the Complements button is clicked, into the new lines that are created based on user’s complement parts selection.

Debugging shows me that the method that triggers when clicking OK after selecting complement parts is CreateOrderDtlComplements and new lines are created as selected. However, in the dataset no lines or Releases ever show a RowMod value other than blank.

In a post-processing BPM on that method I can update lines with the values I want to, except it updates every line on the sales order and not just the newly added lines.

How can I restrict the update to the new lines being added if there’s never a RowMod = “A”?


image
image276×239 5.17 KB

2

In the post-processing dataset, does the new OrderDtl row with the compliment have an OrderLine? A lot of times with methods that create something without using GetNew, the new OrderLine will be 0 in the Post-Processing Dataset. If it is, you can use that as an identifier.

1 Like
3

Nope, it only displays the new line numbers after creation of them.

I’m currently trying to pass through the Line where I’m getting the other values from and seeing if I can do a comparison to have it only update the lines that are greater than that one.

4

Is the selected complement partNum one of the variables (or part of the dataset) in pre-proc? If so, you should be able to nail it down with your idea of OrderLine > Current OrderLine plus the selected PartNum == OrderDtl.PartNum

5

I was able to get it to update the two fields for only the added complement part lines, except it looks updated in the UI but they aren’t actually being written to the db.

image
image311×141 2.34 KB

(Where Line 5 is my new line and Line 6 is the selected complement part line, even after clicking the save button in the UI.)


If I update my post-processing BPM to also set the ds.OrderDtl.RowMod = "U" then it duplicates my complement parts line: one with the values saved and one without.

image
image384×153 3.28 KB

1 Like
6

Does update get called after the method you’re using is finished?

Edit: MasterUpdate*

7

It does not. This particular method seems to be built like everything happens inside a box, then it spits out the finished results, and you have no insight into how it did it or what it’s doing.

8

I was able to get this to ultimately save the additional data to the new lines by using an In-Transaction Data Directive on the OrderDtl table.


Solution:

In a pre-processing BPM on SalesOrder MasterUpdate method…

  1. Create condition where the new lines are greater than Max Line + 1 (because my parent part line doesn’t have a line assigned, yet).
  2. Set the BPM Call Context fields to the columns needing to carry over to the new complement part line(s)

Then in an In-Transaction Data Directive on OrderDtl table…

  1. Set condition to check for lines greater than max line +1
  2. Set fields to update from the BPM Call Context columns

Then, Profit!

1 Like