I need to invisible & Summary pusure VAT by Invoice No.

joycopl_me · 2006-08-24

Hi all,
I am making report use for sumary VAT by the Invoice No of the Sales Invoice Header table (select from 2 table: Sales Invoice Header & Sales Invoice Line)
- I want to check : if VAT Prod. Posting Group == "No VAT", invisible this row
- Summary VAT if % VAT of item as the same

Thanks,
Thang Hong

Please show me step by step because i am a new comer

David_Cox · 2006-08-24

Two ways to do this best way is:
Sales Invoice Line - OnAfterGetRecord()
IF "VAT Prod. Posting Group" = 'NO VAT' THEN
CurrReport.SKIP;

Second way:
View the Report Sections, select the section you want to hide then press F9

Sales Invoice Line, Body (1) - OnPreSection()
CurrReport.SHOWOUTPUT("VAT Prod. Posting Group" <>'NO VAT') ;

Note: If you have variables you are creating totals for clear them OnAfterGetRecord or the will be added again if you use option 2, and you totals will be wrong

Howdy, Stranger!

Quick Links

Categories

I need to invisible & Summary pusure VAT by Invoice No.

Comments

Howdy, Stranger!

Categories

I need to invisible &amp; Summary pusure VAT by Invoice No.

Comments

I need to invisible & Summary pusure VAT by Invoice No.