search-icon

The Sale resource allows getting detailed info about Sale. This is how you call it:

· /Sale/E6E8163F-6911-40e9-B740-90E5A0A3A996 - returns details of a particular sale;

Also, this resource allows creating new Sale, by sending POST request.

The full range of URIs and HTTP Verbs supported are:

Operation

HTTP Action

View any Sale

GET /Sale/{id}

Create new Sale

POST /Sale

Void Sale

DELETE /Sale{id}


Available Fields for Sale:

Property

Type

Length

Required

Notes

ID

Guid

Unique DEAR Sale ID

Customer

String

256

Yes*

Customer name. Required if CustomerID not provided

CustomerID

Guid

 

Yes*

Customer identifier

Contact

String

256

Customer Contact name

Phone

String

50

Customer Contact phone

Email

String

256

Customer Contact email

DefaultAccount

String

50

Account code used by default for invoice lines when no revenue account is defined on Product. By default it is equal to Customer Sale account

SkipQuote

Boolean

Yes

“True” if there is no quote in the sale

BillingAddress

Structured

Sale Billing address, see below

ShippingAddress

Structured

Sale Shipping address, see below

BaseCurrency

String

3

Yes

3 character currency code of Base Currency defined in General Settings on the moment when Sale was created.

CustomerCurrency

String

3

Yes

3 character currency code of customer Currency defined in Customer card at the moment when customer is selected for the Sale.

TaxRule

String

50

Yes

Default Tax Rule name selected for Sale

TaxCalculation

String

Yes

“Inclusive” or “Exclusive”

Terms

String

256

Yes

Payment terms name

PriceTier

String

50

Yes

Price Tier name selected for Sale

ShipBy

Date

Date when shipment is due

Location

String

256

Default location to pick stock from

Created

Date

Date when task was created

LastModifiedOn

DateTime

UTC Time

Note

String

1024

Custom Sale note

CustomerReference

String

256

Reference number used by customer to identify this sale. Could be a purchase order number generated by customer.

COGSAmount

Money

Yes

COGS amount in base currency

Status

String

25

Sale Status, see below for possible values

CurrencyRate

Decimal

Up to 5 decimal places

Yes

Conversion Rate expressed as number of Base currency units for one Customer currency unit

SalesRepresentative

String

256

Sales representative name 

ServiceOnly

Boolean

Yes

“true” when it is service-only sale

Quote

Structured

Sale Quote, see below

Order

Structured

Sale Order, see below

Pick

Structured

Sale Pick, see below

Pack

Structured

Sale Pack, see below

Ship

Structured

Sale Ship, see below

Invoice

Structured

Sale Invoice, see below

CreditNote

Structured

Sale CreditNote, see below

AdditionalTransactions

Structured

Sale Additional Transactions, see below

AdditionalAttributes

Structured

 

 

Sale Additional Attributes, see below

 

Available Sale Statuses:

Status

Description

DRAFT

No data is added to sale details. Quote and order are empty and not authorised

VOIDED

Task has been voided

ESTIMATING

QuoteStatus = DRAFT, OrderStatus = NOT AVAILABLE

ESTIMATED

QuoteStatus = AUTHORISED or Skip Quote=true, OrderStatus = NOT AVAILABLE

ORDERING

OrderStatus = DRAFT

ORDERED

OrderStatus = AUTHORISED, all products in sale order are in stock, no backordering.

PickStatus = NOT AVAILABLE

BACKORDERED

OrderStatus = AUTHORISED, at least one product in sale order has been backordered

PickStatus = NOT AVAILABLE

PICKING

PickStatus = DRAFT

PICKED

PickStatus = AUTHORISED, PackStatus = NOT AVAILABLE

PACKING

PackStatus = DRAFT

PACKED

PackStatus = AUTHORISED, ShipStatus = NOT AVAILABLE

SHIPPING

ShipStatus = DRAFT

INVOICING

OrderStatus=AUTHORISED, ShipStatus=AUTHORISED, InvoiceStatus=DRAFT

INVOICED

ShipStatus=AUTHORISED, InvoiceStatus = AUTHORISED or InvoiceStatus = PAID, TotalInvoice – TotalPaid <> 0

CREDITED

CreditNoteStatus = AUTHORISED, TotalInvoice – TotalPaid <> 0

COMPLETED

InvoiceStatus = PAID, ShipStatus=AUTHORISED, TotalInvoice – TotalPaid = 0

 

Available Fields for BillingAddress and ShippingAddress:

Property

Type

Length

Required

Notes

DisplayAddressLine1

String

256

Address Line 1 as displayed on Sale form. = Line1 + Line2

DisplayAddressLine2

String

256

Address Line 2 as displayed on Sale form. = City + State/Region + Zip/Postcode + Country

Line1

String

256

Line2

String

256

City

String

256

State

String

256

Postcode

String

20

Country

String

32

 

Available Fields for Quote:

Property

Type

Length

Required

Notes

Memo

String

1024

Sale Quote memo

Status

String

20

Yes

Sale Quote status. Possible values are “VOIDED”, “DRAFT”, “AUTHORISED”, “NOT AVAILABLE”

Lines

Array of QuoteLine

Quote Lines, see below

AdditionalCharges

Array of QuoteAdditionalCharge

Quote Additional Charges, see below

Prepayments

Array of Prepayment

Prepayments, see below

TotalBeforeTax

Money

 

Yes

Quote Total before taxes in Customer Currency

Tax

Money

 

Yes

Quote Total Tax in Customer Currency

Total

Money

 

Yes

Quote Total (TotalBeforeTax + Tax) in Customer Currency

 

Available Fields for Order:

Property

Type

Length

Required

Notes

Memo

String

1024

Sale Order memo

Status

String

50

Yes

Sale Order status. Possible values are “VOIDED”, “DRAFT”, “AUTHORISED”, “NOT AVAILABLE”

Lines

Array of OrderLine

Order Lines, see below

TotalBeforeTax

Money

 

Yes

Order Total before taxes in Customer Currency

Tax

Money

 

Yes

Order Total Tax in Customer Currency

Total

Money

 

Yes

Order Total (TotalBeforeTax + Tax) in Customer Currency


Available Fields for Pick:

Property

Type

Length

Required

Notes

Status

String

20

Yes

Sale Pick status. Possible values are “VOIDED”, “DRAFT”, “AUTHORISED”, “NOT AVAILABLE”

Lines

Array of PickLine

Pick Lines, see below

 

Available Fields for Pack:

Property

Type

Length

Required

Notes

Status

String

20

Yes

Sale Pack status. Possible values are “VOIDED”, “DRAFT”, “AUTHORISED”, “NOT AVAILABLE”

Lines

Array of PackLine

Pack Lines, see below

 

Available Fields for Ship:

Property

Type

Length

Required

Notes

Status

String

20

Yes

Sale Ship status. Possible values are “VOIDED”, “DRAFT”, “AUTHORISED”, “NOT AVAILABLE”

Lines

Array of ShipLine

Ship Lines, see below

 

Available Fields for Invoice:

Property

Type

Length

Required

Notes

Memo

String

1024

Invoice memo

Status

String

20

Yes

Invoice status. Possible values are “VOIDED”, “DRAFT”, “AUTHORISED”, “NOT AVAILABLE”, “PAID”

InvoiceDate

Date

 

 

Date when invoice created. Default value is current date, used if not specified

InvoiceDueDate

Date

 

 

Date until invoice is valid. If not specified, used default value from Terms

Lines

Array of InvoiceLine

Invoice Lines, see below

AdditionalCharges

Array of InvoiceAdditionalCharge

Invoice Additional Charges, see below

Payments

Array of Payment

All invoice payments, see below

TotalBeforeTax

Money

 

Yes

Invoice Total before taxes in Customer Currency

Tax

Money

 

Yes

Invoice Total Tax in Customer Currency

Total

Money

 

Yes

Invoice Total (TotalBeforeTax + Tax) in Customer Currency

Paid

Money

 

Yes

Invoice Paid Total in Customer Currency


Available Fields for CreditNote:

Property

Type

Length

Required

Notes

Memo

String

1024

Credit Note memo

Status

String

20

Yes

Credit Note status. Possible values are “VOIDED”, “DRAFT”, “AUTHORISED”, “NOT AVAILABLE”

CreditNoteDate

Date

 

 

 

Lines

Array of CreditNoteLine

Credit Note Lines, see below

AdditionalCharges

Array of CreditAdditionalCharge

Credit Note Additional Charges, see below

Refunds

Array of Refund

All credit note refunds, see below

Restock

Array of RestockLine

Restocked products list, see below

TotalBeforeTax

Money

 

Yes

Credit Note Total before taxes in Customer Currency

Tax

Money

 

Yes

Credit Note Total Tax in Customer Currency

Total

Money

 

Yes

Credit Note Total (TotalBeforeTax + Tax) in Customer Currency

Refunded

Money

 

Yes

Credit Note refunded Total in Customer Currency

 

Available Fields for QuoteLine:

Property

Type

Length

Required

Notes

ProductID

Guid

Yes

Unique ID of the product referenced by this Quote Line

SKU

String

50

Yes

Product SKU referenced by this Quote Line

Name

String

256

Yes

Product name referenced by this Quote Line

Quantity

Decimal with up to 4 decimal places

Yes

Price

Decimal with up to 4 decimal places

Yes

Price per unit in Customer currency

Discount

Decimal with up to 2 decimal places

Yes

Discount. Value between 0 and 100. For free items discount is 100

Tax

Decimal with up to 4 decimal places

Yes

Calculated Tax value in Customer currency

Total

Decimal with up to 2 decimal places

Yes

Line Total in Customer currency. Can include Tax if Tax Rule for Sale is Tax Inclusive

AverageCost

Decimal with up to 5 decimal places

 

 

Current product Average Cost in base currency

TaxRule

String

50

Yes

Line Tax Rule name

Comment

String

256

 

 

 

Available Fields for QuoteAdditionalCharge:

Property

Type

Length

Required

Notes

Description

String

256

Yes

Additional charge description

Amount

Decimal with up to 4 decimal places

Yes

Charge amount in Customer currency

Discount

Decimal with up to 2 decimal places

Yes

Discount. Value between 0 and 100. For free items discount is 100

Tax

Decimal with up to 4 decimal places

Yes

Calculated Tax value in Customer currency

Total

Decimal with up to 2 decimal places

Yes

Additional Charge line total in Customer currency. Can include Tax if Tax Rule for Sale is Tax Inclusive

TaxRule

String

50

Yes

Additional Charge Tax Rule name


Available Fields for Payment, Refund and Prepayment:

Property

Type

Length

Required

Notes

Reference

String

50

Payment reference number

Amount

Money

Yes

Payment amount in customer currency

DatePaid

Date

Yes

Date when payment has been made

Account

String

50

Yes

Account Code of the Bank account

CurrencyRate

Decimal with up to 5 decimal places

Yes

Currency Conversion rate expressed as number of Base currency units for one Customer currency unit. Equals 1 when customer currency is the same as base currency.

 

Available Fields for OrderLine:

Property

Type

Length

Required

Notes

ProductID

Guid

Yes

Unique ID of the product referenced by this Line

SKU

String

50

Yes

Product SKU referenced by this Line

Name

String

256

Yes

Product name referenced by this Line

Quantity

Decimal with up to 4 decimal places

Yes

Price

Decimal with up to 4 decimal places

Yes

Price per unit in Customer currency

Discount

Decimal with up to 2 decimal places

Yes

Discount. Value between 0 and 100. For free items discount is 100

Tax

Decimal with up to 4 decimal places

Yes

Calculated Tax value in Customer currency

Total

Decimal with up to 2 decimal places

Yes

Line Total in Customer currency. Can include Tax if Tax Rule for Sale is Tax Inclusive

AverageCost

Decimal with up to 5 decimal places

 

 

Current product Average Cost in base currency

TaxRule

String

50

Yes

Line Tax Rule name

Comment

String

256

 

 

DropShip

Boolean

 

Yes

“True” if the line selected for drop-shipping

Backorder

Boolean

 

Yes

“True” if the line has backordered product


Available Fields for PickLine and RestockLine:

Property

Type

Length

Required

Notes

ProductID

Guid

Yes

Unique ID of the product referenced by this Line

SKU

String

50

Yes

Product SKU referenced by this Line

Name

String

256

Yes

Product name referenced by this Line

Location

String

256

Yes

Location to pick the product from

Quantity

Decimal with up to 4 decimal places

Yes

Batch

String

50

Batch or Serial Number picked

ExpiryDate

Date

Date when selected Batch expires

 

Available Fields for PackLine:

Property

Type

Length

Required

Notes

ProductID

Guid

Yes

Unique ID of the product referenced by this Line

SKU

String

50

Yes

Product SKU referenced by this Line

Name

String

256

Yes

Product name referenced by this Line

Location

String

256

Yes

Location to pick the product from

Box

String

256

Yes

Box number/name /barcode used for package

Quantity

Decimal with up to 4 decimal places

Yes

Quantity in the box

Batch

String

50

Batch or Serial Number packed

ExpiryDate

Date

Date when selected Batch expires

WarrantyRegistrationNumberString
NoWarranty number associated with packed goods

 

Available Fields for ShipLine:

Property

Type

Length

Required

Notes

ProductID

Guid

Yes

Unique ID of the product referenced by this Line

ShipmentDate

Date

Date when Shipment was made

Carrier

String

256

Yes

Carrier name doing shipment

Boxes

String

256

Yes

Comma/delimited list of box numbers/names included in the shipment

TrackingNumber

String

256

Tracking number for the shipment

IsShipped

Boolean

Yes

“True” if this shipment has been shipped, “False” otherwise


Available Fields for InvoiceLine:

Property

Type

Length

Required

Notes

ProductID

Guid

Yes

Unique ID of the product referenced by this Line

SKU

String

50

Yes

Product SKU referenced by this Line

Name

String

256

Yes

Product name referenced by this Line

Quantity

Decimal with up to 4 decimal places

Yes

Price

Decimal with up to 4 decimal places

Yes

Price per unit in Customer currency

Discount

Decimal with up to 2 decimal places

Yes

Discount. Value between 0 and 100. For free items discount is 100

Tax

Decimal with up to 4 decimal places

Yes

Calculated Tax value in Customer currency

Total

Decimal with up to 2 decimal places

Yes

Line Total in Customer currency. Can include Tax if Tax Rule for Sale is Tax Inclusive

AverageCost

Decimal with up to 5 decimal places

 

 

Current product Average Cost in base currency

TaxRule

String

50

Yes

Line Tax Rule name

Account

String

50

Yes

Revenue Account code

Comment

String

256

 

 


Available Fields for InvoiceAdditionalCharge and CreditNoteAdditionalCharge:

Property

Type

Length

Required

Notes

Description

String

256

Yes

Additional charge description

Amount

Decimal with up to 4 decimal places

Yes

Charge amount in Customer currency

Discount

Decimal with up to 2 decimal places

Yes

Discount. Value between 0 and 100. For free items discount is 100

Tax

Decimal with up to 4 decimal places

Yes

Calculated Tax value in Customer currency

Total

Decimal with up to 2 decimal places

Yes

Additional Charge line total in Customer currency. Can include Tax if Tax Rule for Sale is Tax Inclusive

TaxRule

String

50

Yes

Additional Charge Tax Rule name

Account

String

50

Yes

Revenue Account code


Available Fields for CreditNoteLine:

Property

Type

Length

Required

Notes

ProductID

Guid

Yes

Unique ID of the product referenced by this Line

SKU

String

50

Yes

Product SKU referenced by this Line

Name

String

256

Yes

Product name referenced by this Line

Quantity

Decimal with up to 4 decimal places

Yes

Price

Decimal with up to 4 decimal places

Yes

Price per unit in Customer currency

Discount

Decimal with up to 2 decimal places

Yes

Discount. Value between 0 and 100. For free items discount is 100

Tax

Decimal with up to 4 decimal places

Yes

Calculated Tax value in Customer currency

Total

Decimal with up to 2 decimal places

Yes

Line Total in Customer currency. Can include Tax if Tax Rule for Sale is Tax Inclusive

TaxRule

String

50

Yes

Line Tax Rule name

Account

String

50

Yes

Revenue Account code

Comment

String

256

 

 

 

Available Fields for AdditionalTransactions:

Property

Type

Length

Required

Notes

Status

String

20

Yes

Additional transactions status. Possible values are “VOIDED”, “DRAFT”, “AUTHORISED”, “NOT AVAILABLE”

Lines

Array of AdditionalTransactionLine

Additional Transaction Lines, see below

 

Available Fields for AdditionalTransactionLine:

Property

Type

Length

Required

Notes

Reference

String

50

Custom reference for the transaction

Debit

String

50

Yes

Transaction Debit account code

Credit

String

50

Yes

Transaction Credit account code

Amount

Decimal with up to 2 decimal places

Yes

Value of the transaction in base currency

Date

Date

Yes

Effective date of the transaction

 

Available Fields for AdditionalAttributes:

Property

Type

Length

Required

Notes

AdditionalAttribute1

String

256

Additional Attribute 1 value

AdditionalAttribute2

String

256

Additional Attribute 2 value

AdditionalAttribute3

String

256

Additional Attribute 3 value

AdditionalAttribute4

String

256

Additional Attribute 4 value

AdditionalAttribute5

String

256

Additional Attribute 5 value

AdditionalAttribute6

String

256

Additional Attribute 6 value

AdditionalAttribute7

String

256

Additional Attribute 7 value

AdditionalAttribute8

String

256

Additional Attribute 8 value

AdditionalAttribute9

String

256

Additional Attribute 9 value

AdditionalAttribute10

String

256

Additional Attribute 10 value

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.