Cash Sale
The cash sale record exposes a cash sale to REST web services.
To access this record in NetSuite, go to Transactions > Sales > Enter Cash Sales.
For information about the cash sale record user interface, see Cash Sales.
This record has the following subrecords:
-
Accounting Books (accountingbookdetail)
-
Applied Rules (appliedrules)
-
Billable Expenses (expcost)
-
Billable Items (itemcost)
-
Billable Time (time)
-
Gift Certificate Redemption (giftcertredemption)
-
Item Line Address (iladdrbook)
-
Item (item)
-
Partner (partner)
-
Promotions (promotions)
-
Sales Team (salesteam)
-
Shipment (shipgroup)
-
Taxes (taxdetails)
The REST API Browser includes information about the field names and field types of the cash sale record, and about the HTTP methods, request parameters, and operations available to this record. For details, see the REST API Browser's cash sale reference page.
For information about using the REST API Browser, see The REST API Browser.
This record has fields related to taxation features. Refer to the following table for details:
|
Tax Feature |
ID |
Label |
Type |
|---|---|---|---|
|
TAX_OVERHAULING |
entitytaxregnum |
Customer Tax Reg. Number |
SELECT |
|
basehandlingtaxamount |
Handling Tax Amount |
CURRENCY |
|
|
handlingtaxamount |
Handling Tax Amount |
CURRENCY |
|
|
legacytax |
Legacy Tax |
CHECKBOX |
|
|
baseshippingtaxamount |
Shipping Tax Amount |
CURRENCY |
|
|
shippingtaxamount |
Shipping Tax Amount |
CURRENCY |
|
|
subsidiarytaxregnum |
Subsidiary Tax Reg. Number |
SELECT |
|
|
taxdetailsoverride |
Tax Details Override |
CHECKBOX |
|
|
taxpointdate |
Tax Point Date |
DATE |
|
|
taxpointdateoverride |
Tax Point Date Override |
CHECKBOX |
|
|
taxregoverride |
Tax Registration Override |
CHECKBOX |
|
|
taxdetails |
Taxes |
SUBLIST |
|
|
totalaftertaxes |
Total After Taxes |
CURRENCY |
|
|
NOTTAX_OVERHAULING |
handlingtaxcode |
Handling Tax Code |
SELECT |
|
expcosttaxrate2 |
PST |
PERCENT |
|
|
itemcosttaxrate2 |
PST |
PERCENT |
|
|
tax2total |
PST |
CURRENCY |
|
|
timetaxrate2 |
PST |
PERCENT |
|
|
shippingtaxcode |
Shipping Tax Code |
SELECT |
|
|
expcostdisctax1amt |
Tax Amt |
CURRENCY |
|
|
itemcostdisctax1amt |
Tax Amt |
CURRENCY |
|
|
timedisctax1amt |
Tax Amt |
CURRENCY |
|
|
expcosttaxcode |
Tax Code |
SELECT |
|
|
itemcosttaxcode |
Tax Code |
SELECT |
|
|
timetaxcode |
Tax Code |
SELECT |
|
|
taxitem |
Tax Item |
SELECT |
|
|
expcosttaxrate1 |
Tax Rate |
PERCENT |
|
|
handlingtax1rate |
Tax Rate |
RATE |
|
|
handlingtax2rate |
Tax Rate |
RATE |
|
|
itemcosttaxrate1 |
Tax Rate |
PERCENT |
|
|
shippingtax1rate |
Tax Rate |
RATE |
|
|
shippingtax2rate |
Tax Rate |
RATE |
|
|
taxrate |
Tax Rate |
FLOAT |
|
|
timetaxrate1 |
Tax Rate |
PERCENT |
|
|
expcostdisctaxable |
Taxable |
CHECKBOX |
|
|
istaxable |
Taxable |
CHECKBOX |
|
|
itemcostdisctaxable |
Taxable |
CHECKBOX |
|
|
timedisctaxable |
Taxable |
CHECKBOX |
|
|
vatregnum |
VAT Registration |
TEXT |
To view the complete list of fields, go to Cash Sale in the SuiteScript Records Browser.
REST web services do not support legacy tax features. To work with taxation through REST web services, you must have the SuiteTax feature enabled. For more information about using SuiteTax, see SuiteTax.
Record ID
The record ID for a cash sale REST record is cashsale.
Prerequisites
Before you can use this record through REST web services, you must first enable the Accounts Receivable feature. Go to Setup > Company > Setup Tasks > Enable Features. On the Accounting subtab, check the A/R box, and then click Save.
Usage Notes
To use the Choose Team and Update Customer fields in the Sales Team subtab, an administrator must first enable the Team Selling feature. Go to Setup > Company > Enable Features. Select the CRM subtab. Under Sales, check the Team Selling box, and then click Save.
To use the Update Customer field in the Relationships subtab, an administrator must first enable the Multi-Partner Management feature. Go to Setup > Company > Setup Tasks > Enable Features. Select the CRM subtab. Under Partners, check the Multi-Partner Management box, and then click Save.
Code Samples
These samples show common use cases for cash sales.
In the following examples,
-
<accountID> represents your account ID.
-
<recordKey> represents the database key for the invoice.
Create a Cash Sale with an Item
POST: https://demo123.suitetalk.api.netsuite.com/services/rest/record/v1/cashsale { "asofdate": "2021-03-15", "enddate": "2021-06-15", "entity": { "id": "217" }, "item": { "items": [ { "amount": 1000, "item": { "id": "143" } } ] }, "startdate": "2021-03-15"
}
Create a Cash Sale with a Billable Item
POST: https://demo123.suitetalk.api.netsuite.com/services/rest/record/v1/cashsale { "asofdate": "2021-03-15", "entity": { "id": "218" }, "itemcost": { "items": [ { "apply": true, "doc": { "id": "305" }, "line": 1 } ] }
}
Create a Cash Sale with a Billable Expense
POST: https://demo123.suitetalk.api.netsuite.com/services/rest/record/v1/cashsale { "entity": { "id": "217" }, "expcost": { "items": [ { "apply": true, "doc": { "id": "303" }, "line": 1 } ] }
}
Update a Cash Sale
You can update fields under Primary Information, such as start date and end date, as well as line-item fields, such as quantity.
PATCH: https://demo123.suitetalk.api.netsuite.com/services/rest/record/v1/cashsale/<recordKey> { "item": { "items": [ { "line": 1, "quantity": 5 } ] }, "startDate": "2021-03-05", "endDate": "2021-04-05"
}
Update a Cash Sale with a Line Item
PATCH {{REST_SERVICES}}/record/v1/cashsale/{id}
{
"tranDate": "2026-01-20",
"tranId": "Updated Cash Sale ID",
"item": {
"items": [
{
"item": {
"id": "7"
},
"line": 1, // including line field will update the existing line at this index, excluding will add a new line
"quantity": 1.0
}
]
}
}
Set the Sales Order's Sales Team Members to Match Sales Group 164
"salesGroup": {
"id": 164 }
Update the Customer's Partner Team to Match the Transaction Partners
"syncPartnerTeams": true
Update the Customer's Sales Team to Match the Transaction Sales Team
"syncSalesTeams": true