Purpose: Understand all the fields and functions of the Product Master window.
Environment: Comsense Enterprise
In this article:
Product Information
| Field Name | Description | Notes |
|---|---|---|
| Code | Comsense stock product code | |
| Product Category | Category of the product | Created and assigned at catalog level |
| Inactive | Day the product is no longer available | The product will not be findable as a managed product |
| Imperial | Imperial catalog description |
Default description on purchase orders, sales orders, quotes Users can update |
| Manufacturer | Product manufacturer |
Comsense maintained products have a 2-3 digit manufacture code User-maintained products have a 4 digit manufacture code |
| Metric | Metric catalog description |
You must manually select metric description on purchase orders Users can update |
| Website | Not currently in use | |
| Product Type | "Product Item" or "Expense Item" |
Comsense includes product items in inventory counts and valuation Comsense does not include expense items in inventory counts and valuation |
| Review Date | Date of the next inventory count of the product |
Tip: Cycle counting keeps your reviews efficient and the inventory count accurate |
| Review Note | Any inventory review notes | |
| Note | ||
| Invalid Note | Changes to a product's structure or definition | Populates via Comsense Catalog team |
Properties Tab
The Properties tab is a list of product properties that affect other aspects of the product, work order, or project e.g. lock type affecting hardware preps.
Equivalent Products Tab
The Equivalent Products tab is a list of product(s) that are interchangeable with the managed product. The managed product must perform the same function as the equivalent product and vice versa. Equivalent products are often used if you stock one version of the product or if you have a default version product for the majority of orders and another version of the product for special circumstances. An example is a tri-packed closer as your managed product and regular arm, parallel arm, and top jamb mounted closer as the equivalent products.
The Sourcing Wizard has a checkbox that prompts the use of equivalent product(s).
Attachments Tab
The Attachments tab holds attachments that are sent out with the product e.g. safety data sheets.
Warehouse Pane
The selected warehouse defines all the tabs to the right of the Warehouse pane.
Product Tab
The selected warehouse defines the Product tab information.
| Field Name | Description | Notes |
|---|---|---|
| Stock Item | If the product is a stock item | Stock items are managed products that are available for stock requisitions and stock replenishment |
| Serialized | Product has a serial number | Generally for products with a warranty |
| Managed Serial Numbers | If you manage the serial numbers | |
| Tax Exempt | Taxes the product is exempt from | E.g. tax-exempt items for disabilities |
| Supplier | Default supplier for the manufacturer | |
| Estimated Lead Time | Uses the estimated lead time for the supplier by default | |
| Requisitioned | If the product is immediately pulled on stock requisitions |
Uncheck only if you want the product pulled after a work order is complete Tip: Be aware of inventory counts when a product is not requisitioned and you are pulling a large number of the product |
| Safety Qty | The minimum allowable shelf quantity | Determines suggested order quantity during stock replenishment |
| Max Requisitioned Qty | The maximum allowable quantity on a stock requisition |
If your order amount exceeds the max requisitioned quantity, Comsense automatically creates a purchase order instead of a stock requisition If you require a stock requisition, you must complete two sourcings |
| Restocking Basis | Applies to the restocking algorithm |
Non-Seasonal: Looks at stock over 12 months of use Seasonal: Looks at stock quarterly Discontinued: No restocking |
| Min Order Qty | The minimum allowable quantity on a purchase order for stock replenishment | |
| Review Cycle | Number of days between each inventory review within the warehouse | Tip: Fit this into your purchasing cycle |
|
Service Center Delivery Program |
Specific delivery program for the product |
Currently only applies to hollow metal doors Creates a separate purchase order for products under specific programs to expedite the delivery |
|
Expense Warehouse Location |
Warehouse location of expense items | Lets the receiving department know the destination for an expense item |
|
Allocated Transaction Button |
Access to pending transactions | E.g. stock requisitions or purchase orders |
|
Detailed Transaction Button |
Access to all past transactions |
Comsense uses FIFO costing formula Tip: View the last receiving report for a product to know the value of any additional product counts |
Cost Tab
The selected warehouse defines the Cost tab information.
| Field Name | Description | Notes |
|---|---|---|
| List Price | Catalog list price | |
| Discount String | Discounts for products outside of your normal buying program | |
| Reorder Cost | If you source a product at a cost lower than net cost on a purchase order | Does not appear on any customer-facing documents |
| Net Cost | The cost of the product at the time it leaves inventory |
User maintained field Update the field if price changes Used in selling price calculations |
| Total Cost | Net cost + freight + overhead |
Total cost is also WIP cost Used in selling price calculations |
Sell Tab
The selected warehouse defines the Sell tab information.
| Field Name | Description | Notes |
|---|---|---|
| List Price | Price on sales order | List price is blank by default |
| Effective Date | Date of any list price or pricing method updates | Must update manually |
| Pricing Method | Primary pricing formula for customer to determine Sell tab List Price |
Default is "Markup on Total Distributor Cost" Update fields if price changes |
Usage Tab
The selected warehouse defines the Usage tab information. The usage tab tracks monthly usage of the product to determine the average daily usage. Comsense uses the usage data to calculate suggested order amounts for stock replenishment.
| Field Name | Description | Notes |
|---|---|---|
| Usage Date | The month of usage tracking | |
| Actual Usage | Amount of product sent on stock requisitions | Does not include purchase orders |
| Adjusted Usage | Manual adjustment to offset any irregular orders for suggested restocking amounts |
Warehouse Locations Tab
The selected warehouse defines the Warehouse Locations tab information.
| Field Name | Description | Notes |
|---|---|---|
| Warehouse Location | Location of the product inside the warehouse | |
| Qty | Quantity of product in that location | |
| Primary | It is the primary warehouse location | You can only fill stock requisitions from primary warehouse locations |
| Active | The location can actively hold this product |
Alternate Tab
The selected warehouse defines the Alternate tab information. The Alternate tab is a list of one or more product(s) that make up the managed product. Use alternate products when you do not stock the complete product but stock all the product components. An Example of alternate products is a lock with a specific core where the lock and core are stocked separately.
The Sourcing Wizard has a checkbox that prompts the use of alternate product(s).
Assembly Tab
The selected warehouse defines the Assembly tab information. The Assembly tab is where you define the parts of the product and required labor to assemble the product. Right-click in the Pieces or Labor pane to add or delete line items.
The Product Assembly window is where you create the transaction for the product assembly.
Comments
Please sign in to leave a comment.