PUT v1/PurchaseOrders?loadboms={loadboms}

Update a list of Purchase Orders.

Request Information

URI Parameters

NameDescriptionTypeAdditional information
loadboms

An option to expand BOM's (This cannot be undone)

boolean

Default value is False

Body Parameters

Collection of PurchaseOrder
NameDescriptionTypeAdditional information
SupplierInvoiceReference

string

None.

SupplierAcceptanceDate

date

None.

Port

Port for Indent Order.

string

None.

EstimatedArrivalDate

Estimated time of arrival for Indent Order.

date

None.

FullyReceivedDate

date

None.

InvoiceDate

date

None.

LineItems

Collection of PurchaseOrderItem

None.

Status

Status (Readonly)

OrderStatus

None.

Stage

Stage: New, Awaiting Payment, Declined, Dispatched, Processing, On Hold (default: New)

string

None.

MemberEmail

The CRM contact email of a customer in an order

string

Max length: 250

MemberCostCenter

Member Cost Center (Alternative GL Account).

string

None.

MemberAlternativeTaxRate

The member Alternative Tax Rate.

string

None.

CostCenter

Cost Center (Alternative GL Account).

string

None.

AlternativeTaxRate

Alternative Tax Rate.

string

None.

EstimatedDeliveryDate

Estimated Delivery Date

date

None.

SalesPersonId

The unique Cin7 user Id of the sales person.

integer

None.

SalesPersonEmail

Made obsolete. This value will be null in the response.

string

Max length: 250

PaymentTerms

Payment terrms

string

None.

CustomerOrderNo

Customer purchase order reference

string

None.

VoucherCode

Voucher code

string

Max length: 30

DeliveryInstructions

Delivery instructions e.g. Leave at the door, ​beware the dog.

string

Max length: 2000

Id

The unique Cin7 Id.

integer

None.

CreatedDate

Created date.

date

None.

ModifiedDate

Last modified date.

date

None.

CreatedBy

The ID for the User who created the Transaction.

integer

None.

ProcessedBy

The ID for the User who processed the Transaction.

integer

None.

IsApproved

Is Approved (default: true)

boolean

None.

Reference

A unique order reference (leave blank to auto-generate in an insert).

string

Max length: 30

MemberId

The Customer Id (Optional). MemberId or MemberEmail should be specified to link a member to the order.

integer

None.

FirstName

Contact first name

string

Max length: 250

LastName

Contact last name

string

Max length: 250

Company

Contact company

string

Max length: 250

Email

Contact email address, could be different from MemberEmail assigned to the order

string

Max length: 250

Phone

Contact phone

string

Max length: 50

Mobile

Contact mobile

string

Max length: 50

Fax

Contact fax

string

Max length: 50

DeliveryFirstName

Delivery recipient first name

string

Max length: 250

DeliveryLastName

Delivery recipient last name

string

Max length: 250

DeliveryCompany

Delivery recipient company name

string

Max length: 250

DeliveryAddress1

Delivery address 1

string

Max length: 250

DeliveryAddress2

Delivery address 2

string

Max length: 250

DeliveryCity

Delivery address city

string

Max length: 250

DeliveryState

Delivery address state

string

Max length: 250

DeliveryPostalCode

Delivery address postcode

string

Max length: 250

DeliveryCountry

Delivery address country

string

Max length: 250

BillingFirstName

​Billing recipient first name

string

Max length: 250

BillingLastName

​Billing recipient last name

string

Max length: 250

BillingCompany

The billing company name

string

Max length: 250

BillingAddress1

​Billing address 1

string

Max length: 250

BillingAddress2

​Billing address 2

string

Max length: 250

BillingCity

​Billing address city

string

Max length: 250

BillingPostalCode

​Billing address postcode

string

Max length: 250

BillingState

Billing address state

string

Max length: 250

BillingCountry

Billing address country

string

Max length: 250

BranchId

Branch Id. Not updatable if SO Dispatched or PO Received. Defaults to "Main Branch" ID when omitted.

integer

None.

BranchEmail

Branch email

string

Max length: 250

ProjectName

Project Name

string

None.

TrackingCode

Shipping tracking code

string

Max length: 50

InternalComments

Internal comment

string

None.

ProductTotal

Product Total Only

decimal number

None.

FreightTotal

Total cost of delivery charges

decimal number

None.

FreightDescription

Freight/​carrier description

string

None.

Surcharge

Surcharge

decimal number

None.

SurchargeDescription

Surcharge description

string

None.

DiscountTotal

Total overall discount

decimal number

None.

DiscountDescription

The discount description

string

None.

Total

Order total includes Product Total, Freight Total, Discount Total, Surcharge Total, and Tax

decimal number

None.

CurrencyCode

The three-character ISO currency code e.g. NZD. Omit to use account default.

string

None.

CurrencyRate

The currency rate. ​​If no rate is specified (i.e. zero or null), Cin7 will lookup the currency rate from the start of the day as provided by our 3rd party currency service.

decimal number

None.

CurrencySymbol

The currency symbol e.g. $. This field is automatically populate based on currency code.

string

None.

TaxStatus

Tax Status: Incl, Excl, Exempt. Omit to use account default.

TaxStatus

None.

TaxRate

Tax Rate e.g. 15. If different from your default tax rate you will need to set the CostCenter or Alternative tax rate field as well.

decimal number

Range: inclusive between 0 and 100

Source

The source of the Transaction.

string

None.

CustomFields

Custom fields.

Dictionary of string [key] and Object [value]

None.

Request Formats

application/json, text/json

Sample:
[
  {
    "id": 15,
    "createdDate": "2020-10-20T19:15:30.5259384+13:00",
    "modifiedDate": "2020-10-20T19:15:30.5259384+13:00",
    "createdBy": 16,
    "processedBy": 17,
    "isApproved": true,
    "reference": "sample string 19",
    "memberId": 20,
    "firstName": "sample string 21",
    "lastName": "sample string 22",
    "company": "sample string 23",
    "email": "sample string 24",
    "phone": "sample string 25",
    "mobile": "sample string 26",
    "fax": "sample string 27",
    "deliveryFirstName": "sample string 28",
    "deliveryLastName": "sample string 29",
    "deliveryCompany": "sample string 30",
    "deliveryAddress1": "sample string 31",
    "deliveryAddress2": "sample string 32",
    "deliveryCity": "sample string 33",
    "deliveryState": "sample string 34",
    "deliveryPostalCode": "sample string 35",
    "deliveryCountry": "sample string 36",
    "billingFirstName": "sample string 37",
    "billingLastName": "sample string 38",
    "billingCompany": "sample string 39",
    "billingAddress1": "sample string 40",
    "billingAddress2": "sample string 41",
    "billingCity": "sample string 42",
    "billingPostalCode": "sample string 43",
    "billingState": "sample string 44",
    "billingCountry": "sample string 45",
    "branchId": 46,
    "branchEmail": "sample string 47",
    "projectName": "sample string 48",
    "trackingCode": "sample string 49",
    "internalComments": "sample string 50",
    "productTotal": 51.0,
    "freightTotal": 1.0,
    "freightDescription": "sample string 52",
    "surcharge": 1.0,
    "surchargeDescription": "sample string 53",
    "discountTotal": 1.0,
    "discountDescription": "sample string 54",
    "total": 55.0,
    "currencyCode": "sample string 57",
    "currencyRate": 58.0,
    "currencySymbol": "sample string 59",
    "taxStatus": "Undefined",
    "taxRate": 60.0,
    "source": "sample string 61",
    "customFields": {
      "sample string 1": {},
      "sample string 3": {}
    },
    "memberEmail": "sample string 4",
    "memberCostCenter": "sample string 5",
    "memberAlternativeTaxRate": "sample string 6",
    "costCenter": "sample string 7",
    "alternativeTaxRate": "sample string 8",
    "estimatedDeliveryDate": "2020-10-20T19:15:30.5259384+13:00",
    "salesPersonId": 9,
    "salesPersonEmail": "sample string 10",
    "paymentTerms": "sample string 11",
    "customerOrderNo": "sample string 12",
    "voucherCode": "sample string 13",
    "deliveryInstructions": "sample string 14",
    "status": "DRAFT",
    "stage": "sample string 3",
    "supplierInvoiceReference": "sample string 1",
    "supplierAcceptanceDate": "2020-10-20T19:15:30.5259384+13:00",
    "port": "sample string 2",
    "estimatedArrivalDate": "2020-10-20T19:15:30.5259384+13:00",
    "fullyReceivedDate": "2020-10-20T19:15:30.5259384+13:00",
    "invoiceDate": "2020-10-20T19:15:30.5259384+13:00",
    "lineItems": [
      {
        "id": 10,
        "createdDate": "2020-10-20T19:15:30.5259384+13:00",
        "transactionId": 12,
        "parentId": 1,
        "productId": 13,
        "productOptionId": 14,
        "integrationRef": "sample string 15",
        "sort": 16,
        "code": "sample string 17",
        "name": "sample string 18",
        "option1": "sample string 19",
        "option2": "sample string 20",
        "option3": "sample string 21",
        "qty": 22.0,
        "styleCode": "sample string 1",
        "barcode": "sample string 2",
        "sizeCodes": "sample string 4",
        "lineComments": "sample string 5",
        "unitPrice": 1.0,
        "discount": 6.0,
        "qtyShipped": 7.0,
        "holdingQty": 8.0,
        "accountCode": "sample string 9"
      },
      {
        "id": 10,
        "createdDate": "2020-10-20T19:15:30.5259384+13:00",
        "transactionId": 12,
        "parentId": 1,
        "productId": 13,
        "productOptionId": 14,
        "integrationRef": "sample string 15",
        "sort": 16,
        "code": "sample string 17",
        "name": "sample string 18",
        "option1": "sample string 19",
        "option2": "sample string 20",
        "option3": "sample string 21",
        "qty": 22.0,
        "styleCode": "sample string 1",
        "barcode": "sample string 2",
        "sizeCodes": "sample string 4",
        "lineComments": "sample string 5",
        "unitPrice": 1.0,
        "discount": 6.0,
        "qtyShipped": 7.0,
        "holdingQty": 8.0,
        "accountCode": "sample string 9"
      }
    ]
  },
  {
    "id": 15,
    "createdDate": "2020-10-20T19:15:30.5259384+13:00",
    "modifiedDate": "2020-10-20T19:15:30.5259384+13:00",
    "createdBy": 16,
    "processedBy": 17,
    "isApproved": true,
    "reference": "sample string 19",
    "memberId": 20,
    "firstName": "sample string 21",
    "lastName": "sample string 22",
    "company": "sample string 23",
    "email": "sample string 24",
    "phone": "sample string 25",
    "mobile": "sample string 26",
    "fax": "sample string 27",
    "deliveryFirstName": "sample string 28",
    "deliveryLastName": "sample string 29",
    "deliveryCompany": "sample string 30",
    "deliveryAddress1": "sample string 31",
    "deliveryAddress2": "sample string 32",
    "deliveryCity": "sample string 33",
    "deliveryState": "sample string 34",
    "deliveryPostalCode": "sample string 35",
    "deliveryCountry": "sample string 36",
    "billingFirstName": "sample string 37",
    "billingLastName": "sample string 38",
    "billingCompany": "sample string 39",
    "billingAddress1": "sample string 40",
    "billingAddress2": "sample string 41",
    "billingCity": "sample string 42",
    "billingPostalCode": "sample string 43",
    "billingState": "sample string 44",
    "billingCountry": "sample string 45",
    "branchId": 46,
    "branchEmail": "sample string 47",
    "projectName": "sample string 48",
    "trackingCode": "sample string 49",
    "internalComments": "sample string 50",
    "productTotal": 51.0,
    "freightTotal": 1.0,
    "freightDescription": "sample string 52",
    "surcharge": 1.0,
    "surchargeDescription": "sample string 53",
    "discountTotal": 1.0,
    "discountDescription": "sample string 54",
    "total": 55.0,
    "currencyCode": "sample string 57",
    "currencyRate": 58.0,
    "currencySymbol": "sample string 59",
    "taxStatus": "Undefined",
    "taxRate": 60.0,
    "source": "sample string 61",
    "customFields": {
      "sample string 1": {},
      "sample string 3": {}
    },
    "memberEmail": "sample string 4",
    "memberCostCenter": "sample string 5",
    "memberAlternativeTaxRate": "sample string 6",
    "costCenter": "sample string 7",
    "alternativeTaxRate": "sample string 8",
    "estimatedDeliveryDate": "2020-10-20T19:15:30.5259384+13:00",
    "salesPersonId": 9,
    "salesPersonEmail": "sample string 10",
    "paymentTerms": "sample string 11",
    "customerOrderNo": "sample string 12",
    "voucherCode": "sample string 13",
    "deliveryInstructions": "sample string 14",
    "status": "DRAFT",
    "stage": "sample string 3",
    "supplierInvoiceReference": "sample string 1",
    "supplierAcceptanceDate": "2020-10-20T19:15:30.5259384+13:00",
    "port": "sample string 2",
    "estimatedArrivalDate": "2020-10-20T19:15:30.5259384+13:00",
    "fullyReceivedDate": "2020-10-20T19:15:30.5259384+13:00",
    "invoiceDate": "2020-10-20T19:15:30.5259384+13:00",
    "lineItems": [
      {
        "id": 10,
        "createdDate": "2020-10-20T19:15:30.5259384+13:00",
        "transactionId": 12,
        "parentId": 1,
        "productId": 13,
        "productOptionId": 14,
        "integrationRef": "sample string 15",
        "sort": 16,
        "code": "sample string 17",
        "name": "sample string 18",
        "option1": "sample string 19",
        "option2": "sample string 20",
        "option3": "sample string 21",
        "qty": 22.0,
        "styleCode": "sample string 1",
        "barcode": "sample string 2",
        "sizeCodes": "sample string 4",
        "lineComments": "sample string 5",
        "unitPrice": 1.0,
        "discount": 6.0,
        "qtyShipped": 7.0,
        "holdingQty": 8.0,
        "accountCode": "sample string 9"
      },
      {
        "id": 10,
        "createdDate": "2020-10-20T19:15:30.5259384+13:00",
        "transactionId": 12,
        "parentId": 1,
        "productId": 13,
        "productOptionId": 14,
        "integrationRef": "sample string 15",
        "sort": 16,
        "code": "sample string 17",
        "name": "sample string 18",
        "option1": "sample string 19",
        "option2": "sample string 20",
        "option3": "sample string 21",
        "qty": 22.0,
        "styleCode": "sample string 1",
        "barcode": "sample string 2",
        "sizeCodes": "sample string 4",
        "lineComments": "sample string 5",
        "unitPrice": 1.0,
        "discount": 6.0,
        "qtyShipped": 7.0,
        "holdingQty": 8.0,
        "accountCode": "sample string 9"
      }
    ]
  }
]

Response Information

Resource Description

Collection of BatchResultItem
NameDescriptionTypeAdditional information
Index

​The index at which the record was positioned in an insert or update.

integer

None.

Success

​True if the record was successfully inserted or updated.

boolean

None.

Id

The record Id.

integer

None.

Code

The record code.

string

None.

Errors

A list of errors if the insert or update fails.

Collection of string

None.

Response Formats

application/json, text/json

Sample:
[
  {
    "index": 0,
    "success": true,
    "id": 1,
    "code": "SALE4-28",
    "errors": []
  },
  {
    "index": 1,
    "success": true,
    "id": 2,
    "code": "SALE5-29",
    "errors": []
  }
]