Payable Invoice Line Items

This section describes how to add lines to a payable invoice in Lightning Experience.

Tips:

• To add a new line at the end of the grid, click the last cell of the last row, then press Tab.
• Use the search box above the grid to refine the displayed content and help you find the information you are looking for. You can search the content of any of the displayed columns.

• While editing a field, press Escape to revert it to its previous value.

Note: The use of custom datetime fields for payable invoice lines is not supported in Lightning Experience.

Adding New Expense Lines

Note: The use of local general ledger accounts is supported in Lightning Experience. If you need to use local general ledger accounts, contact your administrator.

To add new expense lines:

1. On the payable invoice record page, click the Expense Lines tab.
2. If the expense lines grid shows an empty row, enter a general ledger account or the Local GLA whichever is applicable for that first row. Select it from the drop-down list once it displays. If you need to add a new row, click and enter the general ledger account or the Local GLA whichever is applicable.
   
3. Enter the net value for the expense line. This value must not include any tax or be modified by any settlement discount.
4. [Optional] Complete the remaining fields as required. For details of other fields, see Payable Invoice Fields.
5. [Optional] Continue adding more lines as required.
6. Click Save.

Notes:  

• If the Tax Code is set at the Account level it will be retrieved directly into the relevant tax fields on the expense line.
• When creating a new expense line item, editing or amending the dimension fields on the line item, you can assign a dimension only when the period start and end date of that payable invoice are within the posting effective dates of that dimension.
• Once the sales invoice is posted, you cannot make any changes to the GLA fields on the line items. When creating a new expense line item or editing the GLA fields on the line item, you can assign a GLA only when the period start and end date of that payable invoice are within the posting effective dates of that GLA.

For more information, see Managing Analysis Dimensions and Managing General Ledger Accounts.

Adding New Product Lines

To add new product lines:

1. On the payable invoice record page, click the Product Lines tab.
2. If the product lines grid shows an empty row, enter the product for that first row. Select it from the drop-down list once it displays. If you need to add a new row, click and then enter the product.
3. Enter a quantity.
4. Enter the unit price. If you leave this field blank, it will be automatically populated with the list price on the price book associated with the product after saving.
5. [Optional] Complete the remaining fields as required. For details of other fields, see Payable Invoice Fields.
6. [Optional] Continue adding more lines as required.
7. Click Save.

Notes:  

• 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.
• If the Tax Code is set at the Account level it will be retrieved directly into the relevant tax fields on the product line.
• When creating a new product line item, or editing, or amending the dimension fields on the line item, you can assign a dimension only when the period start and end date of that payable invoice are within the posting effective dates of that dimension.

Cloning Lines

To clone lines:

1. Select the checkboxes of the lines you want to clone.
2. Click above the grid.
3. [Optional] Modify the cloned lines as required.
4. Click Save.

Note: When you clone a journal line and modify the Line Type, all fields in the line appear blank. This is an expected behavior.

Deleting Lines

To delete lines:

1. Select the checkboxes of the lines you want to delete.
2. Click above the grid.
3. Click Save.

Editing Lines

You can edit expense and product lines while the document's status is "In Progress".

To edit existing lines:

1. In the grid, change the fields for the lines you want to update as required.
2. Click Save.

Managing Allocation Rules on Expense Lines

You can apply, remove and update allocation rules on expense lines. For more information, see Managing Allocation Rules On Expense Lines.

Amending Lines after Posting

Once you have posted the document and its status is "Complete", you can only amend (add, edit or delete) the following fields of your expense and product lines:

• Line Description
• Dimensions 1-4

Note: Custom fields are amendable by default for expense and product lines. If you cannot amend the custom fields of your posted document lines, contact your administrator.

To amend expense or product lines:

1. In the grid, change any of the fields listed above for the lines that you want to amend.
2. Click Save.

Non-amendable fields will show a lock icon when hovering over them.

Note:

If you have applied an allocation rule to an expense line, you cannot amend the Line Description or Dimensions fields after posting.

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. Select the Reverse Charge checkbox on the product or expense line.
2. Enter the appropriate output tax code and output tax value.

Note:  

• You can select the Reverse Charges checkbox from the payable invoice header and enter reverse charge values even if the Enable Place of Supply Rules setting is not configured for the Accounting Company.
• When the VAT/GST Product settings and the Enable Place of Supply Rules Accounting Company setting are not configured then the Output Tax Rate, Output Tax Code, and Output Tax Value fields display in line items only when you select the Reverse Charge checkbox in the payable invoice header.
• When the VAT/GST Product settings and the Enable Place of Supply Rules Accounting Company setting are configured and the product type is selected then the Output Tax Rate, Output Tax Code, Output Tax Value fields display in the line items and are populated with default values.

Creating Miscellaneous Adjustments in PSA

If PSA – Accounting Connector is installed in your org, you can create PSA miscellaneous adjustments from eligible expense lines. You can only do this after the payable invoice has been posted.

To create miscellaneous adjustments, select expense lines in the grid and click Create Miscellaneous Adjustments. For more information, see Creating Miscellaneous Adjustments from Expense Lines on a Payable Invoice.

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 method Method 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 dimensions Custom 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 panel Panels 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 mapping Mapping 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:

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.

This section describes how to add lines to a payable invoice in 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 method Method 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 account The 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 dimensions Custom 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 dimensions Custom 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.