Calculation fields

Epicor ERP 10
1

Hi,

I am hoping someone can point me in the right direction as I am quite new to this kind of configuration in E10 and am not a coder but know a little bit.

I have created a UD field called “TonRte_c” on the “PODetail” table.

I have pulled in a Foreign key from the Part Table “Part.GrossWeight”

The calculation i need is:

PODetail.ScrUnitCost / Part.GrossWeight * 1000

private void PODetail_AfterFieldChange(object sender, DataColumnChangeEventArgs args)
{
// ** Argument Properties and Uses **
// args.Row[“FieldName”]
// args.Column, args.ProposedValue, args.Row
// Add Event Handler Code
switch (args.Column.ColumnName)
{
case “TonRte_c”:

			decimal TonRte_c = (decimal)args.Row["PODetail.ScrUnitCost"] / (decimal)args.Row["Part.GrossWeight"] * 1000; 

			break;
	}

The code compiles as OK but does nothing - Please help.

2

Note: You posted this in the wrong category. This is for reviewing code that you think does work. Post any questions in the E10 to Kinetic categories.

Hi Steve! Welcome!
I don’t have the exact answer you need, but this might help you figure it out.
You can always toss in a message box to help debug things. There are various ways to do it, but in a customization like you have here just do something like:

//Plain Messagebox
MessageBox.Show("Your Message");
//Message box with variable - make sure to convert non string variables to strings for displaying in msgbox.
MessageBox.Show("Part Weight: " + Convert.ToString((decimal)args.Row["Part.GrossWeight"] ));

This can help you see if that after field change event is even firing. If it is, then you can also use the message box to see if there are values in the variables you are trying to calculate.

After looking at this for a minute, I think you haven’t actually assigned the result of your calculation to the field in the table. Try something like:

args.Row["TonRte_c"] = (decimal)args.Row["PODetail.ScrUnitCost"] / (decimal)args.Row["Part.GrossWeight"] * 1000;

Usually, I apply changes to tables using a custom action BPM in a UBAQ. I am not sure if you need that here, but I think you will at least need a method to apply this updated table value to the database. Others may be able to help with that syntax.
Good luck!
Nate