In Tally - Entry of Stock Item Opening Value

4151 views 14 replies

at the time of entering value for stock item you do not have ability to enter different rates of items as your opening value for the item.

 

suppose you are dealing in Groundnuts, and you have stock of 200 kg for which 100 kg is of cost value rs. 50 & another 100 kg is of cost rs. 60....

 

so in this case how to do the same in the tally..........

 

if you know how, then pls reply the same

 

Akash Unadkat - Rajkot (Guj.)

Replies (14)

create multiple item of different rate under same group. eg. create Groundnutsas group item and create Groundnuts @ 50 and Groundnuts @ 60 under this group.

shailesh

create a group under that group make different items like Group Maruti and items Maruti 800 and maruti......

This will work 100% For this type of problem: Activate "Maintain Batch wise Detail" feature by pressing F11. In Item creation set Maintain in Batches to yes and enter batch name as Rs 50, Rs. 60 etc., and you will be able to store different rates of a single item. Manoj Garg

Cant it be taken on average value ???

You can. But if you want to track the movement of items of different rates, it will help you.

i was working on original tally..on my system....due to some problem i have to format the pc...now i am not able to register my original tally on other system...what should i do now??
 

You have to contact the Tallysolutions.com stating the Problem, Serial No., emailid for solution.
Originally posted by : Manoj Garg
This will work 100%


For this type of problem: Activate "Maintain Batch wise Detail" feature by pressing F11. In Item creation set Maintain in Batches to yes and enter batch name as Rs 50, Rs. 60 etc., and you will be able to store different rates of a single item.

Manoj Garg

You have 2 option for this


one as suggested above my friend

For this type of problem: Activate "Maintain Batch wise Detail" feature by pressing F11. In Item creation set Maintain in Batches to yes and enter batch name as Rs. 50, Rs. 60 etc., and you will be able to store different rates of a single item.

 

Other Option is ...


DO PURCHASE ENTRY IN PREVIOUS YEAR OF THIS ..

MEANS IF YOU HAVE OPENING STOCK OF RS 50 *3000 QTY AND RS 60*1000 QTY IN 2009-10THEN

DO PURCHASE ENTRY IN 2008-09 OF 50*3000 AND 60*1000 

NOW YOU CAN USE THIS STOCK IN CURRENT YEAR

FURTHER IN INVENTORY ITEM

YOU ALSO CAN SELECT METHOD OF METHOD OF COSTING STOCK  , THERE IS AVG METHOD OF STOCK IS IN DEFAULT THIS OPTION CAN BE SHOWN

GATEWAY OF TALLY
--INVENTORY - ALTER ---F12 IN THIS --INVENTORY MASTER HEAD--?>ALLOW ADVANCED ENTRY IN MASTER .. YES

SO THAT U CAN CHANGE METHOD OF COSTING STOCK

YOU HAVE TO CHANGE AS FIFO OR LIFE OR WHATEVER OTHERE THAN AVERAGE SO AS TO DIFFERENCIATION OF STOCK ....

 

FIFO IS SUGGESTED

 

REGARDS

-KALPESH VEKARIYA - RAJKOT

I think the other option is not correct.
Originally posted by : P K



I think the other option is not correct.
 


Dear Friend .. P K!

Tally dont work on your thought,


How can you tell without trying it....

as u have not tried or u could not understand, fact will not change dear..!

you are telling is what that if u had not seen japan then u will say there is no japan.. it is absense of  ur knowledge that japan is not that, it's a fake

but please try it and tell me what is problem .. running or not....

i am using in my office this method directly or indirectly..!


regards

Mr. kalpesh vekariya Goodmorning, Accounting dont work on your thought, If you are doing something wrong, it dose'nt mean everybody has to follow you. Please read the question carefully. He just wanted to know how to enter opening balance of an item having different rates. How can you do purchase entry in previous year for entering the opening balance of an item. Point No. 1. If you close books for a FY how can you do any entry in that year. Point No. 2. If you are computerizing the accounts and inventory for the first time in tally and want to create an item having stock of two different rates, how can you do purchase entry in previous year. How will you track the item ? How will you get the report that you have an item of different rates. As you written above, that you are using this method in your office. You enter the opening balance of an item in purchase of previous year, then the …….. knows the status of your …. . Regards. PK

Dear Friend  Following is the self explanatory..

Accounting is the continous process for the pupose of understanding i have attached tally backup to solve your doubts...

/editor_upload/590218523tbk500.001

          Cement  
          Kalpesh  
  Particulars       1-Apr-2009 to 31-Mar-2010  
 
        Inwards Outwards Closing Balance
          Quantity     (Alt. Units)     Value     Quantity     (Alt. Units)     Value     Consumption     Gross Profit     Perc %     Quantity     (Alt. Units)     Value  
 
  Opening Balance                                                             2,000 kg           1,10,000.00  
 
  April                         500 kg           26,000.00     25,000.00     1,000.00     3.85 %     1,500 kg           85,000.00  
 
  May                                                             1,500 kg           85,000.00  
 
  June                         500 kg           28,000.00     25,000.00     3,000.00     10.71 %     1,000 kg           60,000.00  
 
  July                                                             1,000 kg           60,000.00  
 
  August                         200 kg           13,600.00     12,000.00     1,600.00     11.76 %     800 kg           48,000.00  
 
  September                                                                         48,000.00  
 
  October                                                                         48,000.00  
 
  November                                                                         48,000.00  
 
  December                                                                         48,000.00  
 
  January                                                                         48,000.00  
 
  February                                                                         48,000.00  
 
  March                                                                         48,000.00  
 
 
 
  Grand Total                         1,200 kg           67,600.00     62,000.00     5,600.00     8.28 %     800 kg           48,000.00  
 
 

Here is the file uploaded


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register