Payable Invoice Line Items

In this topic you must choose your edition of our application. If you are unsure, contact your administrator.

The Expense Lines and Product Lines sections of a payable invoice are where you specify the items (expenses and products) that you want to include on the document.

See Payable Invoice Fields for a description of the fields that make up a payable invoice line item.

Note:

Note

If your organization is enabled for external tax calculation, you do not need to enter tax details because the tax value will be calculated by the external system upon posting the document. See Setting up External Tax Calculation for more information.

Classic Edition

When a vendor has been specified, the account currency is displayed and you can add line items to the document. You can change this currency up until the time that you add your first expense or product line item.

Adding New Expense Lines

Note:

Ensure your administrator has completed the steps in Setting up Prepaid Expenses before you proceed.

The tax code for an expense line is retrieved from the vendor's tax information.

1. To add a new expense line item to a payable document, either click Default Line to create an expense line using the vendor's default expense account, or select an appropriate GLA from the picklist, then click New Line.
2. [Optional] You may be able to select a local GLA depending how your system administrator has configured your org.
   
3. Enter the net value for the expense line. This should not include any tax nor be modified by any settlement discount.
4. [Optional, VAT/GST only] Change the default tax code for the expense line, or click Edit Tax Value to manually enter the amount of tax for an expense line.
5. [Optional, Combined Tax only] Enter the parent tax code in the Combined Tax Code field, then click the expander icon next to the Tax Rate field to view the tax breakdown for the related child tax codes.
6. [Optional] Select the Prepaid Expense checkbox to set this as a Prepaid Expense Line. If the checkbox is selected you must complete the Date From and Date To fields for the expense line.

Adding New Product Lines

The tax code for a product line is retrieved from the product if the vendor's tax status is home, otherwise the tax code is retrieved from the vendor's tax information.

1. Enter a full or partial product name, or click the lookup icon to search for a valid product, then click New Line. If the specified product is found, a new line is created with a default quantity of 1.00 and a unit price of zero.
2. Enter the Unit Price and Quantity as required.
3. [Optional, VAT/GST only] Change the default tax code for the product line, or click Edit Tax Value to manually enter the amount of tax for a product line.
4. [Optional, Combined Tax only] Enter the parent tax code in the Combined Tax Code field, then click the expander icon next to the Tax Rate field to view the tax breakdown for the related child tax codes.

The tax values for expense and product lines are calculated using the tax calculation methodMethod used by the account to calculate taxes in VAT or GST mode. for the vendor account specified on the document.

Adding Further Analysis, a Line Description and Intercompany Details

To add up to four analysis dimensionsCustom objects that allow you to analyze the activity in your business in additional ways, such as by cost center, project, employee, or any other business entity important to you., a line description and intercompany details on a line:

1. Click the expander icon next to the line number to display an expander panelPanels that are initially hidden when the page is loaded. They allow you to enter, and subsequently view, additional attributes of the related field or line item, such as further analysis or a line description..
2. Specify up to four custom analysis dimensions to attach to this line. Use the lookup icons to search for an appropriate dimension record. Any custom fields that have been set up for sub-analysis mappingMapping of custom fields at header and line level for the purpose of profitability reporting. at line level are displayed immediately below the Dimension analysis fields.
3. [Optional] Type a line description.
4. Set the date range for the selected line.
   Note: This is required for prepaid expense lines.
5. [Optional] Specify a destination company if the selected line is an intercompany line. If you don't want to recharge the line's full amount to the destination company, change the Destination Net Value on an expense line, or the Destination Unit Price and Destination Quantity on a product line, to the preferred amounts. Any unallocated amount will remain with the source company.
6. When complete, click the expander icon, or choose another line, to hide the current panel.

Modifying Tax on an Expense or Product Line

Note:

Note

If you use the Edit Tax Value checkbox for any expense or product line, then make further changes on that line, the tax value is not recalculated. You will need to amend it manually.

The Tax Summary section is automatically updated each time a line item is modified.

Recording a Reverse Charge

This feature only applies to VAT/GST companies.

If you want to record a reverse charge on a product or expense line:

1. Click the Reverse Charge checkbox on the product or expense line.
2. Enter the appropriate output tax code and output tax value.

Removing Lines

To remove an existing line item, either click the Remove Line icon on the right-hand side of the relevant line or Del on the left-hand side depending on your view of the application.

Extended Edition

Adding New Expense Lines

The tax code for an expense line is retrieved from the vendor's tax information. The tax values for expense and product lines are calculated using the tax calculation methodMethod used by the account to calculate taxes in VAT or GST mode. for the vendor account specified on the document.

There are two ways to add new expense lines to a payable invoice:

• Using the New Payable Invoice Expense Line Item button.
• Using the Manage Expense Lines button.

To add a new line item using the New Payable Invoice Expense Line Item button:

1. Display the detail page for the "In Progress" payable invoice that you want to add expense lines to.
2. Scroll down to the Payable Invoice Expense Line Items section.
3. Click New Payable Invoice Expense Line Item.
4. [Optional] You may be able to select a local GLA depending how your system administrator has configured your org.
5. [Optional] Deselect the Derive Line Number checkbox and enter a custom line number. If you leave this checkbox selected, the next available line number is allocated.
6. [Optional] Deselect the Set GLA To Default checkbox and enter a general ledger accountThe general ledger will normally include general ledger accounts (GLAs) for items such as income, expenses, assets, liabilities, and reserves.. If you have a local GLA and neither GLA is selected, the local GLA is populated by default. If you leave this checkbox selected, the default general ledger account is used. You see an error message if this checkbox is not selected, and the Local GLA and General Ledger Account fields are empty. You must select one of them.
7. [Optional] Enter a line description.
8. Enter the net value for the expense line. This should not include any tax nor be modified by any settlement discount.
9. [Optional] Deselect the appropriate checkboxes in the Tax sections to override the default tax codes and rates for this line.
10. [Optional] Specify up to four analysis dimensionsCustom objects that allow you to analyze the activity in your business in additional ways, such as by cost center, project, employee, or any other business entity important to you. to attach to this line.
11. [Optional] Specify a destination company if you are entering an intercompany line. If you don't want to recharge the line's full amount to the destination company, change the Destination Net Value to the preferred amount. Any unallocated amount will remain with the source company.
12. Click Save to save the line item. You can also click Save & New to save the changes to the current line item and begin to create another.

To add a new line item using the Manage Expense Lines button:

1. Display the detail page for the "In Progress" sales invoice that you want to add lines to.
2. Click Manage Expense Lines.
3. Add an expense line.
4. [Optional] Click Add New Line to add another line and repeat.
5. When you are finished, click Save.

Adding New Product Lines

The tax code for a product line is retrieved from the product if the vendor's tax status is home, otherwise the tax code is retrieved from the vendor's tax information.

There are two ways to add new product lines to a payable invoice:

• Using the New Payable Invoice Line Item button.
• Using the Manage Product Lines button.

To add a new line item using the New Payable Invoice Line Item button:

1. Display the detail page for the "In Progress" payable invoice that you want to add product lines to.
2. Scroll down to the Payable Invoice Line Items section.
3. Click New Payable Invoice Line Item.
4. [Optional] Deselect the Derive Line Number checkbox and enter a custom line number. If you leave this checkbox selected, the next available line number is allocated.
5. Enter a full or partial product name and/or click the lookup icon to search for a valid product.
6. [Optional] Enter a line description.
7. [Optional] Deselect the Derive Unit Price from Product checkbox to override the derived unit price.
8. [Optional] Change the quantity from its default value of 1.00.
9. [Optional] Deselect the appropriate checkboxes in the Tax sections to override the default tax codes and rates for this line.
10. [Optional] Specify up to four analysis dimensionsCustom objects that allow you to analyze the activity in your business in additional ways, such as by cost center, project, employee, or any other business entity important to you. to attach to this line.
11. [Optional] Specify a destination company if you are entering an intercompany line. If you don't want to recharge the line's full amount to the destination company, change the Destination Unit Price and Destination Quantity to the preferred amounts. Any unallocated amount will remain with the source company.
12. Click Save to save the line item. You can also click Save & New to save the changes to the current line item and begin to create another.

To add a new line item using the Manage Product Lines button:

1. Display the detail page for the "In Progress" sales invoice that you want to add lines to.
2. Click Manage Product Lines.
3. Enter a full or partial product name and/or click the lookup icon to search for a valid product.
4. [Optional] Enter a line description.
5. [Optional] Change the quantity from its default value of 1.00.
6. [Optional] Edit the unit price.
7. [Optional] Edit the default tax details.
8. [Optional] Complete any Destination fields if this is an intercompany line.
9. [Optional] Click Add New Line to add another line and repeat.
10. When you are finished, click Save.

See the section on data entry grids in Entering and Editing Data for more information.

Recording a Reverse Charge

This feature only applies to VAT/GST companies.

If you want to record a reverse charge on a product or expense line:

1. Click the Reverse Charge checkbox on the product or expense line.
2. Enter the appropriate output tax code and output tax value.

Removing Lines

To remove an existing line item, either click the Remove Line icon on the right-hand side of the relevant line or Del on the left-hand side depending on your view of the application.