Sales Credit Note Line Items

In Lightning Experience you can add, view, clone, edit, and delete line items directly from the sales credit note record page. The sections below provide more information.

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.

Adding New Line Items

To add a new line item:

1. On the sales credit record page, click the Lines Items tab. A grid displays all the line items currently associated with the sales credit note. The columns displayed in the grid vary depending on the company's tax mode and on how your org is set up.
2. If the grid contains an empty row, fill out the columns in the row. To add a new row, click .
3. In the Product Name column, enter the name of a product. As you start typing, a drop-down list automatically displays all the matching products.
4. Select a product from the list.
5. In the Quantity column, enter the number of items being sold.
6. In the Unit Price column, enter the price of a single unit in the document's currency. If the product has an active standard price book in the same currency as the document, its unit price is retrieved and specified as default value. Otherwise, a unit price of zero is used as a default.
7. [Optional] Complete the remaining fields as required. For more information about the available fields, see Sales Credit Note Fields.
8. [Optional] Add more lines as required.
9. Click Save. The line items are now saved. If errors occur, you must fix all the errors before you can save the line items.

Cloning Line Items

You can quickly add new line items by cloning an existing row. You can only do this while the status of the sales credit note is "In Progress".

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 Line Items

You can delete line items while the status of the sales credit note is "In Progress".

To delete lines:

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

Editing Line Items

You can edit line items while the status of the sales credit note is "In Progress".

To edit existing line items:

1. In the grid, change the fields for the lines that you want to edit.
2. Click Save.

Amending Line Items after Posting

Once you have posted the document and its status is "Complete", you can only amend the Line Description field and custom fields created by your administrator. Depending on how your org is set up, you might also be able to amend the Dimension 1-4 fields and custom fields that have been set up for sub-analysis mapping.

To amend line items:

1. In the grid, change the value of the field that you want to amend. When you hover over a non-editable field, the icon displays.
2. Click Save.

Notes:  

• When creating a new 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 sales credit note are within the posting effective dates of that dimension.
• Once the sales credit note is posted, you cannot make any changes to the GLA fields on the line items. When creating a new line item or editing the GLA fields on the line item, you can assign a GLA only when the period start date and end date of that sales credit note are within the posting effective dates of that GLA.

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

Adding new lines

You can add new line items to a sales credit note by:

• Searching for a product in a price book
• Using the New Line button

Searching for a product in a price book

To a add new line item by searching for a product in a price book:

1. Enter a partial product name or code in the Price Book Search section.
2. Click Search.
3. Select one or more products.
• If you only want to add one line item, click on the right-hand side of the relevant line.
• If you want to select multiple products, set the appropriate checkboxes on the left-hand side and then click Add Selected Lines.
4. New line items are added to the document with a default quantity of 1.00 and the default income schedule defined on the product if it has one. You can now add to or edit the default values as required. If the product has a default income schedule, but you do not want to use it, clear the Income Schedule field on the line item or use the lookup icon to select a different schedule.
5. Press Tab or reposition the cursor with the mouse to move on.

Using the New Line button

To add a new line item by using the New Line button:

1. Click New Line. This button is unavailable until an invoice or credit note currency has been set, and a valid product has been specified on all existing line items.
2. Enter a full or partial product name, or click the lookup icon to search for a valid product.

   If the specified product is found, a new line is enabled with a default quantity of 1.00 and the default income schedule defined on the product if it has one.

   If the product has an active standard price book in the same currency as the document, its unit price is retrieved. Otherwise, a unit price of zero is used as a default.

3. [Optional] Override the derived general ledger account (the default is taken from the product) by selecting Enable Override Product GLA in custom settings.
4. [Optional] You may be able to select a local GLA depending how your system administrator has configured your org.
5. [Optional] Change the quantity from its default value.
6. If the product has a default income schedule, but you do not want to use it, clear the Income Schedule field on the line item or use the lookup icon to select a different schedule.
7. You can now edit the unit price and tax details as required.

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. Dimension fields displayed on the sales credit note are automatically populated using values derived from the dimension fields stored on the account specified on the sales credit note. SeeWhat are Analysis Dimensions? for more information. 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. Type the new or amended line description. This will appear on the printed document immediately after the product name.
4. [Optional] Specify a destination company if the selected line is an intercompany line. If you don't want to distribute 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.
5. When complete, click the expander icon, or choose another line, to hide the current panel.

If your administrator One or more individuals in your organization who can configure and customize the application. Users assigned the System Administrator profile have administrator privileges. has set up custom fields on your sales invoices or credit notes, these fields may be listed under Additional Information on 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. in Classic Edition The view of the application that you see when you first install the base managed package.. (These are separate from custom fields set up for sub-analysis mapping.) See Custom Fields on Sales Invoices and Credit Notes for more information.

Modifying tax on a line

The method used to modify tax at the line item level, depends on the current tax mode.

Sales and Use Tax

To modify tax on a selected line, if the current tax mode is "Sales and Use Tax":

1. Click the expander icon next to the Tax Rate field to display an expander panel.

   The derived tax rates depend on the sales tax statuses set on the corresponding account and product details. See About Tax for more information on the effect of sales tax statuses.

2. [Optional] Modify one or more of the three default tax codes. This will update the tax rate in the adjacent field and the calculated tax value column.
3. [Optional] Override the derived tax rate. The calculated tax value will be updated accordingly.
4. When complete, click the expander icon, or choose another line, to hide the current panel.

Note:

If the Allow Override of SUT Tax Values custom setting is enabled, you will be able to modify the tax value on a selected line, as well as the tax rate. See Accounting Settings for more information.

Value Added Tax/Goods and Services Tax

To modify tax on a selected line, if the current tax mode is "Value Added Tax" or "Goods and Services Tax", either:

• Change the tax code on the line, or
• Modify the tax value directly.

Combined Tax

To modify tax on a selected line, if the current tax mode is "Combined":

1. Enter the parent tax code in the Combined Tax Code field.
2. Click the expander icon next to the Tax Rate field to view the tax breakdown for the related child tax codes.

Adding new lines

You can add new line items to a sales credit note by:

• Using the New Sales Credit Note Line Item button.
• Using the Manage Lines button.

To add a new line item using the New Sales Credit Note Line Item button:

1. Display the detail page for the "In Progress" sales credit note that you want to add lines to.
2. Scroll down to the Sales Credit Note Line Items section.
3. Click New Sales Credit Note Line Item.
4. If you want to accept any or all of the default values, keep the relevant Derive checkboxes selected and leave the corresponding fields blank. To specify custom values, enter them into the appropriate field. There is no need to deselect the Derive checkbox.
5. Enter a full or partial product name and/or click the lookup icon to search for a valid product. If the product has an active standard price book in the same currency as the document, the Derive Unit Price checkbox is selected and the Unit Price field is blank, a unit price is retrieved on save.
6. [Optional] Enter a line description.
7. [Optional] Override the derived general ledger account (the default is taken from the product).
8. [Optional] You may be able to select a local GLA depending how your system administrator has configured your org.
   
9. [Optional] Change the unit price and quantity from their default/derived values.
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. Dimension fields displayed on the sales credit note are automatically populated using values derived from the dimension fields stored on the account specified on the sales credit note.
11. [Optional] Specify a destination company if you are entering an intercompany line. If you don't want to distribute 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 Lines button:

1. Display the detail page for the "In Progress" sales credit note that you want to add lines to.
2. Click Manage Lines.
3. Enter a full or partial product name and/or click the lookup icon to search for a valid product.

   If the product has an active standard price book in the same currency as the document, its price is retrieved.

4. [Optional] Override the derived general ledger account (the default is taken from the product).
5. [Optional] Change the quantity from its default value of 1.00.
6. [Optional] Edit the unit price and tax details as required.
7. [Optional] Edit any custom fields your administrator may have added to the grid.
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.

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.