Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Financial Years from the Acumatica API, applying optional field-specific filters to refine the results.

Inputs

• Adjust To Period Start Filter — Filter Financial Years by the boolean 'Adjust To Period Start' field using the 'Equals' operator.
• Belongs To Next Year Filter — Filter Financial Years by the boolean 'Belongs To Next Year' field using the 'Equals' operator.
• Created Date Time Filter — Filter Financial Years by 'Created Date Time' using operators like Equals, After, On or After, Before, or On or Before.
• Day Of Week Filter — Filter Financial Years by 'Day Of Week' string field using operators Equals, Contains, or Starts With.
• Financial Year Starts On Filter — Filter Financial Years by 'Financial Year Starts On' date-time field using comparison operators like Equals, After, On or After, Before, or On or Before.
• First Financial Year Filter — Filter Financial Years by 'First Financial Year' string field using operators Equals, Contains, or Starts With.
• First Period Start Date Filter — Filter Financial Years by 'First Period Start Date' date-time field using standard comparison operators.
• Has Adjustment Period Filter — Filter Financial Years by the boolean 'Has Adjustment Period' field using the 'Equals' operator.
• Last Modified Date Time Filter — Filter Financial Years by 'Last Modified Date Time' date-time field using operators such as Equals, After, On or After, Before, or On or Before.
• Periods Start Day Of Week Filter — Filter Financial Years by 'Periods Start Day Of Week' string field using Equals, Contains, or Starts With operators.
• Period Type Filter — Filter Financial Years by 'Period Type' string field using Equals, Contains, or Starts With operators.
• User Defined Periods Filter — Filter Financial Years by the boolean 'User Defined Periods' field using the 'Equals' operator.
• Year End Calculation Method Filter — Filter Financial Years by 'Year End Calculation Method' string field using Equals, Contains, or Starts With operators.
• Custom Filter — Provide an advanced OData $filter expression to apply additional filtering criteria beyond the predefined filters.

Output shape

a list of Financial Year records matching the specified filters

The operation accepts multiple optional filter parameters each corresponding to specific Financial Year fields; results adhere to these filters combined with any custom OData $filter expression provided. The response returns matching Financial Year items from Acumatica.

Examples

Example 1: Retrieve all Financial Years starting on or after 2023-01-01

Set 'Financial Year Starts On Filter' operator to 'On or After' and value to '2023-01-01T00:00:00'.

Example 2: Retrieve Financial Years where 'Has Adjustment Period' is true

Set 'Has Adjustment Period Filter' value to true, operator defaults to 'Equals'.

Links

• n8n community nodes installation guide