Featured Post

TNTET 2017 BREAKING NEWS

TNTET 2017 BREAKING NEWS | ஆசிரியர் தகுதித்தேர்வு நடத்த அனைத்து ஏற்பாடுகளும் தயார்...ஓரிரு நாட்களில் முறையான அறிவிப்பு வெளியாகிறது...| விண்ண...

Sunday, January 13, 2013

Merge two Stock Items in Tally.ERP 9


How to merge two Stock Items in Tally.ERP ?
Merging two Stock Items in Tally.ERP 9
It is assumed that you have two Stock Items viz “Item 1″ and “Item 2″ and you need to merge the “Item 2″ into “Item 1″ such that all the Vouchers having “Item 2″ would show “Item 1″ after the merge-process.
PS:
a) Take backup of your Tally data for safety purpose before trying out the underneath steps.
b) We have tested Merging of two stock items with Tally.ERP 9 Release 3.0 only
Step-by-step instructions:-
  1. Change Tally.ERP 9 configuration settings
    a) Select option “Gateway of Tally >> F12 >> General”
    b) Set the option “Overwrite Vouchers during Import” to Yes
  2. Set the period in Tally.ERP 9
    Select option “Gateway of Tally >> Alt+F2″ and set the period. Example if you have vouchers for three years, set the period accordingly so that the whole data is accessible.
  3. Export Tally.ERP 9 data in XML
    a) Select option “Gateway of Tally >> Display >> Daybook >> Alt+F2″ and set the full-period
    b) Next, export Tally.ERP 9 data using “Alt+E” in XML format.
  4. Make changes in XML data
    a) Open the file “Daybook.xml” in Notepad and find/replace all occurrences of the “Item 2″ with “Item 1″.
    Remarks: The file daybook.xml is created in step-3 on exporting data  using Alt+E
    b) Save the Daybook.xml file
  5. Import data in Tally.ERP 9
    a) Select option “Gateway of Tally >> Import of Data >> Vouchers”.
    b) Specify the file-name (ex: daybook.xml) and press enter to import it.
  6. Verify the Vouchers in Tally.ERP 9
    Select option “Gateway of Tally >> Display >> Daybook” and check vouchers to verify the merging-
    process.

No comments: