IN Invoices - Lines tab

Navigator > Tasks > Invoicing System > Enter Invoices > Lines tab

Job Defaults panel (if Job Costing available)

Job Defaults are displayed if Show Job Defaults on IN Lines is selected in JC Settings. If Allow IN Sourced Invoice Lines is selected in JC Settings, Job Defaults may be changed, and lines can be added directly to Job Invoices. Lines with a Job code do not allocate or issue stock; they post a Job transaction with invoiced quantity and values only, so they do not add costs for a job.


Job		The default Job code for the Invoice. The Job Code will apply as new lines are inserted. When a Job Code is selected, the Invoice Sales Person, Price code, Discount Code, Contact, and Email Contact are changed to the Job defaults. The Branch, Department and Location are changed to the Job defaults (in Accredo Saturn). The Job code is also displayed on the Header tab.
Type		The JC transaction type (Material, Disbursement or Time) that will apply to new lines as they are inserted. Overridden if the product code selected for the line has Job defaults set.
Cost Centre		The Cost Centre that will apply as new lines are inserted. Overridden if the product code selected for the line has Job defaults set.
Component		The Component that will apply as new lines are inserted. Overridden if the product code selected for the line has Job defaults set.
	Apply to all `(Ctrl+A)`	Applies the selected Job Code, Cost Centre or Component to all Invoice lines.

Invoice lines grid

When entering or editing Invoice lines, Ctrl+Enter moves to the start of the next line.

The following fields are shown by default. Zoom to Form view, or select Customise (Alt+F5) to view all IN Invoice Line Fields, including the GL Account Code.

Note: When changes are made on the Header tab, Accredo attempts to preserve the pricing on existing lines. Changes will be applied to new lines added but not always to existing lines. To make changes to existing lines, select the Reprice button.

For Documents created from JC Job Invoicing, you must have permission for JC / Tasks / Invoicing to edit invoice lines.

Grid Fields

Line Type

Select Product or Narrative.

Auto Kitset, Manual Kitset, Component and Usage line types are selected from the Product code entered and do not appear in the line type lookup. See Components. Job lines do not appear in the line type lookup as they are generated from JC.

Product	Enter product items.
Narrative	Enter extended lines of text, such as a detailed description of a job. Click Narrative `(F2)` in the Description field of a narrative line to open the Narrative Editor, then type a narrative or choose a global narrative.
Auto Kitset	Followed by a list of components. When posted, the components on the lines following are sold, not the product on the Auto Kitset line.
Component	Lines below an Auto Kitset line. These products are recognised as sold when the invoice is posted.
Manual Kitset	The product is manufactured on the fly from the usage lines below and then sold. If Supply Whole Manual Kitsets is selected in IN Settings, usage quantities for Manual Kitsets cannot be edited once calculated based on the Kitset quantity. If Supply Whole Manual Kitsets is unselected, usage quantities can be edited on the Invoice lines.
Usage	Lines below a Manual Kitset line. When the invoice is posted, these products are used to manufacture the Manual Kitset Product which is recognised as a sale.

Product

The Product code from IC (if IC is installed). Selecting a Product code loads a number of defaults: the Description, Unit, Group and Commission fields are loaded with the values from the Product record.

You can also enter a Bar code, and the relevant IC Product will be selected.

If you change the Product Code for an OE sourced line, the line will no longer be linked to the OE line.

If Job defaults have been set for the Product sets Transaction Type, Cost Centre and Component from the Product.

Description

Defaults to the description of the selected product (can be overwritten). Up to 60 characters are available on the selected line. For Narrative lines, for more characters, click Narrative (F2) to open the Narrative Editor.

UOM Code

(UOM Active Only)

The UOM Code from the Product. If the Product has more than one UOM Code, you can select the code to use.

Quantity / UOM Quantity

The quantity supplied on the invoice. When a product is selected, defaults to the Default Invoice Line Quantity value specified in IN Settings (often 1).

You can set the default behaviour for insufficient supply in IN Settings, and you can select to prompt if insufficient quantity is available.

Unit

The unit for the product (for example, Each or Doz) usually printed on the invoice. If a UOM Code is entered, shows the UOM Code Description. If no UOM Code exists, this can be entered.

Price / UOM Selling Price

Price is calculated based on the Discount mode in the Discount Schedule. If the Discount Mode is:

Explicit, the Price shows the Sell Price for the item before a discount, and the discount appears in the Disc% field.
Implicit, the Price shows the discounted price (that is, the Sell Price minus the Discount). No discount shows in the Disc% field.

If using Special Pricing, Price shows the special price according to the rules above.

Note: If prices have changed since the line was saved, the changes will not be reflected. To update prices click Reprice.

Disc%

The discount shown depends on the Discount Mode specified in the Discount Schedule. If the Discount Mode is:

Explicit, Disc% shows the discount percentage applied to the extended amount (Quantity x Price).
Implicit, no discount is shown.

If you use Special Pricing, Disc% shows the total discount according to the rules above.

Note: For Automatic Kitset products, if any of the component Products have a Discount Code set, the Discount Codes of each of the products will be used. You can manually change these.

GST

The GST code for the line. If the Customer has a GST Override set, it will be the default, otherwise the GST code comes from the Product. If there is no Product Code, the GST code will come from the Sales Group. It is unusual to need to change this code manually.

Group

The Sales Group the net sale on the line is analysed to when the invoice is posted. If the line does not include a product from IC, remember to type the appropriate Sales Group code. Failing to do so will result in the amount being analysed to the unspecified Sales Group Code 0000. To avoid code 0000 being used in error, ensure that Allow Unspecified 0000 Sales Analysis Codes is not selected in AR Settings. Search for a sales group using the Accredo Lookups.

Amount

The extended line amount. You cannot enter in this field; it is calculated as, QuantitySupplied x SellingPrice - EnteredDiscount.

Complete For WIP

Available when a Job Code is selected for the Invoice or the Line. Not available for OE sourced lines.

Selected, the transaction will be excluded from WIP calculations when the invoice is posted.

Clear, the transaction is included in WIP calculations.

JC Actuals

Available when a Job Code is selected for the Invoice or the Line. Not available for OE sourced lines.

Selected, JC Actuals and related IC Usages will be created for the JC Transaction when the Invoice is posted. Only enabled if Allow IN Sourced Invoice Lines is selected in JC Settings, and line is IN Sourced, i.e. not generated from Job Invoicing form for an existing JC Transaction.
Complete for WIP will also be set to Selected.

Grid Toolbar

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Zoom (Ctrl+F12)

Access grid fields in Form view for each line on the grid. Invoice lines can be entered/edited in the form or on the grid. To view more fields use the scroll buttons or resize the window. See IN Invoice Line Fields.

Insert (F4)

Insert a new line.

Move (Shift+Up) (Shift+ Down)

Move the selected line.

Delete (F3)

Delete the selected line.

Drill down (Shift+F12)

View the source document (only available if the invoice was saved and sourced from another document).

Sort (Ctrl+F2)

Sort ascending or descending on a field. Sort order is saved when the invoice is saved.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

Prompt for Delete Line On / Off (Shift+F3)

Toggle on and off to specify whether to confirm deletes. The default state is set in Users, Groups and Roles - Preferences tab.

Hide / Show Usages (Ctrl+H)

Toggle on and off to hide and show usages for Manual Kitsets. The default state is set in Users, Groups and Roles - Preferences tab.

Product Quantities (Ctrl+Q)

Opens IC Product Quantity (if IC is Installed) showing quantities to view stock availability and pending stock movements. Allows juggling stock 'on the fly'. Quantities at each location are shown (in Accredo Saturn).

Special Pricing Information (Ctrl+4)

Opens SP Price Query. You can query the results of a rule applied to a line. If a Special Price is applied, the rule reference displays with other information, depending on the Special Pricing script.

Customise Toolbar

Customise Toolbar or right-click in the toolbar below the buttons to access the Customise Toolbar Menu.

Tracking Panel

Show Tracking
Hide Tracking
(Ctrl+T)

Show or hide the tracking detail for the current line.

Stock Levels

Customise

Opens Customise Fields, you can customise the fields visible in the stock levels panel.

UOM Code

(UOM Active Only)

The UOM Code from the Product. If the Product has more than one UOM Code, you can select the code to use.

In Stk / UOM In Stk

Quantity of the selected product in stock on hand.

Alloc / UOM Alloc

Quantity of the selected product currently allocated to customers.

Avail / UOM Avail

Quantity of the selected product available for sale.

Bk Ord / UOM Bk Ord

Quantity of the selected product on back order for customers.

Ship / UOM Ship

Quantity of the selected product on shipments not yet receipted.

On Ord / UOM On Ord

Quantity of the selected product on order from suppliers.

Note: For Automatic Kitset products, the following fields come from the individual components products, not the kitset product, but can be changed:

Discount %
Commission %
Location Code
Branch Code (Accredo Saturn Only)
Department Code (Accredo Saturn Only)
JC Transaction Type
Job Code
Component Code
Cost Centre Code

In This Section

IN Invoice Line Fields

IN Insufficient Query