Actions478
- Account Actions
- Account Details For Period Inquiry Actions
- Account Group Actions
- Account Summary Inquiry Actions
- Activity Actions
- Amazon Store Actions
- Appointment Actions
- Attribute Definition Actions
- Big Commerce Stores Actions
- Bill Actions
- Budget Actions
- Business Account Actions
- Carrier Actions
- Case Actions
- Cash Sale Actions
- Cash Transaction Actions
- Change Order Actions
- Change Order Class Actions
- Check Actions
- Companies Structure Actions
- Company Financial Period Actions
- Contact Actions
- Contract Usage Actions
- Cost Code Actions
- Currency Actions
- Customer Actions
- Customer Class Actions
- Customer Location Actions
- Customer Payment Method Actions
- Customer Price Class Actions
- Deduction Benefit Code Actions
- Discount Actions
- Discount Code Actions
- Earning Type Code Actions
- Email Actions
- Email Processing Actions
- Employee Actions
- Employee Payroll Class Actions
- Employee Payroll Settings Actions
- Event Actions
- Expense Claim Actions
- Expense Receipt Actions
- External Commitment Actions
- Financial Period Actions
- Financial Year Actions
- F O B Point Actions
- Inventory Adjustment Actions
- Inventory Allocation Inquiry Actions
- Inventory Issue Actions
- Inventory Quantity Available Actions
- Inventory Receipt Actions
- Inventory Summary Inquiry Actions
- Invoice Actions
- Item Class Actions
- Item Sales Category Actions
- Item Warehouse Actions
- Journal Transaction Actions
- Kit Assembly Actions
- Kit Specification Actions
- Labor Cost Rate Actions
- Lead Actions
- Ledger Actions
- Lot Serial Class Actions
- Non Stock Item Actions
- Opportunity Actions
- Pay Group Actions
- Payment Actions
- Payment Method Actions
- Pay Period Actions
- Payroll Batch Actions
- Payroll Union Local Actions
- Payroll W C C Code Actions
- Physical Inventory Count Actions
- Physical Inventory Review Actions
- Pro Forma Invoice Actions
- Project Actions
- Project Budget Actions
- Project Task Actions
- Project Template Actions
- Project Template Task Actions
- Project Transaction Actions
- P T O Bank Actions
- Purchase Order Actions
- Purchase Receipt Actions
- Sales Invoice Actions
- Sales Order Actions
- Salesperson Actions
- Sales Prices Inquiry Actions
- Sales Price Worksheet Actions
- Service Order Actions
- Shipment Actions
- Shipping Box Actions
- Shipping Term Actions
- Shipping Zones Actions
- Ship Via Actions
- Shopify Store Actions
- Stock Item Actions
- Storage Details By Location Inquiry Actions
- Storage Details Inquiry Actions
- Subaccount Actions
- Subcontract Actions
- Task Actions
- Tax Actions
- Tax Category Actions
- Tax Reporting Settings Actions
- Tax Zone Actions
- Template Items Actions
- Time Entry Actions
- Transfer Order Actions
- Union Local Actions
- Units Of Measure Actions
- Vendor Actions
- Vendor Class Actions
- Vendor Prices Inquiry Actions
- Vendor Price Worksheet Actions
- Warehouse Actions
- Work Calendar Actions
- Work Class Compensation Code Actions
- Work Location Actions
Sales Price Worksheet → Get List
AI-generatedSummary
Retrieve Sales Price Worksheet records with optional filters for dates, status, hold, reference number, etc.
Inputs
- CreatedDateTimeFilter — Filter results by Created Date Time
- DescriptionFilter — Filter results by Description
- EffectiveDateFilter — Filter results by Effective Date
- ExpirationDateFilter — Filter results by Expiration Date
- HoldFilter — Filter results by Hold
- LastModifiedDateTimeFilter — Filter results by Last Modified Date Time
- OverwriteOverlappingPricesFilter — Filter results by Overwrite Overlapping Prices
- ReferenceNbrFilter — Filter results by Reference Nbr
- StatusFilter — Filter results by Status
- customFilter — Advanced OData $filter expression (e.g. CustomerID/value eq 'CUST001'). Applied in addition to any filter fields above.
Output shape
a list of Sales Price Worksheet records
Returns an empty list if no records match; pagination is handled by Acumatica's $top/$skip but not exposed as UI fields.
Examples
Example 1: Get all non‑held, released price worksheets created after January 1, 2024
CreatedDateTimeFilter.operator=ge, CreatedDateTimeFilter.value=2024-01-01T00:00:00Z, HoldFilter.value=false, StatusFilter.value=Released
Example 2: Search by description containing 'Widget'
DescriptionFilter.operator=contains, DescriptionFilter.value=Widget
Example 3: Apply a custom OData filter for a specific customer and status
customFilter='CustomerID/value eq ''CUST001'' and Status eq ''Open'''