1 / 25

Shoper 9 Tally.ERP 9 Interface

Shoper 9 Tally.ERP 9 Interface. January 2010. Objectives. Shoper 9 Tally.ERP 9 Interface - Scope Need for Shoper 9 Tally.ERP 9 Interface Benefits of Shoper 9 Tally.ERP 9 Interface Create Interface Mapping Prerequisites Settings Mapping Options Post data to Tally.ERP 9 Online Posting

alyn
Download Presentation

Shoper 9 Tally.ERP 9 Interface

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Shoper 9 Tally.ERP 9 Interface January 2010

  2. Objectives • Shoper 9 Tally.ERP 9 Interface - Scope • Need for Shoper 9 Tally.ERP 9 Interface • Benefits of Shoper 9 Tally.ERP 9 Interface • Create Interface Mapping • Prerequisites • Settings • Mapping Options • Post data to Tally.ERP 9 • Online Posting • Offline Posting • Tally Interface Utilities - Uses

  3. Shoper 9 Tally.ERP 9 Interface • Seamless transfer of data from Shoper 9 to Tally.ERP 9 • Update books of accounts using the data transacted in Shoper 9 • Incremental posting to avoid duplication and optimise posting time Shoper Data Response Tally

  4. Need for Shoper 9 Tally.ERP 9 Interface • Create and maintain Books of Accounts. • Use data from Shoper 9 to update Books of Accounts. • Generate Financial Reports: Balance Sheet, Profit and Loss A/c, Trial Balance, etc. • Generate VAT computation statement. • Assist in filing VAT Returns and generate VAT Annexures for all Indian States.

  5. Benefits and Advantages • Books of Accounts are updated at the click of a button • Financial and Statutory reports are available immediately • Inbuilt feature, requires no external hardware or software components • Seamless posting, gives high visibility and security • Frees the user from the need to have accounting knowledge and make duplicate entries

  6. Interface Mapping • Configuring Tally • Tally Compliant Product (TCP) • Settings in Tally.ERP 9 • Creating Mapping • Mapping options • Posting data to Tally.ERP 9

  7. Configuring Tally.ERP 9 • Tally.ERP 9 can be enabled to import data from Shoper 9 through an interface mapping. • Tally Compliant Product (TCP): Tally Compliant Product (TCP) file includes the program scripts that form the customisation framework. This file enables Tally.ERP 9 to recognise and import data from Shoper 9. • Copy the TCP file to Tally.ERP 9 application folder. • Edit the Tally.ini file. 1.Set the field User TDL = Yes. 2.In the following line, enter TDL = <path>\TCP file name (directory path where TDL file is saved and the file name)

  8. Configuring Tally.ERP 9 • Now that the TCP file is copied to the application folder and changes are made to Tally.ini file, start Tally.ERP 9 and make the following settings: • Create a company in Tally.ERP 9 • Select the appropriate State and Country • Set the Financial Year from to the date from which you want to post transactions from Shoper 9 • To handle all the VAT related transactions: Enable VAT in the F11: Statutory Features • Set the option Enable Value Added Tax (VAT) to Yes • Set the option Set/Alter VAT Details to Yes • In the VAT Details screen, enter the VAT registration details for the selected state

  9. Configuring Tally.ERP 9 • Accounting Features: In F11: Accounting Features enable/disable the given parameters. • Alter the Voucher Types Payment, Receipt, Sales, Purchase, Debit Note and Credit Note and set the given fields as shown below:

  10. Create Mapping • Shoper provides a simple and user friendly interface to Add or Edit interface mapping • Go to Menu >Setup > General > Tally Interface – Mapping • Click Add to create a new Mapping

  11. Create Mapping – Map Name • A Map Name is provided when creating a new mapping • The Map Name provided has to be unique on a network

  12. Create Mapping - Options • Shoper 9 provides a variety of configuration options during interface mapping • Enter Details of Tally.ERP 9 site such as Server IP, Port No. and the Company in Tally.ERP 9 to which the data has to be posted

  13. Create Mapping - Options • Transactions entered in Shoper 9 can be posted either Bill by Bill or Cumulative or select No positing to avoid posting the particular transaction type to Tally.ERP 9

  14. Create Mapping - Options • In addition to different transactions, additional information can be selected to be posted to Tally.ERP 9

  15. Create Mapping - Options • Select the option Offline Posting to create an Offline interface • Enter the date from which data has to be posted to Tally.ERP 9 in Post From field

  16. Create Mapping - Options • Different name formats can be used for masters sent to Tally.ERP 9 and also add Prefix or Suffix to them • User can also Preview Mapping details

  17. Preview and Save Settings • After selecting the mapping options, click Preview Mapping to view the mapping details • Click Save Settings to save mapping with the given map name

  18. Posting Data • Once the mapping is created, posting data from Shoper 9 to Tally.ERP 9 is a one step process. • Go to Menu >Housekeeping > Data Export Masters > Post Transactions to Tally • Shoper 9 will display all the mappings created. Select the required Map name and click Post to transfer data to Tally.

  19. Transfer of Data • Data is posted directly to Tally.ERP 9 without any external intervention or conversion • Masters are posted during the mapping process • Transactions are posted on each Map Id using menu option in Shoper 9 • At the same time, an acknowledgement from Tally.ERP 9 is also updated in Shoper 9 directly • In an Offline posting, both data created in Shoper 9 and acknowledgement of receipt from Tally.ERP 9 are created in the form of files and transferred manually • The data file is imported in Tally.ERP 9 using TSBridge application • The acknowledgement file is also transferred manually

  20. TS Bridge • TSBridge: It is a controlled data import application at the Tally.ERP 9 site. This tool helps Tally.ERP 9 import data sent from Shoper 9 and create an acknowledgement file that is sent to Shoper 9. • TSBridge comes with an installation exe and is installed at the site of Tally.ERP 9 application. • The TSBridge application folder displays the following components: • In folder: The data file received from Shoper 9 is copied to this folder enabling import into Tally.ERP 9. • Out folder: The response from Tally.ERP 9 is created in the form of a file in this folder. This file is manually transferred to Shoper 9 application folder. • Log folder: This folder contains the log files for import process. • TSBridge exe: The exe will start the import process and displays the progress using a message window.

  21. Data Response Offline Posting • Offline posting option can be used to send data when Shoper 9 and Tally.ERP 9 are not connected by a network • Mapping: Select the option Offline Posting in Tally Synchronisation Mapping Manager window • Transfer of Data: The Data files created are transferred manually and updated using TSBridge application

  22. Offline Posting Process • Posting Transactions to Tally.ERP 9 will create a data file in <Shoper 9 application folder>\Out folder • Transfer this file to <TSBridge application folder>\In folder • Double click TSbridge.exe • Tally.ERP 9 imports the data and creates a response file in the <TSBridge application folder>\Out folder • Transfer this file to <Shoper 9 application folder>\In folder • When Post Transactions to Tally operation is executed the next time, Shoper 9 reads this response file received from Tally.ERP 9 and creates a data file with incremental data Note: First time posting of data for a particular Map Id will require the user to provide information about Tally.ERP 9, similar to the details provided during creation of mapping.

  23. Tally Interface Administration Tools • Shoper 9 Tally.ERP 9 Interface module comes with associated tools to help the user to monitor and control data posting • Change Company Information: Substitutes Tally.ERP 9 Company in an Interface • Delete Mapping: Deletes a mapping permanently • Change Masters: Accepts changes made to masters in Tally.ERP 9 • Manage Missing Voucher: Repost the vouchers deleted in Tally.ERP 9 • Offline Re-posting: Reset the last posting information in an Offline Interface when the response file from Tally.ERP 9 is lost or not working

  24. Questions & Answers For more information log in to: www.tallysolutions.com

  25. Thank You

More Related