# Xero - Upsert line item to bill or invoice action

The Upsert line item to bill or invoice action allows you to insert or update a single line item on an existing Xero bill. If the line item ID is provided, the action updates the whole line.

Upsert line item to bill or invoice actionXero - Upsert line item to bill or invoice action

# Input

Input field Description
Invoice ID Enter the unique identifier of the invoice.
Line item ID Provide the identifier of the line item to update. Leave this field empty to add a new line item.
Description Input a description for the line item.
Item name Specify the name of the item for the line item.
Quantity Enter the quantity of the item in the line item.
Unit price Specify the price per unit of the item.
Line amount Enter the total amount for the line item.
Discount rate Provide the discount rate, if applicable, for the line item.
Account code Input the account code from your Xero chart of accounts for this line item.
Tax type name Specify the name of the tax type applied to the line item.
Tax amount Enter the amount of tax for the line item, if applicable.
Item code Provide the item code. If both the item name and item code are provided, the item code takes precedence.

# Output

Output field Description
Reference Reference information for the updated line item.
Type The type of document updated (bill or invoice).
Invoice ID The unique identifier of the invoice or bill.
Invoice number The number of the invoice or bill.
Payments Details of payments associated with the invoice.
Credit notes Details of credit notes applied to the invoice.
Amount due The total amount due on the invoice or bill.
Amount paid The total amount paid on the invoice or bill.
Amount credited The total amount credited to the invoice or bill.
URL The link to the invoice or bill in Xero.
Currency code The currency code used for the invoice or bill.
Currency rate The exchange rate applied to the currency.
Has errors Indicates if there are errors related to the invoice or bill.
Is discounted Indicates if a discount has been applied to the invoice or bill.
Has attachments Indicates if there are attachments included with the invoice or bill.
Contact Details of the contact associated with the invoice or bill.
Date The date of the invoice or bill.
Due date The due date for payment of the invoice or bill.
Status The current status of the invoice or bill.
Branding theme ID The identifier for the branding theme applied to the invoice or bill.
Line amount types The type of line amounts on the invoice or bill.
Line items Details of each item listed on the invoice.
Sub total The subtotal amount of the invoice or bill before tax.
Total tax The total tax amount for the invoice or bill.
Total The total amount of the invoice or bill, including tax.
Updated date The date when the invoice or bill details were last updated.
Paid date The date when the invoice or bill was fully paid, if applicable.


Last updated: 9/5/2024, 2:04:04 PM

On this page