Product Details

View and edit product master records. The product form is organized into a Details tab, a Supplier Costs / Bar Codes tab, a Locations tab (Saturn only), a Stock History tab (once the product has been saved), an Information tab, and an automatically added Custom Fields tab. A dashboard with widgets displays stock quantities, pending movements, activity values, and related links.

Header

The product header displays the product description and provides navigation links to related pages:

Stock Group Link to the product's stock group record. Displayed when the product has a StockGroupCode assigned.
Pending Movements Link to the Pending Stock Movements page, pre-filtered for this product.
Product Quantities Link to the Product Quantities page for this product.
Tracking Quantities Link to the Product Tracking Quantities page (Saturn only). Only displayed when the product is serial/lot tracked (IsTracked is true).
Components Link to the Components (Bill of Materials) page. Displayed when the product's Component Mode is not "None", or when the product already has parts (HasParts is true).

Details Tab - Product Information

ProductCode The unique identifier for this product. This is a code input field; it can only be set when creating a new product.
Description The product name or short description.
Details Extended product description or additional information.
Comment Internal notes or comments about this product.
AlternateCode An alternative product code or reference number.
BarCode The primary barcode for this product. Additional barcodes can be managed in the Supplier Costs / Bar Codes tab.
CreditorCode The default supplier (creditor) for this product.
GstCode The tax code that applies to this product.

Details Tab - Categories & Groups

StockGroupCode The stock group this product belongs to. Determines GL account posting.
SalesGroupCode Sales analysis group classification.
ExpenseCode Expense analysis code. Looks up from the APANL table (AnalysisCode / AnalysisName). Allows empty values.
Category1 First user-defined category for product classification.
Category2 Second user-defined category for product classification.

Details Tab - Cost Prices

This section is collapsible (default expanded) and hidden when the user does not have cost price viewing permission.

StandardCost The standard cost assigned to this product.
LatestCost The most recent purchase cost for this product.
AverageCost The weighted average cost calculated from purchase history.

Details Tab - Sell Prices

This section is collapsible (default expanded) and hidden when the user does not have sell price viewing permission. It contains the Pricing Widget.

DiscountScheduleCode The discount schedule that applies to this product.
Price Date A date selector that repopulates the pricing grid to show the price list effective at the selected date for each price group. Defaults to the system date. Clearing the date lists every price list. The selection persists when switching between browse and edit modes.
Price UOM A dropdown to select which Unit of Measure to display prices in. Only visible when UOM is enabled. Defaults to the product's SaleUOMCode, falling back to BaseUOMCode.
Pricing Grid An editable grid displaying pricing information. Columns include:
  • PriceCode - Price list code (read-only)
  • Name - Price list name (read-only)
  • Price (SellingPrice) - The selling price (editable)
  • UOM Price (UOMSellingPrice) - Price converted to selected UOM (read-only, only when UOM enabled)
  • Markup % - Markup percentage (editable)
  • Currency - Currency code (read-only)
  • Markup Price - Markup base price code (read-only)
  • Rounding - Rounding direction (editable)
  • Rounding Unit - Rounding unit value (editable)
  • Margin % - Margin percentage (read-only)
  • Price Number - Price level number (read-only)
Markup Prices A toolbar button that recalculates selling prices based on markup percentages and the configured markup basis (Standard Cost, Latest Cost, Average Cost, or another Price). Requires both cost price read permission and sell price write permission. Disabled when markup basis is set to "None". When foreign currencies are involved, an exchange rate dialog is shown for confirmation.

Details Tab - Units of Measure

This section is collapsible (default collapsed) and only visible when UOM is active in the system.

Base UOM Grid A single-row grid for the product's base unit of measure. The UOMCode lookup is filtered to show only base UOMs (Base=true, Inactive=false). Columns: UOMCode, Name, Description, UOM Group, Multiplier, Decimals, Comment.
Other UOMs Grid A grid for additional units of measure. The UOMCode lookup is filtered to show UOMs in the same UOM Group as the Base UOM, excluding the Base UOM code and any already-added codes. Columns: UOMCode, Name, Description, UOM Group, Multiplier, Decimals, Comment.
Defaults Three dropdown fields for default UOM assignments, populated from the combined list of Base UOM and Other UOMs:
  • SaleUOMCode - Default unit of measure for sales
  • PurchaseUOMCode - Default unit of measure for purchases
  • ManufactureUOMCode - Default unit of measure for manufacturing

Details Tab - Tracking

This section is collapsible (default expanded) and visibility is controlled by the Products Tracking read permission.

SerialTracked Controls whether individual serial numbers are tracked for this product.
LotTracked Controls whether lot/batch numbers are tracked.
ExpiryDateTracked Controls whether expiry dates are tracked for lots.
SerialNoLength Maximum length for serial numbers.
LotNoLength Maximum length for lot numbers.
MinimumExpiryCount The minimum time count before expiry for warnings.
MinimumExpiryUnit The unit of time for the minimum expiry count.
GenerateLotNos Controls automatic generation of lot numbers.
RetainYearsTracking Number of years to retain serial/lot tracking history.
SupplySingleLot When enabled, sales transactions must use a single lot per line.

Details Tab - Product Settings

ComponentMode Defines how this product participates in bill of materials.
NonDiminishing When enabled, this product does not reduce physical inventory on issue.
ManuallyCosted When enabled, uses Standard Cost for inventory valuation instead of Average Cost.
Inactive When enabled, the product is hidden from normal views and cannot be used in new transactions.
Discontinued Marks the product as discontinued.
BackOrder Controls whether backorders are allowed for this product.

Details Tab - Additional Fields

Unit Short unit description or abbreviation.
Weight The weight of one unit of this product.
Volume The volume of one unit of this product.
CommissionPercentage The default commission percentage for sales of this product.
LeadTime The typical lead time for ordering and receiving this product.

Details Tab - Image

The product image widget displays the product's associated image. In edit mode, images can be uploaded by dragging and dropping an image file onto the widget. Supported formats include JPG, PNG, and GIF. The viewer supports zoom, pan, and rotation.

Details Tab - Information

A free-form text field for additional notes and information about the product. Editable when the form is in edit mode.

Supplier Costs / Bar Codes Tab

Supplier Costs Grid

An editable grid for managing supplier cost records from the product's Supplier sub-collection (read-only while browsing). Rows can be added and deleted in edit mode. Entering a CreditorCode looks up the supplier from the APCRED table and auto-fills the supplier name and currency; the code must be unique within the grid. Deleting the row of the product's default supplier clears the default CreditorCode on the Details tab. The Effective Cost and Effective Standard Cost columns are hidden when the user lacks the Supplier Cost Prices read permission. Key fields include:

CreditorCode / CreditorName The supplier identification.
CurrencyCode The currency of the supplier cost.
SupplierCost / SupplierCostBs The supplier's cost price and base currency equivalent.
SupplierStandardCost / SupplierStandardCostBs The supplier's standard cost price and base currency equivalent.
SupplierDiscount The discount percentage from the supplier.
EffectiveCost / EffectiveCostBs The effective cost after discount, and base currency equivalent.
DateOfLastReceipt Date of last receipt from this supplier.
Comment Notes about this supplier cost record.

Bar Codes Grid

An editable grid for managing additional product barcodes. Fields include:

BarCode The barcode value.
UOMCode / UOMMultiplier Unit of measure for this barcode. Only visible when UOM is active. Looks up from the COUOM table.
CreditorCode Optional supplier code associated with this barcode. Looks up from the APCRED table.
CustomerCode Optional customer code associated with this barcode. Looks up from the ARCUST table.
Comment Notes about this barcode.

Locations Tab (Saturn Only)

This tab is only available in Saturn multi-location editions. It displays an editable grid of location-specific data for this product.

Editable Fields

LocationCode / LocationName The stock location. LocationCode is editable with lookup from the ICLOCN table; LocationName is read-only.
BinCode The bin location within the warehouse. Uses a bin code editor filtered by the row's LocationCode.
MinimumQuantity Minimum stock quantity for this location.
MaximumQuantity Maximum stock quantity for this location.

Read-Only Quantity Fields

The grid also displays these read-only quantity columns:

On Hand, Available, On Order, Allocated, On Back Order, Theoretical, Reorder Point, In Transit, Shipped, Committed, Returned, Transfer In, Transfer Out, In Production, Stocktake Variance.

Read-Only Period/Year Fields

Period-to-date and year-to-date quantities and values are available as additional columns: Sales Qty, Receipts, Adjustments, Transfers, Usage, Manufactured, Opening Stock, Non Diminishing, Closing (for both PTD and YTD). Value columns include: Sales Value, Cost of Sales, Cost Value, Revaluation (for both PTD and YTD). Also includes Transferred Value, GL Closing Stock Account, GL Stock On Hand Account, and date fields (Last Sale, Last Receipt, Last Usage, Last Manufacture).

UOM Columns (when UOM active)

When UOM is active, additional UOM quantity columns are available: UOM Code, UOM Multiplier, Base UOM, and UOM equivalents for On Hand, Available, On Order, Allocated, On Back Order, Theoretical, In Transit, Shipped, Committed, Returned, In Production, Transfer In, Transfer Out, and Stocktake Variance.

Stock History Tab

Displays stock history data for the product. This tab is only available when the product has been saved (has a ProductCode).

Dashboard Widgets

The product form includes a configurable dashboard. In browse mode it shows the full set of widgets below; in edit mode the dashboard is reduced to Quick Actions and Links.

Quick Actions Provides quick access buttons: Transactions (opens the IC Transaction List filtered to this product and the current period) and Show Prices / Hide Prices (toggles visibility of the Cost Prices and Sell Prices sections). When the user has the Reports permission, a Print section also offers Product Report and Label printing.
Activity & Values Shows period-to-date and year-to-date activity quantities (Opening, Sales, Receipts, Usage, Manufactured, Adjustments, Non-Diminishing, Closing), values (Cost Value, Sales, Cost of Sales, Revaluation, Margin), and latest activity dates (Last Sale, Last Receipt, Last Usage, Last Manufacture). Visibility is controlled by the Products Activity read permission.
Stock Quantities Displays a breakdown of stock quantities: In Stock, Allocated, Available, Stocktake Variance, On Order, Shipped, On Back Order, Committed, Returned, In Production, and Theoretical. In Saturn mode, includes Transfer In/Out and a location dropdown to view quantities per location (or "All Locations").
Component Of Shows which other products use this product as a component in their bill of materials. Displays Product Code, Description, Component Mode, Quantity, and UOM. Rows are clickable to navigate to the parent product. Supports pop-out to a full-screen dialog. Visibility is controlled by the Components read permission.
Pending Movements Displays pending stock movements for this product. Rows are clickable to navigate to the source document (IN Invoice or OE Order). Supports pop-out to a full-screen dialog.
Memos View and manage memos related to the product.
Links View and manage links (attachments and references) related to the product. Available in both browse and edit modes.

Permissions

The product form respects a number of permission-based visibility and edit controls. Editing requires Write on the Products permission; inserting, duplicating, and deleting require Control. The following table summarises the section-level controls:

Products (Sell Prices) Read shows the Sell Prices section; Write allows editing selling prices and markup percentages.
Products (Cost Prices) Read shows the Cost Prices section (and enables the Markup Prices button); Write allows editing Standard, Latest, and Average cost.
Products (Tracking) Read shows the Tracking section; Write allows editing tracking fields.
Products (UOM) Read shows the Units of Measure section (when UOM is active); Write allows editing UOM configurations.
Products (Commissions) Read shows the Commission Percentage field; Write allows editing it.
Products (Supplier Cost Prices) Read shows the Effective Cost and Effective Standard Cost columns in the Supplier Costs grid.
Products (Activity) Read shows the Activity & Values dashboard widget.
Components Read shows the Component Of dashboard widget.
Reports Allow shows the Product Report and Label print actions in the Quick Actions widget.