Free Items and Discount Practical Assignment in Tally

AD Computer Campus

Free Items and Discount 

Practical Assignment 

1.   Introduction

 

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

‘Osiya Distributors Pvt Ltd’ from Pune is engaged in FMCG products trading, as it is promoting new products in the market it offers ‘Freebies’ and ‘Discounts’ to get these products a market share.

Set-up Tally for handling free items and discounts.

 

1.1.           free items

Various types of promotional and free items are given to retailers and customers, some of them are

1.     Buy one get one free

2.     Buy one item and get another item free

3.     Free samples distribution to retailers

 

1.1.1.     Business Scenario I – ‘Buy one get one free’

The company sells below stock items on an offer

Stock Item Name	Offer
Detergent Bar - 250g	Buy 1 and Get 1 Free
Detergent Bar - 500g	Buy 2 and Get 1 Free

 

Record 2 sales transactions with Actual and Billed Quantity and print the invoice.  Check inventory reports for movement of goods.

 

1.1.2.     Business Scenario II - Buy one item and get another item free

Offer for ‘Buy one item and get another item free’

·       Buy 5 Nos ‘Hand Wash Bottle’ and get 1 No ‘Hand Wash Refill’ free

·       Buy 10 Nos ‘Soap Powder - 1kg’ and get 1 No ‘Hand Wash Bottle’ free

Record 2 Sales transactions for each type and see the inventory reports for movement of goods

 

1.1.3.     Business Scenario III – Free samples distribution to Retailers

·       10 Nos ‘Soap Powder - 20g’ sachets given free to retailer M/s Anand Traders

Record this zero valued transaction and see the inventory movement.

 

1.2.           discounts

Company offers discount on some stock items, record transactions according to business scenarios for discounts offered.

1.2.1.     Business Scenario I - Item-wise Discount

Company gives discount as shown below for stock items:

Stock Item Name	Rate	Discount %age
Floor Cleaner - Big - 1ltr	230	5%
Floor Cleaner - Small - 500ml	75	2%

 

Record sales transactions with item-wise discount

 

1.2.2.     Business Scenario II – Invoice Discount

Company gives cash discount to some of its customers

Stock Item Name	Qty	Rate	Amount
Floor Cleaner - Big - 1ltr	5	230	1,150
Floor Cleaner - Small - 500ml	10	75	750
Sub-Total			1,900
Cash Discount			-100
Invoice Total			1,800

 

 

2.   outcome

 

Below are the outcomes after setting up multiple addresses as per business scenarios, this is for your reference to ensure that you have done it properly.

 

2.1.           Free items

2.1.1.     Buy One Get One free

   

 

2.1.2.     Buy one item and get another item free

  

 

2.1.3.     Free samples distribution to Retailers

 

 

2.2.           discount

2.2.1.     Item-wise Discount

 

 

2.2.2.     Invoice-wise Discount