Tally Integration tool in Retail POS Accounts*
Tally Integration is addon tool which is used to export accounts data in xml file and import to tally ERP. Many users use tally as their accounting tools. So the users who wants to maintain the tally erp as their accounting tool can export data from our POS accounts to tally erp.
Business rules
- Tally integration is very much useful feature retail or any kind of business.
- Tally integration tool will export data in two type
- Auto export
- Manual export
- In both type, all the masters and vouchers from POS accounts will exported in xml file and uploaded to Tally.
- So the user can use the both our POS application and Tally application for them.
- There should be the separate menu called Tally integration in accounts, user should open that tally integration tool while configuration.
- User should create a separate company in Tally erp application.
- Then user will create one test ledger and do payment against that ledger and export day book report from Tally.
- Day book should be exported as xml file and user can find “GUID number” of that created company in exported day book xml file.
- Once GUID number found, then user can config both POS accounts and Tally ERP using that GUID number.
- To config tally erp and accounts, user should open the tally integration tool and select the company name and then enter the GUID number from the tally day book xml file.
- After that user will select the export type from one of the option “auto or manual”
- For manual export option tally company name and POS accounts company name can be different. But for Auto export the company name should be same in both the applications.
- For manual export, user will browse the folder for file export and for Auto export user should enter the Tally ERP product IP code.
- Then user will select the option for export data like which data need to be exported from the following option
- All transaction
- Sales
- Purchase
- Sales & Purchase only.
- Then also user need to select the options like export ledgers with opening balance or not, export ledgers with code or not and export ledgers with address or not.
- Then user will save this above settings.
- Once configuration is done by user, Then there should be the menu called export in tally integration tool where user will select the company, financial year and the specific date range and click on export.
- For manual export, the system will download the xml file in selected folder, user will import that file in tally erp import menu.
- For auto export, data will be uploaded directly to tally for respective company.
- In this feature tally integration tool will export both master and voucher data in xml file separately. So user also need to import the master and voucher file separately in tally erp.
- User should import master first and then user need to import voucher.
- After importing the data, if any transaction is changed in POS accounts, then user need to reexport the data from tally integration tool.
- For reexport, there should be the separate menu in tally integration tool where user will enter admin password and select company, financial year and specific date range.