Products are the foundation of your inventory system, representing all the items and services you buy, sell, assemble, or track. Before you can manage stock levels, create transactions, or generate reports, you must first add products to your account. Each product requires a unique Product Code and can be configured with detailed specifications including pricing, suppliers, units of measure, stock tracking options, and much more.
This comprehensive guide covers everything you need to know about creating and managing your products, from basic setup to advanced configurations like serialization, batch tracking, and bill of materials.
Create a product
Before you can add stock on hand (SOH) for a product to your account or allocate it to a transaction, the item or service must first be added as a product in your account. You can create new products either directly in your account, as described below, or by importing them with the Products CSV template.
To create a new product in your account:
From the main menu, go to Inventory > Products > Add Products.
Enter a unique Product Code and Product Description in the fields provided.
Click Save.
Each product added to your inventory requires a unique Product Code, which is used to identify the specific item or service in your account. Once a new product is created, its product code can only be changed via the Product Change Codes page.
π€ Tip: Avoid using leading zero's, spaces or special characters when providing Product Codes for new products, as they can have adverse effects when importing or exporting data with CSV templates.
Functions from a product
In the top right of a product's a record, there are four functional buttons available:
Delete
Search
Product
Save
Click on the drop-down arrow icon in the Product button to select one of the following options:
Manage in AIM
Create Purchase
Create Quote
Create Order
Create Adjustment
Clone Product
Print Label
You can also use the left and right arow icons, below the Save button, to navigate between product records. The records are listed in alphabetical order, by product code.
Clone products
Use the Clone Product option to replicate the product for a new one. Once Clone product is selected, a pop-up window will appear, in which you will fill out the required details for the new product:
Product Code: Enter a unique code for the new product.
Product Description: Enter a unique description for the new product.
Base Unit Barcode: If known, provide a barcode number for the product's base unit of measure.
Clear Supplier Code and Description: Tick the checkbox if you do not want to copy the existing product's Purchase tab's Supplier details to the new product.
Click Clone Product once the relevant details have been provided, and a new product record will be created, pre-populated with the original product's details.
Details tab
The Details tab in a product's record allows you to configure the basic setup and requirements of your item or service. The following section describes the fields and configuration settings available in a product's Details tab.
Tutorial video: Adding Products into Unleashed - the Details tab
The table below outlines some of the fields available in a product record's Details tab and how they can be updated. Not all fields are required, but most can be updated at any time to align with your real-world uses of the product.
Product Detail field name | Description |
Product Code | The unique code provided for the item or service to identify it in your account. The Product Code cannot be edited in the Details tab. |
Product Description | A description of the item of service. |
Product Group | Use the drop-down menu to select which Product Group the product is associated with. |
Product Sub Group | Use the drop-down menu to select which Product Sub Group the product is associated with, based on the Product Group selected. |
Product Brand | Use the drop-down menu to select which Product Brand the product is associated with. |
Default Label Template | Use the drop-down menus available to select the Label template from your Doc Designer that will be the default printed for Products, Sales Orders, and Purchase Orders. |
Default Label Quantity | Use the drop-down menus available to set how many labels will print for Sales Orders and Purchase Orders. You can select one of the following options:
|
Sales account | If integrated with an accounting provider, use the drop-down menu displayed to select which Sales account invoices completed for the product will export to. The product's Sales account will take precedence over the customer and account's selected sales accounts. |
Cost of Goods Sold (COGS) account | If integrated with an accounting provider, use the drop-down menu to select which COGS account sales journals will export to. |
To the right of these initial fields in the Details tab, you'll also see a summary of your product's current global inventory. These details are automatically calculated to provide a quick insight into your current stock holdings, where each header's described in the table below.
Product inventory overview | Description |
Stock On Hand | The total number of base units currently on hand across all warehouses. Click on the Stock On Hand title to open the Stock On Hand Enquiry. |
Allocated Qty | The total number of base units currently allocated to open Sales Orders, Assemblies, and Warehouse Transfers across all warehouses. Click on the Allocated Qty title to open the Product Allocations report. |
Available Qty | The total number of units from your SOH not allocated to an open Sales Order, Assembly, or Warehouse Transfer. The availability will be negative if the product has been allocated to more transactions than there is SOH currently. Click on the Available Qty title to open the Stock On Hand Enquiry. |
On Purchase Qty | The total number of base units that have been included on Placed status Purchase Orders. Hover over the calendar icon to display the product's next delivery date, based on the soonest Placed status Purchase Order that includes it. Click on the On Purchase Qty title to open the Purchase Enquiry. |
Can Assemble | If the product has the Type setting Assembled Product enabled and has a Bill of Materials (BOM), the Can Assemble value will show the total number of base units that can be assembled based on the BOM's component stock availability across all warehouses. Click on the Can Assemble title to open the product's BOM. |
Stock Value | The total value of all SOH, across all warehouses, based on the product's current Average Landed Cost (ALC). The Stock Value is calculated using the formula SOH x ALC. Click on the Stock Value title to open the Stock On Hand Enquiry. |
Type
The Type section in a product's Details tab, found on the right-hand side underneath the product's inventory overview, allows you to configure how and where a product should be used within your account and processes. When available, use the toggle on each Type setting to enable or disable it for the appropriate purpose, as described in the table below.
Product Type setting | Description |
Never Diminishing | If the product does not manage any SOH and is only expected to be used as an intangible charge, enable the Never Diminishing setting. Disabled by default. |
Assembled Product | |
Component Product | |
Obsolete | If the product is no longer actively used in your account but has been included in completed transactions, enable the Obsolete setting to block it from further use, but retain it for historic reporting. Disabled by default. |
Serialized | If the Serialized Products setting is enabled in your account's company settings, enable Serialized in the product's Type settings to track the product's units. Disabled by default. |
Batch Tracked | If the Batch Tracking setting is enabled in your account's company settings, enable Batch Tracked in the product's Type settings to track the product in batches. Disabled by default. |
Sellable | If the product is not expected to be sold to a customer, disable the Sellable setting. When disabled, the product cannot be added to Sales Quotes, Sales Orders or Credit Notes. Enabled by default. |
Purchasable | If the product is not expected to be purchased from a supplier, disable the Purchasable setting. When disabled, the product cannot be added to a Purchase Order or Supplier Return. Enabled by default. |
Attributes
The Attributes section in the Details tab allows you to add further context to your product, using the Attribute Sets configured in your account's system settings. Select one of your account's Attribute Sets from the drop-down menu displayed, and the Attribute fields from the Attribute Set will become available to update for the product.
Important: Only one Attribute Set can be selected per product. If the fields of an Attribute Set are saved, then another Attribute Set is selected and its attributes and saved, the original Attribute Set's attributes will be cleared from the product.
International Commerce Attributes
If products from your inventory are to be sold or purchased internationally, enable the International Commerce Codes setting in your account's company configurations to have the option to fill in the International Commerce Attributes in a product's record.
The International Commerce Attributes section allows you to provide the following details per product, so that you can produce compliant Commercial Invoices for Sales Orders due to be dispatched overseas:
International Commerce Code: A 6-14 digit code that Customs authorities use to identify goods that are distributed internationally. Also known as a Commodity Code, Harmonized Code, HS Code, or Tariff Code.
Customs Description: A simplified description of the product to appear on a Commercial Invoice.
Country of Origin: A drop-down menu to select the product's country of origin.
Supplementary Unit: A drop-down menu to allocate a unit of measure appropriate for customs.
Units of Measure
The Units of Measure section in a product's record is used to standardize how your product quantities are counted when they're purchased, stored, and sold. Each type of unit of measure used for your inventory must be added to your account's system settings before it can be set up in a product's record.
Every product must have a base unit of measure, which describes the amount for one unit in your product's SOH. This base unit of measure is used to describe your product's total SOH quantity and the amounts allocated to and used in transactions processed from your inventory. You can also establish alternative units of measure, which are available to use in Purchase Orders, to account for purchasing products in larger quantities or amounts.
Set up products with units of measures
When a product doesn't have a base unit set, click Add New in the product record's Unit of Measure section, and the "Add Base Unit of Measure" window will be displayed. Use the Unit of Measure dropdown menu to select one of your system settings' measures that describes the product's stock units. Fill in the remaining fields in the window, including Pack size, Barcode, Weight, Width, Height, and Depth to add further detail to the product's base unit of measure, then click Add.
π Note: Once a base unit of measure has been saved against a product and a transaction has been completed, the base unit of measure cannot be changed.
Once a base unit is saved, each time you select Add New, the "Add Unit of Measure" window will be shown. This time, use the Unit of Measure dropdown menu to select one of your system settings' measures to describe how the product is purchased, then provide its Conversion Rate to clarify how many base units make up this unit of measure. Tick the Available in Purchasing checkbox to make this unit of measure available to select when creating Purchase Orders for the product, enter the unit of measure's Pack size, Barcode, Weight, Width, Height, and Depth, and click Add.
When the alternative unit of measure is selected for the product on a Purchase Order, when the Purchase Order is receipted, the conversion rate for the unit of measure will be used to calculate how many base units are received into stock.
Notes, Reminder, and Comments
The Notes, Reminder, and Comments fields in a product record's Details tab are free text fields that allow you to include further context on your products and can be updated at any time.
Text entered into the Reminders field will always show up as a pop-up window for any user adding the product to a Sales Quote, Sales Order, or Purchase Order.
Any text provided in the product's Comments field will automatically populate in the Sales Quote and Sales Order, or Purchase Order's line comment for the product, provided the respective "Add to Sales Quotes & Sales Orders" and "Add to Purchase Orders" checkboxes are ticked.
Inventory tab
The Inventory tab in a product's record shows you a breakdown of your product's SOH, along with bin locations and minimum and maximum stock levels per warehouse. The functions available in your products' Inventory tab will differ depending on whether the Per Warehouse Controls setting is enabled within the account's company settings.
π Note: If a product has the Type setting Never Diminishing enabled, the Inventory tab will not be available.
Tutorial Video: How to use the Inventory Tab
At the top of the Inventory tab is a Quick Transfer button, which allows you to move the product's SOH from one warehouse to another without leaving the product record's page. Below this, you'll see a grid showing the product's stock holding and stock alert level, per warehouse.
Inventory grid column header | Description |
Warehouse | Displays the warehouse's name in alphabetical order. |
Bin Location | If Per Warehouse Controls are enabled, the Bin Location field displays the product's location within the warehouse. Click on the warehouse's Bin Location field to update it. |
Min Stock Level | If Per Warehouse Controls are enabled, the Min Stock Level advises the minimum number of units the product should have available in the warehouse. Click on the warehouse's Min Stock Level field to update it. |
Max Stock Level | If Per Warehouse Controls are enabled, the Max Stock Level advises the maximum number of units the product should have available in the warehouse. Click on the warehouse's Max Stock Level field to update it. |
Available Qty | Displays the number of units from the warehouse's SOH that are not allocated to Sales Orders, Assemblies, or Warehouse Transfers. The Available quantity will show as negative if the product is over-allocated. |
On Purchase | Displays the total number of units, per warehouse, currently included on Purchase Orders in Placed status for the product. |
Stock On Hand | Displays the the total number of units currently stored in the warehouse. |
Alert | Indicates whether a product's stock availability in the warehouse has breached the Min or Max stock level parameters. The Alert field will display:
|
Stock Value | Displays the total stock value calculated for the warehouse's SOH, based on the product's current Average Landed Cost (ALC). Where, Stock Value = SOH x ALC. |
π€ Tip: Only one Bin Location field is available per warehouse for a product. If your product is stored in multiple warehouse locations, each location can be listed within the warehouse's single Bin Location field, but the locations entered cannot be individually managed.
How the Reorder Report uses Stock Level alerts
The Min and Max Stock Levels in a product's Inventory tab are critical tools for maintaining optimal inventory levels. They serve two important functions:
Minimum Stock Level: Acts as a trigger point. When your product's availability in a warehouse falls below this threshold, it's flagged for replenishment in the Reorder Report.
Maximum Stock Level: Represents the target inventory level after restocking. The Reorder Report will suggest quantities designed to bring your stock up to this maximum level.
When a product's warehouse has a Low stock alert, the Reorder Report's Suggested Replenishment column will advise how much stock of the product needs to be purchased, assembled, or transferred to bring the warehouse's stock availability to its Max Stock Level.
If the Min Stock Level is left blank, it is assumed to be zero, and if the Max Stock Level is blank, the Reorder Report will calculate how much stock is required to fulfill all current allocations. The Reorder Report's Suggested Replenishment calculation takes existing Placed Purchase Orders, Parked Assemblies, and incoming Parked Warehouse Transfers into account for each product, to ensure duplicate orders, assemblies, and transfers aren't created and resulting in an overstock.
If certain items, particularly those that are part of a Bill of Materials (BOM), don't appear in the Reorder Report as expected, check the following:
Verify Stock Level Configuration: Ensure that minimum and maximum stock levels are defined for each BOM component in their respective product records. Without this configuration, components may be excluded from the report.
Check Report Filters: When using the "under minimum" filter in the Reorder Report, only items with stock below the minimum level are displayed. Confirm all relevant items meet this criterion to appear.
Set Appropriate Thresholds: Adjust and save proper stock levels for any missing items to ensure accurate reporting during the next reorder cycle.
π€ Tip: Properly configuring minimum and maximum stock levels is essential for effective inventory management. Take time to set these values based on your actual usage patterns, lead times, and business requirements to avoid both stockouts and excess inventory.
Purchase tab
The Purchase tab in a product record helps you automate and streamline your purchasing processes by allowing you to identify default suppliers for your stock and set purchase prices at the product, supplier, and quantity levels.
Tutorial video: Adding Products into Unleashed - Purchase tab
At the top of the Purchase tab in the product's record, you'll find the following optional, editable fields:
Default Purchase Price: The price that will populate for the product when added to a Purchase Order, if no Supplier or Quantity price applies.
Minimum Order Quantity: The smallest number of units that should be purchased per Purchase Order (PO). If less than the product's Minimum Order Quantity is added to a PO, a warning will be displayed.
Default Purchasing Unit: The default unit of measure to be used when creating POs, if no Supplier Default unit of measure applies. Only available when at least a base unit of measure is saved on the product, use the drop-down menu to select from the unit of measures currently saved in the Details tab.
Purchase Tax Rate: The default tax rate that will apply when the product is added to a PO, if the supplier is taxable. If used, the product's Purchase Tax Rate will take precedence over the supplier's and your account default's tax rates.
Nominal Cost: An advisory cost for one base unit of the product, used when the product has zero SOH and no Last Cost, to calculate a margin estimate in Sales Quotes.
You'll also see the following locked fields, which cannot be edited directly in the product's Purchase tab:
Average Land Cost: Displays the product's current Average Landed Cost (ALC).
Last Cost: Displays the total unit cost of product was added to your SOH with, from the most recently receipted or re-costed Purchase Order, or completed Assembly.
Suppliers tab
When managing your inventory and purchasing products from different suppliers, it can be helpful to set up specific purchase prices and details for each supplier defined per product. These pre-defined prices and parameters will automatically apply when the product's added to a PO for the supplier, allowing for more accurate and efficient purchasing processes.
π Note: The supplier must already exist in your account before it can be added to a product.
Use the Supplier Code field in the product's Purchase > Suppliers tab to search and select the supplier you wish to set up. You will then see a list of optional fields available, to provide supplier-specific parameters:
Supplier Product Code
Supplier Product Description
Unit of Measure
Min. Order Quantity
Purchase Price
Fill in the appropriate information for the supplier you have selected, then click Add. The supplier and details provided will then be displayed in the Suppliers tab's grid, along with the supplier's currency and Lead Time. Click on a supplier in the grid to edit their Supplier Product Code, Supplier Product Description, Min. Order Quantity, Purchase Price, or Lead Time, at any time.
π€ Tip: You can update a product's supplier details in bulk using the Import Product Suppliers template.
Suppliers tab grid explained
Suppliers tab grid explained
The following section describes each field displayed, per supplier, in a product's Suppliers tab's grid:
Supplier Product Code: If your supplier uses their own product codes, that don't match yours, enter their product code here. The Supplier Product Code will populate the appropriate product when searched for in a PO.
Supplier Product Description: If your supplier uses their own product descriptions, enter their product description here.
Unit of Measure: Use the drop-down menu to select which of the product's purchasing unit of measures you typically purchase the product in, from this supplier, to automatically populate when creating a PO. The unit of measure must be set up in the product's Details tab first.
Min. Order Quantity: The minimum number of units, based on the Unit of Measure selected, that can be ordered from the supplier, per PO.
Purchase Price: The unit price that will automatically populate when the product is added to a PO for the supplier. This will take precedence over the product's Default Purchase Price.
Supplier Currency: The supplier's currency.
Lead Time (days): Initially populated from the Supplier's record, the number of days it takes for this supplier to deliver this product. Update the Lead Time if the product's lead time differs from the supplier's default lead time.
Action cog: Hover over the action cog to select either Add Purchase, Default, or Delete.
Quantity Prices
If a supplier offers a standardized discount or special pricing when purchasing their products, you define them in a product's Quantity Prices tab. To add a Quantity Price for a product's supplier, ensure the supplier has been added to the Suppliers tab in the product's Purchase tab first. Then, you can go to the Quantity Prices tab, search and select the supplier in the Supplier Code field, and enter the parameters of the supplier's price break in the remaining fields: Unit of Measure, Min Quantity, Price/Discount, Price Type, and click Add.
Once added, the Quantity Price will be shown in the tab's grid . You can update each price break's parameters at any time by clicking on the fields in the appropriate row.
π€ Tip: You can update a product supplier's Quantity Prices in bulk using the Import Supplier Quantity Prices template.
Quantity Prices grid explained
Quantity Prices grid explained
Supplier Code: The unique code from the supplier's record.
Supplier Name: The name of the supplier.
Unit of Measure: Use the drop-down menu to select which of the product's purchasing unit of measures the quantity price break applies to when purchasing from this supplier. The unit of measure must be set up in the product's Details tab first.
Min. Quantity: The minimum quantity required for the price or discount to apply.
Price/Discount: A numeric value to advise either the unit price or percentage discount to apply to the product when the Min. Quantity is ordered, based on the Price Type selected.
Price Type: Use the drop-down menu to advise whether the Price/Discount value is a Fixed Price (unit price) or Discount %.
Price: An uneditable field that displays the calculated unit price when the product supplier's quantity prices.
Currency: An uneditable field that displays the supplier's currency.
Comments: A free text field for any notes relevant to the quantity price.
Action cog: Hover over the action cog icon to select either Add Purchase or Delete.
Quantity Prices example
Quantity Prices example
To further demonstrate how the Quantity Price structure can be used, let's say our supplier "Hamper Time Inc" supplies our product "CranJam". Hamper Time Inc offers a default purchase price of 4.82 per CranJam unit, but offers a 25% discount if at least 50 units are ordered, and 30% discount if more than 100 units are ordered, which have been added to the product's Quantity Prices tab.
When a PO for Hamper Time Inc is created and CranJam is added with a quantity of 60, the unit price is calculated at 25% off 4.82, to be 3.62. If 150 units of CranJam are ordered, the unit price is calculated as 30% off 3.82, to be 3.37.
Sale tab
The Sale tab in a product record helps you automate and streamline your selling processes by allowing you to set sale prices at the product, price tier, and quantity levels.
Tutorial video: Adding Products into Unleashed - Sales tab
At the top of the Sales tab, you'll see the following editable fields:
Default Sell Price: The unit price that will populate when the product's added to a Sales Order (SO) or Sales Quote (SQ). This can be overridden by a Sell Price Tier, Quantity Price, or Customer Pricing, if provided.
Minimum Sell Price: The minimum price the product can be sold for. If a lower price is entered, a warning will be shown on the SO or SQ. The minimum sell price warning does not apply to quantity prices or customer pricing.
Minimum Sale Quantity: The minimum number of units that can be ordered on a SO or SQ. If a lower quantity is ordered a warning will be shown in the SO or SQ.
Sales Tax Rate: The default tax rate that will apply when the product is added to a SO or SQ, if the customer is taxable. If used, the product's Sales Tax Rate will take precedence over the customer's and your account default's tax rates. use the drop down menu to select one Sales Tax from your Taxes.
Automatic Charge: If Automatic Product Charge is enabled in your company configuration settings, enter the sale value that will be automatically added as a charge line to an SO when the product's added.
Below these, you'll then find the following uneditable fields that provide further context on the product:
Nominal Cost: Populated from the product's Purchase tab, displays the advisory cost used to calculate the product's margin on an SQ, when the product has no stock for an ALC or Last Cost.
Average Land Cost: Displays the product's current Average Landed Cost (ALC).
Last Cost: Displays the total unit cost of product was added to your SOH with, from the most recently receipted or re-costed Purchase Order, or completed Assembly.
Default Purchase Price: Populated from the product's Purchase tab, displays the product's default purchase price.
Sell Price Tiers
Within the product's Sale tab, you'll find the Sell Price Tiers tab, which is used to define the default sale price for the product, depending on the price tier the ordering customer is assigned in their customer record. Up to ten Price Tiers are available to use and will be displayed in a grid, showing the Tier name and Current Price, in the Sell Price Tier tab. You can head to Settings > System > Sell Price Tiers to set a custom name per tier, helping you easily identify and apply the tiers as appropriate.
To set or update a price for each sell price tier in a product, you can either:
Enter the price in the Tier's Current Price field in the product's Sell Price Tier tab.
Bulk update each sell price tier via a CSV, using the Import Products template.
Apply a Markup Price.
Markup Prices
If you want to set up the Sell Price Tiers in a product by applying a percentage increase on one of the product's established prices or costs, you can use the Markup Price function. Click on the View Markup Prices in the product's Sell Price Tiers tab, and the grid will expand to include the following additional fields:
Margin %
Markup From
Markup %
Markup Price
Apply Markup Price
Use the drop-down menu in the Markup From field to select which price or cost of the product the tier price will be increased from:
Nominal Cost
Average Land Cost
Last Cost
Default Purchase Price
Default Sell Price
Enter a numerical value in the Markup% field for the percentage increase that will apply, e.g., enter 5 for a 5% increase on the Markup From value, and the Markup Price field will show what the calculated price would be, then select Apply Markup Price. The product's tier's Current Price will then update, based on the calculated increase. To update the Current Price for all tiers in a product's Sell Price Tier tab by a markup percentage, hover over the action cog icon in the header of the grid and select Apply All Markup Prices.
The Margin% field for each sell price tier displays a percentage calculated as the margin between the tier's Current Price and the product's current ALC. If the product has no stock, therefore no ALC, the product's Last Cost is used instead.
Warning: The Markup Price function will not dynamically update the Current Price in a product's tier if the value of the Markup From price or cost selected changes. You must manually apply the markup each time the current price needs to be recalculated.
Quantity Prices
If you want to provide your customers with standardized discounts based on the quantities they order, you can set them up to automatically apply to your SO's via the Quantity Prices tab in a product's Sales tab.
Tutorial video: Setting Quantity Discounts for your customers
To set up quantity price breaks for the sale of a product, use the parameter fields in the Sale tab's Quantity Prices tab: Min Quantity, Price/Discount, Price Type, Discount From and click Add. Enter the appropriate parameters in the fields available in the Sale tab's Quantity prices tab and select Add.
Once added, the selling Quantity Price will be shown in the tab's grid. You can update each price break's parameters at any time by clicking on the fields in the appropriate row.
π€ Tip: You can update a product's selling Quantity Prices in bulk using the Import Product Pricing template.
Quantity Prices grid explained
Quantity Prices grid explained
Min. Quantity: The minimum quantity that must be entered in the SO for the discount price to apply.
Valid From: If the discount is only applicable from a certain date, use Valid From to set a date from which the discount price will apply.
Valid To: If the discount is only applicable until a certain date, use Valid To to set the last date when the discount price will apply.
Price/Discount %: A numeric value to advise either the unit price or percentage discount to apply to the product when the Min. Quantity is ordered, based on the Price Type selected.
Price Type: Use the drop-down menu to advise whether the Price/Discount value is a Fixed Price (unit price) or Discount %.
Show Discount: Use the checkbox to determine whether the discount rate calculated is visible on the SO.
Discount From: Use the drop-down menu to select whether the discount is applied to the product's Default Dell Price or the Customer Price Tier, if applicable.
Comments: Enter any further notes relevant to the quantity price break.
Delete: Use the bin icon in the Delete column to remove the price break.
Transactions tab
The Transactions tab in a product's record displays an overview of all completed transactions the product was included in, providing an easy-to-view history of the stock's movements the product's to date.
Initially, the product's Transactions tab's view will always mirror your Transaction Enquiry's default grid layout. You can adjust the order, position, and grouping of the Transaction tab's details by dragging and dropping the grid headers within the Transactions tab. And if you want to change which columns are displayed, either create or update your Transaction Enquiry's default grid layout.
π Note: If a product has the Type setting Never Diminishing enabled, the Transactions tab will not be available.
Tutorial video: A guide to the products Transactions tab
References tab
The References tab in a product's record displays an overview of open transactions the product is currently included on, allowing you to see, simply, which transactions the product's currently allocated to.
The References tab shows the Transaction Ref and Transaction Type for each open transaction the product is included on, and displays the total quantity included on the transaction.
Tutorial video: How to use the References tab
Production tab
The Production tab provides an overview of the Bill of Materials (BOM) that the product's included in, as either a component or the assembled product.
Tutorial Video: How to use the Production tab
Assembled product
If the product has the Type detail Assembled Product enabled, and a BOM has been created to outline which components are required to make it, a link to the BOM will be displayed in a blue banner at the top of the Production tab.
Bills of Material including this Product as a Component
If the product has the Type detail Component Product enabled, and is included as a component line to an assembled product's BOM, the BOM will be displayed in the Product tab's grid layout.
By default, only active BOMs the product is a component of will be displayed, but you can tick the Show Obsolete checkbox above the grid's headers to include obsolete BOMs the product's a component of too.
This grid in the Production tab will display the following details, per BOM the product is a component of:
Bill Number: The BOM's reference number.
Product Code: The code of the product being assembled on the BOM.
Product Description: The description of the product being assembled on the BOM.
Can Auto Assemble: If the BOM has Can Auto-Assemble enabled, a tick icon is displayed; otherwise, a cross icon is shown.
Can Auto Disassemble: If the BOM has Can Auto-Disassemble enabled, a tick icon is displayed; otherwise a cross icon is shown.
Obsolete: If the BOM is toggled as Obsolete, a tick icon is displayed. If the BOM is active, a cross icon will display.
Quantity: Displays how many units of the component product have been set in the BOM.
Costs tab
The Costs tab provides traceability of how the product's ALC has changed over time, listing each transaction that has affected your product's value to date.
Tutorial Video: How to use the Costs tab
At the top of the Costs tab, you'll find the following uneditable fields that provide context on the product's current value:
Average Land Cost: Displays the product's current Average Landed Cost (ALC).
Last Cost: Displays the total unit cost of product was added to your SOH with, from the most recently receipted or re-costed Purchase Order, or completed Assembly.
The grid in the Costs tab will always mirror your Costing Analysis Report's default grid layout. You can adjust the order, position, and grouping of the Costs tab's details by dragging and dropping the grid headers within the Costs tab. But if you want to change which columns are displayed, either create or update your Costing Analysis Report's default grid layout.
Attachments tab
Upload and manage product images and documents via the product record's Attachments tab. The files available in the product's record will then be stored in your File Library and available to attach to the emails sent for transactions the product is included on. Use the grey space at the top of the Attachments tab to either upload local files or allocate files from your File Library to your product.
If you've attached an image to the product, you can set it to be the default image or default label image by hovering over the action cog icon in the Attachments grid and selecting Default Image and Default Label Image.
π Note:
The upload file size limit is 20MB, per attachment.
Supported file formats are: .png, .gif, .jpg, .jpeg, .bmp, .webp, .csv, .pdf, .doc, .xls, .xlsx, .docx, .msg, .dwg, .stp, .dxf, .ppt, .pptx.
Tutorial Video: How to use the Attachments tab
Serial and Batch Numbers tab
If the product has the Type detail Serialized or Batch Tracked enabled, a Serial Numbers or Batch Numbers tab will be available in the product's record. The Serial Numbers and Batch Numbers tabs provide an overview of the serial and batch numbers that have been included on completed transactions and are currently available from your SOH.
Serial & Batch Numbers Tab Tutorial Video
Serial Numbers tab
If your product is serialized, a Serial Numbers tab will list all the available serial numbers across your warehouses, providing a historic view of the transactions they've been included in. You can filter the Serial Numbers by Warehouse, Status, and serial number. Click on a serial number in the grid and a pop-up window will appear, detailing the transactions the serial number has been included in and the dates the transactions were completed.
Batch Numbers tab
If your product is batch tracked, a Batch Numbers tab will list all the available batch numbers across your warehouses. Filter the list by warehouse, Status, Batch Number or Expiry Date to refine the tab's view. Click on the batch number, and a pop-up window will appear, detailing the transactions the batch number has been included on, the dates the transactions were completed, and quantities involved.
Frequently asked questions
Why can't I obsolete a product?
Why can't I obsolete a product?
A product cannot be obsoleted if it currently holds any SOH or has been allocated to an open transaction or active Bill of Materials (BOM). Go to the product's Inventory tab to locate any existing SOH, the References tab to identify any open transactions, and the Production tab to identify non-obsolete BOMs.
Why can't a product be deleted?
Why can't a product be deleted?
A product cannot be deleted if it has ever had SOH or been included on any transaction (deleted or completed); this is to maintain the product's historical record for reporting purposes. Obsolete the product if it cannot be deleted.
Why is a product missing the Inventory tab?
Why is a product missing the Inventory tab?
If a product has the "Never Diminishing" setting turned on, it is not expected to track inventory or stock movements, so it does not require an Inventory ta. Go to the product's Details tab, and under "Type", check the "Never Diminishing" option to confirm and update if needed.
Can a product's Last Cost be manually updated?
Can a product's Last Cost be manually updated?
The Last Cost for a product cannot be updated directly in the product's record, but you can manually set or update a product's "Last Cost" using the Import Products template.