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 a filtered list of Sales Price Worksheets from Acumatica, applying optional OData-based filters on dates, text fields, boolean flags, and custom expressions.
Inputs
- Created Date Time Filter — Filter results by Created Date Time using operators like equals, after, on or after, before, or on or before.
- Description Filter — Filter results by Description with operators equals, contains, or starts with.
- Effective Date Filter — Filter results by Effective Date using comparison operators.
- Expiration Date Filter — Filter results by Expiration Date using comparison operators.
- Hold Filter — Filter results by Hold status (boolean equals).
- Last Modified Date Time Filter — Filter results by Last Modified Date Time using comparison operators.
- Overwrite Overlapping Prices Filter — Filter results by Overwrite Overlapping Prices status (boolean equals).
- Reference Nbr Filter — Filter results by Reference Number with operators equals, contains, or starts with.
- Status Filter — Filter results by Status with operators equals, contains, or starts with.
- Custom Filter — Provide an advanced OData $filter expression to combine with other filters for more complex queries.
Output shape
a list of Sales Price Worksheet records matching the applied filters
Returns the filtered collection of worksheets as received from the Acumatica API; supports multiple optional filters that are combined using OData syntax. The custom filter string applies additionally to the other filters. If no filters are provided, returns all items (subject to remote API limits). Pagination or total count behavior depends on the Acumatica API and is not controlled by the node.