I’m trying to prepare GI similar to the AP Register Detailed report. I tried copying the same relations as defined in the report designer for the GI but the results are not as expected. the date filter does not work well.
I would really appreciate help on this one.
Hello,
Date filters in the GI’s can be tricky because it treats the date fields often as Date + Time fields. So I find I often have to use a “DateAdd” function to add 24 hours to my filters. See my last comment from Aug 3, 2022 at the post below with a similar Date issue:
There’s another post here as well which may be helpful:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.