Hello! In the process of transitioning to Kinetic from E9. In AP Invoice Entry, we have a few UD fields that get updated on either the ChangeRefPONum or PreUpdate methods. Have some code that sums up the amount of money invoiced to date for a specific PO, but when I try and assign it to the respecti…

Shouldn’t it officially be like below. Since it came from E9 it is a hybrid UD and lots of unofficial things work. tt.SetUDField<decimal>("Number03", amtSum);

Sorry, was multi-tasking and didn’t read your post fully. Add this to the top to be able to access the temp ds: var tt = ds.ApInvHed.FirstOrDefault(r=>r.Updated()); Then you can set tt.Number03 = amtSum;

That’s a way, sure. I’ve literally never used that syntax, though, soooo… :woman_shrugging:t2: Skin your cat however you want! :scream_cat:

[image] hmwillett: Sorry, was multi-tasking and didn’t read your post fully. Ok haha, I was looking at the first bit of code you sent and was like “oh, I’m in way over my head”. This looks much more familiar, but unfortunately, it’s still saying that APInvHedRow doesn’t contain a definition f…

I had something in post processing ChangeRefPONum already that had come thru the ABL conversions from 9 that I slammed your code into and added a piece I use to sum previous quantities, but has sql do the work. This runs, but I don’t have Number03 [image] /* sum amount */ foreach (var tt in ds.A…

So I ran a bunch of null tests and found that the foreach was good. It was when I took out the statement assigning amtSum to Number03 that the error went away so it seems like I still need to fix that part. Not sure how it compiled if it was just going to throw an error when the method gets called… …

Maybe Number03 is somehow missing. Can you see it in Extended UD table maintenance and in the dbo.APInvHed view in SSMS? I assigned the sum in my routine to rounding and it shows in the data. [image]

That’s a good point actually. Did you ever have data in that field in E9? If not, the upgrade won’t bring that field over and it won’t exist.

[image] gpayne: Maybe Number03 is somehow missing. Can you see it in Extended UD table maintenance and in the dbo.APInvHed view in SSMS? It does exist: [image] Going to try some other ways to call that table since there’s a “_UD” at the end of it.

The database context will include the _UD table in the ds.APInvHed object. Have you run a debugger on the code to see what the ds.APInvHed object looks like?

I’m sure there’s a better way to debug, but I set callContextBpmData.Character05 = ds.APInvHed.ToString(); and threw it on a show message widget and got this: [image]

Setting UD Fields to a Variable

Kinetic ERP

hmwillett (Hannah Willett) March 15, 2023, 1:36pm 23

Shoutout to @klincecum for this: Server Event Log Dashboard - Code Review / Sharing - Epicor User Help Forum (epiusers.help)

Topic		Replies	Views
BPM and UD field questions/issues Epicor ERP 10 ud-field	2	1783	August 27, 2019
Set a UD field from an unrelated UD Table Epicor ERP 10 e10 , bpm	10	2755	February 17, 2022
Referencing a decimal UD field in a Kinetic Postprocessing Method directive Kinetic ERP	24	1361	March 21, 2023
Addressing a UD table in a BPM Epicor ERP 10 bpm	2	1319	July 16, 2019
BPM to Copy UD field Value from Part to QuoteDtl Epicor ERP 10 e10 , bpm	54	8143	October 25, 2018

Setting UD Fields to a Variable

Related topics