# 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.
Xero - 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