Skip to main content
Solved

Unable To Apply Two Filter Of Similar Sort In Report

Hi,

I am editing the SO Invoice report SO643000 and adding in packing info to the invoice so it will show what item is pack to which Skid or Box. After finishing my whole setup, it would work great for invoices. However it now product a blank report when the document type is Credit. Examples below:

Credit Memo:

Invoices (Boxes):

Invoice (Skid)

I know the main issue is when I apply SOShipLineSplitPackage.PackedQty filter to IsNotNull, it somehow takes away information from Credit Memo. 

I have tried to change the filter to apply IsNull for Credit Memo and IsNotNull for INV, but it did not work. 

 

 

Does anyone have suggestion on what I can do to achieve below logic, either with Filter or another way?

  • If it is Invoice, PackedQTY is not empty
  • If it is Credit Memo, PackedQTY is empty.

Thank you,

Calvin

2 replies

Y
Rank
Userlevel 5
Badge +3

Calvin,
The two statements you have are separated by an "AND," both statements cannot be true at the same time. What you want instead is "OR" in between your two statements. Also, you want to warp both those statements into another bracket to combine them as one.

 

I hope that helps!

Yisroel Hartman • https://www.linkedin.com/in/yisroelhartman/
C
Rank
Userlevel 4
Badge

Thank you @yhartman!

 

Reply


Terms & ConditionsCookie settings