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.
Less than X Date ==> you can add this condition in the CONDITIONS Tab
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.
Hi @ketiller Since you wanted to apply the 2 filters, you can try like below and verify.
Less than X Date ==> you can add this condition in the CONDITIONS Tab
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.