Tally Integration
Window Introduction
Introduction
Introduction:
Masters are the containers of the Accounting Data. These are the heads, which will be set once and used in many places such as Accounting Voucher Creation, Reports Generation etc. Data stored in Masters is independent.
Business Example:
Masters are the most important entity to record transactions in tally.The accounting masters primarily consist of Group,Ledger and voucher types.
Tabs
Tally Integration master
Critical Fields:
1) Tally Company name - Tally integration company name to be maintained.
2) Sales Voucher Type - Mention accounting voucher name used to record sales transactions made by a business.
3) Receipt Voucher Type - It is a type of accounting voucher used to record money received from customers.
4) Purchase Voucher Type - It is used when you have to purchase some goods from any party and you get an invoice against cash or credit purchase from the party.
5) Journal Voucher Type - It is used to record financial transactions other than cash and bank.
6) Payment Voucher Type - Payment voucher is used to account all the payments made by the company by way of Cash/Bank.
7) Fill tally Ledgers -
Critical & onetime setup fields:
1) Organisation - This Field is used to select the organization which you are going to process tally integration.
2) Accounting schema - An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar.
Non-critical fields:
Serial number/Lot number (ASI):
Zoom conditions:
Customization:
Ledger Mapping
Exclusion
Critical Fields:
1) Document type - The Document Type determines document sequence and processing rules & by using this we can eliminate document type which will be generated while exporting XML file in tally XML generation.
Document Mapping
Critical Fields:
1) Name - It is used to mention the type of entries ex - Purchase,sales etc.,
2) Document type - Based on selected document type XML file will be exported in tally XML generation window.
Procedure
Procedure
Step 1:
The name of the business partner should be kept in the Name 2 field in the business partner header.
Step 2:
Details of the ledger should be mentioned in the description field of the account element window.
Step 3:
Voucher type details should be mentioned in tally integration master.
Step 4:
Details to be exported in tally XML generation will be based on document type mentioned in the tally integration master tab.
Step 5:
The month from which data to be exported must be entered in the header details of the Tally XML generating window.After completing it XML lines will be generated with the help of generate XML lines button & document will be completed.
Step 6:
Export XML file button will be displayed after completing the document, then data should be exported.Exported data will be saved in attachments.
Three XML files will be saved in attachments for particular month - Business partner XML file,Master XML file & Transaction XML file.
Step 7:
Download XML file & maintain that in separate folder.
Step 8:
Import Business partner & Master XML file in tally Masters, then Import Transactions XML file in tally transactions menu.