Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a filtered list of Project Budget records from Acumatica, applying various optional filters on fields like Account Group, Actual Amount, Project ID, and others to narrow down results.

Inputs

• Account Group Filter — Filter results by Account Group with operators Equals, Contains, or Starts With.
• Actual Amount Filter — Filter results by Actual Amount with comparison operators like Equals, Greater Than, Less Than, etc.
• Actual Plus Open Committed Amount Filter — Filter results by Actual Plus Open Committed Amount with comparison operators.
• Actual Qty Filter — Filter results by Actual Quantity with comparison operators.
• Auto Completed Filter — Filter results by Auto Completed status (boolean, only Equals operator).
• Budgeted CO Amount Filter — Filter results by Budgeted CO Amount with comparison operators.
• Budgeted CO Qty Filter — Filter results by Budgeted CO Quantity with comparison operators.
• Committed CO Amount Filter — Filter results by Committed CO Amount with comparison operators.
• Committed CO Qty Filter — Filter results by Committed CO Quantity with comparison operators.
• Committed Invoiced Amount Filter — Filter results by Committed Invoiced Amount with comparison operators.
• Committed Invoiced Qty Filter — Filter results by Committed Invoiced Quantity with comparison operators.
• Committed Open Amount Filter — Filter results by Committed Open Amount with comparison operators.
• Committed Open Qty Filter — Filter results by Committed Open Quantity with comparison operators.
• Committed Received Qty Filter — Filter results by Committed Received Quantity with comparison operators.
• Completed Filter — Filter results by Completed value with comparison operators.
• Cost At Completion Filter — Filter results by Cost At Completion with comparison operators.
• Cost Code Filter — Filter results by Cost Code with operators Equals, Contains, or Starts With.
• Cost To Complete Filter — Filter results by Cost To Complete with comparison operators.
• Description Filter — Filter results by Description with operators Equals, Contains, or Starts With.
• Draft Invoices Amount Filter — Filter results by Draft Invoices Amount with comparison operators.
• Inventory ID Filter — Filter results by Inventory ID with operators Equals, Contains, or Starts With.
• Last Cost At Completion Filter — Filter results by Last Cost At Completion with comparison operators.
• Last Cost To Complete Filter — Filter results by Last Cost To Complete with comparison operators.
• Last Modified Date Time Filter — Filter results by Last Modified Date Time with date comparison operators.
• Last Percentage Of Completion Filter — Filter results by Last Percentage Of Completion with comparison operators.
• Original Budgeted Amount Filter — Filter results by Original Budgeted Amount with comparison operators.
• Original Budgeted Qty Filter — Filter results by Original Budgeted Quantity with comparison operators.
• Original Committed Amount Filter — Filter results by Original Committed Amount with comparison operators.
• Original Committed Qty Filter — Filter results by Original Committed Quantity with comparison operators.
• Pending Invoice Amount Filter — Filter results by Pending Invoice Amount with comparison operators.
• Percentage Of Completion Filter — Filter results by Percentage Of Completion with comparison operators.
• Performance Filter — Filter results by Performance with comparison operators.
• Project ID Filter — Filter results by Project ID with operators Equals, Contains, or Starts With.
• Project Task ID Filter — Filter results by Project Task ID with operators Equals, Contains, or Starts With.
• Retainage Filter — Filter results by Retainage with comparison operators.
• Revenue Task Filter — Filter results by Revenue Task with comparison operators.
• Revised Budgeted Amount Filter — Filter results by Revised Budgeted Amount with comparison operators.
• Revised Budgeted Qty Filter — Filter results by Revised Budgeted Quantity with comparison operators.
• Revised Committed Amount Filter — Filter results by Revised Committed Amount with comparison operators.
• Revised Committed Qty Filter — Filter results by Revised Committed Quantity with comparison operators.
• Tax Category Filter — Filter results by Tax Category with operators Equals, Contains, or Starts With.
• Type Filter — Filter results by Type with operators Equals, Contains, or Starts With.
• Unit Rate Filter — Filter results by Unit Rate with comparison operators.
• UOM Filter — Filter results by UOM with operators Equals, Contains, or Starts With.
• Variance Amount Filter — Filter results by Variance Amount with comparison operators.
• Custom Filter — Apply an advanced OData $filter expression for custom filtering in addition to other filters.

Output shape

a list of Project Budget records matching the specified filters

The returned list respects all provided filters combined as an OData query; if no filters are specified, all records are returned.

Links

• n8n community nodes installation guide