Filtering table on the basis of number series in reports

jetins9810 · 2006-02-24

Dear All

Please let me know the Can i filter the table on the basis of
number seriel through coding in reports.

For example in posted Invoices i have lotes of entries and entries are
differenciate on the basis of number series.
Like for simple purchase we have number series POSP0001....
Purchase for Research we have number series PORA0001....
For fixed assets we have number series like POFA0001...
and so on....

in a report i want the i pick all the records whose number series
contain the Character FA in the middle. Is that possible through coding
if yes pl help me. Welcome all

Thanks in advence..

Jetins :roll:

kriki · 2006-02-24

SETFILTER("My Code-Field",'%1','*FA*');

But speed will be low, because Navision will read the whole table to find the records.

bthor · 2006-02-24

You can filter on the No. Series field in the Sales invoice table.

Bjarni Þór

kine · 2006-02-27

Better sollution is to add some setup with options where you will assign the "meanings" to the no. series. You can use this setup to go through the entries. And if there is no no. series field in your table, you can add it there. For example this field is used on document headers...

Filtering table on the basis of number series in reports

Comments

Categories