Expression "<>" in Sale VAT Reg. Report

TomekJot
TomekJot Member Posts: 23
edited 2007-09-11 in NAV/Navision Classic Client
Hi all :)
In Polish version of Navision 4.0 sp3 in General Ledger/Reports/Poland/ Sale|Purchase Vat Reg. I want to preview VAT Sale/Purchase report using Business Posging Groups and VAT Product Posting Groups as a filter. And here I have a problem :) I have 40 VAT Product Posting Groups e.g:

K0, K1, K2, K3, K4, K5, K6, K7, K8, K9, K10, K ...

In my report I want to use almost everything, but without K1 K2 K3 K4, so I can use this formulas: K0|K5..Kn or <>K1&<>K2&<K3>&<K4>

but is it possible to sum up those excluded VAT Prod.Post.Groups? Becasue sth. like: <>K1..<k4> it is a wrong formula. How to sum up formulas with <> expression, is it possible?
Thanks in advance for any advice.

Comments

  • David_Singleton
    David_Singleton Member Posts: 5,479
    Look at it from the Database perspective instead of the Programing perspective.

    Add a new boolean Field "Include in Preview" to the Vat Product Group Table.

    Then tick that box for these VAT codes, and then just
    SETRANGE("Include in Preview",true);
    David Singleton
  • Albertvh
    Albertvh Member Posts: 516
    Hi

    You could also use

    SETFILTER("VAT Product Posting Group",'<>%1','K*');



    Albert
  • Phenno
    Phenno Member Posts: 630
    Albertvh wrote:
    Hi

    You could also use

    SETFILTER("VAT Product Posting Group",'<>%1','K*');



    Albert


    Nop, that will not work.
  • Albertvh
    Albertvh Member Posts: 516
    Hi

    Ok then try this

    SETFILTER("VAT Product Posting Group",'%1','A..J*|L..Z*');

    this will work

    Albert

Categories