Selections

Display Inactive

Inactive records are hidden from view with financial information and history retained for reporting.

Selected, Inactive records are shown.

Clear, Inactive records are hidden from view.

Auto Select

Selected, selections, filters and sorts will be immediately applied to the list.

Clear, click Select Products to apply selections, filters and sorts to the list.

The default value is set in IC Settings Misc tab.

Select Products(F9)

Click to apply selections, filters and sorts to the grid.

Grid Fields

Product Code

A unique alpha numeric code of up to 28 characters. Data can only be entered when inserting new products.

Description

Further product description.

Stock Group

The Stock Group closing stock and stock on hand values for this item to be attributed to. Also commonly used for grouping inventory reports. These are setup from Navigator > Maintain > Inventory Control > Stock Groups.

Creditor Code

The default Creditor code the product is purchased from.

Standard Cost

A Cost Price for valuation and pricing where fluctuation with latest or average cost is not allowed, for example, an importer not requiring valuation to fluctuate with exchange rate differences.

Latest Cost

The current Cost Price entered for a Stock Receipt.

Average Cost

A weighted average Cost Price of the stock item taking into account all receipted stock. It is recalculated when Receipt transactions are posted, the calculation is as follows:

((Quantity in stock prior to the receipt * Average cost prior to the receipt) + (Quantity receipted * Cost Price for receipt)) / Quantity in stock after receipt is posted = New Average Cost

If the quantity in stock prior to the receipt is negative, the Average cost is reset to the Cost Price for the receipt (that is, the Latest cost).

Category 1, Category 2

For Products. Categories can be added from Navigator > Maintain > Inventory Control > Categories 1&2. Labels can be replaced in IC Settings.

Minimum Quantity, Maximum Quantity

Minimum and maximum quantities to be held in stock. If the quantity in stock falls below the minimum level a quantity is calculated and can be included on the Product, Product by Location (Accredo Saturn Only) and Stock Sales and Valuation report layouts. You can generate a Purchase Order to bring stock to the maximum level by using the Generate Order button on the PO Enter Purchase Order form. Minimum Quantity and Maximum Quantity are only relevant for diminishing items. See Re-Order Report for details of how these fields are used. The fields on this tab are read-only; to edit these values, refer to the Locations tab (Accredo Saturn) or Quantity tab (Accredo Mercury).

Quantity on Order

The quantity ordered from suppliers.

Quantity Allocated

Stock allocated in Sales Orders and Invoices that have not been posted from OE and / or IN. Also includes unposted JC Batches.

Quantity on Back Order

The quantity on back order for Customers.

Quantity in Stock

Stock currently on hand.

Quantity Committed

Stock On Order or Shipped that is already committed to a Job.

Date of Last Manufacture

Date the product was last manufactured.

Quantity Shipped

The quantity on Shipments not yet receipted.

Selling Prices 1-9

Prices, Currency Codes Markups and Margins for Price lists mapped to Price Mapping numbers 1 through 9.
Note: Margins are calculated for base currency prices only from valuation cost.

Grid Toolbar

Expand Toolbar (Alt+F9)

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

Insert (F4)

Opens IC Product to insert a new Product.

Open Details (F12)

Opens the product in IC Product, where you can view or edit details.

Print (Ctrl+P)

Print the list, save it to an Excel worksheet or PDF file.

Filter / Sort List (Ctrl+F2)

Clear Filter / Sort (Ctrl+F3)

Apply or clear a Filter & Sort. The button changes to indicate if a filter and sort is applied.

Customise (Alt+F5)

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

Refresh (F5)

Reloads the list with changes other Users may have made.

Calculate Totals / Clear Totals
(Alt+=)

Toggle on/off total calculation for the list fields where Total is selected in grid customisation.

Create List View (Alt+L)

Save the current list state as a List View.

Customise Toolbar

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

Footer

Record Count

The total number of records shown in the list. Click to refresh the total number.