i have design Sales Register

Mohit_B1
Mohit_B1 Member Posts: 13
in NAV/Navision Classic Client
Please help
whether i have twice of tax type VAT or CST but when Report Generate i have to need filter tax type .
if i select VAT then only VAT type record appear .
how can write filter for this issue

Best Answers

Answers

  • Sowkarthika
    Sowkarthika Member Posts: 102
    Is it your custom report ? If the field you are using is part of DataSet in your report then you can filter your report before selecting Preview in your report.
  • Mohit_B1
    Mohit_B1 Member Posts: 13
    RecPurchaseHeader - OnPreDataItem()
    IF recdetail.GETFILTER("Tax Type") <> '' THEN
    txtOtherfilter := 'Filter By :- ' + recdetail.GETFILTER("Tax Type")

    i have write code like this but i didn't get tax type filter.....
  • Mohit_B1
    Mohit_B1 Member Posts: 13
    i am unable to solve this issue
  • Mohit_B1
    Mohit_B1 Member Posts: 13
    simply i have a table Purch. Inv. Header . that use in my report
    but tax type value comes from Table record "'Detailed Tax Entry"
    i have get tax type from Detailed Tax Entry table Data has successfully comes but when i am trying to want data tax type - Vat wise then filter not working.

  • Sowkarthika
    Sowkarthika Member Posts: 102
    Are you using Detailed Tax Entry in your Data Item ? Are you using request page to get Tax Type ?
  • Mohit_B1
    Mohit_B1 Member Posts: 13
    yes sir......
  • Mohit_B1
    Mohit_B1 Member Posts: 13
    i have only Purch. Inv. Header in Data item ..........
  • Mohit_B1
    Mohit_B1 Member Posts: 13
    Expanded Data Type Data Source Name Include Caption
    1 DataItem Purch. Inv. Header RecPurchaseHeader No
    0 Column RecCompany.Name CompanyName No
    0 Column RecPurchaseHeader."No." InvoiceNo No
    0 Column RecPurchaseHeader."Posting Date" PostingDate No
    0 Column RecPurchaseHeader."Buy-from Vendor No." VendorCode No
    0 Column RecPurchaseHeader."Buy-from Vendor Name" VendorName No
    0 Column RecVendor."E.C.C. No." ECCNo No
    0 Column RecVendor."T.I.N. No." TINNo No
    0 Column decBaseAmount BaseAmount No
    0 Column decTaxPercentage TaxPercentage No
    0 Column decTaxAmount TaxAmount No
    0 Column decOtherCharge VendorCharge No
    0 Column RecPurLine."Tax %" Dectax No
    0 Column taxVATCST taxVATCST No
    0 Column TxtDateFilter DateFilter No
    0 Column txtLocationfilter LocationFilter No
    0 Column txtOtherfilter Otherfilter No
    0 Column RecPurchaseHeader."Location Code" LocationCode No
  • pavithrap0992
    pavithrap0992 Member Posts: 21
    Put the 'Tax Type' filter on the request page. Once you get the Tax Type from Detailed Tax Entry table you can hide those rows using visibility option or simply use CurrReport.SKIP with an IF condition.

Categories