Questions Empty Drilldown filter page

When you drilldown on a Pivot Table, all it does is apply a filter to the underlying Generic Inquiry.

So when you click a number like this:

It drills you down to the underlying Generic Inquiry and opens a Drilldown Filter Applied tab like this:

But you can click the Filter icon highlighted in the screenshot above to see what filters were applied. Clicking that icon will show you something like this:

Looking at those applied filters hopefully will help you to troubleshoot what the problem is.

Tim,

I have checked the filter and noticed that the formatting of the application period is different. It is 01-2018 in GI result, but 201801 in pivot result, therefore, they do not match, hence the filter shows nothing. I even tried to change the formatting of the period on the pivot table to mm-yyyy, but it still kept its own format of yyyymm.

Ah, very interesting. What build number of Acumatica are you on? Seems like you found a bug which isn't that surprising because Pivot Tables are a newer thing.

I just tried on 6.10.0472 and it worked for me.

I used a simple Pivot Table:

I drilled down on a number:

And it seems to work:

So, maybe it was a bug in the earlier versions and fixed later. Hopefully, I won't have this issue in 2017 R2.

Thank you for your help Tim.