How to customize column to add both columns as total (A + B = C)

Created by Ariel Hoong, Modified on Fri, 17 Nov, 2023 at 9:46 AM by Ariel Hoong

Scenario:

I would like to customize another two column and would like to add both columns as total, how to do the setting?

Example:

A + B = C

Column A = workmanship , column B = Sales Price , column C = Unit Price

1) Go to Customization Centre > double click QNE Optimum

2) Model > BOModel > QnEBS.BO.Sales > CashSalesDetails > OwnMembers > right click > Add… > Persistent

3) Follow below screenshot

4) Go back to OwnMembers and right click again > Add… > Persistent

5) Follow below screenshot

6) Go to CashSalesDetails > EvaluateExpressions > right click > Add… > MemberEvaluateExpression

7) Follow below screenshot (EvaluateMember must be key in the column name correctly else system unable track or detect to show the requested result)

8) After done all > Save > Close

9) Logout system and login again

10) Go to Cash Sales > Point to the Stock Code > right click > column chooser > Add… > search and tick the column that just created > OK > drag out

11) When key in the amount system will auto calculate and show the correct amount

Result:

** Learn more about Azure Cloud

Refer attachment for details

Attachments (1)

How to custo....pdf
442 KB