Data split in tally|Think for due date while posting entries in tally

Data splitting in tally is very necessary upon completion of the financial year.Data splitting means separation of two financial year of the company data. Data spiting help you to avoid creating a new company for every financial year. If you create a new company for the new financial year, then you will have to go a long way e.g. creating all the new ledger, grouping, opening balances sheet further, there will not be consistency in the financial reports. So, the best solutions is to split your data between two difference year. It will also speed up your tally software and it will require less MB spaces.

Recently one tally nine reader Ms.Shakuntala, raised a problem while she was trying to split the company for the new financial year starting from 1st April, 2010. When she try to split the data, she was facing an error namely incorrect due date for bill ref. no…. due to this, she was not able to split her data. After modifying that particular bill due date, she had successfully splited her data.

Tally support helped her to identify the particular bill

Let me explain you this problem and solutions in more details.

when you create a supplier ledger, it will ask for default credit period. I will suggest you, even if you don’t have any credit policy for your supplier/debtors, you should specify a default credit period of 15 days, 30 days or whatever you wish so.Do this job starting from the first bill of the  .supplier. IF you set a default credit period for a supplier/customer after entering few bills, then re enter all the past bill of that supplier again setting a default due date.

If you don’t do this, then tally system will automatically pick a due date which might be a date prior to the commencing of the current financial year and due to this, you will not be able to split your data!

If you are facing such problem, and not able to identify that particular bill  which is creating problem in data splitting then don’t’ worry. Here is a way to find out that bill. First of all, run your data splitting wizard and it will tell you the reference number of the bill which has an incorrect due date.After that, following process, will help you to find out this bill.

Go to Display from the main menu of tally.

image thumb2

Select Statements of accounts

image thumb3

Select outstanding

image thumb4

select Payable  (you may follow the same process step by step in case of receivable)

image thumb5

It will show you all the bill reference number, voucher number, name of supplier and its due date. alternatively you

Alternatively, Press Alt+F12

and select the criteria as shown below

image thumb8

in the blank field here, type the particular ref number of the bill and you will find that bill which is creating the problem. Once you find out that bill, go to alteration mode of that bill, and remove the due date . keep it blank or select any bill falling under the current FY and accept the screen.

Do share your experience with tally nine readers if ever you have used tally support.

Latest Comments
  1. sameer April 10, 2010
    • Mahendra April 10, 2010
  2. Nagarajan.S April 15, 2010
  3. madhu April 18, 2010
    • Mahendra April 18, 2010
  4. madhu April 18, 2010
    • Mahendra April 18, 2010
  5. SOMA April 19, 2010
    • Mahendra April 19, 2010
  6. Deepak April 23, 2010
    • Mahendra April 23, 2010
  7. girish sharma May 3, 2010
  8. Manimozhian.M September 7, 2010
    • Mahendra September 9, 2010
  9. prakasan October 14, 2010
  10. srikanth October 17, 2010
    • Mahendra October 17, 2010
  11. Pradeep January 27, 2011
  12. Ashok January 31, 2011
  13. diren February 26, 2011
    • Mahendra February 27, 2011
  14. ELIZABETH RANI April 8, 2011
  15. Dhanya April 8, 2011
  16. RAKESH KUMAWAT April 8, 2011
    • Mahendra April 8, 2011
  17. Rakesh Ranjan Rath April 28, 2011
  18. Girishkumar May 6, 2011
  19. khyati June 20, 2011
  20. Dush September 24, 2011
  21. BIJENDRA September 26, 2011
  22. Jyothi October 10, 2011
    • Mahendra October 11, 2011
  23. sudha November 2, 2011
  24. Hari Rai November 17, 2011
    • Mahendra November 18, 2011
  25. VISHAL SHAH November 17, 2011
    • Mahendra November 18, 2011
  26. Ashish Fogla March 18, 2012
  27. kunal May 19, 2012
  28. Tushar May 28, 2012
  29. Annie Prakash June 14, 2012
  30. Jitendra July 2, 2012
    • Mahendra July 2, 2012
  31. Shaileshkumar Maisuria July 4, 2012
  32. aliasgar July 7, 2012
  33. Arpit shah July 23, 2012
  34. sabari August 29, 2012
  35. Nirmala June 27, 2013

Leave a Reply

Your email address will not be published. Required fields are marked *

Optimization WordPress Plugins & Solutions by W3 EDGE