DataItemTableview - filter on multiple doc types

markcle Member Posts: 65

2020-12-22 in NAV Three Tier

Hi All

I want to have a report that runs identically from sales orders and blanket sales orders. Is it possible to change the where clause below to Order or Blanket Order:

DataItemTableView = SORTING("Document Type", "No.") WHERE("Document Type" = CONST("Blanket Order"));

0

Answers

• 

  sradouan@hotmail.com Member Posts: 11

  2021-01-05

  Hi Marcle,
  Try With this: = CONST("Blanket Order"|Order|Invoice));
  Thanks.

  0
• 

  RockWithNAV Member Posts: 1,172

  2021-01-05

  You need to use PIPE for this the way you wish it to work.

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  0