Create New Product
The Product Management tab comprises the following options that are crucial in setting up and using the STOCKS Module:
- Product & Service Maintenance
- Product Group
- Product Account Group
- Unit of Measure
- Product Brand
- Product Size
- Product Made
- Conversion Factors
- Inventory Control Account
- Product Data Import
Important: Before proceeding to create a new product or service code, we need to setup some Optional fields (such as Product Group, Size, Model, and Made, Discount Group, Customer/Supplier IM Group and Product Price Group), as well as some Mandatory fields (such as Product Account Group, Inventory Control Account, Units of Measures and Conversion Factors).
Product & Service Maintenance
Product Group
How to Create Product Group?
- 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.
Product Account Group
Unit of Measure
Product Brand, Size, Made
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.
Conversion Factors
Inventory Control Account
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
Debit | Credit | |
Purchase Account | $500 | |
Trade Creditor Control | $500 |
b. Sales Invoice amounted to $1,000.00
Debit | Credit | |
Trade Debtor Control | $1000 | |
Sales Account | $1000 |
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
Purchase Account | ||
Trade Creditor Control | ||
Closing Stock B/S |
Product Data Import
Warehouse Locations