Friday, June 17, 2011

Re-arranging of Voucher No, Invoice No. in Tally

Friends,

Some times there is a need to re-arrange the Voucher No's and invoice No's in Tally. The question arises whether  there is  any way to rearrange voucher numbers, invoice numbers in tally? If you are in the middle of the financial year and want to re-arrange invoice number for some reasons like adding suffix to invoice number, need of a new starting number etc.

In normal cases some people use voucher number s restarting every month, i.e. every month starts with a fresh invoice number or voucher number. Some uses the continuation of same number until the end of a financial year. Generally speaking nobody changes the invoice number in the middle of a financial year.

However if you require re-arranging of voucher numbers for some reasons you can do it with the following methods.

Let’s change the voucher numbers of the following sales vouchers.

As in the above invoice number starts with 1, we can change the starting number with 1001 with a suffix and prefix   ABC/1000/2011-12

So our invoice number should be like this

ABC/1001/2011-12
ABC/1002/2011-12
ABC/1003/2011-12
ABC/1004/2011-12
ABC/1005/2011-12
ABC/1006/2011-12

Go to   Gateway of tally » Accounts info »Voucher types »Alter

Select the sales voucher and set “Use Advance Configuration” as “Yes”

Press enter a new screen appear make the following changes in the field
Starting number = 1001
Width of numerical part =4

Restart numbering
Applicable from = 1.4.2011
Starting number =1001
Particulars = yearly    if you want to restart voucher number monthly you can select likewise.
Prefix Details
Applicable from = 1.4.2011
Particulars = ABC/
Sufix Details
Applicable from = 1.4.2011
Particulars = /2011-12
Below image will give you a clear picture.

Now save the entire screen.

This will do in Tally ERP9 Series, but older version does not change automatically. You need rewrite tally data to see the effect of the change you made.

How to rewrite tally data
Before rewriting data you must back up tally data.
1. Go to gateway of tally then press Alt+Ctrl+R at a time.
2. Now select the company that you changed the voucher number
3. Press Yes to “Rewrite”

After completion of rewrite, you can see all the voucher numbers will have changed.


Thanks for Your Visit

style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8636229337784449"
data-ad-slot="2782765492">

Labels

2012-13 (1) 80C (33) 80E (22) 80GG (8) Aadhaar (21) Accountant (70) admiss (1) Admission (48) Admit Card (10) AICL (3) AICTE (4) AIEEE 2012 (6) Allahabad Bank (3) Andhra Bank (3) Anna Hazare (11) APDSC (3) APSPSC (4) ASI (3) Asia Cup 2012 (2) Assistant (212) Assistant Manager (106) Auditor (3) Axis Bank (4) B.Ed (23) Bank of India (6) Bank of Maharashtra (10) BARC (6) BHEL (66) BMB (1) BOB (13) BOI (6) BPCL (30) BPO (1) BSEB (1) BSF (16) BSNL (13) Canara Bank (11) Capital Gain (2) Career (246) CBSE (16) CCS HAU (3) CDAC (2) Central Bank of India (10) Central Excise (36) Challan Status (7) Champions League (11) CHB (3) CHSL (5) Clerical (128) Company (8) Conductor (2) Corona (1) Corono (1) Covid-19 (2) Cricket (3) CRPF (5) CSIR (3) CTET (21) CUHP (2) Customs (23) CWE (29) Data Entry Operators (26) Date Sheet (2) dbtl (1) DDA (7) Dearness Allowance (5) Delhi Metro (32) Delhi Police (51) Delhi University (50) Dena Bank (1) Digital Signature (7) DJB (2) DLF IPL (13) DMRC (13) Driver (1) DSSSB (3) e-Filing (69) e-Payment (27) e-TDS (61) Engineers (230) EPFO (8) FaceBook (3) FCI (4) Food Civil Supply (8) Foreign Trade (1) Forms (14) Formula One Race (3) Free Internet (8) Freshers (4) GAIL India (62) GATE (10) GET (1) GGB (1) GIC (2) GNDU (2) Government (6) GPRS (2) HAL (5) Happy Diwali (2) HCL (3) HECL (1) High Court (13) HOLI (2) HPCL (33) HPEG (1) HPPSC (27) HPSEB (7) HPSSB (9) HRA Rebate (6) HSSC (23) HTET (16) HUDA (4) IBPS (62) ICC World Cup 2015 (10) ICICI (3) IDBI (1) iim (3) IIST (1) IIT-JEE (12) IIT-Ropar (1) Importer Exporter Code (3) Income Tax (314) Indian Air Force (25) Indian Army (33) Indian Bank (10) Indian Navy (25) Indian Railways (18) INFOSYS (11) Inspector (37) Intel (1) Intelligence Bureau (10) IOB (5) IOCL (40) IPL T20 (28) ISAT (3) ISRO (7) ITI (3) JPSC (2) Junior Engineer (195) Jurisdiction (1) Kendriya Vidyalaya (2) Knowledge (1) KPCL (5) KUK (9) KVS (3) LAW (1) Lecturer (1) LIC (11) Lok Sabha (3) Lokpal Bill (9) LPG (3) Lum-Sum Savings (4) M.Ed (5) Madhya Pradesh (1) Manager (105) MBA (6) MCD (4) MDU (22) Medical Reimbursement (3) Mewar (1) MICR (2) Misc (20) Mobile (2) MP High Court (8) MPPEB (3) MSOFFICE (10) MTNL (2) NBCC (13) NDA (2) NDMC (2) NET (1) NIT (1) Nokia (1) Non-Teaching (40) NPCIL (6) NPS (1) NRDC (1) NRI's (1) NSDL (5) NTPC (9) OBC (13) Officer's (165) ONGC (12) OPGC (1) OPGCL (1) Oriental Insurance (5) OROP (1) PAN (11) Patwari (3) PFC (1) PGB (1) PGI Rohtak (7) PGIMER (6) PGT (12) PNB (18) Post Office (13) Power Grid (24) PPF (7) Probationary Officer (66) PTU (3) Punjab and Sind Bank (12) Railway Budget (17) Rajasthan Police (13) Rajya Sabha (1) RBI (23) REC (1) Refund (2) Register Your Company in 24 HRS (8) Result (64) RGU (2) RITES (10) RPSC (5) RRB (20) Sahaj (2) SAIL (51) SBI (41) SBOP (6) Scholarship (5) SDE (5) Service Tax (16) Service Tax Rate 12.36 (2) Shortcut (2) Sikkim University (3) SMS (1) Sole Proprietorship Business (1) Solved Test Papers (5) Specialist Officer (39) SSC (34) st-3 (1) Staff Nurse (4) STAT test (10) Sugam (1) Supreme Court of India (6) Syndicate Bank (2) T20 (14) Tally (13) TAN (2) TCS (3) Teaching (38) Technical (189) Term Deposit Interest (37) TGT (11) Ticket Booking (3) TIN (2) TMC (1) TRACES (3) Trainee (31) Tution Fee (3) Twenty20 (4) Typist (1) UCO Bank (4) UDC (2) UGC (4) UID (7) Union Bank of India (7) Union Budget (6) United Bank (4) UPCL (3) UPPSC (27) UPSC (38) UTI (4) Vijaya Bank (3) VIZAG (3) WBSEDCL (1) Wipro (3) WORD DOCUMENT (5) Yahoo (1)

Infolinks