Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / Vendor Ledger Entries ...
Microsoft Dynamics NAV forum
Answered

Vendor Ledger Entries - Show Results When "On Hold" = BLANK

(0) ShareShare
ReportReport
Posted on by Raymond Ng 30

Hi All,

I am trying to set the On Hold = BLANK, to show all invoices which are not on hold in the Vendor Ledger Entries.

Please let me know what is the correct syntax.

Thanks.

Categories:
Financial Management
  • Verified answer
    Raymond Ng Profile Picture
    Raymond Ng 30 on at
    RE: Vendor Ledger Entries - Show Results When "On Hold" = BLANK

    I entered as 2 single quote (') and it worked!

    Thank so much for your help.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,991 Super User on at
    RE: Vendor Ledger Entries - Show Results When "On Hold" = BLANK

    Ok, and then try enter '' this

    Thanks.

  • Raymond Ng Profile Picture
    Raymond Ng 30 on at
    RE: Vendor Ledger Entries - Show Results When "On Hold" = BLANK

    If I left it blank, it will retrieve on hold invoices.  I think I do need to enter something to exclude on hold invoices.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,991 Super User on at
    RE: Vendor Ledger Entries - Show Results When "On Hold" = BLANK

    No Need to enter anything in Yellow part, leave this like this only, it be default a blank value for filters.

    Thanks.

  • Raymond Ng Profile Picture
    Raymond Ng 30 on at
    RE: Vendor Ledger Entries - Show Results When "On Hold" = BLANK

    Hi Nitin,

    Thanks for your advice.

    I actually need to enter a criterion (snip below) in order to retrieve invoices which are not "On Hold", i.e. On Hold = BLANK.

    Do you know what I need to enter in the box to achieve the above result?

    Thanks.

    pastedimage1679627605332v2.png

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,991 Super User on at
    RE: Vendor Ledger Entries - Show Results When "On Hold" = BLANK

    Hi,

    You can try below

    VendleEntry.setrange("On Hold",'');

    Thanks

    Nitin

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans