Create New Product

How to Set-up Product Maintenance?

In UNIQ365, product and service maintenance are essential for effective inventory and financial management. By accurately adding and managing product and service details, users can ensure seamless tracking, reporting, and accounting within the system. This functionality helps maintain up-to-date records, streamline operations, and support decision-making for inventory and sales.

1. Click on Stock– Product Management – Product & Service Maintenance icon for following Inventory listing screen. 

UNIQ365 offers various filtering options to help users quickly locate the desired items. Users can filter items based on criteria such as status, type, product details, and location for a more efficient search. Whether filtering by active stock, brand, size, or country of origin, UNIQ365 enables a customized and streamlined search process.

• Status Filter. Allows users to choose what status to display in the system interface. Options typically include Active, Inactive, or All.
  

• Type Filter. Used to filter items based on their category, such as stock, service, or all items.
  

• Code, Brand, and Group Filters. Users can input specific product codes, brands, and groups to filter results.
  

• Description, Model, and Size Filters. Allows filtering based on the product description, model, or size.
  

• Country of Origin, Main Category, and Default Location Filters. Users can use these filters to further refine the search by country of origin, main category, or default location.

• Excel Export Button. This will let user download all the products and services added within the System and convert into excel format.

2. How to ADD Products and Services?

2.1 Product Info. Click the Add button for new inventory. The user will be redirected to the Product Info page.

i. Fill in the following components:

• Product Code: The code for the new product is autogenerated by the system.
• Description: Enter the product name (maximum 50 alphanumeric characters).
• Pack Info: Enter any relevant pack information.
• Other Description: Enter additional details (unlimited lines, maximum of 40 alphanumeric characters per line).
• Barcode: Enter the product barcode

ii. Click the Additional button if there is extra information to link with the new product.

2.2 Product Classification. UNIQ365 helps organize and categorize products for better inventory and financial management. It consists of two key components:

• Product Type: Specifies whether the product is a Stock Item or a Service.
• Account Group:  If any auto account posting depends on Product, then click to select the relevant Accounts Group defined under Inventory/Maintenance/Product Account Group. 
  Example: Stock-Computer Hardwares, Stock-Softwares, Stock Accessories, Stock-Others. 

2.3 Product Costing. UNIQ365 accurately determine and manage the cost of their products, ensuring effective pricing and profitability. This feature plays a key role in cost control, helping to track expenses and set competitive prices. 

Note: Please ensure that only one costing type is needed to be attached to all the products.

• Standard Costing. The cost entered in the product master as Standard cost is taken for updating cost of sales.
• Weighted Average. The cost for each product is maintained and the current weighted average cost is used for updating cost of sales.
• FIFO. First In First Out method of costing uses the cost for the first set of available item for updating cost of sales.
• LIFO. Last In First Out method of costing uses the cost for the last set of available item for updating cost of sales.

• Cost Type: Used by the business process (FIFO, Weighted Average, LIFO & Standard Cost).
  • Standard - This field is where we set up the Standard cost of the product if Costing type is set to Standard Cost.
  • Weighted Average - A non-entry field. Displays the Weighted Average cost of the product.'
• Created Date: The date the product was added to the system.
• Latest IR Date: The most recent Inventory Receipt date.
• Min Market %: The minimum market percentage for pricing.

2.4 Unit of Measure (UOM) UNIQ365 used to quantify and track products, such as pieces, boxes, or kilograms. It ensures consistency in inventory management, allowing seamless conversion between units for accurate tracking, pricing, and reporting. This also has its own maintenance tab.

• Stock Unit:  Enter desired unit of measure for Stock unit. This is the unit that will be used in calculations for quantities in subsequent inventory related reports.
  
• Purchase Unit: If different from Stock Unit a Stock Conversion Factor record must exist.
• Sales Unit: If different from Stock Unit a Stock Conversion Factor record must exist.
• Biggest Case Unit: The largest packaging unit, used for bulk inventory management and converting stock quantities into larger cases or cartons.

2.5 Quantities Available. In UNIQ365 the total quantity of a product that is available for use, sale, or inventory tracking, taking into account various stages of the product lifecycle. It helps businesses monitor and manage stock levels efficiently. Its 3 components have non-entry field. 

• On Hand: The quantity of the product currently in stock and physically available in the warehouse or storage.
• On Purchase: The quantity of the product that has been ordered from suppliers but has not yet been received.
• On Order: The quantity of the product that is pending or backordered and is expected to be delivered in the future.

 3. Product Image. allows users to upload a picture for each product, helping with visual identification and inventory management.

 4. Attribute. 

How to Create Product Group? 

1. Click on Stock – Product Management – Product Group icon for the following screen.

2. Enter the Product Groups as per the above example.

Important: Product groups are mainly used as additional analysis tool for various reports in the system. Some of the most commonly used reports are Sales Analysis-Product Group Wise and Inventory reports that can be sorted by Product groups.

How to Set-up Product Account Group?

a. Click on Stock – Product Management – Product Account Group icon for following screen. 

This setup is mandatory when the posting type selected in the Inventory Account Posting Settings is configured as by Product Account Group. To verify or configure this setting, users should navigate to their system settings and access Account Posting Settings.

b. How to Add a New Item to Your Product Account Group

1. Click the New Icon:
   In the upper-left portion of the screen, click the New icon to begin.

2. Fill in the Item Information:
   A table will appear where you need to enter the following details:

   • New Item Name
   • Description
   • Sales Account
   • Cost of Sales Account
   • Sales Return Account
   • Stock Adjustment Account
   • Stock Surcharge Account
   • Cost of Service Account
   • Purchase Account
   • Issue Account
   • Purchase Return Account
   • Receipt Account
   • Closing Stock Account
   • Service Accrual Account

3. Select Corresponding Accounts:
   For each category, choose the appropriate account based on your business processes.

4. Select Item Type:
   In the 'Type' section, tick the boxes for Service and/or Stock, depending on the nature of your item.

5. Mark as Inactive (if applicable):
   If the item is no longer in use, you can check the Inactive option.

6. Save the Information:
   After filling in all the necessary fields, click Save. Your new item will now be added to your product account group.

How to Create Product Brand/Size/Made? 

Click on Stocks – Product Management – Product Brand icon for the following screen.

Click on Stocks – Product Management – Product Size icon for the following screen

Click on Stocks – Product Management – Product Made icon for the following screen

• Enter the Size, Brand, Model, and Made options as shown in the examples above.
• The codes are limited to 4 alphanumeric characters.
• The descriptions are limited to 40 alphanumeric characters.

Important: Size, Model, Brand and Made are mainly used as additional analysis tools for various reports in the system. Some of the most commonly used reports are Sales Analysis-Product Size Model Wise and Inventory reports that can be sorted by Model and Brand.

How to Set-up Stock Conversion Factors?

1. Click on Stock– Product Management – Conversion Factors icon for following screen. 
2. Take note that this setting is for general conversion which will apply to all the products. If conversion is specific to each product, the setting is done in Custom Conversion Factor tab of each product in Stock – Maintenance – Products & Service Maintenance.

How to Set-up Inventory Control Account? 

Click on Stock – Maintenance – Inventory Control Account for following screen.

In UNIQ365, this option determines how the GL is to be updated when saving transactions. You need to specify the chart of account codes for Sales, Purchase and Inventory transactions.

 Important: Being a packaged solution, UNIQ365 caters for almost any type of industries with 3 types of stock posting options.
1. No Stock Posting
2. Cost of Sales Posting
3. Closing Stock Posting

 Stock Posting Methods

1. No Stock Posting

• Inventory module is not linked to GL.
• All the movement of the stock could still be captured in inventory module.
• User needs to post a journal entry manually to Closing stock & Opening stock accounts for month end closing or year-end closing.
• Normally, Profit and Loss Account will be presented as follows: 

In this case, Purchase Account will be categorized under Expense account.

Below is an example of a double entry for: - 

a. Purchase Invoice amounted to $500.00

b. Sales Invoice amounted to $1,000.00

2. Cost of Sales Posting

• Inventory module is linked to GL.
• Closing stock will be automatically updated when Sales,
• Purchase or Inventory transactions are performed. 

Profit and Loss Account will be presented as follows:

• In this case, Purchase Account will be categorized under Liabilities account. 

Below is an example of a double entry for:-

a. Purchase Invoice amounted to $500.00

b. Sales Invoice amount of $1000

3. Closing Stock Posting

• Inventory module is linked to GL.
• Closing stock will be automatically updated when Sales, Purchase or Inventory transactions are performed.
• Normally, Profit and Loss Account will be presented as follows:

• In this case, Purchase Account will be categorized under Expense account.
• Below is an example of a double entry for: - 

a. Purchase Invoice amounted to $500.00

b. Sales Invoice amount of $1000

You need to fix the relevant GL Account for Stock Control A/c (B/S), Stock Issue Account, Stock Receipt Account and Closing Stock Account. 

Important: After you have decided on the Stock Posting Method, you can now set up the auto posting for the Stock Control Account (B/S), Stock Issue Account, Stock Receipt Account, Stock Take Adjustment A/c, Cost of Sales A/c & 
Closing P/L Stock Account based on the guidelines set above.

Guide: The setting is Fixed if you only have one account but should be set as Product if you have multiple accounts. For example, if you have multiple Stock accounts (i.e. Stock-Computer Hardwares, Stock Software, Stock-Accessories, Stock-Others).