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:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/01222dcb-4355-46c3-a82b-ccfdd27e0a3f.png)
Invoices (Boxes):
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/5e179e4d-3f7e-4007-8b1c-81c8beee1a17.png)
Invoice (Skid)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d53bc1b7-d65a-4e3b-98b9-fd4a87993a9e.png)
I know the main issue is when I apply SOShipLineSplitPackage.PackedQty filter to IsNotNull, it somehow takes away information from Credit Memo.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/79fac09d-a0eb-4724-81bb-12ef97af9d6b.png)
I have tried to change the filter to apply IsNull for Credit Memo and IsNotNull for INV, but it did not work.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/02501e8d-4b26-4ee8-9c82-5590e87bb84f.png)
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