Skip records

roshini
roshini Member Posts: 122
edited 2009-01-08 in NAV/Navision Classic Client
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

Comments

  • lubost
    lubost Member Posts: 633
    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
    roshini Member Posts: 122
    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.

Categories