Calculated field in table extension

(0) Share

Report

Posted on by BchM

Hello, I am doing an extension of the table "Sales line", and I want to create a field called "Shipped Not Invoiced No VAT", which would be the result of multiplying the fields "Qty. Shipped Not Invoiced" * "Unit price", exactly where would you have to do this operation? I have tried to use the "CalcFormula" property, but apparently it does not work for these cases

All responses (2)

Answers (0)

Sort by

Suggested answer

Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can't create a field using calculation formula from two different fields.

You can create a variable on that page, calculate that variable on OnAfterGetRecord trigger, and show that variable.
Suggested answer

JAngle 159 on at

Like (1)

Report
Copy link

Link copied!

This video shows you a good method: https://youtu.be/fXDxAM0ZrvU