Skip records

roshini

Hi Nav Experts

I trying to update 2 fields in Cust. Ledger Entry table, the two fields values will be caliculated based on three filelds in customer table. I create a processonly report for the update.

I am facing few issues..

Can any expert suggest me how to skip records for following points:

1. how to write code to skip that particular record, when any one of the field is blank
ex: I have used (IF NoofSusMonth <> '' THEN) but still error is showing

2. how to use between function in navision(ex: if other then 0-12 then skip)

Thanking you

lubost

Hi,

Ad 1.) Which kind of error do you obtain?
Ad 2.) You can use: enumerated construction IF NOT (x IN [a,b,c...]) THEN ...
two comparisons IF (x < bottomboundary) OR (x > topboundary) THEN ...

roshini

Hi Mr. Lubost,

Thanks for your reply.

Ad 2.) You can use: enumerated construction IF NOT (x IN [a,b,c...]) THEN ...
two comparisons IF (x < bottomboundary) OR (x > topboundary) THEN ...

as that filed is in Text type.