Screenshot:Product

Back to Screens_Reference

Product

Product master data window is the place where you can easily organize and centralize the key data of the items of any type you might manage as part of the organization processes and/or activities.

Product

Product window allows the creation of items such as products, raw materials, resources, services, etc.

• Organization : Organizational entity within client
• Manage Variants
• Search Key : A fast method for finding a particular record.
• Name : A non-unique identifier for a record/document often used as a search tool.
• Image : A visual picture used to describe an item.
• UOM : A non monetary unit of measure.
• Product Category : A classification of items based on similar characteristics or attributes.
• Tax Category : A classification of tax options based on similar characteristics or attributes.
• Is Generic
• Purchase : An indication that an item may be purchased by a business partner.
• Sale : An indication that an item may be sold by a business partner.
• Generic Product
• Description : A space to write additional related information.
• Product Type : An important classification used to determine the accounting and management of a product.
• Stocked : Organization stocks this product
• Weight : Weight of a product
• UOM for Weight : Standard Unit of Measure for Weight
• Attribute Set : A group of attributes which are assigned to a selected product.
• Use Attribute Set Value As : A distinct Attribute Set Value characteristic.
• Attribute Set Value : An attribute associated with a product as part of an attribute set.
• Active : A flag indicating whether this record is available for use or de-activated.
• UPC/EAN : A bar code with a number to identify a product.
• Brand
• Sales Representative : The person in charge of a document.
• Business Partner : Identifies a Business Partner
• Image URL : An address for the product image which can be accessed via internet.
• Description URL : An address for the product description which can be accessed via internet.
• Production : An indication that an item is being used in production.
• Process Plan : A guide stating how a certain item must move through the transformation process.
• Summary Level : A means of grouping fields in order to view or hide additional information.
• Storage Bin : A set of coordinates (x, y, z) which help locate an item in a warehouse.
• Volume : Volume of a product
• Shelf Width : Shelf width required
• Shelf Height : Shelf height required
• Shelf Depth : Shelf depth required
• Units Per Pallet : Units Per Pallet
• Discontinued : A statement mentioning that this product will no longer be available on the market.
• Discontinued by : The name of the person who discontinues an item.
• Bill of Materials : Bill of Materials
• Print Details on Invoice : Print detail BOM elements on the invoice
• Print Details on Pick List : Print detail BOM elements on the pick list
• BOM Verified : The BOM tree has been verified
• Verify BOM : Verify BOM Structure
• Is Quantity Variable : If checked, goods shipment lines and sales invoice lines with quantity greater than quantity ordered are permitted for this product.
• Returnable : Indicates if the Product is Returnable or not
• Overdue Return Days : Indicates if a Service is Returnable how many days has the customer to return it after buying
• Lifecycle Status : Product Lifecycle Management Status
• Deferred Revenue : When flagged revenue of the product will be deferred using the plan and the number of periods
• Deferred Expense : When flagged expense of the product will be deferred using the plan and the number of periods
• Book Using Purchase Order Price : When checked, the Purchase Order posting will use the Purchase Order Price instead of the Product Cost.
• Characteristic Description
• Revenue Plan Type : Type of plan used to defer revenues
• Period Number : Number of periods to which revenue is deferred.
• Default Period
• Expense Plan Type : Type of plan used to defer expenses
• Period Number  : Number of periods to which expense is deferred.
• Default Period
• Create Variants
• Update Product Characteristics Description
• Linked To Product : The service can be linked to a Product
• Included Product Categories : Product Category Selection Mode
• Included Products : Product Selection Mode
• Is Price Rule Based : Indicates if the Service has a fixed price or it obtains the price based on a Service Price Rule
• Quantity Rule : Rule to define how many related lines will be created while relating a service to multiple lines of a sales order
• Unique Per Document : This flag indicates if the Service can only be added once in a ticket. This Service could be related to zero, one or more than one lines of the ticket.
• Print Description : If selected, the ticket footer printing should add the description of the Service
• ModifyTax : The service can modify the tax of the linked products
• Relate Prod Categories : P&E to include/exclude product categories in Products tab to indicate that the Service could be applied on those product categories.
• Relate Products : P&E to include/exclude products in Products tab to indicate that the Service could be applied on those products
• Allow Deferred Sell : Boolean field available for product of type service that defines whether the service can be linked to a product in a non-active ticket or not
• Deferred Sell Max Days : Defines in the case of services that does allow deferred sell the maximum days after the original product was sold, this service can be linked with it.
• Modify Tax for Product Category : Process to define the Modify Tax configuration for the selected services
• Copy Service Modify Tax Configuration : Process to copy configuration from current service to selected services
• SKU : A "stock keeping unit" used to track items sold to business partners.
• Product : An item produced by a process.
• Print Price : Defines if the pricestd is going to be printed or not in the document
• Name 2 : Additional space to write the name of a business partner.
• Help/Comment : A comment that adds additional information to help users work with fields.
• Guaranteed Days : Number of days the product is guaranteed or available
• Freight Category : A classification used to help calculate shipping company freight amounts.
• Download URL : URL of the Download files
• Comments : A space to write additional related information.
• Client : Client for this installation.
• Classification : The Classification can be used to optionally group products.

Price

A product can be part of many Price List Versions which are valid for a given time period.

• Price List Version : A price list with a specified validity range.
• Unit Price : The regular or normal price of a product in the respective price list.
• List Price : The official net price of a product in a specified currency.
• Price Limit : The lowest net price a specified item may be sold for.
• Active : A flag indicating whether this record is available for use or de-activated.
• Product Price
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Client : Client for this installation.

Product Price with Exceptions

The product Price with Exceptions tab allows setting a different unit price for the selected product in a price list version. The new price can be established to be applicable for a date range and a specific organization. This new price will be used instead of the unit price coming from the price list version (product price tab) for the selected organization or any of its children when fulfilling the date criteria. If there are two exceptions valid for a given organization, that one with an organization closer to it in the tree structure will be the one chosen to be applied.

• Organization : Organizational entity within client
• Product Price
• Valid From Date : A parameter stating the starting time of a specified request.
• Valid To Date : A parameter stating the ending time of a specified request.
• Product : An item produced by a process.
• Unit Price : The regular or normal price of a product in the respective price list.
• List Price : The official price of a product in a specified currency.
• M_Productprice_Exc_ID
• Client : Client for this installation.
• Active : A flag indicating whether this record is available for use or de-activated.

Product customer

Asigns products to customers

• Name : A non-unique identifier for a record/document often used as a search tool.
• Description : A space to write additional related information.
• UPC/EAN : A bar code with a number to identify a product.
• Business Partner : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
• Active : A flag indicating whether this record is available for use or de-activated.
• Product Customer : Product assignation to customer
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Client : Client for this installation.

Price Rule Version

• Organization : Organizational entity within client
• Active : A flag indicating whether this record is available for use or de-activated.
• Valid From Date : A parameter stating the starting time of a specified request.
• Service Price Rule : Rules to establish service price.
• Product : An item produced by a process.
• M_Servicepricerule_Version_ID
• Client : Client for this installation.

Accounting

Accounting tab allows to configure the ledger accounts to be used while posting product related transactions such as product purchase or sales to the general ledger.

• General Ledger : The book containing all financial transactions recorded for the legal entity.
• Product Asset : A tangible asset used for business without expectation of sale in the coming fiscal year.
• Product Expense : An account number in the general ledger to mark transactions with this item.
• Product Deferred Expense : Used when expense is deferred from a purchased product.
• Product Revenue : An account number in the general ledger to mark transactions with this product.
• Product Deferred Revenue : Used to defer revenue for a sold product
• Product COGS : The cost of goods sold for a specified product.
• Invoice Price Variance : The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price.
• Product Revenue Return : An account number in the general ledger to mark returns of this product.
• Product COGS Return : The cost of goods returned for a specified product.
• Active : A flag indicating whether this record is available for use or de-activated.
• Product Accounting
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Client : Client for this installation.

Bill of Materials

This tab allows to edit the bill of materials components the selected product consists of.

• Line No. : A line stating the position of this request in the document.
• BOM Product : Bill of Material Product
• BOM Quantity : Bill of Materials Quantity
• BOM Price : Bill of Materials weighted price
• Description : A space to write additional related information.
• BOM Type : Type of BOM
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Client : Client for this installation.
• BOM Line

Costing Rule

Costing rule tab allows to review the costing rules that apply to the product within a given date range.

• Costing Rule
• Costing Algorithm
• Starting Date : A parameter stating the starting time range related to a specified request.
• Warehouse Dimension
• Validated
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Costing Rule Product
• Client : Client for this installation.

Substitute

Define substitute products to be used if this product becomes unavailable.

• Name : A non-unique identifier for a record/document often used as a search tool.
• Active : A flag indicating whether this record is available for use or de-activated.
• Substitute Product : Product which can be used in place of another product
• Substitute
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Client : Client for this installation.

Costing

Costing tab collects and summarize product cost related information as a result of every product transaction. Product's costs are valid during a fixed date range and can be calculated either by using an Average or a Standard costing algorithm.

• Organization : Organizational entity within client
• Inventory Transaction
• Cost Type : A distinct cost characteristic used for processes.
• Cost : A charge related to conducting business.
• Starting Date : A parameter stating the starting time range related to a specified request.
• Ending Date : A parameter stating the ending time range related for a specified request, query, etc.
• Quantity : The number of a certain item.
• Net Unit Price : The cost or value of a good or service.
• Total Movement Quantity : The final quantity to be moved based on the related business process.
• Manual : A task or process completed directly by the user, not automatically by the application.
• Permanent
• Warehouse : The location where products arrive to or are sent from.
• Total Stock Valuation
• Production : An indication that an item is being used in production.
• Currency : An accepted medium of monetary exchange that may vary across countries.
• Original Cost
• Product : An item produced by a process.
• Invoice Line : A statement displaying one item or charge in an invoice.
• Costing
• Client : Client for this installation.
• Active : A flag indicating whether this record is available for use or de-activated.

Average Cost Transactions

• id
• Movement Type : The type of a certain item being moved from one location to another.
• Inventory Transaction
• Movement Date : The date that a certain item is moved from one location to another.
• Transaction Process Date
• Costing
• Movement Qty
• Net Unit Price : The cost or value of a good or service.
• Transaction Cost
• Cum. Qty
• Cost : A charge related to conducting business.
• Cum. Cost
• Adjustment Amt.

Transaction Adjustments

• Cost Date
• Cost : A charge related to conducting business.
• Currency : An accepted medium of monetary exchange that may vary across countries.
• Cost Adjustment Line
• Unit Cost : When checked the cost amount is considered part of the unit cost of the transaction or a cost added like freight costs or insurance costs.
• Accounting Date : The date this transaction is recorded for in the general ledger.
• Organization : Organizational entity within client
• M_Transaction_Cost_ID
• Inventory Transaction
• Client : Client for this installation.
• Active : A flag indicating whether this record is available for use or de-activated.

Transactions

Transaction tab is a summarized view of all the transactions of a product.

• Organization : Organizational entity within client
• Attribute Set Value : An attribute associated with a product as part of an attribute set.
• Storage Bin : A set of coordinates (x, y, z) which help locate an item in a warehouse.
• Movement Quantity : The number of items being moved from one location to another.
• Movement Date : The date that a certain item is moved from one location to another.
• Active : A flag indicating whether this record is available for use or de-activated.
• Transaction Process Date
• Movement Type : The type of a certain item being moved from one location to another.
• Goods Shipment/Receipt Line : A statement displaying one item, charge, or movement in a shipment or receipt
• Physical Inventory Line : A statement displaying one item in the physical inventory list.
• Movement Line : An often automatically generated identifier for a movement line.
• Production Line : A statement displaying one item or action in the application.
• Project Issue : Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock.
• Is Cost Calculated
• Costing Status : Costing Calculation Status
• Trx Original Cost
• Total Cost
• Unit cost
• Is Cost Permanent : Determines whether the cost is permanently adjusted or not.
• Currency : An accepted medium of monetary exchange that may vary across countries.
• Is Processed
• Manual Cost Adjustment
• Warehouse : The location where products arrive to or are sent from.
• Product : An item produced by a process.
• Inventory Transaction
• Costing Algorithm
• Client : Client for this installation.

Transaction Costs

• Cost Date
• Cost : A charge related to conducting business.
• Currency : An accepted medium of monetary exchange that may vary across countries.
• Cost Adjustment Line
• Unit Cost : When checked the cost amount is considered part of the unit cost of the transaction or a cost added like freight costs or insurance costs.
• Accounting Date : The date this transaction is recorded for in the general ledger.
• Organization : Organizational entity within client
• M_Transaction_Cost_ID
• Inventory Transaction
• Client : Client for this installation.
• Active : A flag indicating whether this record is available for use or de-activated.

Purchasing

Purchasing tab information is used for products that are planned by the purchasing plan.

• Business Partner : Anyone who takes part in daily business operations by acting as a customer, employee, etc.
• Quality Rating : Method for rating vendors
• Active : A flag indicating whether this record is available for use or de-activated.
• Current Vendor : Use this Vendor for pricing and stock replenishment
• UPC/EAN : A bar code with a number to identify a product.
• Currency : An accepted medium of monetary exchange that may vary across countries.
• List Price : The official net price of a product in a specified currency.
• Price Effective From : The time from which a price is valid.
• Purchase Order Price : The price charged to purchase a specific item.
• Last Purchase Price : The last price pad for this product, as noted in a completed purchase order.
• Last Invoice Price : The last price paid for this product, as noted in a completed invoice.
• UOM : A non monetary unit of measure.
• Minimum Order Qty. : The minimum number of an item that must be purchased at one time from a vendor.
• Quantity per Package : The number of a specific item that comes in one package.
• Purchasing Lead Time : Number of days between placing an order and the actual delivery as promised by the vendor.
• Fixed Cost per Order : The additional added fixed cost for a purchased product.
• Vendor Product No. : The identifier used by a vendor to indentify a product being purchased by their business partners.
• Vendor Category : A classification of vendors based on similar characteristics or attributes.
• Discontinued : A statement mentioning that this product will no longer be available on the market.
• Discontinued by : The name of the person who discontinues an item.
• Quantity Type : Quantity Type
• Manufacturer : The business partner that makes a specific product.
• Standard Quantity : Quantity Standard
• Capacity : Capacity
• Product PO
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Client : Client for this installation.
• Actual Delivery Days : Actual days between order and delivery

Manufacturing

Manufacturing tab is used for products that are planned by the manufacturing plan.

• Organization : Organizational entity within client
• Storage Bin : A set of coordinates (x, y, z) which help locate an item in a warehouse.
• Planning Method
• Planner : The person in charge of making an MRP plan.
• Capacity : Capacity
• Min. Quantity : Minumun Quantity.
• Quantity Type : Quantity Type
• Standard Quantity : Quantity Standard
• Minimum Lead Time : Delaymin
• Safety Stock
• Abc : ABC classification according to a Pareto distribution
• Preferred Vendor
• Max not reserved stock : Max Qty of the product in stock, not reserved.
• Active : A flag indicating whether this record is available for use or de-activated.
• Product Organization : Details for a product in different organizations.
• Product : An item produced by a process.
• Max. Quantity : Maximum Quantity
• Creation Date : The date that this record is completed.
• Client : Client for this installation.

UOM

Add a unit of measurement to this product.

• UOM : A non monetary unit of measure.
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Order UOM : The unit of measure being used for the request.
• Client : Client for this installation.

Translation

Product names can be translated to any language.

• Language : A method of communication being used.
• Name : A non-unique identifier for a record/document often used as a search tool.
• Comments : A space to write additional related information.
• Active : A flag indicating whether this record is available for use or de-activated.
• Translation : An indication that an item is translated.
• Characteristic Description
• Product Translation
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Client : Client for this installation.

Characteristics

Relation of characteristics assigned to the Product

• Sequence Number : The order of records in a specified document.
• Characteristic
• Variant
• Explode Configuration Tab
• Defines Price
• Price List Type
• Defines Image
• Characteristic Subset
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• Organization : Organizational entity within client
• Client : Client for this installation.
• Characteristic of Product

Characteristic Configuration

Characteristic Configuration tab contains the available values for each characteristic assigned to the generic product. Price modifiers to create the variants are defined in this tab as well.

• Characteristic Value
• Code
• Unit Price : Unit price of the variants using this value.
• Image : A visual picture used to describe an item.
• Active : A flag indicating whether this record is available for use or de-activated.
• Product Characteristic Configuration
• Organization : Organizational entity within client
• Client : Client for this installation.
• Characteristic of Product

Characteristic Values

• Product : An item produced by a process.
• Characteristic
• Characteristic Value
• Active : A flag indicating whether this record is available for use or de-activated.
• Organization : Organizational entity within client
• M_Product_Ch_Value_ID
• Client : Client for this installation.

Unit Cost

• Organization : Organizational entity within client
• Active : A flag indicating whether this record is available for use or de-activated.
• Stock
• Stock Valuation
• Warehouse : The location where products arrive to or are sent from.
• Product : An item produced by a process.
• Unit Cost
• M_Stock_Valuation_ID
• Client : Client for this installation.

Stock

This Tab shows the available Stock for this Product in the application. It only shows Storage Bins for which the quantity available of the Product is not 0

• Organization : Organizational entity within client
• Product : An item produced by a process.
• Storage Bin : A set of coordinates (x, y, z) which help locate an item in a warehouse.
• Attribute Set Value : An attribute associated with a product as part of an attribute set.
• UOM : A non monetary unit of measure.
• Order UOM : The unit of measure being used for the request.
• Quantity on Hand : On Hand Quantity
• On Hand Order Quantity
• Last Inventory Count Date : Date of Last Inventory Count
• Quantity in draft transactions
• Quantity Order in draft transactions
• Active : A flag indicating whether this record is available for use or de-activated.
• Reserved Qty
• Allocated Quantity
• Storage Detail
• Client : Client for this installation.

Product Categories

The user can define if a product of a certain product category can be related to a product of 'Service' type by creating a relation between an Order Line of the Service product and another Sales Order Line of the product belonging to included/excluded product categories.

• Search Key : A fast method for finding a particular record.
• Organization : Organizational entity within client
• Name : A non-unique identifier for a record/document often used as a search tool.
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• Description : A space to write additional related information.
• Product Category : A classification of items based on similar characteristics or attributes.
• M_Product_Category_Service_ID
• Client : Client for this installation.

Category Price Rule Version

• Organization : Organizational entity within client
• Active : A flag indicating whether this record is available for use or de-activated.
• Valid From Date : A parameter stating the starting time of a specified request.
• Service Price Rule : Rules to establish service price.
• Product : An item produced by a process.
• Related Product Category
• M_Servicepricerule_Version_ID
• Client : Client for this installation.

Products

The user can define if a product can be related to a product of 'Service' type by creating a relation between an Order Line of the Service product and another Sales Order Line of the product included/excluded.

• Search Key : A fast method for finding a particular record.
• Organization : Organizational entity within client
• Name : A non-unique identifier for a record/document often used as a search tool.
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• Brand
• Product Category : A classification of items based on similar characteristics or attributes.
• Product
• Generic Product
• Characteristic Description
• M_Product_Service_ID
• Client : Client for this installation.

Product Price Rule Version

• Organization : Organizational entity within client
• Active : A flag indicating whether this record is available for use or de-activated.
• Valid From Date : A parameter stating the starting time of a specified request.
• Service Price Rule : Rules to establish service price.
• Product : An item produced by a process.
• Related Product
• M_Servicepricerule_Version_ID
• Client : Client for this installation.

Alternate UOM

• Organization : Organizational entity within client
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• UOM : A non monetary unit of measure.
• Conversion Rate : Defines the conversion between Quantity and Process Quantity
• Gtin : The GTIN is a globally unique 14-digit number used to identify trade items, products, or services
• Sales : It represents the priority of this AUM to the Sales flows
• Purchase : It represents the priority of this AUM to the Purchases flows
• Logistics : It represents the priority of this AUM to the Logistics flows
• M_Product_Aum_ID
• Client : Client for this installation.

Modify Taxes Categories

Defines taxes modification for products linked to service. Products linked to this service that belongs to the configured category will change the tax category when linked to this service.

• Organization
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• Product Category : A classification of items based on similar characteristics or attributes.
• Tax Category : A classification of tax options based on similar characteristics or attributes.
• M_Product_Servicelinked_ID : Identifier of properties for services linked to product
• Client : Client for this installation.

Media

• Organization : Organizational entity within client
• Active : A flag indicating whether this record is available for use or de-activated.
• Product : An item produced by a process.
• Media Type
• Size
• Sequence Number : The sequence indicates the priority of the grid configuration.
• URL : An address which can be accessed via internet.
• Preview Image URL
• M_Product_Media_ID
• Client : Client for this installation.

Back to Screens_Reference