FinPeriod Default Value in Generic Inquiry

​@Crisel As a workaround, could you please try adding the Month Start and Month End as parameters? This may help you achieve a filter that more closely matches the values you are expecting.

Thank you for your reply, @ranjithduraisamy72.

I tried joining the MasterFinPeriod DAC so I could use Month Start and Month End as parameters in the Generic Inquiry conditions. However, I am still encountering the following error:

"System was not able to get record count. Number pages mode is unavailable. Export to Excel is limited to 1000 records."

Has anyone experienced this even after limiting the inquiry by date range? Is there anything else I should check that could be preventing Acumatica from calculating the record count?

That time out error in GIs is frustrating. Sometimes the only way to get around that is to recreate the GI as a xlsx friendly report in report designer

Hi ​@Crisel 

I imported your xml into a local environment and did not get the error you are seeing, could be because I don’t have a lot of data in general.

But looking at the GI, it does look like you have a lot of different data sources and joins. Sometimes in accurate joins can create duplicate records which cause record limit issue. I recommend keeping your GI as simple as you can, start with revieing the joins. Removing any unused tables. For example, it looks like you have a relation between InSite and Branch but with no fields linked on, this could potentially cause every result row gets multiplied by the number of branches in the tenant. 

I also like to check my record count by hardcoding a date in the conditions or even in the join directly, to make sure there are no duplicates and the GI returns the number of records I expect to see within that date range. 

Thank you for this. I was trying to modify the formula; however, I was getting different results, so I did not proceed with that approach.

I will probably try recreating it instead.