How to create UDF and create field calculation : QNE Software Sdn. Bhd.

How to create UDF and create field calculation Print

Created by: Cheng Kah Poh

Modified on: Mon, 7 Sep, 2020 at 5:02 PM

BOModel (Additional User Define Field + Field Calculation)

Please refer KB How to Access Customization Centre

Scenario: How to create Field Value 3 with calculation is equal Field Value1 * Field Value2 Value1*Value2=Value3

Step 1 - Go to BOModel > Search for QnEBS.BO.Sales > SalesInvoiceDetail

Step 2 - Create 3 field under SalesInvoiceDetail > OwnMembers

Step 3 - After create field GOTO EvaluateExpression > Add > MemberEvaluateExpression

Id : Field name (Value1*Value2=Value3)

EvaluateExpression: Field A*Field B (Value1*Value2)

EvaluateMember: Calculation Field (Value3

Pull the new field under ‘Views’

Save and re-login system.

Calculation TEST, Value1 * Value2 = Value3

Cheng is the author of this solution article.

Did you find it helpful? Yes No

How to create UDF and create field calculation Print