Calculate 'Commission %' on a report.

Business Central/NAV Developers Forum
1

Hello,

Right now I’m working on a report. I’ve taken three DataItems: Sales Invoice Header, Sales Invoice Line, Salesperson/Purchaser.

Now in the report I’ve taken few fields like Salesperson Code(grouped), Amount, & ‘Commission %’ from Salesperson/Purchaser table. Now I declared another field named ‘Amount Including Commission’ which will calculate the amount with ‘Commission %’ for each Salesperson Code.

For that I’ve declared a decimal variable named as ‘AmountInclCommission’ Now I’ve written the following code:

Sales Invoice Header- OnAfterGetRecord:

AmountInclCommission := 0;

AmountInclCommission := (“Sales Invoice Header”.Amount * “Salesperson/Purchaser”. “Commission %”) / 100;

After that, I declared another field in my report & taken the ‘AmountInclCommission’ variable in that field.

But after I run the report I didn’t get the desired result. I only get lots of zeros in the ‘Amount Including Commission’ field. How could I resolve the matter??

Thank You in advanced,

2

May be Comission % from Saleperson table not fetch in record ? Or It might be zero
How the Sales Invoice Header and Salesperson table connected ? Have you define relationship ?

3

You have to use CALCFIELDS(Amount) first.