Acumatica API - Endpoint Default 23 200 001Install

Summary

Retrieve a list of Project Budget records filtered by optional criteria.

Inputs

• AccountGroupFilter — Filter results by Account Group
• ActualAmountFilter — Filter results by Actual Amount
• ActualPlusOpenCommittedAmountFilter — Filter results by Actual Plus Open Committed Amount
• ActualQtyFilter — Filter results by Actual Qty
• AutoCompletedFilter — Filter results by Auto Completed
• BudgetedCOAmountFilter — Filter results by Budgeted CO Amount
• BudgetedCOQtyFilter — Filter results by Budgeted CO Qty
• CommittedCOAmountFilter — Filter results by Committed CO Amount
• CommittedCOQtyFilter — Filter results by Committed CO Qty
• CommittedInvoicedAmountFilter — Filter results by Committed Invoiced Amount
• CommittedInvoicedQtyFilter — Filter results by Committed Invoiced Qty
• CommittedOpenAmountFilter — Filter results by Committed Open Amount
• CommittedOpenQtyFilter — Filter results by Committed Open Qty
• CommittedReceivedQtyFilter — Filter results by Committed Received Qty
• CompletedFilter — Filter results by Completed
• CostAtCompletionFilter — Filter results by Cost At Completion
• CostCodeFilter — Filter results by Cost Code
• CostToCompleteFilter — Filter results by Cost To Complete
• DescriptionFilter — Filter results by Description
• DraftInvoicesAmountFilter — Filter results by Draft Invoices Amount
• InventoryIDFilter — Filter results by Inventory ID
• LastCostAtCompletionFilter — Filter results by Last Cost At Completion
• LastCostToCompleteFilter — Filter results by Last Cost To Complete
• LastModifiedDateTimeFilter — Filter results by Last Modified Date Time
• LastPercentageOfCompletionFilter — Filter results by Last Percentage Of Completion
• OriginalBudgetedAmountFilter — Filter results by Original Budgeted Amount
• OriginalBudgetedQtyFilter — Filter results by Original Budgeted Qty
• OriginalCommittedAmountFilter — Filter results by Original Committed Amount
• OriginalCommittedQtyFilter — Filter results by Original Committed Qty
• PendingInvoiceAmountFilter — Filter results by Pending Invoice Amount
• PercentageOfCompletionFilter — Filter results by Percentage Of Completion
• PerformanceFilter — Filter results by Performance
• ProjectIDFilter — Filter results by Project ID
• ProjectTaskIDFilter — Filter results by Project Task ID
• RetainageFilter — Filter results by Retainage
• RevenueTaskFilter — Filter results by Revenue Task
• RevisedBudgetedAmountFilter — Filter results by Revised Budgeted Amount
• RevisedBudgetedQtyFilter — Filter results by Revised Budgeted Qty
• RevisedCommittedAmountFilter — Filter results by Revised Committed Amount
• RevisedCommittedQtyFilter — Filter results by Revised Committed Qty
• TaxCategoryFilter — Filter results by Tax Category
• TypeFilter — Filter results by Type
• UnitRateFilter — Filter results by Unit Rate
• UOMFilter — Filter results by UOM
• VarianceAmountFilter — Filter results by Variance Amount
• customFilter — Custom OData $filter expression (e.g. CustomerID/value eq 'CUST001'). Applied in addition to any filter fields above.

Output shape

a list of Project Budget items

Response contains all fields defined for the Project Budget resource; pagination may be limited; filters are applied via OData $filter; empty filters are ignored.

Examples

Example 1: Retrieve budgets for a specific account group

Set AccountGroupFilter.operator to eq and AccountGroupFilter.value to '1000'

Example 2: Retrieve budgets where Actual Amount exceeds 5000

Set ActualAmountFilter.operator to gt and ActualAmountFilter.value to 5000

Example 3: Apply a custom OData filter expression

Provide customFilter with value "AccountGroup/value eq '1000' and ActualAmount/value gt 5000"

Links

• n8n community nodes installation guide