Symptom

When using the Velixo GIFILTER() function with an Acumatica financial period, the GI function returns #VALUE! (but the GI function works when not filtered)

Cause

This can occur when using Velixo 6 (or higher) with Acumatica 2020 R2 (or newer) and a financial period formatted as YYYYMM.

e.g.,

=GIFILTER("Demo","AR-Invoices and Memos","PostPeriod","201306")
gifilter_yyyymm.png

Earlier versions of Acumatica expected the financial period in YYYYMM format and older versions of Velixo Reports automatically corrected any issues because GI filtering was performed on the client computer by Velixo Reports.

In order to speed processing, newer versions of Velixo Reports now have the Acumatica server handle the filtering whenever possible.

With the release of version 2020 R2, Acumatica changed the format it uses for filtering and requires that it match the MMYYYY format used in the user interface.

Resolution

When using Acumatica 2020 R2 or newer, use the MMYYYY financial period format with the Velixo Reports GIFILTER function:

gifilter_mmyyyy.png
Did this answer your question?