Food Court Product Master Configuration - TenthPlanet Technologies

The Product Master is the foundation of the Food Court ERP application, where all products are created and maintained before they are used in Point of Sale (POS), Sales, Purchase, Inventory, and other business operations. This guide presents the Product Master configuration and functional validation scenarios used during implementation, helping ensure that products are configured accurately and consistently across the system.

Product Creation

Product creation is the first step in configuring the Product Master. This process allows authorized users to add new products and maintain existing products whenever business requirements change.

Create or Edit Product

The Product Master should support both product creation and product maintenance.

Validation

Verify that the system allows users to create a new product and edit an existing product.

Test Scenario

Create Product

Navigate to the Product Master.
Create a new product.
Save the product.

Edit Product

Open an existing product.
Modify the required information.
Save the changes.

Sample Data

Create

ViVo Pro Mobile

Edit

Titan Watch

Expected Result

The system should allow users to create a new product successfully.
The system should allow users to edit an existing product successfully.

Product Name

The Product Name uniquely identifies a product throughout the Food Court ERP application. The field should support various naming conventions based on business requirements.

Validation

Verify that the Product Name field accepts:

Alphabetic characters
Numeric characters
Special characters
Alphanumeric characters

Sample Data

Product Name

Redmi Note 12

Expected Result

The system should allow users to enter alphabetic characters.
The system should allow users to enter numeric characters.
The system should allow users to enter special characters.
The system should allow users to enter alphanumeric values.
The Product Name should be saved successfully.

Product Availability

Product availability determines whether a product can participate in Sales and Purchase transactions. Based on the selected options, the application should automatically display the relevant business tabs.

Can be Sold

Products that are available for customer sales should have the Can be Sold option enabled.

Validation

Verify that users can enable or disable the Can be Sold option.

Business Rules

When Can be Sold is selected, the Sales tab should be displayed.
When Can be Sold is not selected, the Sales tab should not be displayed.

Expected Result

The system should allow users to enable the Can be Sold option.
The system should generate the Sales tab automatically.
The system should allow users to disable the Can be Sold option.
The Sales tab should not be displayed when the option is disabled.

Can be Purchased

Products that are procured from suppliers should have the Can be Purchased option enabled.

Validation

Verify that users can enable or disable the Can be Purchased option.

Business Rules

When Can be Purchased is selected, the Purchase tab should be displayed.
When Can be Purchased is not selected, the Purchase tab should not be displayed.

Expected Result

The system should allow users to enable the Can be Purchased option.
The system should generate the Purchase tab automatically.
The system should allow users to disable the Can be Purchased option.
The Purchase tab should not be displayed when the option is disabled.

General Information

The General Information section contains the basic product information required for identifying, classifying, and managing products across the Food Court ERP application. Proper configuration of these fields ensures that products are organized correctly and are available for Sales, Purchase, Inventory, POS, and Reporting.

Point of Sale Category

The Point of Sale Category is used to classify products within the POS application. Assigning the appropriate category helps organize products for faster billing and easier product management.

Validation

Verify that the system allows users to select a Point of Sale Category.

Sample Data

Point of Sale Category

Mobile

Expected Result

The system should allow users to select the Point of Sale Category successfully.

Department

The Department field groups products according to the organization’s business structure.

Validation

Verify that the system allows users to select a Department.

Sample Data

Department

Redmi

Expected Result

The system should allow users to select the Department successfully.

Brand

The Brand identifies the manufacturer or business brand associated with a product.

Validation

Verify that the system allows users to select a Brand.

Sample Data

Brand

Expected Result

The system should allow users to select the Brand successfully.

Product Type

The Product Type determines how a product behaves within the Food Court ERP application. Selecting the correct Product Type ensures that the product participates appropriately in Inventory, Sales, and Purchase transactions.

Validation

Verify that users can select the appropriate Product Type while creating or updating a product.

Available Options

Consumable
Service
Storable Product

Business Rules

The system should display all available Product Types.
Users should be allowed to select only one Product Type for each product.

Sample Data

Product Type

Storable Product

Expected Result

The system should allow users to select Consumable, Service, or Storable Product.
Only one Product Type should be selected for a product.
The selected Product Type should be saved successfully.

Invoicing Policy

The Invoicing Policy determines when invoices are generated for customer orders. This configuration helps businesses manage billing based on ordered quantities or delivered quantities.

Validation

Verify that users can configure the required Invoicing Policy.

Available Options

Ordered Quantities
Delivered Quantities

Business Rules

Users should be allowed to select only one invoicing policy.
The selected policy should be applied during the sales process.

Expected Result

The system should allow users to select either Ordered Quantities or Delivered Quantities.
The selected Invoicing Policy should be saved successfully.

Product with Reinvoice Expenses

The Reinvoice Expenses option determines how expenses incurred for a product are billed to customers.

Validation

Verify that users can configure the required Reinvoice Expenses option.

Available Options

No
At Cost
Sales Price

Business Rules

Only one option should be selected.
The selected option should be applied during customer invoicing.

Expected Result

The system should allow users to select No, At Cost, or Sales Price.
The selected configuration should be saved successfully.

Associate Product Categories

Product Categories help organize products into logical business groups. Every product should be associated with an appropriate Product Category.

Validation

Verify that Product Categories are loaded from the Product Category Master and that users can assign a category to the product.

Business Rules

The Product Category list should be loaded from the Product Category Master.
Users should be allowed to select only one Product Category.

Expected Result

The Product Category dropdown should display all available Product Categories.
The selected Product Category should be saved successfully.

Internal Reference

The Internal Reference is used as the unique internal identification code for a product. It helps users quickly identify products during operational activities.

Validation

Verify that users can enter an Internal Reference.

Expected Result

The system should allow users to enter the Internal Reference.
The Internal Reference should be saved successfully.

Barcode

The Barcode uniquely identifies a product during Point of Sale and Inventory transactions.

Validation

Verify that users can enter a valid Barcode number.

Sample Data

Barcode

0012235496897

Expected Result

The system should allow users to enter the Barcode number.
The Barcode should be saved successfully.

Sales Price

The Sales Price represents the default selling price of the product.

Validation

Verify that the system automatically loads the Sales Price for the selected product.

Sample Data

Sales Price

1.000

Expected Result

The system should automatically load the Sales Price.

Customer Taxes

Customer Taxes determine the tax applied when the product is sold to customers.

Validation

Verify that Customer Taxes are loaded from the Taxes Master and that multiple taxes can be selected when required.

Sample Data

Customer Taxes

GST 5%

Expected Result

The system should load the Customer Taxes from the Taxes Master.
The system should allow users to select multiple Customer Taxes.
The selected Customer Taxes should be saved successfully.

Update Product Costing

Product Costing should be updated automatically based on the Purchase Order cost.

Validation

Verify that the product cost is automatically updated after Purchase Order transactions.

Expected Result

The system should automatically load the latest product cost based on the Purchase Order.
The updated cost should be reflected in the Product Master.

Unit of Measure

The Unit of Measure (UOM) defines how products are purchased, stocked, and sold within the application.

Validation

Verify that the Unit of Measure list is loaded from the Unit of Measure Master.

Sample Data

Unit of Measure

Pieces
Unit

Expected Result

The system should load the Unit of Measure list from the Unit of Measure Master.
The system should allow users to select only one Unit of Measure.
The selected Unit of Measure should be saved successfully.

Purchase Unit of Measure

The Purchase UOM defines the default unit used while purchasing the product from suppliers.

Validation

Verify that the Purchase Unit of Measure list is loaded from the Unit of Measure Master.

Sample Data

Purchase Unit of Measure

Pieces
Unit

Expected Result

The system should load the Purchase Unit of Measure list from the Unit of Measure Master.
The system should allow users to select only one Purchase Unit of Measure.
The selected Purchase Unit of Measure should be saved successfully.

Product with ROHS Compliance

The ROHS Compliance option identifies whether the product complies with the Restriction of Hazardous Substances (ROHS) standards. This information can be used for regulatory compliance and product classification.

Validation

Verify that users can enable or disable the ROHS Compliance option.

Business Rules

Users should be able to select the ROHS Compliance checkbox.
Users should be able to deselect the ROHS Compliance checkbox.

Expected Result

The system should allow users to enable the ROHS Compliance option.
The system should allow users to disable the ROHS Compliance option.
The selected configuration should be saved successfully.

HSN/SAC Code

The HSN/SAC Code is used for GST classification and taxation. Every applicable product should be assigned the appropriate HSN or SAC code.

Validation

Verify that the HSN/SAC Code field accepts different input formats.

Validation Checklist

Alphabetic characters
Numeric characters
Special characters
Alphanumeric characters

Sample Data

HSN/SAC Code

1001-5600

Expected Result

The system should allow users to enter alphabetic characters.
The system should allow users to enter numeric characters.
The system should allow users to enter special characters.
The system should allow users to enter alphanumeric characters.
The HSN/SAC Code should be saved successfully.

Pricelist

The Pricelist displays the price list associated with the selected product. This information is used to determine the applicable selling price during customer transactions.

Validation

Verify that the system displays the available Pricelist for the selected product.

Sample Data

Pricelist

Pricelist Records

Expected Result

The system should display the applicable Pricelist for the selected product.

Batch Number

The Batch Number identifies products belonging to a specific batch. Batch information is maintained to support pricing, traceability, and inventory control.

Validation

Verify that Batch Numbers can be maintained for products where batch tracking is applicable.

Sample Data

Batch Number

0012235496897
abcd1234

Expected Result

The system should allow alphabetic characters.
The system should allow numeric characters.
The system should allow special characters.
The system should allow alphanumeric characters.
The Batch Number should be saved successfully.

Attributes & Variants

The Attributes & Variants section allows products to be configured with different characteristics and variations. This functionality helps businesses manage products with multiple options while maintaining a single product definition.

Attributes

Attributes define the characteristics of a product, such as size, color, model, flavour, or any other configurable option.

Validation

Verify that the configured Attributes are displayed in the Product Master.

Expected Result

The system should display the configured Attributes in the Product Master.

Values

Values represent the available options for each configured Attribute.

Validation

Verify that the configured Attribute Values are displayed in the Product Master.

Expected Result

The system should display the configured Values in the Product Master.

Price Information

The Price Information section maintains the pricing structure of a product. It enables businesses to calculate the selling price, purchase cost, discounts, taxes, margins, and final product cost. Proper configuration of these values ensures accurate pricing, profitability analysis, and inventory valuation.

MRP (Maximum Retail Price)

The MRP represents the maximum selling price defined for the product.

Validation

Verify that the system displays the MRP in the Product Master.

Sample Data

MRP

Expected Result

The system should display the MRP in the Product Master.

Mark Down %

The Mark Down % represents the percentage reduction applied to the selling price.

Validation

Verify that the system displays the Mark Down percentage.

Sample Data

Mark Down %

8.00

Expected Result

The system should display the Mark Down percentage.

Mark Up %

The Mark Up % represents the percentage added to the product cost for calculating the selling price.

Validation

Verify that the system displays the Mark Up percentage.

Sample Data

Mark Up %

8.70

Expected Result

The system should display the Mark Up percentage.

Basic Cost

The Basic Cost represents the base purchase cost of the product before applying taxes and other charges.

Validation

Verify that the system displays the Basic Cost.

Sample Data

Basic Cost

Expected Result

The system should display the Basic Cost in the Product Master.

Discount %

The Discount % represents the percentage discount applicable to the product.

Validation

Verify that the system displays the Discount percentage.

Expected Result

The system should display the Discount percentage.

Discount Amount

The Discount Amount represents the calculated discount value for the product.

Validation

Verify that the system displays the Discount Amount.

Sample Data

Discount Amount

Expected Result

The system should display the Discount Amount.

Gross Cost

The Gross Cost represents the total product cost before applying scheme discounts and additional cost calculations.

Validation

Verify that the system displays the Gross Cost.

Sample Data

Gross Cost

Expected Result

The system should display the Gross Cost.

Scheme Discount %

The Scheme Discount % represents the percentage discount applied through promotional schemes.

Validation

Verify that the system displays the Scheme Discount percentage.

Expected Result

The system should display the Scheme Discount percentage.

Scheme Discount Amount

The Scheme Discount Amount represents the monetary value calculated from the scheme discount.

Validation

Verify that the system displays the Scheme Discount Amount.

Expected Result

The system should display the Scheme Discount Amount.

Final Gross Cost

The Final Gross Cost represents the final product cost after applying all discounts and pricing calculations.

Validation

Verify that the system displays the Final Gross Cost.

Sample Data

Final Gross Cost

Expected Result

The system should display the Final Gross Cost.

Purchase Tax %

The Purchase Tax % represents the tax percentage applied during product procurement.

Validation

Verify that the system displays the Purchase Tax percentage.

Expected Result

The system should display the Purchase Tax percentage.

Purchase Tax Amount

The Purchase Tax Amount represents the calculated purchase tax value.

Validation

Verify that the system displays the Purchase Tax Amount.

Expected Result

The system should display the Purchase Tax Amount.

Net Cost (NC)

The Net Cost (NC) represents the final procurement cost after applying taxes and pricing calculations.

Validation

Verify that the system displays the Net Cost.

Sample Data

Net Cost

Expected Result

The system should display the Net Cost.

CESS %

The CESS % represents the applicable cess percentage configured for the product.

Validation

Verify that the system displays the CESS percentage.

Expected Result

The system should display the CESS percentage.

CESS Amount

The CESS Amount represents the calculated cess value.

Validation

Verify that the system displays the CESS Amount.

Expected Result

The system should display the CESS Amount.

Landed Cost

The Landed Cost represents the total cost incurred to bring the product into inventory, including purchase cost and associated charges.

Validation

Verify that the system displays the Landed Cost.

Sample Data

Landed Cost

Expected Result

The system should display the Landed Cost.

Selling Margin Type

The Selling Margin Type defines the method used to calculate the product’s selling margin.

Validation

Verify that the system displays the configured Selling Margin Type.

Sample Data

Selling Margin Type

Based on MRP

Expected Result

The system should display the configured Selling Margin Type.

Selling Price

The Selling Price represents the final selling price of the product.

Validation

Verify that the system displays the Selling Price.

Expected Result

The system should display the Selling Price.

Selling Margin MRP %

The Selling Margin MRP % represents the margin percentage calculated based on the Maximum Retail Price.

Validation

Verify that the system displays the Selling Margin MRP percentage.

Expected Result

The system should display the Selling Margin MRP percentage.

Selling Margin NC %

The Selling Margin NC % represents the margin percentage calculated based on the Net Cost.

Validation

Verify that the system displays the Selling Margin NC percentage.

Expected Result

The system should display the Selling Margin NC percentage.

Batch / Barcode Information

The Batch / Barcode section provides detailed information about product batches, barcode mapping, available quantities, and inventory traceability. These details help businesses manage stock accurately, improve barcode-based billing, and support batch-wise inventory management.

Product

The Product field displays the product associated with the selected batch or barcode record.

Validation

Verify that the Product information is displayed correctly.

Expected Result

The system should display the Product in the Product Master.

Product Template

The Product Template identifies the parent product associated with the selected batch or barcode.

Validation

Verify that the Product Template is displayed correctly.

Expected Result

The system should display the Product Template in the Product Master.

Barcode

The Barcode uniquely identifies the selected product and supports barcode-based billing and inventory operations.

Validation

Verify that the Barcode information is displayed.

Expected Result

The system should display the Barcode in the Product Master.

Batch

The Batch identifies the inventory batch associated with the selected product.

Validation

Verify that the Batch information is displayed.

Sample Data

Batch

00002900010000

Expected Result

The system should display the Batch information in the Product Master.

BCode

The BCode represents the internal barcode reference associated with the selected product batch.

Validation

Verify that the BCode is displayed correctly.

Expected Result

The system should display the BCode in the Product Master.

MRP

The MRP displays the Maximum Retail Price associated with the selected batch.

Validation

Verify that the MRP is displayed correctly.

Sample Data

MRP

Expected Result

The system should display the MRP in the Product Master.

Purchase Quantity (P Qty)

The Purchase Quantity (P Qty) displays the total quantity procured for the selected batch.

Validation

Verify that the Purchase Quantity is displayed correctly.

Sample Data

Purchase Quantity

Expected Result

The system should display the Purchase Quantity in the Product Master.

Sales Quantity (S Qty)

The Sales Quantity (S Qty) displays the total quantity sold from the selected batch.

Validation

Verify that the Sales Quantity is displayed correctly.

Sample Data

Sales Quantity

Expected Result

The system should display the Sales Quantity in the Product Master.

Available Quantity (Qty)

The Available Quantity (Qty) displays the current stock available for the selected batch.

Validation

Verify that the available quantity is displayed correctly.

Sample Data

Available Quantity

Expected Result

The system should display the available quantity in the Product Master.

Price List

The Price List section displays the pricing information associated with the selected product. It enables businesses to maintain different selling prices for different price lists while supporting batch-wise pricing where applicable.

Pricelist

The Pricelist displays the price list associated with the selected product.

Validation

Verify that the configured Pricelist is displayed.

Sample Data

Pricelist

Public Pricelist (INR)

Expected Result

The system should display the configured Pricelist in the Product Master.

MRP

The MRP displays the Maximum Retail Price available for the selected Price List.

Validation

Verify that the MRP is displayed correctly.

Expected Result

The system should display the MRP for the selected Pricelist.

Lot

The Lot field displays the Lot associated with the selected product.

Validation

Verify that the Lot information is displayed.

Expected Result

The system should display the Lot information.

Barcode

The Barcode displays the barcode associated with the selected Price List record.

Validation

Verify that the Barcode information is displayed.

Expected Result

The system should display the Barcode successfully.

Purchase Information

The Purchase Information section contains vendor-specific details required for procurement activities. It helps organizations maintain supplier information, purchase pricing, tax configuration, delivery schedules, and procurement policies for every product.

Vendor

The Vendor field identifies the preferred supplier associated with the selected product. Maintaining vendor information simplifies procurement and ensures consistency during Purchase Order creation.

Validation

Verify that the Vendor information is displayed and can be associated with the selected product.

Sample Data

Vendor

Sample Vendor

Expected Result

The system should display the Vendor information in the Product Master.
The selected Vendor should be associated with the product successfully.

Purchase Price

The Purchase Price represents the default procurement cost of the product from the selected vendor.

Validation

Verify that the Purchase Price is displayed correctly.

Sample Data

Purchase Price

Expected Result

The system should display the Purchase Price in the Product Master.
The Purchase Price should be available while creating Purchase Orders.

Delivery Lead Time

The Delivery Lead Time defines the expected number of days required for the vendor to deliver the product after a Purchase Order is confirmed.

Validation

Verify that the Delivery Lead Time is displayed correctly.

Expected Result

The system should display the configured Delivery Lead Time.
The Delivery Lead Time should be considered during Purchase Order planning.

Vendor Taxes

Vendor Taxes define the tax structure applicable while purchasing the product from suppliers.

Validation

Verify that users can select Vendor Taxes for the product.

Sample Data

Vendor Taxes

Expected Result

The system should allow users to select the required Vendor Taxes.
The selected Vendor Taxes should be saved successfully.
The configured tax should be applied during Purchase transactions.

Control Policy

The Control Policy determines how supplier billing and purchase validation are managed for the selected product.

Validation

Verify that users can select the appropriate Control Policy.

Expected Result

The system should allow users to select the required Control Policy.
The selected Control Policy should be saved successfully.