Can I filter Inventory /WIP Reconciliation report by PO or packing slip?

[khunchay_Leela]

I cannot to see field for filtering

Anyone have any ideas on what I can do or use?
Thank you in advance.

[ckrusen (Calvin Krusen)]

I believe the WIP Recon report is iterative - meaning it does several cycles of processing, and isn’t just a complex query. This is why it takes so long to run.

You can’t add filters to the WIP/Recon form. But you could create a Report style
that only shows records with a Pack slip or PO num in the data.

If you want to see PO Receipts, use the following expression in row visibility
=iif(InStr(Fields!TmpReference.Value, "PS: "), false, true)

Note that would only hide the other rows from displaying, they would still be included in the G/L Account Recap section.

[ckrusen (Calvin Krusen)]

Or even easier … you could use the Tran types filter to just show the ones you’re interested in.

[khunchay_Leela]

Dear Calvin Krusen,
Thank you so much for your reply.

I’m try to below it’s working for me.
1.Pass value to report parameter ( Receipt Legal number to DispAccount)

2.Add Cal field for Recon

3.Add expression for showing (Legal number=DispAccount)

br,
khunchay