Filtering Generic Inquiries by Financial Period IDs

Created by Damien Zwillinger, Modified on Sun, 3 Sep, 2023 at 11:25 PM by Damien Zwillinger

Applies to:

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


Follow the questionnaire below to determine which financial period format you should use for the GI filters:

  • Which version of Acumatica do you connect to?

    • 2020R2 or newer:

      • Use the MMYYYY format, e.g. '122021'

    • 2020R1 or older:
      (Check if the "Always load the entire Generic Inquiry and filter the data locally" flag is enabled under Options -> [Inquiry Name] -> Edit.

      • The box is unchecked:

        • Use the YYYYMM , e.g. '202112'

      • The box is checked:

        • Use the MMYYYY format, e.g. '122021'

Normally you should never separate the ordinal ("month") and the year with a dash in your filters - the financial periods are stored without a dash in Acumatica.

Explanation

In 2020R1 and older, Acumatica expected the YYYYMM format for the financial period columns in OData filters. In 2020R2 and newer, however, Acumatica began to expect the MMYYYY format, which is a breaking change and you may need to change your formulas.



At the same time, if you enabled client-side filtering with Velixo ("Always load the entire Generic Inquiry...") for a particular inquiry, you should always use the MMYYYY format regardless of the Acumatica version.

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article