GI function returns #VALUE! when using GIFILTER with Financial Period

Created by Damien Zwillinger, Modified on Wed, 13 Sep 2023 at 04:24 PM by Harry Lewis

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, Cegid, MYOB


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



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



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



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


In order to speed processing, newer versions of Velixo now have the ERP 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.



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


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article