ExpenseItem

IMPORTANT The SOAP API entered a limited enhancement phase in Q4 2020. Access deactivation for version 1.5 began in Q1 2022 and will enter its concluding phases in October 2022. Access to version 1.6 will deactivate in Q4 2024. Visit our SOAP API lifecycle FAQ article to learn more.

This entity describes a line item associated with an Expense Report entity. It allows expense line items to be created, queried, and updated through the API.

In Autotask, Expense Items can be added to an Expense Report from the Timesheets or Home modules, or a ticket, project, or task.

Entity details

You can also retrieve this information with the Web Services API call The getEntityInfo() SOAP API call.

Fields that cannot be queried

The following fields from this entity will return an error when queried.

  • GLCode
  • Reimbursable
  • Rejected

Conditions and requirements

General

  • create() and update() are allowed only when the associated ExpenseReport has a Status = In Progress or Rejected

    • Special field attributes

    Field Conditions and Requirements
    AccountID

    When a TicketID or ProjectID are set, the AccountID is calculated based on the ticket or project. If you set an AccountID that differs from the calculated AccountID, an error is returned.

    When a TaskID is set, the AccountID and ProjectID are calculated based on the task and associated project. If you set an AccountID or ProjectID that differs from the calculated AccountID and Project ID, an error is returned.

    If no AccountID is supplied, the expense is associated to the "0" account.
    CurrencyID If no CurrencyID is specified, the ExpenseItem will use the Currency associated with the Account associated with ExpenseItem.AccountID.
    Destination, Origin, and Miles Destination, Origin, and Miles are all required when Category = Mileage
    EntertainmentLocation EntertainmentLocation is required when Category = Entertainement Expense
    ExpenseAmount ExpenseAmount represents the internal currency value of the ReceiptAmount.
    ExpenseAmount, ReceiptAmount

    Neither ExpenseAmount or ReceiptAmount is required. The following conditions apply for single currency databases (multi-currency is not enabled):

    • If a value for ExpenseAmount or ReceiptAmount (not both) is provided, the value for both is set to the value provided.
    • If values for both ExpenseAmount and ReceiptAmount are provided, the value for ReceiptAmount is used and ExpenseAmount is updated to equal ReceiptAmount.
    • If no value is provided for either, then the fields remain without value.

    The following conditions apply for multi-currency databases:

    • On create, ReceiptAmount is required when no value is provided, or if only ExpenseAmount value is provided. When values are provided for both ExpenseAmount and ReceiptAmount, ReceiptAmount is used and ExpenseAmount is updated to equal ReceiptAmount.
    • On update, the ReceiptAmount value always populates both fields. If only ExpenseAmount is provided, neither field is updated.

    NOTE Best Practice: Going forward from API version 1.5.13, as best practice use ReceiptAmount for both single and multi-currency databases. ExpenseAmount is calculated from ReceiptAmount. The ExpenseAmount field is available for backward compatibility in single currency databases.
    ExpenseCategory

    An inactive ExpenseCategory cannot be specified when creating an ExpenseItem or updating the ExpenseCategory field. An ExpenseItem with an inactive ExpenseCategory can be updated.

    PaymentCategory options are configurable in the Autotask Admin module. Use Web Services API getFieldInfo() call to retrieve the list for a specific implementation.
    ExpenseReportID If Organizational Structure is enabled in Autotask, access to Expense Items is subject to the user's Organizational Structure Line of Business assignments and the Line of Business associated with ExpenseItem.ExpenseReportID, if any.
    PaymentType

    PaymentType picklist options = American Express, Cash, Company Check, Company Credit Card, Mastercard, Other, Personal Check, Visa. These picklist options are not configurable.

    Reimbursable status is updated from the corresponding attribute of the current PaymentType every time the ExpenseItem entity is touched.
    ReceiptAmount

    ReceiptAmount specifies the amount of the expense in the currency it was received. ExpenseAmount now represents the internal currency value of the ReceiptAmount. If no ReceiptAmount is specified for the ExpenseItem, the field will be populated by the amount equal to ExpenseAmount divided by the ExchangeRate of the specified currency (ExpenseCurrencyID).
    ReimbursementAmount

    ReimbursementAmount = the reimbursement amount for this expense in the internal currency. This field impacts databases with multi-currency enabled.

    If this value is not supplied on creation of an ExpenseItem, the field will be populated with the the ExpenseAmount value (the expense amount of the expense in the internal currency). If ExpenseItem.PaymentType is not reimbursable, this value will be 0 and cannot be updated.
    ReimbursementCurrencyReimbursementAmount

    ReimbursementCurrencyReimbursementAmount = the reimbursement amount for this expense in the reimbursement currency of ExpenseItem.ExpenseReportID (the expense's expense report.) This field impacts databases with multi-currency enabled.

    • If this value is not supplied on creation of an ExpenseItem, the field will be populated by dividing the ExpenseAmount by the ExchangeRate of the ReimbursementCurrency associated with the ExpenseItem's ExpenseReport. If the ExpenseItem.PaymentType is not reimbursable, this value will be 0 and cannot be updated.
    • If this value is edited, the ReimbursementAmount will be recalculated by multiplying the new value by the ExchangeRate of the ReimbursementCurrency associated with the ExpenseItem's ExpenseReport.
    • If both values are supplied or edited at the same time, we will take the ReimbursementAmount as the correct one and calculate the ReimbursementCurrencyReimbursementAmount. The supplied ReimbursementCurrencyReimbursementAmount will be discarded.
    WorkType WorkType picklist options are configurable in the Autotask Admin module. Use Web Services API getFieldInfo() call to retrieve the list for a specific implementation.

    Field definitions

    ClosedAbout this table

    The following table describes the standard Autotask PSA field objects for this entity.

    • To retrieve more detailed information specific to a particular Autotask PSA implementation, use the Web Services API call The getFieldInfo() SOAP API call.
    • For information on entity UDFs, use getUDFInfo().
    • For String datatypes, the number in parentheses ( ) indicates the maximum number of characters allowed.
    • LT indicates Local Term.

    For more information about fields marked as picklists, review our Understanding picklists article.

    Field Name Label Datatype Read Only Is Required Reference Name Picklist
    AccountID Account ID integer Account
    BillableToAccount Billable To Account boolean
    Description Description string(128)
    Destination Destination string(128) See Conditions
    EntertainmentLocation Entertainment Location string(128) See Conditions
    ExpenseAmount Expense Amount double
    ExpenseCategory Expense Category integer
    ExpenseCurrencyID Expense Currency ID integer Currency
    ExpenseDate Expense Date datetime
    ExpenseReportID Expense Report ID integer ExpenseReport
    GLCode GL Code String(20)
    HaveReceipt Have Receipt boolean
    id Expense Item ID long
    Miles Miles double See Conditions
    OdometerEnd Odometer End double
    OdometerStart Odometer Start double
    Origin Origin string(128) See Conditions
    PaymentType Payment Type integer
    ProjectID Project ID integer Project
    PurchaseOrderNumber purchase_order_number string (50)
    ReceiptAmount Receipt Amount double
    Reimbursable Reimbursable boolean
    ReimbursementAmount Reimbursement Amount double
    ReimbursementCurrencyReimbursementAmount Reimbursement Currency Reimbursement Amount double
    Rejected Rejected boolean
    TaskID Task ID integer Task
    TicketID Ticket ID integer Ticket
    WorkType Work Type integer