| PRODUCT_SUPPLIER_ORDER_SEARCH | PRODUCT Endpoint | |
| /rpc/product/?method=PRODUCT_SUPPLIER_ORDER_SEARCH | ||
| For information on how to use Advanced Searches, click here |
| DETAILS | |||
| Prefix | SupplierOrder |
| SUB SEARCHES | |||
| Attachment | CORE_ATTACHMENT_SEARCH | ||
| OrderItem | PRODUCT_SUPPLIER_ORDER_ITEM_SEARCH | ||
| SupplierBusiness | CONTACT_BUSINESS_SEARCH | ||
| SupplierPerson | CONTACT_PERSON_SEARCH |
| AVAILABLE FIELDS | TYPE | ||
| Area | Numeric | Id of the Linked Area | |
| AreaText | Text (50) | Title of the linked Area | |
| DeliveryDate | Date | ||
| DeliveryDateTimeZone | Numeric | ||
| DeliveryDateTimeZoneText | Text (50) | ||
| DeliveryInstructions | Text (1000) | ||
| Id | Numeric | ||
| Notes | Text (4000) | ||
| Object | Numeric | ||
| ObjectText | Text (50) | ||
| ObjectContext | Numeric | See above | |
| PriceGroup | Numeric | ||
| PriceGroupText | Text (50) | See above | |
| ProcessingStatus | Numeric | Define your own | |
| ProcessingStatusText | Text (50) | See above | |
| Project | Numeric | Id of the Linked Project | |
| ProjectText | Text (50) | Reference of the linked Project | |
| PurchaseDate | Date | ||
| PurchaseDateTimeZone | Numeric | ||
| PurchaseDateTimeZoneText | Text (50) | ||
| Reference | Text (50) | ||
| Status | Numeric | 1=In Progress,2=Approved - Awaiting Invoice,3=Completed - Expense Created,4=Cancelled,6=Supplier Marked as Completed | |
| StatusText | Text (50) | See above | |
| Store | Numeric | Id of the linked Store | |
| StoreText | Text (50) | Title of the linked Store | |
| SupplierBusiness | Numeric | Id of the Supplier Business | |
| SupplierBusinessText | Text (50) | Tradename of the Supplier Business | |
| SupplierPerson | Numeric | Id of the Supplier Person | |
| SupplierPersonText | Text (50) | Name of the Supplier Person | |
| SupplierReference | Text (50) | ||
| Audit Fields | Click here for more information |
| RETURN | ||
| Selected Fields |
| EXAMPLE | |
| 1. Orders created this month, but are currently Cancelled | |
| var oAdvancedSearch = new AdvancedSearch(); oAdvancedSearch.endPoint = 'product'; oAdvancedSearch.method = 'PRODUCT_SUPPLIER_ORDER_SEARCH'; oAdvancedSearch.addField('reference'); oAdvancedSearch.addFilter('status','EQUAL_TO','4'); oAdvancedSearch.addFilter('createddate','MONTH_TO_DATE'); oAdvancedSearch.sort('reference', 'desc'); oAdvancedSearch.getResults(function(asData) { SearchComplete(asData);}); |
