Expense Report

Internal ID: expensereport

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
account select false Account false Select an account for this expense. Note: This field is available to edit only in the following cases: * You have checked the Accounting Approval box on this form. * You are editing an expense report entered previously.
accountingapproval checkbox false Accounting Approval false If you have the appropriate accounting authority to approve this report indicating it is ready to pay, place a check mark in this box.
acctcorpcardexp select false Account for Corporate Card Expenses false Select the credit card account to use for corporate card expenses.
advance currency false Advance To Apply false Enter any advance that should be applied to any reimbursement for these expenses.
amount currency false Amount false The number NetSuite enters here represents the total of all line items minus any advances and lines marked as non-reimbursable.
approvalstatus select false Approval Status false When you use SuiteFlow for expense report approvals, the forms now include an Approval Status field. The Approval Status field reflects the state of the transaction in the approval process. Expense reports may have one of the following statuses: * Pending Approval – The expense is in the approval queue. * Approved – The expense has been given approval for processing. * Rejected – The expense has not been approved and will not be processed.
class select false Class false Choose a class to associate with this transaction. Click New to enter a new class.
complete checkbox false Complete false This field shows if this report is complete. Only complete reports are submitted for approval and processing. Note: Once an expense report is marked complete, you can no longer make changes to it.
createddate datetime false false
customform select false Custom Form true To use a different custom form to enter the expense report, select it here.
department select false Department false Choose a department to associate with this transaction. Click New to enter a new department.
duedate date false Date Due false Enter the due date of the expense report.
entity select false Employee true Enter the name of the employee who incurred these expenses.
entitynexus select false Nexus false
expensereportcurrency select false Currency true Select a currency for this expense report.
expensereportexchangerate currency2 false Exchange Rate true Select an exchange rate for this expense report.
externalid text false ExternalId false
lastmodifieddate datetime false false
location select false Location false Choose a location to associate with this transaction. Select New to enter a new location record. Go to Lists > Locations for details about existing location records.
memo text true Purpose false Enter the purpose of the entire expense report.
nextapprover select false Next Approver false When you use SuiteFlow for expense approvals, expense reports include a Next Approver field. This field is populated based on the associated workflow. For example, in your workflow you may create a state of Pending Approval. In that state you create a formula to set the Next Approver as the employee’s supervisor.
nexus select false Nexus false Select the nexus that you want to associate with the expense report. This field shows the valid nexuses (tax registrations) for the subsidiary on the expense report.
postingperiod select false Posting Period true The current period is entered as the posting period for the expense report. If this period is closed before the expense report is approved, the posting period is determined by the accounting preference Default Posting Period When Transaction Date in Closed Periods. 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.
status text false Status false
statusRef text false false
subsidiary select false Subsidiary false The subsidiary associated with the selected employee is displayed here. To enter expenses associated with other subsidiaries, the Intercompany Time and Expense feature must be enabled, and journal entries will need to be created to adjust for intercompany expenses. Automated intercompany adjustments can be generated at Transactions > Financial > Create Intercompany Adjustments.
subsidiarytaxregnum select false Tax Reg. Number false When you select a nexus, the corresponding tax registration number is automatically selected in this field. If there is more than one tax registration number for the nexus, the transaction date (in the Primary Information section) determines the tax registration number to be used based on the validity dates set on the subsidiary record. When you select a different tax registration number, the corresponding nexus is automatically selected in the Nexus field.
supervisorapproval checkbox false Supervisor Approval false If you have the appropriate authority as a supervisor to approve this report, place a check mark in this box.
taxdetailsoverride checkbox false Tax Details Override false
taxpointdate date false Tax Point Date false
taxpointdateoverride checkbox false Override false
total currency false Expenses Total false NetSuite will keep track of the total expenses as you add and edit line items below.
trandate date false Date true NetSuite inserts today's date as the date of this expense report. You can type or pick another date.
tranid text false Exp. Rept. # false NetSuite increases the largest expense report number by one. If you wish, you can type another number. The next expense number will revert to the standard pattern. You can enter a maximum of 45 characters in this field.
usemulticurrency checkbox false Use Multi Currency false Check this box if you want to enter expenses in foreign currencies on this expense report. This box is checked by default if you have enabled the Use Multicurrency Expense Reports preference on the General subtab at Home > Set Preferences. Foreign amounts are translated into base currency amounts. Note that exchange rates and converted amounts displayed on expense lines are provided as approximations only. Actual reimbursement amounts will be based on rates at the time of reimbursement.

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
amount currency Amount true
category select Category true
class select Class false
corporatecreditcard checkbox Corporate Card false
currency select Currency true
customer select Customer false
department select Department false
exchangerate currency2 Exchange Rate false
expensedate date Date true
foreignamount currency2 Foreign Amount false
isbillable checkbox Billable false
isnonreimbursable checkbox Non-reimbursable false
line text false
location select Location false
memo text Memo false
receipt checkbox Receipt false
taxdetailsreference text Tax Details Reference false

taxdetails - Taxes

Internal ID Type Label Required Help
calcdetail textarea Details false
taxamount currency Tax Amount true
taxbasis currency Tax Basis true
taxcode select Tax Code true
taxdetailsreference text Tax Details Reference true
taxrate percent Tax Rate true
taxtype select Tax Type true

Tabs

Name Label
custom Custom
history History
items Items
workflow Workflow

Search Data

Transaction