Vendor Bill

Internal ID: vendorbill

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
account select false Account false Select the Accounts Payable account that will be affected by this transaction. Click New to set up a new account. For details on accounts, go to Setup > Accounting > Manage G/L > Chart of Accounts.
approvalstatus select false Approval Status false The approval status of this bill shows in this field. Accept the default status or choose one of the following: * Approved – No further review or processing is required before a payment is processed. * Pending Approval – Someone with permission must approve the bill before a payment can be processed for it.
availablevendorcredit currency false Available Vendor Credit false The Available Vendor Credit field displays the remaining credit available to this vendor before a payment is received. It is converted from vendor’s primary currency into the transaction currency. The field value is available only in edit mode. This field is visible after you customize the vendor bill. To display this field, enable accounts payable preferences: 1. Go to Setup >Accounting > Preferences > Accounting Preferences. 2. In the Accounts Payable section, check the Vendor Credit Limit Warnings and Vendor Credit Limit Includes Orders boxes. 3. Click Save. 4. In the vendor bill Customize menu, click Customize Form. 5. In the Screen Fields subtab, beside Available Vendor Credit, check the Show box. 6. Click Save. If the transaction exceeds the vendor’s credit limit, a warning message appears displaying the exceeded credit amount. The message does not prevent you from saving the transaction.
balance text false false
billaddresslist select false Vendor Select false In the Vendor Select field, choose a vendor. Verify the billing address displayed in the Vendor field.
billingaddress summary false false
class select false Class false If you wish, select the class that applies to this item. Click —New— to set up a new class. Go to Lists > Classes for details about existing classes.
createddate datetime false false
creditlimit currency false Credit Limit false The credit limit you entered for your purchases from this vendor will appear here. To enter or change a credit limit, go to Lists > Relationships > Vendors. On the vendor record's Financial tab, enter the credit limit. NetSuite will warn you when you meet or exceed this vendor's limit while you are entering orders if you go to Home > Set Preferences and check the Credit Limit Warnings box.
currency select false Currency true The transaction currency for this bill is shown here. If this bill was created from a purchase order, the currency on the originating purchase order is shown, and you cannot change the currency on the bill.
currencyname text false Currency false This vendor's currency is shown in this field. All currency amounts on this transaction are shown in this currency.
currencysymbol text false Currency Symbol false
customform select false Custom Form true Select the appropriate standard or custom form to use.
department select false Department false Select a department to associate with this transaction. To create a new department, select New. For details on existing departments, go to Setup > Company > Departments.
discountamount currency false Disc. Amt. false NetSuite enters the amount discounted on this bill. This discount is based on the purchase order terms. For example, if terms are set as 2%-10, Net 30 and the bill is paid within 10 days, a 2% discount is applied. If this discount item is taxable, the discount is applied before taxes. If it is not taxable, the discount is applied after taxes.
discountdate date false Disc. Date false If your vendor offers discounts for early payments on bills, a calculated date based on the terms of the bill automatically shows up in this field. This date is the last day you can pay this bill in order to receive a discount.
documentstatus text false false
duedate date false Due Date false NetSuite inserts today's date. You can type or pick another date. If you do not assign a due date, this bill will not appear on aging reports.
entity select false Vendor true Select the vendor for this purchase. Click New to set up a new vendor. Go to Lists > Relationships > Vendors for details about existing vendors. Note: If you use NetSuite OneWorld, the Subsidiary field defaults to the primary subsidiary assigned to the selected vendor. If the selected vendor has been shared with multiple secondary subsidiaries, you can select the secondary subsidiary to associate with this bill.
entitynexus select false Nexus false
entitytaxregnum select Tax Reg. Number false The tax registration number for this entity displays here.
exchangerate currency2 false Exchange Rate true 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.
externalid text false ExternalId false
isbasecurrency checkbox false Base Currency false
landedcostperline checkbox false Landed Cost per Line false Check this box to enter a landed cost per line item.
lastmodifieddate datetime false false
location select false Location true Select a location to associate with this line item. Select New to create a new location record. Go to Lists > Locations for details about existing locations.
memo text true Memo false Enter a memo that will appear on such reports as the 2-line Accounts Payable Register.
nextapprover select false Next Approver false This field displays the next person set to approve this bill via approval routing.
nexus select false Nexus false This field shows the nexus of the transaction. NetSuite automatically populates this field based on the nexus lookup logic. You can override the transaction nexus and tax registration number that NetSuite automatically selects by checking the Nexus Override box. When you select a different nexus in the dropdown list, the corresponding tax registration number is automatically selected in the Subsidiary Tax Reg. Number field.
overrideinstallments checkbox false Override Installments false Check this box to override the default calculated installment amounts and enter custom ones. Note that you must ensure that custom installment amounts must add up to the total amount due.
paymenthold checkbox false Payment Hold false Check the Payment Hold box to apply a payment hold on a disputed bill: * The Make Payment button does not appear on the vendor bill and a vendor payment for that bill cannot be processed. * Vendor bills subject to a payment hold do not appear on the bill payments page. * The Electronic Payment SuiteApp does not process payments that are subject to a payment hold.
postingperiod select false Posting Period true Select the period to which you want to post this transaction. You cannot post to a closed period. If your transaction is subject to approval, the posting period is set when the transaction is approved. For details, see the help topic Approval Routing, subsection Posting Period for Transactions Subject to Approval.
received text false Received Bill false Place a check mark in this box if you have received a bill for this order. If you have received all the items on your order but have not checked this box, this transaction will now appear in your open bills report with no due date.
status text false Status false
statusRef text false false
subsidiary select false Subsidiary false Enter the subsidiary you want to associate with this transaction.
subsidiarytaxregnum select Tax Reg. Number false This field shows the tax registration number of the transaction nexus. NetSuite automatically populates this field based on the nexus lookup logic. You can override the transaction nexus and tax registration number that NetSuite automatically selects by checking the Nexus Override box. When you select a different tax registration number in the dropdown list, the corresponding nexus is automatically selected in the Nexus field.
taxdetailsoverride checkbox Tax Details Override false Check this box to override the tax information on the Tax Details subtab of the transaction. Only roles with at least the Edit level of the Tax Details Tab permission can override the tax details.
taxpointdate date false Tax Point Date false Tax point date is a legal requirement in many countries. It is the date of the transaction that determines the taxability. It may be different from the transaction date that determines the GL impact. Specific rules consider the reporting of transactions based on tax point date and other factors.
taxpointdateoverride checkbox false Override false Check this box to change the tax point date.
taxregoverride checkbox Tax Registration Override false Check this box to override the values in the Nexus and Subsidiary Tax Reg. Number fields. Only roles with at least the Edit level of the Tax Details Tab permission can override the values that NetSuite automatically selects in these fields.
terms select false Terms false Select discount terms or payment terms that apply to this bill. To add additional choices to this list, go to <_TABNAME=LIST_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY=LIST_ACCOUNTINGOTHERLIST_> > Accounting Lists > Terms.
total currency false Amount false
trandate date false Date true NetSuite inserts today's date for the posting date of this bill. You can type or pick another date. What you enter here determines the date range in which this transaction appears on the Accounts Payable Register. You can select or enter custom date ranges on registers.
tranid text false Reference No. false Enter up to 45 characters to identify this transaction, such as the vendor's invoice number. This reference appears on reports such as the Accounts Payable Register. Note: The maximum number of characters you can enter in this field is 45.
transactionnumber text false Transaction Number false By default, transaction lists display only the Number field in searches and reporting. If you plan to include the new Transaction Number field, be aware that this value will be the different from the value in the Number field for the twelve transaction types available through Version 2014 Release 1. For the transaction types available through previous releases, these two values will be the same. Note: The Transaction Number field is visible by default on standard NetSuite forms and invisible by default on customized forms. You can customize a form to display this field.
unbilledorders text false false
usertotal currency false Amount false You can enter the dollar amount of the bill, but NetSuite will update this amount as you add or edit line items.

Sublists

accountingbookdetail - Accounting Books

Internal ID Type Label Required Help
accountingbook select Secondary Book false
exchangerate currency2 Exchange Rate true

expense - Expenses

Internal ID Type Label Required Help
account select Account true Select the Accounts Payable account that will be affected by this transaction. Click —New — to set up a new account.
amortizationenddate date Amort. End false
amortizationresidual rate Residual false
amortizationsched select Amort. Schedule false
amortizationtype text false
amortizstartdate date Amort. Start false
amount currency Amount true
category select Category false
class select Class false If you wish, select the class that applies to this item. Click —New— to set up a new class. Go to Lists > Classes for details about existing classes.
customer select Customer false
department select Department false If you like, select a department. Click New to enter a new department. Go to Lists > Departments for details about existing departments.
grossamt currency Gross Amt false
isbillable checkbox Billable false
line text false
location select Location false Select a location to associate with this line item. Select New to create a new location record. Go to Lists > Locations for details about existing locations.
memo text Memo false Enter a memo that will appear on such reports as the 2-line Accounts Payable Register.
orderdoc text false
orderline text false
projecttask select Project Task false
scheduletype text false

installment - Installments

Internal ID Type Label Required Help
amount poscurrency Amount true
amountdue currency Amount Due false
duedate date Due Date true
seqnum integer Installment Number false
status text Status false

item - Items

Internal ID Type Label Required Help
amortizationenddate date Amort. End false
amortizationresidual rate Residual false
amortizationsched select Amort. Schedule false
amortizationtype text false
amortizstartdate date Amort. Start false
amount currency Amount false
billreceipts select Receipts false
billvariancestatus text false
catchupperiod select false
class select Class false If you wish, select the class that applies to this item. Click —New— to set up a new class. Go to Lists > Classes for details about existing classes.
customer select Customer false
deferrevrec checkbox false
department select Department false If you like, select a department. Click New to enter a new department. Go to Lists > Departments for details about existing departments.
description textarea Description false
grossamt currency Gross Amt false
id text false
inventorydetail summary Inventory Detail false
isbillable checkbox Billable false
isvsoebundle text false
item select Item true
itemsubtype text false
itemtype text false
landedcostcategory select Landed Cost Category false
line text false
linenumber integer false
location select Location true Select a location to associate with this line item. Select New to create a new location record. Go to Lists > Locations for details about existing locations.
matrixtype text false
options namevaluelist Options false
orderdoc text false
orderline text {1} false
quantity float Quantity false
rate rate Rate false
rateschedule text false
scheduletype text false
units select Units false
vendorname text Vendor Name false

taxdetails - Tax Detail

Internal ID Type Label Required Help
calcdetail textarea Details false
grossamount currency Gross Amount false
linename text Name false
linetype text Line type false
netamount currency Net Amount false
taxamount currency Tax Amount true
taxbasis currency Tax Basis true
taxcode select Tax Code true
taxdetailsreference text Tax Details Reference false
taxrate percent Tax Rate true
transaction select Transaction false

Tabs

Name Label
custom Custom
history History
items Items
landedcost Landed Cost
workflow Workflow

Search Data

Transaction