Expression "<>" in Sale VAT Reg. Report

TomekJot

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.

David_Singleton

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);

Albertvh

Hi

You could also use

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



Albert

Phenno

Albertvh wrote:

Hi

You could also use

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



Albert

Nop, that will not work.

Albertvh

Hi

Ok then try this

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

this will work

Albert