Get a list of Purchase Orders
Use this method to get a detailed list of Purchase Orders based on the applied filters within a date range.
Valid Tokens: Company and Vendor.
When using this method, take the following statements into account:
The maximum range for this request is six months.
Filtering by
vendorId
,status
,number
,origin
,prebook
andlocationId
uses an exact match.Filtering by
vendor
andproduct
uses a "LIKE" expression.Filters are not case-sensitive.
The
boxes
array is only available when the Purchase Order was shipped by the Grower.
Related Articles
-
Substitute Items (Knowledge Base)
-
Confirm PO's - "V" Mark (Knowledge Base)
-
Confirm POs from the Vendor Portal (Knowledge Base)
-
Purchase Order Management (Knowledge Base)
-
Problems finding Purchase Orders (Knowledge Base)
Request
URL: https://api.kometsales.com/api/purchase.order.list Â
Method: GET
Content-Type: URL ParametersÂ
Input parameters:
authenticationToken (required)(string:50)
Komet Sales security token.
date (required if number
is not sent)(date)
Vendor Ship Date.
Date format: YYYY-MM-DD
futureInventoryAvailableFrom (optional)(date)
Date when the product will be available.
The specified date range must not exceed 4 days.
Date format: YYYY-MM-DDÂ
futureInventoryAvailableTo (optional)(date)
Date when the product stops being available.
Date format: YYYY-MM-DDÂ
The specified date range must not exceed 4 days.
vendor (optional)(string:50)
Vendor name or code.
vendorId(optional)(integer:10)
Komet Sales internal Vendor ID.
This parameter is used to search purchase orders from only one vendor.
You can get this value from the vendor.list API method.
customerId(optional)(integer:20)
Komet Sales internal Customer ID.
You can get this value from the customer.list API method.
customerPONumber (optional)(string:20)
Customer PO Number.
product (optional)(string:100)
Product description.
number (required if date
is not sent)(string:10)
Purchase order number.Â
You can send a set of numbers separated by commas.Â
origin (optional)(string:4)
Origin code. For example: MIA, MDE, and BOG.
prebook(optional)(string:10)
Prebook number.
awbId (optional)(integer)
AWB ID of the order.
If you use this parameter, or inboundTruckId
, you don’t need to send any other parameters aside from the authenticationToken
.
inboundTruckId (optional)(integer)
Inbound Truck ID.
If you use this parameter, or awbId
, you don’t need to send any other parameters aside from the authenticationToken
.
locationId (optional)(integer:10)
Komet Sales internal Location ID.
You can obtain this value from the location.list API method.
status (optional)(string:20)
Prebook status.
Valid values: Confirmed by Farm, Approved, Pending Approval, Cancelled.
If this filter is not set, the system will return every Purchase Order, including those that have the Pending Approval status.
statusLine (optional)(string:20)
Product line status.
Valid values:Â Pending, Confirmed, Cancelled, Partial Confirm, Shipped.Â
purchaseOrderItemIds (optional)(string:200)
A set of Purchase Order Item IDs separated by commas.
This is very useful for the Vendor Availability integration.Â
includeVendorAvailabilityDetails (optional)(boolean)
Include Vendor Availability information.
Valid values: True | False
Default it's false. Â
updatedAsOf (optional)(datetime)
When provided the system will only return orders that have been updated as of the date/time that is specified.
Date format: YYYY-MM-DDhh:mm:ss
Time must be in the GMT time zone.Â
excludeDetails(optional)(integer:1)
If the result should include only headers and exclude details.
Valid values: 0 = Include details | 1 = Exclude details
Default is 0.
https://api.kometsales.com/api/purchase.order.list?
authenticationToken=token_info_goes_here&date=2014-09-24&status=A
Response
status (integer:1)
Transaction status.
Valid values: 1 = Success | 0 = Failure
message (string:500)
Transaction status description.
purchaseOrders (array)
An array containing Purchase Orders.
id (integer:20)
Komet Sales internal Purchase Order ID.
number (integer:10)
Purchase Order number.
carrierName (string:200)
Purchase Order carrier name.
carrierId (integer:20)
Purchase Order Carrier ID.
networkCodeId (integer)
Purchase Order Carrier’s Komet Network Code.
origin (string:4)
Origin code.
vendorId (integer:20)
Komet Sales internal Vendor ID.
vendorName (string:200)
Vendor name.
shipDate (date)
Purchase Order shipping date.
Date format: YYYY-MM-DD
status (string:1)
Status code.
Valid values: CF = Confirmed by Farm | A = Approved | PA = Pending Approval | CA = Cancelled
locationId (integer:20)
Komet Sales internal Location ID.
locationName (string:200)
Location name.
totalCost (decimal:10,3)
Total cost of the order.
comments (string:500)
Special instructions or comments.
totalBoxes (integer:10)
Number of boxes.
updatedOn (datetime)
Last time when the order was updated.
Date format:Â YYYY-MM-DD'T'hh:mm:ssÂ
Time is in the GMT time zone.
createdOn (datetime)
Date when the order was created.
Date format: YYYY-MM-DD'T'hh:mm:ss
details (array)
Purchase Order details.
poItemId (integer:20)
Komet Sales internal Purchase Order Item ID.
prebookItemId (integer:20)
Prebook item internal ID.
prebook(integer:10)
Prebook number.
prebookTruckDate(date)
Prebook Truck Date.
Date format: YYYY-MM-DD
carrierId(integer:20)
Prebook Carrier ID.
carrierName(string:200)
Prebook Carrier Name.
standingOrder(string:10)
Standing order number.
orderType(string:1)
Order type.
Valid values: P = Prebook | S = Standing Order | D = Double
customerId(integer:20): customer Komet Sales internal ID.
customerName(string:200): customer name.
customerCode (string:50): Customer code.
shipName (string:200): Ship To name.Â
shipCity (string:200): ship city name. Â
subtotalCost(decimal:10,2)
Purchase Order total cost plus additional charges.
shipState (string:200): ship state name.Â
shipAddress (string:200): ship address.Â
shipZipCode (string:10): ship zip code. Â
shipCountry (string:200)
Ship country name.
productId (integer:20) product Komet Sales internal ID.
productDescription(string:200): product description.
recipes (array) of the products included within the recipe:
productDescription(string:200): item description.
stems(integer: 3): the number of stems.
laborAndMaterials:Â array of the labor and materials included within the recipe:
productDescription(string:200): product description.
quantity(integer: 3): the number of units.
totalBoxes(integer:10): number of boxes.
quantityConfirmed(integer:10): number of boxes confirmed by the vendor.Â
boxType(string:3): box type code. (HB, QB, EB, etc).
bunches (integer:10): number of bunches per box.
stemsBunch(integer:10): stems per bunch.
unitCost(decimal:10,3): unit flower cost.
units (integer:10): units per box.
unitType(string:5): stem or bunch.
totalFbe(decimal:10,2)
Total Full Box Equivalent (FBE) of every box in the Purchase Order.
totalUnits(integer:10):total of units.
totalCost(decimal:10,3): total cost.
totalAdditionalCharges (decimal:10,2)
Total additional charges.
unitPrice(decimal:10,3): unit flower price. This field is only available if the token type is Company Token.Â
totalPrice(decimal:10,3): total price. This field is only available if the token type is Company Token.Â
markCode(string:20): special mark code or slot number.
customField1 (string:50): additional field #1.
notes (string:200): general notes for each line.
notesForVendor (string:200): notes for the vendor associated to the prebook item.
lineItemStatus(string:1): vendor status code of the product line. P for Pending, C for Confirmed, CA for Cancelled, PC for Partial Confirm, S for Shipped.
breakdowns: array of breakdowns
productId (integer:20) product Komet Sales internal ID.
productDescription(string:200) product description.
stemsBunch(integer:10): stems per bunch.
bunches (integer:10): number of bunches.
cost (decimal:10,3): unit flower cost.
boxes: array of boxes
boxCode(string:20): box code number.
lotNumber(string)
Box lot number.
position (string:5): physical position of the box.
statusId(integer:10): status Komet Sales internal ID.
statusName(string:20): status name (Farm Shipped, Received Warehouse, Shipped Warehouse)
customFields: array of custom fields of the line, only if they exist.
name and value of the custom field (string:20).
vendorAvailabilityDetails: details of the vendor availability items associated to this line of the order.Â
productDescription(string:200): product description.
availableFrom(date):Â date when the product was available from the vendor. (date format YYYY-MM-DD).
postHarvest (string:20): post harvest.Â
unitType(string:20): unit type. Stem or Bunch.Â
unitsAllocated(integer:10): number of units allocated to this line of the order.Â
downgraded (boolean): true if the product was downgraded.
originalProductDescription(string:200)
product where the item was downgraded from.Â
upc: details of the upc information added to the product.Â
number (string: 50): UPC number.Â
checkDigit(integer: 2): UPC check digit.Â
pullDate(string: 20): UPC Pull date
price (string:20): UPC unit price.Â
description (string:200): Product description for the UPC.Â
instructions (string:200)
Additional UPC instructions. Â
The Ship-To information is only displayed with Company-type Tokens.
{
"message": "OK",
"purchaseOrders": [
{
"origin": "MIA",
"vendorId": 25211,
"totalBoxes": 15,
"shipName": "",
"createdOn": "2024-10-07T08:06:28",
"shipCountry": "",
"number": "P002937",
"locationId": 4,
"id": 90456,
"shipZipCode": "",
"shipCity": "",
"locationName": "Omaha Mod",
"updatedOn": "2024-10-07T07:06:37",
"vendorName": "AgriFarms",
"shipDate": "2024-10-07",
"shipAddress": "",
"subtotalCost": "15",
"shipState": "",
"totalCost": "15",
"totalAdditionalCharges": "0",
"status": "PA",
"carrierId": 1357,
"carrierName": "Armellini",
"networkCodeId": 0,
"details": [
{
"orderType": "P",
"stemsBunch": 2,
"totalPrice": "10",
"notesForVendor": "",
"customFields": [],
"breakdowns": [],
"bunches": 1,
"prebookItemId": 934637,
"customerCode": "main code",
"units": 1,
"totalBoxes": 5,
"unitType": "Bunch",
"totalFbe": "10",
"carrierName": "Elite",
"referenceNumber": "",
"poItemId": 288102,
"customerId": 29330,
"lineItemStatus": "P",
"productDescription": "Fancy Alstro",
"unitPrice": "2",
"boxes": [],
"recipes": [],
"productId": 217045,
"laborAndMaterials": [],
"boxType": "FB",
"customerName": "customer test main",
"totalUnits": 5,
"prebook": 3280,
"unitCost": "1",
"prebookTruckDate": "2024-10-07",
"quantityConfirmed": 0,
"carrierId": 3000,
"totalCost": "5"
},
{
"orderType": "P",
"stemsBunch": 2,
"totalPrice": "20",
"notesForVendor": "",
"customFields": [],
"breakdowns": [],
"bunches": 1,
"prebookItemId": 934636,
"customerCode": "main code",
"units": 1,
"totalBoxes": 10,
"unitType": "Bunch",
"totalFbe": "20",
"carrierName": "FedEx",
"referenceNumber": "",
"poItemId": 288103,
"customerId": 29330,
"lineItemStatus": "P",
"productDescription": "10 pack Leather Leaf",
"unitPrice": "2",
"boxes": [],
"recipes": [],
"productId": 219070,
"laborAndMaterials": [],
"boxType": "FB",
"customerName": "customer test main",
"totalUnits": 10,
"prebook": 3279,
"unitCost": "1",
"prebookTruckDate": "2024-10-07",
"quantityConfirmed": 0,
"carrierId": 4605,
"totalCost": "10"
}
]
}
],
"status": 1
}