Skip to main content
Solved

The "Is Null" in report designer visibility setting does not work, then how can I filter the data I want?

  • December 29, 2020
  • 3 replies
  • 1604 views
R
Captain II
Forum|alt.badge.img+6
  • ray20
  • Captain II
  • 445 replies

Hello,
Thanks to Gabriel’s help. I can get the data I want in GI using a second filter.  like below:

 

  The key in the join condition is that “INitemsitehistday” might only have qty in record，no sales record

     So if “left join” used， might get a joined line with INitemsitehistday.Sdate as Null.

 

This filter out  is working well in GI.
However if I would like to apply the same kind of second filter by using the visibility section setting in report Designer. 
The “ Or [INItemSiteHistDay.SDate] Is Null” does not work.
 

 

Then can somebody help me to get the data I want in Report designer?

1， Not sold in 90 days

2， never sold， which left join get a NULL value

Best answer by BenjaminCrisman

Hi @ray20 Have you tried using something like IsNull() or INItemSiteHistDay.SDate=Null or ‘’?

 

3 replies

D
Freshman II
  • Desmond78
  • 2 replies
  • December 30, 2020

Hi Ray

You can try do one of the following in Report Designer:

  1. Add the two conditions to the Report Filters (Schema Builder>Filters) or, if that doesn’t work, try
  2. Add the two conditions to the Relationship Data Links (Schema Builder>Relationships) for that specific join.

Then yoiu can remove the VisibleExp condition.

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 789 replies
  • Answer
  • December 30, 2020

Hi @ray20 Have you tried using something like IsNull() or INItemSiteHistDay.SDate=Null or ‘’?

 

R
Captain II
Forum|alt.badge.img+6
  • ray20
  • Author
  • Captain II
  • 445 replies
  • December 31, 2020

Hello, all,

([INItemSiteHistDay.SDate] = Null)   is working

So remember in Report design, should use ‘=’ not ‘is’


Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved