Skip to main content
Solved

GI quick filter - PMTran Date Include all dates up to filter + blank dates

  • 17 May 2022
  • 1 reply
  • 124 views

ketiller
Jr Varsity III
Forum|alt.badge.img

Hello,

I am trying to include a quick filter on the PMTran Date for a GI. I would like to have the filter setup up to show everything “Is less than or equal to”, I would like it to also show all blank dates as well. 

Does anyone know how to do this?

I attached two screenshots

1). GI Screen results (with quick filter)

2). Results grids of that field

Any insights would be helpful!

 

Thank you,

KT

Best answer by Naveen Boga

Hi @ketiller  Since you wanted to apply the 2 filters, you can try like below and verify.

  1. Less than X Date ==> you can add this condition in the CONDITIONS Tab
  2. Blank Date ==> Since this is Date field, Acumatica will not provide Is Empty condition, but you can do the below workaround to get the blank date records.
    • Workaround: In the RESULTS GRID tab, you can provide the Schema field as any string field from that table, so that after viewing the inquiry you can filter with Is Empty condition. Please find the screenshot for reference.

Hope this helps!!

 

 

 

View original
Did this topic help you find an answer to your question?

Naveen Boga
Captain II
Forum|alt.badge.img+19

Hi @ketiller  Since you wanted to apply the 2 filters, you can try like below and verify.

  1. Less than X Date ==> you can add this condition in the CONDITIONS Tab
  2. Blank Date ==> Since this is Date field, Acumatica will not provide Is Empty condition, but you can do the below workaround to get the blank date records.
    • Workaround: In the RESULTS GRID tab, you can provide the Schema field as any string field from that table, so that after viewing the inquiry you can filter with Is Empty condition. Please find the screenshot for reference.

Hope this helps!!

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings