Reg: Code Unit for designing reports

Business Central/NAV Developers Forum
1

Hi…can anyone say how to write code to calculate Tax % for designing reports.

2

Welcome to DUG!!!

What Report you are designing and what you required???

3

Purchase order report… In that report i want to calculate tax %.

4

Purchase order report…In that report i want to calculate tax % …

5

For that you don’t required to Calculate Tax as there is already field available in Purchase line Table i.e Tax% ,Tax Amount

6

ok…but my requirement is if tax % is available then it should display that value…if not it should not display 0 or that field…for example tax % … 0 …

7

Then create 2 sections

1 with Tax%

2 without Tax%

Based on the Tax% value show the section…

8

Then Take a variable and put tax% in that variable and show that variable in section

Write a code like

If Tax%<>0 then

var Tax:=Tax%

Else

…

9

ok thank you…

10

Hi amol sir…should i write that code in purchase line dataitem? If u dont mind please give me the detailed description of that code…

11

Create a text variable for the VAT % label and give a value to the variable only if the “VAT %” is <> 0

The “VAT %” field has a property BlankZero and should be set to Yes.

So now, you can control what is displayed.

You can find out if the VAT amount for the order is zero or not:

CALCFIELDS(Amount,“Amount Including VAT”);
IF Amount <>“Amount Including VAT” then
VAT%Label := ‘VAT %’;

12

You Can write code on onAftergetrecord trigger of purchase line

As well as you can write code on Section (But it is not feasible option because if anybody delete the section then code will also gone)

13

Go to the C/AL Code of the Body Section, if the “Tax Amount” is the field that you want to hide if its zero then,

IF “Tax Amount” = ’ ’ THEN

CurrReport.showoutput(false)

ELSE

CurrReport.showoutput(true);

14

hi elisha…for the above code i can hide only " Tax Amount" field if it zero…but i want to hide along with “Tax%” and label field .

plz suggest if any one know.

15

Did you try this?

16

Hi mohana…Can u please explain in detail ?

17

Header 1

<field 1> <field 2> <tax %>

Header 2

<Field 1> <field 2>

Show Header 1 if tax % is not equal to 0

Show header 2 if tax % equal to 0

Did you get?

18

Hi mohana…can u please explain in detail.

19

Sorry…I cannot explain more in detail than this…

[:#]

20

Hi mohana…can u plz explain in detail?