Solved

Unable To Apply Two Filter Of Similar Sort In Report

C
Rank
Userlevel 4
Badge

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

icon

Best answer by yhartman 6 May 2022, 04:05

View original

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
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