I’m running into an odd issue when using XL Connect 7 to drilldown into data in an period with a FY Suffix.
I’m using a GL Period Balances query, and was able to add a FiscalYearSuffix filter without issue.
However, when I run the GL Transaction Detail by Seg1 function, it pulls data that respects all the filters except the FY Suffix. It also pulls data from other periods that have the same FY and FP value but a different FY Suffix.
Is there any way I can make it respect the FY Suffix? I noted that the data pulled contains all the other data I’m filtering on, but not the FY Suffix. Could that be why?