Advance Inventory Set-Up Assignment in Tally

 

 Advance Inventory Set-Up 

Assignment in Tally

1.   Introduction

Read the below-given business scenario and implement it in TallyPrime by creating a company for ‘Abhay Distributors Pvt Ltd’.

1.1.  Business Scenario I

‘Abhay Distributors Pvt Ltd’ from Kochi is into distribution FMCG (Fast-Moving Consumer Goods) in Kerala.  They want to see reports based on type of consumer goods, e.g., Soap Powders, Shampoos, Tooth brushes, etc.,

1.1.1.   Stock Group Creation

Create Parent Groups and Sub-Groups as per below-given details:

1.     Soap Powders

a.      Washing Machine Soap Powders

                                                                     i.     Front Load Washing Machine Powders

                                                                    ii.     Top Load Washing Machine Powders

b.     Hand Wash Soap Powders

2.     Shampoos

a.      Anti-dandruff Shampoos

b.     Anti-hair Fall Shampoos

3.     Toothbrushes

a.      Adults’ Toothbrushes

b.     Kids’ Toothbrushes

 

1.1.2.     Stock Item Creation

Sl No	Stock Item Name	Stock Group	Opening Balance	Rate per No
1	Surf Excel Matic 5 Kg (Front Load)	Front Load Washing Machine Powders	11 Nos	750
2	Henko 5 KG (Front Load)	Front Load Washing Machine Powders	5 Nos	680
3	Surf Excel 5 Kg (Top Load)	Top Load Washing Machine Powders	9 Nos	550
4	Henko 5 KG (Top Load)	Top Load Washing Machine Powders	13 Nos	590
5	Surf Excel Soap Powder 1 Kg	Hand Wash Soap Powders	50 Nos	44
6	Henko Soap Powder 1 Kg	Hand Wash Soap Powders	61 Nos	53
7	Dove Anti-dandruff Shampoo	Anti-dandruff Shampoos	21 Nos	135
8	Himalaya Anti-dandruff Shampoo	Anti-dandruff Shampoos	19 Nos	130
9	Dove Anti-hair Fall Shampoo	Anti-hair Fall Shampoos	22 Nos	132
10	Himalaya Anti-hair Fall Shampoo	Anti-hair Fall Shampoos	48 Nos	142
11	Colgate Tooth Brush – Zig Zag	Adults’ Toothbrushes	90 Nos	25
12	Oral-B Care Tooth Brush	Adults’ Toothbrushes	40 Nos	56
13	Oral-B Kids Tooth Brush	Kids’ Toothbrushes	10 Nos	66

 

1.1.3.     Check Reports

·       Stock summary with all details expanded for Group and Sub-group classification

·       Group Summary report for parent group such as Washing machine soap powders

 

1.2.  Business Scenario II

‘Abhay Distributors Pvt Ltd’ wants to classify stock items brand-wise, so that they can analyse the reports. 

 

1.2.1.     Create ‘Stock Categories’ as given-below details:

1.     Surf Excel

2.     Henko

3.     Dove

4.    Himalaya

5.     Colgate

6.     Oral-B

1.2.2.     Alter Stock items for selecting ‘Stock Categories’ as per given-below table:

Sl No	Stock Item Name	Stock Category
1	Surf Excel Matic 5 Kg (Front Load)	Surf Excel
2	Henko 5 KG (Front Load)	Henko
3	Surf Excel 5 Kg (Top Load)	Surf Excel
4	Henko 5 KG (Top Load)	Henko
5	Surf Excel Soap Powder 1 Kg	Surf Excel
6	Henko Soap Powder 1 Kg	Henko
7	Dove Anti-dandruff Shampoo	Dove
8	Himalaya Anti-dandruff Shampoo	Himalaya
9	Dove Anti-hair Fall Shampoo	Dove
10	Himalaya Anti-hair Fall Shampoo	Himalaya
11	Colgate Tooth Brush – Zig Zag	Colgate
12	Oral-B Care Tooth Brush	Oral-B
13	Oral-B Kids Tooth Brush	Oral-B

 

 

1.3.  business scenario iii

‘Abhay Distributors Pvt Ltd’ has started operations in different locations, they have added branches, warehouses.  Now it wants to track stock items location-wise.

 

1.3.1.     Activate and create Godowns

1.     Main Location - Kochi

2.     Branch 1 - Thiruvananthapuram

3.     Branch 2 – Kannur

 

 

1.3.2.     Record given-below transactions:

·       On 10^th April 2019, stocks transferred from Kochi to Thiruvananthapuram Branch

Sl No	Stock Item Name	Opening Balance
1	Surf Excel Matic 5 Kg (Front Load)	3 Nos
2	Henko 5 KG (Front Load)	2 Nos
3	Surf Excel 5 Kg (Top Load)	3 Nos
4	Henko 5 KG (Top Load)	4 Nos
5	Surf Excel Soap Powder 1 Kg	20 Nos

 

·       On 11^th April 2019, stock transferred from Kochi to Kannur

Sl No	Stock Item Name	Opening Balance
1	Henko Soap Powder 1 Kg	31 Nos
2	Dove Anti-dandruff Shampoo	11 Nos
3	Himalaya Anti-dandruff Shampoo	11 Nos
4	Dove Anti-hair Fall Shampoo	10 Nos
5	Himalaya Anti-hair Fall Shampoo	23 Nos

 

1.4.  business scenario iv

‘Abhay Distributors Pvt Ltd’ has started receiving orders from customers, as well it wanted to send orders to suppliers.  It wants to have ‘Right stock available at right time’, now it wants to replenish stock as they sell.

1.4.1.     Activate order processing and record transactions

·       On 15^th April 2019, received Purchase Order No 131 from customer ‘Quick Traders’

 

Sl No	Stock Item Name	Ordered Qty	Rate
1	Surf Excel Matic 5 Kg (Front Load)	3	875
2	Henko 5 KG (Front Load)	2	770
3	Surf Excel 5 Kg (Top Load)	4	570
4	Henko 5 KG (Top Load)	5	630
5	Surf Excel Soap Powder 1 Kg	10	52

Note:  Check ‘Saleable Stock’ report in Stock Summary after recording this order.

·       On 16^th April 2019, the company sent an order to Supplier ‘Famous Distributors Ltd’ via Order No 001

 

Sl No	Stock Item Name	Ordered Qty	Rate
1	Surf Excel Matic 5 Kg (Front Load)	10	750
2	Henko 5 KG (Front Load)	10	680
3	Surf Excel 5 Kg (Top Load)	10	590
4	Henko 5 KG (Top Load)	10	550
5	Surf Excel Soap Powder 1 Kg	20	44

Note:  Check ‘Net Stock’ report in Stock Summary after recording this order.

 

1.5.  price list

‘Abhay Distributors Pvt Ltd’ wants to fix prices for different types of customers like Retailers, Customers, etc.,

1.5.1.     Activate Price list and Create Price List

Sl No	Stock Item Name	Retailers’ Price	Customers’ Price
1	Surf Excel Matic 5 Kg (Front Load)	850	900
2	Henko 5 KG (Front Load)	800	850
3	Surf Excel 5 Kg (Top Load)	700	750
4	Henko 5 KG (Top Load)	650	700

 

1.5.2.     Create ledgers and assign Price List

Create couple of the customers under ‘Retailers’ and ‘Customers’ assign Price List to them

Note:  Check the price is picked automatically in an invoice

 

2.   Reports outcome

 

Below are the outcomes after recording transactions in business scenarios, this is for your reference to ensure you have done it properly.

2.1.  business scenario I

2.1.1.     Stock Summary Report (expanding all levels)

 

2.1.2.     Group Summary

 

2.2.  business scenario II

2.2.1.     Stock Category Summary Report

 

2.2.2.     Stock Query Report (to see Items of Same category)

 

2.3.  business scenario iii

2.3.1.     Godown Summary Report (with New column and expanded in all levels)

 

2.3.2.     Stock Query Report (for seeing Godown-wise stock availability)

2.3.3.     Stock Summary (expanded in all levels to get Godown-wise details)

 

2.4.  business scenario iv

2.4.1.     Saleable Stock report

 

2.4.2.     Sales Order Outstanding Report

 

2.4.3.     Net Stock Report

 

2.4.4.     Purchase Order Outstanding