| Name | Type | Cardinality | Label | Required | Help |
|---|
| account |
RecordRef |
0..1 |
Account |
F |
Select the Accounts Receivable account that will be affected by this transaction. </P
Click New to set up a new account.
For details on accounts, go to <_TABNAME=LIST_ACCOUNT_> > <_TASKCATEGORY=LIST_ACCOUNT_> > Chart of Accounts. |
| accountingBookDetailList |
AccountingBookDetailList |
0..1 |
|
|
|
| altHandlingCost |
double |
0..1 |
Handling Cost |
F |
The handling cost automatically calculates depending on the shipping method you select in the Ship Via field.
To change the cost of handling, go to Lists > Shipping Items and select the shipping method with the handling cost you want to change. |
| altShippingCost |
double |
0..1 |
Shipping cost |
F |
The shipping cost automatically calculates depending on the shipping method you select in the Ship Via field above.
To change the cost of a shipping method, go to Lists > Shipping Items and select the shipping method you want to change.
If you use UPS Real-Time rates, shipments over 150lbs are broken up into shipments less than or equal to 150lbs for charging. |
| amountPaid |
double |
0..1 |
|
|
Displays the total amount paid for this invoice. |
| amountRemaining |
double |
0..1 |
|
|
Displays the total amount due for this invoice. |
| approvalStatus |
RecordRef |
0..1 |
Approval Status |
F |
|
| balance |
double |
0..1 |
|
|
Displays the total of all outstanding invoices for this customer. |
| billAddressList |
RecordRef |
0..1 |
|
|
Select the appropriate billing address for this transaction.
* Select New to enter a new billing address to be used for this transaction and saved with the associated entity record.
* Select Custom to enter a new billing address to be used for this transaction only (and not saved with the associated entity record).
* Click the Edit icon to modify an existing billing address. |
| billingAccount |
RecordRef |
0..1 |
Billing Account |
|
|
| billingAddress |
Address |
0..1 |
|
|
|
| billingSchedule |
RecordRef |
0..1 |
|
|
|
| class |
RecordRef |
0..1 |
|
|
|
| contribPct |
string |
0..1 |
|
|
|
| createdDate |
dateTime |
0..1 |
|
|
|
| createdFrom |
RecordRef |
0..1 |
Created From |
F |
This field shows the sales order this invoice is created from.
Click the link to open the sales order. |
| currency |
RecordRef |
0..1 |
Currency |
T |
If you do not use the Multi-Currency Customers feature, the currency of the customer you are creating this transaction for is shown here.
If you use the Multi-Currency Customers feature, select the transaction currency you want to create this transaction in. This customer's primary currency is selected by default.
If you have already selected items on this transaction, selecting a new currency refreshes them to show the price in the new currency (except for items you entered custom prices for) and recalculates tax and gross profit. |
| currencyName |
string |
0..1 |
Currency |
F |
This customer's currency is shown in this field.
All currency amounts on this transaction are shown in this currency. |
| customFieldList |
CustomFieldList |
0..1 |
|
|
|
| customForm |
RecordRef |
0..1 |
Custom Form |
T |
If you customized an invoice form, select it here, or click New to customize a new invoice form. |
| deferredRevenue |
double |
0..1 |
|
|
Deferred Revenue:
amount of revenue deferred on this transaction |
| department |
RecordRef |
0..1 |
|
|
|
| discountAmount |
double |
0..1 |
|
|
The amount listed here is the discount your customer will receive if he or she pays this invoice according to the terms you have set. |
| discountDate |
dateTime |
0..1 |
|
|
The date listed here is the date your customer must pay this invoice by in order to receive a discount. The discount your customer receives in based on the terms you have set for the customer. |
| discountItem |
RecordRef |
0..1 |
Discount |
F |
You can select a discount for this invoice. NetSuite fills the Rate and Discount Total fields based on the discount you choose.
Leave this field blank if you do not want to apply a discount to this transaction.
To create new discount items, go to <_TABNAME=LIST_ITEM_> > <_TASKCATEGORY=LIST_ITEM_> Items and click New. On the New Item page, click Discount. |
| discountRate |
string |
0..1 |
Rate |
F |
NetSuite enters the rate for the discount item you selected. You can change the discount rate for this cash refund.
Enter the discount as a dollar amount like 10.00, or as a percentage like 10%. |
| discountTotal |
double |
0..1 |
Discount Total |
F |
NetSuite enters the amount discounted on this invoice.
If this discount item is taxable, the discount is applied before taxes. If it is not taxable, the discount is applied after taxes. |
| dueDate |
dateTime |
0..1 |
|
|
Type or pick the due date for this invoice. If you do not assign a due date, this invoice will not appear on aging reports. |
| email |
string |
0..1 |
|
|
|
| endDate |
dateTime |
0..1 |
|
|
Type or pick the end date for this invoice.
If an invoice is created from a sales order that includes a Start Date and End Date, those dates autofill on the invoice when the order is billed. |
| entity |
RecordRef |
0..1 |
|
|
Select the customer for this invoice.
Click New to set up a new customer.
Go to <_TABNAME=LIST_CUSTJOB_> > <_TASKCATEGORY=LIST_CUSTJOB_> > Customers for details about existing customers. |
| estGrossProfit |
double |
0..1 |
|
|
Estimated Gross Profit: Read-only field that equals the revenue amount minus the Est. Cost. At the transaction level, it equals the gross profit of all lines, factoring transaction-level discounts and markups. |
| estGrossProfitPercent |
double |
0..1 |
|
|
Estimated Gross Profit Margin, as a percentage: Read-only field that equals the Est. Gross Profit divided by revenue, expressed as a percentage. At the transaction level, it equals the gross profit percent of all lines, factoring transaction-level discounts and markups. |
| exchangeRate |
double |
0..1 |
Exchange Rate |
T |
The currency's exchange rate is shown in this field.
You can edit the exchange rate for this transaction only, or you can update the currency record with the exchange rate you enter here. |
| excludeCommission |
boolean |
0..1 |
Exclude Commissions |
F |
Check this option to exclude this transaction and its subordinate transactions from inclusion in all commission calculations. |
| expCostDiscAmount |
double |
0..1 |
|
|
The rate you enter automatically appears here.
If you entered a percentage in the Rate field, NetSuite multiplies the discount or markup percentage by the total amount of line items you select. |
| expCostDiscount |
RecordRef |
0..1 |
|
|
If you want to add a discount or markup to the cost of the expenses you are billing, select it from the list.
To see a list of your discounts or markups, go to Lists > Items and select Discount or Markup from the dropdown list at the bottom of the page.
To create a new discount or markup, go to Lists > New Item and click Discount or Markup. |
| expCostDiscPrint |
boolean |
0..1 |
|
|
Check this box if you added a discount or markup and want to print it on the invoice. |
| expCostDiscRate |
string |
0..1 |
|
|
The rate for the discount or markup item you selected automatically appears here.
If you want, enter a new rate.
Rates can be entered as dollar amounts and percentages. |
| expCostDiscTax1Amt |
double |
0..1 |
|
|
|
| expCostDiscTaxable |
boolean |
0..1 |
|
|
Check this box if the expenses you are billing are taxable. |
| expCostList |
InvoiceExpCostList |
0..1 |
|
|
|
| expCostTaxCode |
RecordRef |
0..1 |
|
|
|
| expCostTaxRate1 |
double |
0..1 |
|
|
NetSuite inserts the GST rate based on the tax code you assigned to this expense.
To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes.
To change the assignment of a tax code to an item, go to Lists > Items. |
| expCostTaxRate2 |
double |
0..1 |
|
|
NetSuite inserts the PST rate based on the tax code you assigned to this expense.
To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes.
To change the assignment of a tax code to an item, go to Lists > Items. |
| fax |
string |
0..1 |
|
|
|
| fob |
string |
0..1 |
|
|
Enter the location where the customers technically acquire ownership. For example, if your customers own goods as soon as they ship and pay the shipping costs from your location to theirs, you might enter Our warehouse. |
| giftCertApplied |
double |
0..1 |
|
|
|
| giftCertRedemptionList |
GiftCertRedemptionList |
0..1 |
|
|
|
| handlingCost |
double |
0..1 |
Handling Cost |
F |
The handling cost automatically calculates depending on the shipping method you select in the Ship Via field.
To change the cost of handling, go to <_TABNAME=LIST_SHIPITEM_> > <_TASKCATEGORY=LIST_SHIPITEM_> > Shipping Items and select the shipping method with the handling cost you want to change. |
| handlingTax1Rate |
double |
0..1 |
Tax Rate |
F |
The tax rate for the tax code selected shows here. |
| handlingTax2Rate |
string |
0..1 |
Tax Rate |
F |
|
| handlingTaxCode |
RecordRef |
0..1 |
Handling Tax Code |
F |
Select the tax code that determines the tax for handling charges. |
| isTaxable |
boolean |
0..1 |
Taxable |
F |
|
| itemCostDiscAmount |
double |
0..1 |
|
|
The rate you enter automatically appears here.
If you entered a percentage in the Rate field, NetSuite multiplies the discount or markup percentage by the total amount of line items you select. |
| itemCostDiscount |
RecordRef |
0..1 |
|
|
If you want to add a discount or markup to the cost of the items you are billing, select it from the list.
To see a list of your discounts or markups, go to Lists > Items and select Discount or Markup from the dropdown list at the bottom of the page.
To create a new discount or markup, go to Lists > New Item and click Discount or Markup. |
| itemCostDiscPrint |
boolean |
0..1 |
|
|
Check this box if you added a discount or markup and want to print it on the invoice. |
| itemCostDiscRate |
string |
0..1 |
|
|
The rate for the discount or markup item you selected automatically appears here.
If you want, enter a new rate.
Rates can be entered as dollar amounts and percentages. |
| itemCostDiscTax1Amt |
double |
0..1 |
|
|
|
| itemCostDiscTaxable |
boolean |
0..1 |
|
|
Check this box if you want the discount or markup you entered to be applied before taxes. |
| itemCostList |
InvoiceItemCostList |
0..1 |
|
|
|
| itemCostTaxCode |
RecordRef |
0..1 |
|
|
|
| itemCostTaxRate1 |
double |
0..1 |
|
|
NetSuite inserts the GST rate based on the tax code you assigned to this item.
To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes.
To change the assignment of a tax code to an item, go to Lists > Items. |
| itemCostTaxRate2 |
double |
0..1 |
|
|
NetSuite inserts the PST rate based on the tax code you assigned to this item.
To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes.
To change the assignment of a tax code to an item, go to Lists > Items. |
| itemList |
InvoiceItemList |
0..1 |
|
|
|
| job |
RecordRef |
0..1 |
|
|
|
| lastModifiedDate |
dateTime |
0..1 |
|
|
|
| leadSource |
RecordRef |
0..1 |
Lead Source |
F |
Select the lead source associated with this transaction.
If you use the Marketing Automation feature, select the campaign you want to associate with this transaction's revenue. |
| linkedTrackingNumbers |
string |
0..1 |
Tracking Numbers |
F |
|
| location |
RecordRef |
0..1 |
|
|
|
| memo |
string |
0..1 |
|
|
|
| message |
string |
0..1 |
|
|
The text of the customer message you select in the Select Message field appears here.
You can edit the message or enter a new customer message for only this transaction. |
| messageSel |
RecordRef |
0..1 |
Select Message |
F |
Select a customer message to appear on this form. For example, you may add "Thank you for your business!" Choose from the list of existing customer messages stored in Accounting Lists.
The text of the selected message appears in the Customer Message field. In this field, you can optionally edit the message or enter a new customer message for only this transaction.
To add messages to appear in the Select Message field, go to <_TABNAME=LIST_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY=LIST_ACCOUNTINGOTHERLIST_> > Accounting Lists > New, and click Customer Message. |
| nextApprover |
RecordRef |
0..1 |
|
|
|
| onCreditHold |
string |
0..1 |
|
|
|
| opportunity |
RecordRef |
0..1 |
Opportunity |
F |
If you are entering this transaction for an opportunity, select the opportunity.
You can create opportunity records at <_TABNAME=EDIT_TRAN_OPPRTNTY_> > <_TASKCATEGORY=TRAN_OPPRTNTY_> > Create Opportunities. |
| otherRefNum |
string |
0..1 |
|
|
To make it easy for your customers to locate this invoice in their own records, enter their purchase order number here. |
| partner |
RecordRef |
0..1 |
Partner |
F |
The partner associated with this customer appears in the Partner field.
You can change the partner for this transaction. |
| partnersList |
InvoicePartnersList |
0..1 |
|
|
|
| postingPeriod |
RecordRef |
0..1 |
Posting Period |
T |
Select the period you want to post this invoice to.
If a period is closed, you cannot post to that period. |
| promoCode |
RecordRef |
0..1 |
|
|
If you want to apply a multiple-use coupon code to this transaction, select the promotion here.
If you want to apply a single-use coupon code, enter the code in the Coupon Code field. The promotion for that coupon code is shown here.
Customers associated with a partner can only use coupon codes from that partner's promotions. If you select a promotion associated with a partner, this transaction is attributed to that partner for reporting purposes.
You can choose to have a promotion selected by default at <_TABNAME=TRAN_CAMPAIGNSETUP_> > <_TASKCATEGORY=TRAN_CAMPAIGNSETUP_> > Marketing Preferences in the Default Promotion Code on Sales Transactions field.
Create new promotion codes at <_TABNAME=LIST_REFERRALCODE_> > <_TASKCATEGORY=LIST_REFERRALCODE_> > Promotions > New. |
| promotionsList |
PromotionsList |
0..1 |
|
|
|
| recognizedRevenue |
double |
0..1 |
|
|
Recognized Revenue:
cumulative amount of revenue recognized for this transaction |
| recurringBill |
boolean |
0..1 |
|
|
|
| revenueStatus |
RevenueStatus |
0..1 |
|
|
The possible values for this field are:
1. Pending: indicates that no recognition has occurred. All revenue is still deferred.
2. In Progress: indicates that some recognition has occurred.
3. Completed: indicates that all recognition has occurred. No deferred revenue remains. |
| revRecEndDate |
dateTime |
0..1 |
Rev. Rec. End Date |
F |
|
| revRecOnRevCommitment |
boolean |
0..1 |
|
|
Check this check box to create a Revenue Commitment or Revenue Commitment Reversal.
* On a Sales Order, the Revenue Commitment replaces an invoice
* On a Return Authorization, the Revenue Commitment Reversal replaces a credit memo.
NetSuite creates all applicable Revenue Recognition schedules the Revenue Commitment or Revenue Commitment Reversal. |
| revRecSchedule |
RecordRef |
0..1 |
Rev. Rec. Schedule |
F |
|
| revRecStartDate |
dateTime |
0..1 |
Rev. Rec. Start Date |
F |
|
| salesEffectiveDate |
dateTime |
0..1 |
Sales Effective Date |
F |
You can change the sales effective date for this transaction. The sales effective date determines which commission plan and historical sales team this transaction applies to. |
| salesGroup |
RecordRef |
0..1 |
Choose Team |
F |
Select a sales team to associate with this transaction.
To create a sales team, go to <_TABNAME=EDIT_CRMGROUP_> > <_TASKCATEGORY=EDIT_CRMGROUP_> > New > Select Sales Team Members. |
| salesRep |
RecordRef |
0..1 |
Sales Rep |
F |
NetSuite inserts the sales representative associated with this company on the customer record at Lists > Customers.
If a different sales rep is assigned to this transaction, select that sales rep here.
To add additional sales reps to this list, go to Lists > New Employee. |
| salesTeamList |
InvoiceSalesTeamList |
0..1 |
|
|
|
| shipAddressList |
RecordRef |
0..1 |
|
|
Select the appropriate shipping address for this transaction.
* Select New to enter a new shipping address to be used for this transaction and saved with the associated entity record.
* Select Custom to enter a new shipping address to be used for this transaction only (and not saved with the associated entity record).
* Click the Edit icon to edit an existing shipping address. |
| shipDate |
dateTime |
0..1 |
|
|
Type or pick a shipping date for this invoice. |
| shipGroupList |
InvoiceShipGroupList |
0..1 |
|
|
|
| shipIsResidential |
boolean |
0..1 |
Shipping address is residential |
F |
|
| shipMethod |
RecordRef |
0..1 |
|
|
Select a shipping method for this order.
If you automatically charge for shipping, the shipping amount is entered in the shipping costs field. To automatically charge for shipping, go to <_TABNAME=ADMI_SHIPPING_> > <_TASKCATEGORY=ADMI_SHIPPING_> > Shipping. Check the Charge for Shipping box and click Save. You must also set up the charge details of your shipping items.
To add or edit shipping items, go to <_TABNAME=LIST_SHIPITEM_> > <_TASKCATEGORY=LIST_SHIPITEM_> > Shipping Items. |
| shippingAddress |
Address |
0..1 |
|
|
|
| shippingCost |
double |
0..1 |
Shipping cost |
F |
The shipping cost automatically calculates depending on the shipping method you select in the Ship Via field above.
To change the cost of a shipping method, go to <_TABNAME=LIST_SHIPITEM_> > <_TASKCATEGORY=LIST_SHIPITEM_> > Shipping Items and select the shipping method you want to change.
If you use UPS Real-Time rates, shipments over 150lbs are broken up into shipments less than or equal to 150lbs for charging. |
| shippingTax1Rate |
double |
0..1 |
Tax Rate |
F |
The tax rate for the selected tax code shows here. |
| shippingTax2Rate |
string |
0..1 |
Tax Rate |
F |
|
| shippingTaxCode |
RecordRef |
0..1 |
Shipping Tax Code |
F |
Select the tax code that determines the tax charged for shipping. |
| source |
string |
0..1 |
Source |
F |
|
| startDate |
dateTime |
0..1 |
|
|
If you use the Advanced Billing feature, enter the date for the first invoice to be created.
If an invoice is created from a sales order that includes a Start Date and End Date, those dates autofill on the invoice when the order is billed. |
| status |
string |
0..1 |
Status |
F |
|
| subsidiary |
RecordRef |
0..1 |
|
|
This field displays the subsidiary associated with this transaction. |
| subTotal |
double |
0..1 |
|
|
This field shows the total of the items on this invoice.
This is the total before any discounts, shipping cost, handling cost or tax is added to the order. |
| syncPartnerTeams |
boolean |
0..1 |
|
|
Check this box if you want to update the sales team on the customer's record with changes you make here. |
| syncSalesTeams |
boolean |
0..1 |
|
|
Check this box if you want to update the sales team on the customer's record with changes you make here. |
| tax2Total |
double |
0..1 |
PST |
F |
NetSuite multiplies the tax rate by the taxable total of line items and enters it here. |
| taxItem |
RecordRef |
0..1 |
Tax Code |
|
A tax item is a tax that you collect at one certain rate and pay to one tax agency for this invoice. NetSuite inserts the tax item for this customer from the record at Lists > Customers. To change it just for this order, select another tax item.
To add additional choices to this list, go to Lists > New Item > Sales Tax Item. |
| taxRate |
double |
0..1 |
|
|
NetSuite inserts the percentage rate of the tax item from its record at Lists > Items. You can change it here for just this transaction if you wish. |
| taxTotal |
double |
0..1 |
Tax |
F |
NetSuite multiplies the tax rate by the taxable total of line items and enters it here. |
| terms |
RecordRef |
0..1 |
|
|
Select discount terms that will apply to this invoice.
To add additional choices to this list, go to <_TABNAME=LIST_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY=LIST_ACCOUNTINGOTHERLIST_> > Accounting Lists > New > Terms. |
| timeDiscAmount |
double |
0..1 |
|
|
The rate you enter automatically appears here.
If you entered a percentage in the Rate field, NetSuite multiplies the discount or markup percentage by the total amount of line items you select. |
| timeDiscount |
RecordRef |
0..1 |
|
|
If you want to add a discount or markup to the cost of the time you are billing, select it from the list.
To see a list of your discounts or markups, go to Lists > Items and select Discount or Markup from the dropdown list at the bottom of the page.
To create a new discount or markup, go to Lists > New Item and click Discount or Markup. |
| timeDiscPrint |
boolean |
0..1 |
|
|
Check this box if you added a discount or markup and want to print it on the invoice. |
| timeDiscRate |
string |
0..1 |
|
|
The rate for the discount or markup item you selected automatically appears here.
If you want, enter a new rate.
Rates can be entered as dollar amounts and percentages. |
| timeDiscTax1Amt |
double |
0..1 |
|
|
|
| timeDiscTaxable |
boolean |
0..1 |
|
|
Check this box if you want the discount or markup you entered to be applied before taxes. |
| timeList |
InvoiceTimeList |
0..1 |
|
|
|
| timeTaxCode |
RecordRef |
0..1 |
|
|
|
| timeTaxRate1 |
double |
0..1 |
|
|
NetSuite inserts the GST rate based on the tax code you assigned to this time.
To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes.
To change the assignment of a tax code to an item, go to Lists > Items. |
| timeTaxRate2 |
double |
0..1 |
|
|
NetSuite inserts the PST rate based on the tax code you assigned to this time.
To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes.
To change the assignment of a tax code to an item, go to Lists > Items. |
| toBeEmailed |
boolean |
0..1 |
To Be Emailed |
F |
When processing individual invoices:
* Check the To Be Emailed box if you want to email this invoice. Then enter the email address in the space to the right of the check box.
* You can enter multiple email addresses by separating them with a semicolon. It is important to separate the addresses with only a semicolon, and do not include any spaces.
When bulk processing invoices:
In the To Be Emailed field:
* Select Yes if you want to email this form.
* Select No if you do not want to email this form.
* Select Respect Customer Preference to send the form based on the default preference on the customer record. Set the preference on the Info subtab of a customer record in the Send Transactions Via field. |
| toBeFaxed |
boolean |
0..1 |
To Be Faxed |
F |
When processing individual invoices:
* Check the To Be Faxed box if you want to fax this invoice. Then enter the fax number in the box to the right of the check box if it does not already appear.
When bulk processing invoices:
In the To Be Faxed field:
* Select Yes if you want to fax this form.
* Select No if you do not want to fax this form.
* Select Respect Customer Preference to send the form based on the default preference on the customer record.
Set the preference on the Info subtab of a customer record in the Send Transactions Via field.
To fax NetSuite forms, an administrator must first set up fax service at <_TABNAME=ADMI_PRINTING_> > <_TASKCATEGORY=ADMI_PRINTING_> > Printing, Fax and Email Preferences. |
| toBePrinted |
boolean |
0..1 |
To Be Printed |
F |
When processing individual invoices:
Check the To Be Printed box if you want to print this invoice.
When bulk processing invoices:
* Select Yes if you want to save this in a queue of invoices to print.
* Select No if you do not want to print this form.
* Select Respect Customer Preference to send the form based on the default preference on the customer record.
Set the preference on the Info subtab of a customer record in the Send Transactions Via field. |
| total |
double |
0..1 |
|
|
NetSuite computes the total of line items, tax and shipping costs, and then enters it here. |
| totalCostEstimate |
double |
0..1 |
|
|
Estimated Cost: Estimated cost of the specific number of items; estimated rate x quantity = estimated cost. |
| trackingNumbers |
string |
0..1 |
Tracking Numbers |
F |
Enter the shipment tracking number from the shipping company.
If a tracking number is entered in the exact format used by UPS or FedEx and the transaction is saved, the tracking number will show on the transaction as a link to the UPS or FedEx website. You can click the link to check the status of the shipment. |
| tranDate |
dateTime |
0..1 |
|
|
NetSuite inserts today's date for the posting date of this invoice. You can type or pick another date.
What you enter here determines the date range in which this transaction appears on the Accounts Receivable Register.
You can select or enter custom date ranges on registers. |
| tranId |
string |
0..1 |
|
|
NetSuite increases the largest invoice number by one. You can type another number. The next invoice number will revert to the standard pattern. |
| tranIsVsoeBundle |
boolean |
0..1 |
Transaction Is VSOE Bundle |
F |
Check this box to include all items added to this transaction as a VSOE bundle. |
| vatRegNum |
string |
0..1 |
|
|
|
| vsoeAutoCalc |
boolean |
0..1 |
Auto Calculate VSOE Allocation |
F |
The VSOE allocation amount for a sale can be calculated automatically by checking the Auto Calculate VSOE Allocation box.
Allocation is the process to determine the VSOE price for items on a sale. The total VSOE amount allocated is the revenue amount to be recognized for the bundle. |