• Acceso a una base de datos (Oracle) mediante ASP y ODBC Proyecto AjpdSoft. The Oracle ODBC Driver for Rdb follows the Microsoft ODBC 3.0 Software Development Kit (SDK) guidelines for manipulating and displaying real and double data types.
• Normally ODBC Driver submits SQL request from the ODBC client and these SQL request will be executed and result will be given back to the ODBC client. Tally.ERP 9 is a application which can act as ODBC Server as well as ODBC Client.

IT Resources. Born To Learn blog. Find technical communities in your area. Azure training. Official Practice Tests. All applications seem to work fine but something's lacking: the x64 ODBC Drivers for Access and Excel are not available in the 64 bits odbcad32.exe.

I'm currently working on a project for a class at my University. I am learning about connecting and manipulating databases and we are using a Microsoft .accdb file.

Here is what I have so far.

When looking for 'sun.jdbc.odbc.JdbcOdbcDriver' I am getting the following output.

It seems simple enough to work through. It seems I am missing the driver or something along those lines. However I am having a hard time finding out what to do about this. Is the driver included with the JDK anywhere? Must I download something separate? Does it depend on my Operating System? (Mac OS X 10.9). Or am I simply doing something wrong in code?

I would appreciate the help! Thanks!

Additional Info:

2 Answers

As mentioned in the comments to the question, the JDBC-ODBC Bridge is - as the name indicates - only a mechanism for the JDBC layer to 'talk to' the ODBC layer. Even if you had a JDBC-ODBC Bridge on your Mac you would also need to have

• an implementation of ODBC itself, and
• an appropriate ODBC driver for the target database (ACE/Jet, a.k.a. 'Access')

So, for most people, using JDBC-ODBC Bridge technology to manipulate ACE/Jet ('Access') databases is really a practical option only under Windows. It is also important to note that the JDBC-ODBC Bridge will be has been removed in Java 8 (ref: here).

There are other ways of manipulating ACE/Jet databases from Java, such as UCanAccess and Jackcess. Both of these are pure Java implementations so they work on non-Windows platforms. For details on how to use UCanAccess see

Didn't work with ODBC-Bridge for me too.I got the way around to initialize ODBC connection using ODBC driver.

Not the answer you're looking for? Browse other questions tagged javamacosms-accessjdbcjdbc-odbc or ask your own question.

Some of the new features in Tally.ERP 9 include,

Remote Access

Tally.ERP 9 provides remote capabilities to its users to access data from anywhere. Using Tally.NET features, the user can create remote users (ids), authorize & authenticate them to access company remotely. Currently, the remote connectivity allows the user to view/display the required information on his system instantly.

The process for remote access is as follows:

• Start Tally.ERP 9, load the required company and connect to Tally.NET

• Enter the remote user ID at the remote login location to access company data from Tally.ERP 9 Licensed / Educational.

Requirements for Remote Connectivity:

At the Customer’s Location:

• A valid Internet connection

• A valid Tally.ERP 9 License with a Tally.NET subscription

• Create and authorise remote users for a Company that has to be accessed remotely

• Load & Connect the Company to Tally.NET for remote access

Note: For the company to be accessed by the Remote User the computer has to be kept on and Tally.ERP 9 with company loaded.

At the Remote Location:

• A valid Internet connection

• Tally.ERP 9 (Licensed/Education)

• A valid remote User ID and Password

Benefits of Remote Access:

• Provides anytime, anywhere access to required information

• Allows you to access Reports & Statements on the move to keep yourself updated with the latest Business happenings.

• Enhances response time to customers (For e.g., Sales staff can access Customer’s Outstanding Statement for immediate reference / discussion)

• Easy access to financial information for faster & timely decision making.

Data Security:

• The Remote connectivity is initiated with a secured Handshake between two computers using Tally.NET environment.

• Customer can allow / disallow access to the Company Data for remote users at any point of time.

• Data resides on the Customer’s Computer only.

• Encrypted Data is transferred between two computers on request.

• The customer can assign Security controls to remote users depending upon what access to be given.

• For the Remote user(s) Back up / Restore options will not be available in the remote location.

Remote TDL’s

During Remote Access, the additional TDL’s running at the customer’s place will also be available to the Remote User at the remote Location.

The user experience remains the same either working locally on Customer’s Computer or from a Remote Location. It is recommended to use Broadband connections to enjoy the best Remote experience.

Tally.NET

Tally.NET is an enabling environment which works behind the scenes to facilitate various Internet based services in Tally.ERP 9. Each Tally.ERP 9 is enabled for Tally.NET Services by default. Tally.NET provides the following services/capabilities in this release of Tally.ERP 9:

Tally.NET Features

• Create and maintain Remote Users

• Remote Access

• Control Centre

• Support Centre

• Synchronization of data (via Tally.NET)

• Product updates & upgrades

The following services will be available in the forthcoming releases:

• Online help capability in the form of reference Manuals, Articles and FAQ’s

• Access information from Tally.ERP 9 via SMS from mobile

• Employer Recruitment Test

Simplified Installation Process

Tally.ERP 9 comes with a new enhanced installer, which allows the user to configure different settings from a single screen, as per requirements.

New Tally.ERP 9 Installer

The new installer allows the user to install Tally.ERP 9 application as well as License Server, however you may choose to install either of them one after the other.

Using the new Installer, the user can install Tally.ERP 9 and License Server separately on different Computers/folders or same folder.

• While installing Tally.ERP 9, the user can specify the path for Application, Data, Configuration and Language files to be stored.

• While Installing Tally.ERP 9 on the Client machine in a multiuser environment, the user is required to provide the Computer Name / IP Address and Port Number of the computer, where the License Server is installed & running.

Uninstaller:

The Uninstaller wizard similar to the Installer, also provides flexibility to uninstall either Tally.ERP 9 application or License Server separately or both together. If only License Server is uninstalled, then Tally.ERP 9 will switch to Education mode on the Client Computer.

Tally Admin Tool

The TallyAdmin tool is a new component that has been introduced with Tally.ERP 9 which enables the user to perform the following activities without starting Tally.ERP 9

• Initiate License Service operations.

• Display the active Tally.ERP 9 License Servers in a LAN.

• Administer Site License for different products from Tally.ERP 9.

• Check network connections between the computers designated as Client and Server.

• Convert TCP and TSF files of Tally 9 to the format compatible with Tally.ERP 9.

The Tally Admin Tool is available in the Tally.ERP 9 application folder, on installation.

Introduction to TDL Server DLL Component

Tally.ERP 9 onwards, a new component TDLServer.DLL has been introduced, which gets copied to the folder in which Tally.ERP 9 has been installed. All the default TDL files of Tally have been integrated in this component. On invoking Tally.ERP 9, these TDL’s will be loaded. The user TDL’s will be subsequently loaded as usual from Tally.ini.

The componentization will result in a more robust application. The benefits of this componentization are as follows-

• In case of any updates/ changes in TDL, only TDLServer.dll file needs to be downloaded and not the entire Tally application which enables faster downloads.

• This will help in dynamic loading and unloading of TDL Files while Tally application is running

• Forthcoming Tally Developer will be directly using this component, thus eliminating the need for a separate DefTDL.dat file.

Unified File Format for Tally.ERP 9

The Tally.ERP 9 application folder contains files other than the data files. These are referred to as secondary files. From this release onwards the file format of all the secondary files have been standardized.

TCP Files

All the TDL files which were compiled for previous versions of Tally as .tcp have to be converted to a new format. Mentioned below are the ways in which this can be done.

Note: The TDL files in txt format does not require this conversion.

Conversion of Tally 7.2 tcp files to Tally.ERP 9 Format

Tally7.2 tcp files can be migrated to Tally.ERP 9 format using the Tally72Migration tool available in the Tally.ERP 9 folder. Migration process is the same as earlier.

Conversion of Tally 9 tcp files to Tally.ERP 9 Format

• Automatic Conversion Process: When Tally.ERP 9 is installed in the existing Tally 9 folder then all the files with .tcp extension included in the “tally.ini” file are automatically converted to the Tally.ERP 9 compatible format. The original “.tcp” file is renamed as “<filename>.tcp.BAK”. The name of the file which is converted to new format is same as the original filename. The original TCP file is retained as a backup file.

• Manual Conversion Process: To manually convert the files in the new format use the Conversion tab of Tally Admin Tool.

It is mandatory to specify the File Type. The file Type can be TSF or TCP.

• TSF: Converts tally configuration file from old format to new format e.g. tallysav.tsf to tallycfg.tsf

• TCP: Converts TCP file from old format to new format.

In the Source File box specify the name of file to be converted.

In Destination File box provide the name for the converted file.

Note: Start Tally.ERP 9 and check the status of your TDL file. [Go to Gateway of Tally, click F12:Configuration > Functions and Features] If the status is Active, then the tdl is compatible to Tally.ERP 9 format. If the status is Error, then scroll down to the line and press enter to know the details. Then make the TDL syntactically compatible as per the Tally.ERP 9 standards.

Configuration File

Manually the file “Tallysav.tsf” can be converted to the new standardized format by selecting “TSF” as the file type in the Conversion tab of Tally Admin Tool. Ensure that the destination file name is “Tallycfg.tsf”

Licensing in Tally.ERP 9

Tally.ERP 9 launches a new Licensing mechanism which is simple, user-friendly and addresses all the licensing activities from a single screen for users across segments of business. Besides, allowing activation of Single User (Silver) and Multi User (Gold) license, it also extends the feature to Multi-Site Licensing.

The salient features of Licensing are:

• License Activation is simple and easy two step process.

• Introducing the concept of an Account for better management & administration of Licenses through the Control Centre.

• Provide your Account ID and Password to reactivate license

• The flexibility and compatibility to centrally manage multiple licenses across locations in a secured environment

• Removes all licensing data from your computer for a particular instance of license.

Site Licensing

A new concept of Site Licensing is introduced from Tally.ERP 9. A site refers to activation of Tally.ERP 9 Single or Multi User license. The site licensing is broadly classified into two categories namely Single Site and Multi-Site.

• Single Site: A single instance of Tally.ERP 9 Silver or Gold license is active at a time under an Account.

• MultiSite: Is more than one active Tally.ERP 9 Silver or Gold licenses on different machines under a single account comprising of same or different Serial numbers.

Advantages:

• Centrally configure Sites / License across locations.

• An Account is created using your E-Mail ID provided in the activation form.

• All the serial numbers are assigned to the Account.

• User can split an Account or merge two or more Accounts.

• The Account information is accessible using the Account ID and Password.

Licensing Mechanism

• Provide the required details and your E-Mail ID in the activation form.

• On processing the request an encrypted (not in readable format) license file is generated and needs to be decrypted using a set of character and numbers called key.

Control Centre

Control Centre is a new feature being introduced with Tally.ERP 9. This utilises Tally.NET as an interface between the end user and Tally.ERP 9 installed at different locations. With the help of Control Centre, you will able to:

• Create users with predefined Security levels

• Centrally Configure & manage your Tally.ERP 9

• Surrender, Confirm or Reject activation of a Site

• Maintain Account related information

Following are brief descriptions of the features of the Control Center:

Create users with predefined Security levels

Using the Control Centre feature, the Account Administrator can create users and map them to a predefined security level and authorise them to access a Site/Location linked to that Account. Further, the system administrator can also create Remote users (Tally.NET Users & Tally.NET Auditors) and allow / disallow them to remotely access the data.

The predefined security levels in Tally.ERP 9 are:

• Owner - This security level refers to the ownership for the complete Account. The Owner can create Standard Users or Owners with required permissions.

• Standard User - Created by the Owner with required permissions.

Centrally Configure and manage your Tally.ERP 9

The Control Centre provides the flexibility to create (or change) the master configurations set for an Account and apply them to one or more sites (all sites) belonging to that Account.

The following master configurations set can be made from the Control Centre:

• Add/Modify the Tally.ini parameters

• Assign TDL’s to a site or all the sites under an Account

• Permit or Deny changes to the local configurations

The master configurations set created, is applied initially to the Account centrally, which is then inherited by the site(s) on updation of license, based on the site level permissions defined by the Account Administrator.

Surrender, Confirm or Reject activation of a Site

The Account Administrator is authorised to surrender, confirm a site license or Reject the request received on activation from another site.

Maintain Account related information

Allows you to maintain information about the organisation. Based on the requirements, the Account Administrator can merge multiple accounts into one or split an account into multiple accounts for easy and better management.

Support Centre

Tally.ERP 9 provides a new capability known as Support Centre, wherein a user can directly post his support queries on the functional and technical aspects of the Product. Using Support Centre feature, the user can view all the support queries reported via Support Centre and also through other modes viz., Email, Calls, etc.

The Support Centre feature facilitates viewing queries for an activated license along with the Status i.e., Closed / Pending and Ticket Summary. The report is viewed based on Date, Status and Location.

Faster reach for help and support

The Support Centre makes it easy and convenient to reach out Tally Support, including the Tally Service Partner, for any product help and support, by a click of a button from within the product.

Access solutions to your problems any time

This feature facilitates instant reference to the solutions provided for your queries at any point of time.

Avoid repeated explanations

Availability of information on the issues, interactions and resolutions, to the entire Tally Support Team, including the Tally Service Partners largely reduces the possibilities of repeated explanations on the issues/support queries and thereby ensures quality help and support.

Track your issues on real-time basis

Support Centre enables you to track the status of your queries including the full chain of interactions irrespective of the mode of communication. If you have posted a query from the Support Centre within Tally.ERP 9 and then interacted over the phone, you will be able to see both the interactions.

Access issues of any Location/Site

In case of Multi-site License, you can view the details of issues of any location /site from any of your Location(s).

Reach out to your nearest Partner instantly

You can search for a service partner and post your queries instantly.

Access your Support Centre remotely from any Tally.ERP 9

As an authorized Tally.NET user, Support Centre feature can be accessed remotely from any Tally.ERP 9 (active or in Educational mode) from anywhere. Support Centre also allows you to Select the required account from the list of User Accounts in case your ID (user name) is linked to multiple accounts.

Configure Tally.ERP 9 from Tally.ERP 9

The user can make all the necessary changes to the product configuration from Tally.ERP 9 itself by going to Data Configuration, TDL Configuration, Advanced Configuration and Licensing options available under F12:Configurations from Gateway of Tally. This provides a flexible option for the user to make changes in the Tally.ini file (Configuration file) and apply them from the application itself.

• Data Configuration - To specify the default Companies that should load during start up and path for the data files, language files, Confide files.

• TDL Configuration - Displays the additional TDL’s (Local TDL’s, Account TDL’s, and Remote TDL’s) and the user can specify the Local TDL’s that need to be loaded. The TDL’s specified will be loaded dynamically (without restarting Tally.ERP 9).

• Advanced Configuration - To configure Tally.ERP 9 as Server/Client/none, as ODBC Server and the port configured for ODBC or Data Sync.

• Licensing - To configure the License path in a Multiuser environment.

New Look & Feel

Resizing Screens

The user can resize the Tally.ERP 9 screen/window. The resize parameters such as height and width are defined in the Tally.ini file. The user can compare identical reports of different companies by changing the screen size for the two instances of Tally.ERP 9.

Multiple Selection capabilities

The user can now select multiple lines in a Report at single instance. On selecting multiple lines, the user can delete or hide line(s) based on the requirement of the report.

Bottom Button Toolbar

Another new component that has been introduced in a set of buttons located at the bottom part of every report and Data Entry screen. Click on the button or press the relevant keys to perform the required task.

Information panel

A new component titled Information Panel or Info Panel has been introduced which is located in the bottom part of the Tally.ERP 9 screen. The Info Panel has five blocks namely Product, Version, Edition, Configuration and Calculator. The user can click on any one of these blocks to view the detailed information.

Product

Displays the logo and product name. The user can click on this section to go to Tally Solutions website to view the latest happenings.

Version

This part of the Info Panel displays the Release, Build, Date on which the recent License Update is done. In case Tally.ERP 9 is not updated with the recent Release/Build, the info panel will take you to the Download Center get the latest update. The user can also click on as on Date to update the License. It also displays the information on the Type of License (Silver/Gold/Auditors’ Edition).

License

Displays the Serial Number, Site ID, Account ID and Tally.NET subscription details.

Configuration

Displays the Stat and Client Server Information. Stat Information will take the user to the Download center to download the Latest Stat file. The Client Server Information will allow the user to re-configure the settings. The Additional TDL’s loaded will also be shown in this section.

During Voucher Entry or while viewing reports the information panel is hidden to provide additional working space. However, you can click on the directional arrows to restore the information panel as and when required.

Calculator

Displays the Connection status while connecting to Tally.NET, during Data Sync, and Remote connectivity. This can also be used as Calculator.

Enhanced Payroll Compliance

Payroll in Tally.ERP 9 is now simplified & enhanced to handle all the functional, accounting and statutory requirements of your business. The following Statutory features and processes have been incorporated for faster, better and accurate payroll processing.

Payroll Statutory Features

The following statutory features have been incorporated in Tally.ERP 9:

• Provides automated computation and deduction/contribution of Employees & Employer’s Contribution towards Provident Fund.

• Provides a predefined PF process to expedite voucher entry and accurate processing of contributions.

• Generates the following Monthly / Annual statutory Challans & Reports:

• Form 12A: Statement of PF Contribution during a particular month

• Form 5: Details of the Employees joining during a particular month

• Form 10: Details of the Employees leaving during a particular month

• PF Combined Challan: Monthly Challan form to be submitted to the bank while paying the PF amount

• Form 3A: Employee wise Annual Payment details

• Form 6A: Annual Statement of PF contribution

• Facilitates automated computation and payment of following administrative charges with the help of predefined processes.

• PF Administration Charges @ 1.10%

• Employees’ Deposit-Linked Insurance Scheme (EDLI) @ 0.5%

• EDLI Administration Charges @ 0.01%

• Other Admin Charges (inspection charges, interest paid etc.)

Employees State Insurance (ESI)

• Provides automated computation and deduction/contribution of Employees & Employer’s Contribution towards Employees State Insurance

• Provides predefined ESI process to expedite voucher entry and accurate processing of contributions

• Generates the following Monthly / Half Yearly statutory Challans & Reports:

• ESI Monthly Payment Challan: Challan form to be submitted to the bank while paying the paying the ESI amount.

• Form 3: Monthly Declaration form

• Form 5: Half Yearly Return of ESI Contributions

• Form 6: Half Yearly Employee Register

Professional Tax (PT)

• Provides automated computation and deduction of Professional Tax based on user-defined Slab rates

• Provides predefined PT payment process to expedite voucher entry and accurate payment of Professional Tax

• Generate following PT Reports:

• PT Computation Report: Print reports with Slab-wise details of Professional Tax by the Employer

• PT Statement: Print monthly reports with Employee wise details of Professional Tax

Payroll Processes

The following pre-defined payroll processes have been provided to automate different functions in Payroll:

• Salary Process – Automates the Computation of Salary

• PF Process – Automates the Computation of Employer PF Contribution

• ESI Process – Automates the Computation of Employer ESI Contribution

• Salary Payment – Automates the Payment of Salary

• PF Challan – Automates the Payment of PF

• ESI Challan – Automates the Payment of ESI

• Professional Tax Payment – Automates the Payment of PT

Excise for Manufacturers

Tally.ERP 9 provides a complete solution for Excise related Business requirements for versatile industries. Salient features of Excise in Tally.ERP 9 are:

• The new Excise module allows you to maintain the required Central Excise records for multiple excise units of Traders /Manufactures in a single company.

• Excise module handles Ad valorem, Ad Quantum, MRP based Valuation Method for Excise Duty calculation, and also Expenses / Income can be apportioned for calculation of assessable value either by Value or by Quantity. Additional Expenses / Income can be apportioned for calculation of assessable value, both by Value or by Quantity.

• The user can maintain a Single Excise invoice book for all purposes of removals as per the requirement of Rule 11 and an option is provided to maintain the multiple Excise invoice book for a given Excise unit, the Serial number of Excise book will be generated as running series & with a check for duplicate numbers.

• The Excise Duty types & it’s Calculation Method are Pre-defined for error free calculation.

• Items can be classified as per tariff (CETSH/HSN) number, and to support error free calculation duty types and calculation methods can be pre-defined with options provided to manage excise duty for Exempt and Special Rates.

• An option is provided to avail CEVAT Credit during purchase entry or avail partial/full credit in a separate entry. Input Service Tax can also be taken as input credit towards Excise duty payable.

Excise Manufacturing Reports in Tally.ERP 9

• Personal Ledger Account (P.L.A.): This is to be submitted on a monthly basis with the details of Excise duty payments and payable.

• ER1: Monthly return for production and removal of Goods and other relevant particulars

• G.A.R.-7: Proforma for Central Excise duty payments

• CENVAT Credit on / Capital Goods Availed / Utilized Account: Details of CENVAT Credit availed and utilized for capital goods.

• CENVAT Credit on Inputs availed / Utilised Account

• Rule 11 Invoice: The Excise invoice can be generated as per Rule 11 requirements.

• Daily Stock Account (RG 1 Register): Provides RG1 Register as prescribed the excise dept. for daily entry of production and removals.

• Statutory Sales Register: provides complete details of Excise sales of finished goods.

Auditors’ Edition of Tally.ERP 9

Tally.ERP 9 offers a special Gold Auditors’ Edition, which provides Audit and Compliance capabilities exclusively for Chartered Accountants. The current release provides the following tools:

Using Tally.ERP 9, Chartered Accountants can provide Audit and Compliance services to their clients in the following scenarios:

Audit at CA’s office by accessing local data

The Auditors’ Edition includes the Audit/Compliance capabilities as a default feature without any dependency on Tally.NET for Authentication. When the Client’s data is locally available at CA’s office, the Auditor can perform the Audit or Verification as the Tax Audit and Statutory Compliance features are available by default.

Audit at Client’s place by accessing local data

When the Auditor wants to use the Auditors’ License from Clients Office to provide the Audit or Compliance Service, the Internet Connection and Tally.NET subscription is required. The Client should have authorized the Chartered Accountant as Tally.NET Auditor for the Company. In this scenario, Tally.NET is used to Authenticate the Auditor and fetch the Auditors’ License on the Client’s Tally.ERP 9. The Auditor can then open the Company and perform Audit or Verification in the same way as it is done in the Auditor’s office with Local data using the Auditor’s License.

In this scenario, the Auditor should have a valid Tally.NET subscription to perform Audit.

Audit Remotely by accessing Client’s data from anywhere

When the Auditor wants to access the Client’s Data Remotely and provide Audit and Compliance services from his office (or from any other remote location), the internet connection and valid Tally.NET subscription is a must for both Auditor and Client. The Client should have authorized the Chartered Accountant as Tally.NET Auditor and Connect the Company to Tally.NET at the time of Audit/Verification process. The Auditor will Login as Remote User and provide the Auditor’s Username and Password to view the Companies that are available for Audit (Connected) belonging to various Client’s based on the Access provided. The Auditor can open the required Company to perform the Audit/Verification and save the Audit/Verification Notes.

The user experience essentially remains the same in all the three scenarios.

Tax Audit

The Tax Audit feature in Tally.ERP 9 enables the auditor to compile information in comparatively less time with required accuracy to form his opinion and print Annexure as required for Tax Audit under Section 44AB. The following Clauses are available with respect to Form 3CD:

• Bonus PF, ESI Recoveries (Clause 16)

• Amounts inadmissible u/s 40A(3)(Clause 17(h))

• Payments u/s 43B (Clause 21)

• Employer’s Contribution

• Tax Collected at Source

• Service Tax

• Value Added Tax

• Loans / Deposits Accepted (Clause 24(a))

• Loans / Deposits Repaid (Clause 24(b))

• Fringe Benefits Tax (Annexure II)

Statutory Compliance

Statutory Compliance is a comprehensive tool available with Auditors’ Edition to provide Compliance services for the following Direct and Indirect Tax modules available in Tally.ERP 9.

• Value Added Tax (VAT)

• Service Tax

• Fringe Benefit Tax (FBT)

• Tax Collected at Source (TCS)

The salient features for Statutory and Compliances are:

• Taxation based in-built rules to classify the Masters and Vouchers as Possibly Incorrect (not created as per the recommended setup for each Taxation)

• Reasons for Possibly Incorrect Masters and Vouchers

• Auditor can concentrate only on Possibly Incorrect and save time

• No need for 100% verification of Masters and Vouchers (for other than Possibly Incorrect)

• Taxation based Payable & Paid information

• Taxation based Due Dates

• Random verification of In Accordance Masters and Vouchers

• Provision to raise Clarification on Master and Vouchers from Clients

• Provides facility to record Verification Remarks using Verification Note

Major Enhancements

Some of the major functionality changes in Tally.ERP 9 include,

• TDS Compliance

• Data Synchronization

• Size and Performance

• FBT

Tax Deducted at Source (TDS)

The TDS feature in Tally.ERP 9 has been revamped to handle all the functional, accounting and statutory requirements of your business in an accurate and simplified manner. The new/enhanced TDS features are:

• Option provided to the user to deduct the TDS at the time booking the Expense itself.

• The user can deduct the TDS in a single Voucher at the end of the month for all TDS related Expenses/ Advance Payments booked during a particular month.

• Provides an option to have a single Expense Ledger for multiple Nature of Payments. This will reduce the need to create Nature of Payments wise separate Ledgers.

• The user can have a single TDS Duty Ledger for multiple Nature of Payments. This will reduce the need to create multiple Duty Ledgers.

• Both TDS related and non-TDS related Expenses can be booked in a single Voucher. You can also deduct the TDS at the time of Voucher entry or later.

• Handling TDS for Non-Residents (Sec.195) Payments

• Tally.ERP 9 handles TDS deductions where payment to the contractor or the sub-contractor exceeds Rs.20, 000 in a single payment or Rs. 50,000 in aggregate during a financial year as prescribed under section 194C

• Surcharge Retrospective Calculation – Once the Surcharge Exemption Limit exceeds for a particular Nature of Payment for a Particular Vendor, the Surcharge will be calculated for the previous payments also.

• Facility to Print (Hard Copy) and Export Form 26, 26Q & related Annexure, Form 27, 27Q & related Annexure and Form 16A

• Provides the option to configure the Lower / Zero rate, Ignore IT / Surcharge Exemption Limit in the Party Creation screen. This will facilitate faster data entry as the user need not remember the party TDS details at the time of Voucher entry.

TDS related Reports in Tally.ERP 9:

• TDS Computation Report - This report will help the user to manage the TDS deductions.

• TDS Challan (ITNS 281) printing – Monthly challan based on the TDS sections.

• TDS Outstanding Reports – Displays the details of the TDS Outstanding for the selected period.

This can be filtered based on:

• TDS Payable

  Conditii: - Cazier auto fara inscrisuri grave ( permis retinut pentru consum de bauturi alcoolice sau acci. Cazier judiciar ilfov program.

• Nature of Payment wise

• Party wise

• TDS Exception Reports – This report will display the details of the vendor which are not having the required details for E-TDS filing (There are certain pre-defined fields to captured and validated before E-TDS filing). e.g. TDS parties not having PAN details.

• Form 16A – TDS Certificate to be provided to the vendors either at the time of Payment or at the end the year (Annually).

• Form 26 & Annexure – Annual returns of TDS deducted and paid.

• Form 26Q & Annexure – Quarterly returns of TDS deducted and paid.

• Form 27 & Annexure - Annual returns for Non-Residents for TDS deducted and paid.

• Form 27Q & Annexure - Quarterly returns for Non-Residents for TDS deducted and paid.

• E-TDS – Generates the required file for filing the TDS returns electronically.

• Form 27A – Covering Letter for E-TDS returns.

Data Synchronization Changes

Using Direct – Client and Server Capability

Direct- Client and Server capability for Synchronization through a private network will be incorporated as a default feature of Tally.ERP 9 Series A release 1.0 onwards.

Using Tally.NET Server

The process of Data Synchronization using TallyLink Server has been changed in Tally.ERP 9. Going forward Synchronization will be available as a service through the Tally.NET Framework. The user will be able to use Tally.ERP 9 Silver (SU) at both the ends to Synchronize data.

To use this service the Tally Server Company has to be Connected to Tally.NET server at the time of Synchronization.

Note:Tally.NET Server (TNS) will be used for Synchronization instead of TRB Server.

In Sync Configuration, under TallyLink Configuration, the options 'Use Tally Link” & 'Connect to Tally Link Server' have been removed.

Size and Performance changes

Automatic caching based on system memory

Report generation involving large amount of data was always impeded by the problem of high memory usage. In Tally.ERP 9, a new feature has been introduced to overcome this hurdle. The application now uses an automatic caching based on the memory of the system it is running on. This results in the usage of lesser memory even with higher data volumes.

Reports which were running out of memory or consuming a large amount of virtual memory on a 2GB system, will now respond even on a 1GB system. This can be observed by generating a report, say a day book containing 50,000 to 100,000 vouchers on a 512MB machine using the last major release as well as this release.

Faster Data Entry

The data entry speed has been considerably increased in scenarios where there are a large number of ‘Tracking numbers’ and ‘list of pending orders’. In other words, the time taken to make a single entry has been reduced due to the faster retrieval and display of tables for selection of tracking numbers and pending orders.

Application size reduction by three-fourth

A faster, powerful and a SMALLER Tally.ERP 9 application! The application has been redesigned to drastically reduce its size. The “exe” file of the application has been reduced to approximately three-fourth the size of earlier versions. To be more precise, it has been reduced from 10.7 MB to 1.96 MB. This will result in faster installation, loading, and opening of the application, thereby enhancing the overall user experience.

DATA SIZE Reduction

The data size for Tally.ERP 9 has been effectively reduced to 40%. This will help in enhancing the overall performance of the application.

Note: Data rewrite is mandatory in this release.

Performance

• GST Analysis Report - Performance of GST Analysis Report (Singapore) for a specific period has improved compared to Tally 7.2 and Tally 9 (earlier releases)

• Bank Reconciliation Statement- Performance of Bank Reconciliation statement for a specific period has improved compared to earlier releases of Tally 9.

• Memory and performance is Optimized for long reports like daybook based on vouchers.

Fringe Benefits Tax

The following enhancements are made in the Fringe Benefits Tax feature of Tally.ERP 9:

• FBT Annual Returns in Form ITR 8 along with FB I schedule displaying the details of computation of Fringe Benefits & Fringe Benefits Tax is available

• Exemption Amount field is provided for FBT transactions to capture exemption amount and to accurately calculate the FBT on the assessable value.

• F12: Configuration option in FBT Computation allows you to view FBT, Surcharge, Education Cess and Secondary Education Cess details in Separate columns, by enabling Show Tax Details.

TDL Enhancements for Tally.ERP 9

In Tally.ERP 9, major changes have been provided by the platform to enhance the TDL capabilities which helps the programmer to develop and deploy quick and efficient solutions with ease. Major improvements have taken place in terms of language usage standardisation and performance improvements.

Breakthrough enhancements at the Collection level to provide capabilities of Remoting and Advanced Reporting. Collection is now a complete Data Processing Artefact in TDL.

Let us now have an overview of the major enhancements that have taken place in the areas mentioned below. A detailed documentation for each of these enhancements is available in our document “TDL Enhancements for Tally.ERP 9”. This document along with corresponding Sample TDL’s can be downloaded from our website.

For detailed documentation refer to TDL Enhancements for Tally.ERP 9 on Tally Website.

Attributes and Modifier Enhancements

Based on user requirements and analysis many new attributes have been introduced. These have impacted the programmer in a way that has reduced their deployment time to cater to functional requirements. Some of the new usage have improved the performance drastically.

The behaviour and syntax of many attributes and modifiers have been changed to maintain consistency and ease of code. The sequence of evaluation of attributes and modifiers have been standardised.

Mentioned below is the complete set of new Attributes and Modifiers

• Report Attribute – Full Screen

• Key attributes – Scope

• Part attribute – Retain Focus

• Field attributes - Tool Tip, Set By Condition

• Collection Attribute – Subtitle

• New Modifier- Switch

Mentioned below is the list of existing attributes and modifiers for which the behaviour has been changed

• Attribute Set As and Info – When both are specified, Info takes Precedence

• Enhanced syntax of Local - Now can be nested

• Format Attribute

• Attribute Sync

• The sequence of evaluation of Attributes and Modifiers

• Modifier-Use

• Standardization of Modifiers Add/Delete/Replace across definitions

Enhanced Special Symbols

New special symbols have been introduced to take care of Multiline commenting (/* */), reinitializing definitions (*). The existing system formulas can now be modified for optimized performance using the extended behaviour of ‘#’

New Method Formula Syntax with Relative Object Specification

The $ operator has been enhanced with a new capabilities. This allows direct access to any object method including its sub-collections to any level with a dotted notation framework. Using the new capability, there is no need to repeat a line over a sub-collection to access it. The values from any object anywhere can be accessed without making the object as the current object in context.

Enhancements-Object Association & Object Access via Interface Object

In TDL, Interface Object exists in context of any data object. Every Interface object needs to be associated with some data object. In the absence of any explicit object association, Interface object will get associated with Anonymous object. TDL programmer can explicitly associate Interface objects like Report, Part, Line and Field with data object. There have been changes either in the form of syntax improvements or with the introduction of new attributes like “Object Ex” at the part level.

From this release onwards, data objects in associated with Interface objects can be accessed using the new Interface object access syntax. Now it is possible to identify an Interface object using Access Name and then use the enhanced method formula syntax to access the Data Object associated with it.

Data object which is associated to Interface Object can be accessed with the following 2 step procedure.

• Identifying Part and Line Interface object with ‘Access Name’

• Value/Collection Extraction

Bracket Support in Language Syntax

Prior to this release, the usage of TDL language token bracket (‘(’ and ‘)’) was restricted as mathematical operator only. From this release onwards brackets can be used in the following scenarios.

• During the function call to enclose the function parameter.

• In the language syntax for nesting formulas.

• As a Mathematical Operator

Action Enhancements

Key action is enhanced to perform various operations on multiple lines. Multiline selection capability is possible with the help of two attributes Scope (Key definition) and Selectable (Part and Line definition).

Some New and Changed Actions are mentioned below

New Actions

• Modify Object

• Set Object Values

• Browse URL

• HTTP Post

Enhanced Actions

• Print

• Mail

• Export

• Upload

User Defined Functions in TDL

This is one of the breakthrough changes which has taken place at the platform level. We all know that TDL is a definition language which provides capability for rapid development. But now TDL is procedural as well. With the introduction of Functions/Procedures as a part of Tally.ERP 9 family the TDL capabilities have reached a new dimension.

This will help the application programmers to develop their own functions for achieving business functionality. Their will be a decrease in platform dependency for particular business function. The resultant would be faster development cycles for business modules.

For detailed documentation, refer to User Defined Functions for Tally.ERP 9 on Tally Website.

Collection Enhancements

Collection, the data processing artefact of TDL provides extensive capabilities to gather data not only from Tally database but also from external sources using ODBC, DLLs, and HTTP and so on. A set of new capabilities have been added to Collection which provides far more flexibility and power in the hands of the TDL programmer. This will allow writing significantly complex reports with ease and still delivering enhanced performance with high volume of data.

The following are the capabilities which have been achieved using new collection enhancements.

Aggregation & Summarization

A major technological advancement in this release of Tally.ERP 9 is “Data Roll up in TDL Collection – GROUP BY”. This will now facilitate the creation of large summary tables of aggregations in a single shot using the new attributes of the Collection description. This allows us to Walk down the object hierarchies and gathers values and summarizes them in one scan. Overall it reduces the TDL code complexity, resource requirement and increases performance drastically in case of reports generated using this new capability.

Collection re-use, extraction and chaining

A collection can extract information from other collections including its sub-objects with the choice of method(s), filter(s) and sort-order. Source Collection within a collection, collection(s) can be chained. In other words, Summary Collection can be used as Source Collection for some other Collection and so on.

Indexed or Searchable Collection on TDL defined keys

The capabilities discussed above extend the data gathering capabilities of TDL. However business reporting in general and in Tally uses hierarchical presentation or columnar presentation rather than simple table representation. If Report is having two or more dimensions like Ledger and Cost Centre and so on, a simple repeat on the summarized collection will not suffice. In order to improve performance indexing capability has been introduced which will work with a key combination.

Usage as Tables

TDL allows to display the values obtained from the collection as a pop-up table. Earlier the values of voucher and the ODBC data can’t be displayed as a collection. Now all limitations pertaining to usage of Collections as Tables have been completely eliminated. Any collection which can be created in TDL can be displayed as a table now. Collection with aggregation and XML Collections can also be used as Tables.

Integration Capabilities using HTTP XML Collection

Collection capability has been enhanced to gather live data from HTTP/web-service delivering XML. The entire XML is automatically now converted to TDL objects and is available natively in TDL reports as $ based methods. Reports can be shown live from an HTTP server. The attributes in collection for gathering XML based data from a remote server over HTTP are RemoteURL, RemoteRequest, XMLObjectPath, and XMLObject.

Dynamic Object support for HTTP-XML Information Interchange

When a collection is used for editing (alter/create), objects are dynamically added to the collection when a new line is repeated over the same. The type of object which is added depends on the specification in the TYPE attribute. In case the TYPE attribute is not specified it defaults to adding a standard empty object.

However the following holds true for a COLLECTION keeping in mind the latest enhancements

• It can be made up of multiple types of objects (say Ledgers and Groups)

• It can have TDL defined objects which are retrieved from XML file. They are specified using XML Object.

• It can have aggregated objects

Depending solely on the TYPE attribute for deciding the object type is a constraint with respect to the above facts. This is now being removed with the introduction of a new attribute which will independently govern the type of object to be added to the collection on-the-fly. A new attribute NEW OBJECT is now supported for collection

Collection Capabilities for Remoting

Enabling access to your organizational data in an ‘any-time, any-where’ and yet being truly usable is what Tally.ERP 9 delivers. With Tally.NET enabled remote access, it will be possible for any authorized user to access Tally.ERP 9 from anywhere.

Major Enhancements have taken place at the collection level to achieve remoting capabilities. The attributes Fetch, Compute and AggrCompute provided at the collection level and FetchObject and FetchCollection at the report level significantly help in above functionality.

For detailed documentation, refer to Writing Remote Compliant TDL for Tally.ERP 9 on Tally Website.

Minor Enhancements

Accounting Masters

• In the Group Creation /Alteration screen, the option No Appropriation has been removed as it had the same behaviour of Not Applicable.

• On disabling TDS / TCS, in the Ledger Alteration, Tally.ERP does allow the manual selection of State.

• The field Rounding Method is provided in Ledger masters grouped under Duties & Taxes, Direct Expenses, Indirect Expenses, Direct Income, Indirect Income, Current Asset, Current Liability, Sales Accounts, Purchase Accounts and Primary Group in Purchase/Sales Invoice mode only.

Accounting Reports

• F8: Other Report option is disabled in Statistics and Group Payment Performance under Group Summary.

Accounting Vouchers

• In sales invoice, the Company’s/Buyer’s Tax Registration numbers will be printed in the order given below:

• Company’s VAT TIN

• Company’s CST No.

• Company’s Service Tax No.

• Buyer’s VAT TIN/Sales Tax No.

• Buyer’s Service Tax No.

• The Option ‘Show Ledger Current Balances’ in F12: Voucher Configuration is now applicable for Ledgers in Invoice Format. If this field is set to NO, the Current Balance of ledgers will not be displayed in the invoices.

• A Purchase order entered in a company with GST Registration number can be exported using Excel (Spreadsheet) or HTML format.

• Application supports the printing of Inventory Details for Debit Note, Credit Note, Payment, Receipt and Journal entered in voucher mode, by enabling the option Print Inventory Details in F12: Print Configuration.

• A Facility to print the serial number for each item in the Sales Invoice has been provided.

• An option has been provided to print the system date and time in all the reports including the Invoice.

Company Master

• Enhanced Company Creation Master with user friendly interface is provided.

• The F12 Configuration options are modified for all the masters. The F12: Configuration screen will now display only relevant configurations depending upon the selected Master/Voucher/Feature.

• A new option Disallow Opening in Educational Mode is provided in the Company Creation/Alteration mode as an additional scattier control measure to prevent the users from opening the particular Company in Educational Tally.ERP 9. This will appear only if the Security Control feature is enabled.

This feature will help to ensure that the unauthorised users does not open and view/alter/delete the Company data from Educational version of Tally.ERP 9. The users will be restricted to open the data without the Account TDL’s being loaded (which may have certain restrictions) in Educational Mode.

Cost Categories/Cost Centres

• Cost Centres will appear along with Cost Centre Class in all Vouchers.

CST

• In CST Forms Issuable / Receivable report, F12: Configure option is provided to sort details of Party in an alphabetical order.

E-mail

• SSL Interfaces are provided to enable the user to E-mail the required information from Tally.ERP 9 to external Mail servers. e.g. now you can use Gmail service to send E-mail through Tally.ERP 9.

Excise for Dealers

• In Excise Sales Invoice, Supplier Details for Stock item displays Rate of Basic Excise Duty and Excise DutyPer Unit along with supplier details and quantity purchased in the List of Purchases table.

• A separate column has been provided to display the Special Additional Duty in the printed format of Excise Purchase Invoice.

• In Gujarat Excise Sales invoice, a separate column has been added to display the HSN Code.

• In an Excise Purchase Invoice, an option has been provided to create a ledger under Manufacturer/Importer Details section in Supplementary Details screen.

• Configuration Use Excise Format in F12: Configuration is displayed only on enabling the option Allow Excise rules for Invoicing in F11: Features.

Fringe Benefits Tax

• Verification Details is provided in the FBT Print Configuration screen for FBT Returns to capture the Designation, Date and Place details.

Final Accounts

• If the option Income/Expense Statementinstead of P & L is enabled in F11: Accounting Features, then in Income and Expenses A/c report, F12: Configure displays Show Vertical Income & Expense Stmt. instead of Show Vertical Profit & Loss.

• In Statistics report, a facility has been provided to sort the voucher types using the configuration Sort by Parent Voucher Type.

Installation

• The language support for BahasaIndonesia and BahasaMelayu has been provided for Windows 98 & Windows NT operating system also.

Inventory Masters

• In the Stock Group and StockItem creation and alteration screen, a minimum width of 30 characters is provided to ensure visibility of names entered.

Inventory Vouchers

• The option “Show using Alternate Units” is provided in F12: configure of Stock Vouchers screen to display the alternate unit details for stock items.

Job Costing

• In Material Consumption Stock Summary report, Alt+C – New column will now display the details of all the Godowns, related to a particular Job/Project instead of other Job/Project (Cost Centre) details.

Licensing

• A Confirmation message is displayed when the user opts to surrender the licensed version of Tally.ERP 9.

• In the process of activating license, an hourglass will be displayed as an indicator to show the progress of activation.

Multi-currency

• Bank Reconciliation displays the accurate Closing Balance of Transacted Currency as per Company Books and Actual Balance, when 'Show Forex Transactions only' is activated in F12: Configure.

Payroll & Statutory

• The Payslip when emailed in HTML format contains the Company Name and Address.

• In the Pay Head Master, an option has been provided to round off the Gratuity amount.

• The Option ‘Show Zero Value Payslips Also’ is provided in Multi Payslip Printing to print the Blank Payslips.

• In Paysheet, the Grand Total of Attendance is displayed and the user can drill down to Attendance Voucher from Attendance details.

• Position Index for Reports of the Employee is set as Default Sorting Method for all the Payroll Reports, in addition Alphabetical (increasing) and Alphabetical (decreasing) options are added to the Sorting Methods list of Pay Sheet Configuration.

• Tally.ERP 9 now allows the user to group the (Income Tax) TDS Pay Head under Duties & Taxes and Salary Payable Pay Head under Provisions

• The option Show new joinees only has been renamed as Show zero valued Employees also in F12: Configuration of Gratuity Report.

• In Pay sheet report the option “Display Attendance/Production Types in Tail Units?” is provided under F12: Configure.

• New Pay Head Type Bonus has been provided in the Pay Head masters creation.

• In International Version of Tally Gratuity Report Option has been provided in Payroll Reports Menu.

• The Payroll Info. menu order has been changed as shown below:

• Employee Groups

• Employees

• Units (Work)

• Attendance/Production Types

• Pay Heads

• Salary Details

• Voucher Types

• The shortcut key for Payroll Reports (payroll statutory reports) under Statutory Reports has been changed from A to P.

• The option Payroll Configuration will be available by default in the F12: Configurations screen, whether the Company is selected or not.

• Professional Tax Pay Head can now be created with Calculation Period as both Month and Period. This will support the Professional Tax Computation either monthly or Periodically (Half Yearly) as required by some of the states (e.g. Tamil Nadu).

POS

• Party Details can now be entered and Printed in the POS Invoice.

Printing

• The Option “Print Narration for Each Entry” is provided in F12: Invoice printing Configuration to print narration for each entry in Purchase or Sales voucher.

• The Option “Print Narration” is provided in F12: Configure (Physical Stock Printing Setup) to print Narration in Physical Stock Voucher. The same facility is provided to print Stock Journal Voucher.

• Print Configuration is provided for Rejections In and Rejections Out Voucher Types.

• The Title provided in Print configuration screen of Payment/Receipt/ Journal/Debit Note/Credit Note voucher is changed from Printing Setup to Printing Configuration.

Reports

• Alt + Enter key has been provided for Remote as well as Local users, to facilitate to drill down to voucher level in Display mode

• Ctrl + Enter key has been provided for Remote as well as Local users, to facilitate to drill down to voucher level in Alteration mode

Security Control

• A warning message “Forgetting your password will render your data unusable!!” will be displayed when the user is setting or changing the Admin User Name and/or Password in Company Creation/alteration screen.

Service Tax

• In Sales Register columnar report, a separate column has been provided for displaying the Service Tax Registration number.

• In Service Tax Payables report, F4: Category button has been added to filter the services provided, based on the service category.

• According to the new notification the “Focal Bank Details” has been withdrawn from Company F11: Statutory and Taxation under Company Service Tax Details.

• Options have been provided to Display/Alter the Exemption Notification Number in item invoice.

• In service tax payment voucher, cheques/Draft/Pay order No and Bank Name fields are provided under ‘Payment Details’ sub screen in ‘Provide details’ field.

• Option to enter Challan No. and Challan Date is provided under Payment Details in Service Tax GAR 7 Payment Voucher, which will get printed in ST3 Form.

• Cost centre allocation has been provided for Service Tax ledgers created under Duties and Taxes while recording Sales Vouchers.

• The Service Tax Invoice captures Company's PAN Number after Buyer's Service Tax Number.

VAT

• In the voucher class screen of sales voucher type, the Calculation Methods Additional Tax and Cess on VAT can be selected only if the VAT Classification is selected in the respective sales ledger.

• When a Company opts for Composition to Regular VAT and tries to pass a purchase entry during composition period, in Purchase Accounting Allocation Screen VAT/TAX Class displays Composition VAT Classifications for selection.

• When a MRP Stock Items Invoice is printed with VAT Analysis, total MRP Assessable Value is displayed as Net Value under VAT analysis

• Payment Details are now supported for Haryana VAT Forms and CST Form.

• Payment Details are now supported for Himachal Pradesh VAT Forms and CST Form

Issues Resolved

Accounting Masters

• Opening Balance Bill Details in the ledger master are neither being updated nor erased when the Opening Balance is altered in the ledger.

This issue has been resolved.

Accounting Reports

• On selecting Budget Variance and then selecting any particular month in Stock Item Monthly Summary, the error message Memory Access violation is being displayed.

This issue has been resolved.

• In Purchase/Sales Voucher Register report, where the sort option is selected as Amount-wise (Decreasing) and Amount-wise (Increasing), the amount as per the selected method is not being displayed.

This issue has been resolved.

• In case of a journal entry consisting of a sundry creditor ledger, the Day Book Extract report of Journal voucher is not displaying Sundry Creditors under Current Liabilities.

This issue has been resolved.

• The Post Dated vouchers report displays regular vouchers along with post dated vouchers when the report period was changed.

This issue has been resolved.

• Date range is not refreshing while viewing Outstanding Report from the Ledger Report.

This Issue has been resolved.

• A credit note entry made in voucher mode, is displaying the invoice format without Party name when printed from Multi Voucher Printing option. The same entry when made in invoice mode, displays the invoice format with party name when printed from Multi Voucher Printing.

This issue has been resolved. The credit note entry made both in voucher and invoice mode, when printed from Multi Voucher Printing option is displaying the Party name.

• In case of multi year data, date range provided for previous year in ledger outstanding report from respective Ledger account is not being displayed as per the specified date range.

This issue has been resolved.

• On pressing Enter on the exploded line of Group Vouchers; it would display Forex Gain / Loss Statement as the report heading.

This issue is resolved and it does not allow to drill down.

• In the Outstanding Ledger Report, when Show Bills of following type is set to Debit Bills in F12: Configure, both credit and debit bills are displayed in the report.

This issue has been resolved and only Debit Bill are displayed when Show Bills of following type is set to Debit Bills in F12: Configure.

Accounting Vouchers

• In sales invoice, if one VAT ledger is selected and then changed to another VAT ledger before saving the entry, the percentage and amount are not being refreshed.

This issue has been resolved and the VAT Percentage and amount are now being calculated on the basis of the re-selected VAT ledger.

• A voucher class consisting of multiple excise duty ledgers with Type of Calculation based On Item Rate calculates the amount of duty on the item for all excise ledgers included in the voucher class and displays it in the Excise Sales Invoice.

This issue has been resolved. The calculation of excise duty on an item is now being displayed only for the relevant excise ledger.

• On activating Use Additional Description(s) for Ledger Name in Invoice Configuration, the Description of Ledger screen is not being displayed for Accounts only companies.

This issue has been resolved. The Description of Ledger screen is now being displayed even for Accounts only companies.

• When the same Bank Ledger is selected for both Cheque and Card Payment fields in POS Invoice entry, the amount displayed in both the fields was the same, when opened in alteration mode

This issue has been resolved.

• On changing the invoice date in a Sales Invoice entered with voucher class having discount ledger and method of calculation set to As User Defined Value, in the alteration mode, the percentage entered is not being displayed.

This issue has been resolved.

• In a Sales / Purchase Invoice containing two different VAT sales/ purchase ledger, the sales/purchase figure of an item is modified either by changing the rate, quantity or the sales/purchase amount directly. After this modification, the sales/purchase value is not being picked up automatically in the 'Assessable Value' field.

This issue has been resolved.

• When a single excise stock item is accounted in a sales voucher with the Voucher Class containing Multiple Excise Ledgers with different Rates (Grouped under Duties & Taxes) and Type of calculation as Tax based on Item Rate, the Excise amount is being calculated for all the Excise Ledgers.

This issue has been resolved.

• When a voucher is recorded with the selection of Voucher class having Excise duty ledgers set to calculate the Excise on Current Sub Total and the option Calculate Tax on current Sub-Total is activated in F12: Configure, the Excise amount is calculated based on the Current Subtotal. But, if the same voucher is altered by deactivating the option Calculate Tax on current Sub-Total, the Excise amount is calculated based on the Item Rate and not on the current sub-total.

This issue has been Resolved and now the excise amount is calculated correctly.

• On creating a POS invoice with different amounts entered in the Credit/Debit Card Payment and Cheque fields with the same bank ledger in the voucher creation mode and then on opening this invoice in the alteration mode, the same amount is being displayed in both fields. Apart from that, the entries are not being saved in the alteration mode.

This issue has been resolved and the values entered in the above mentioned fields are being retained with the flexibility to save the changes made to the invoice.

• While altering a Sales Invoice, the VAT/TAX Class does not appear for the second and subsequent items.

This issue has been resolved and the VAT/TAX class is now displayed for any number of items added to the sales invoice in the alteration mode.

• When the option Maintain Bill wise Details is not enabled under F11: Accounting Features, a Ledger created under Sundry Debtors or Sundry Creditors Group with Opening Balance allows the mentioning of Bill-wise Break-up for the amount.

This issue has been fixed.

Audit Features

• A voucher accepted during Audit and then deleted displays particulars as DELETED – Audit Voucher in Audit Listing. On pressing Enter to view such a voucher, Ledger Forex Gain/Loss report is being displayed.

This issue has been resolved.

Budgets and Credit limits

• The function Sales Voucher Registers with Extract of all vouchers, crashes when Budget Variance is selected.

This issue has been resolved and the Budget variance button has been removed from the Sales Register, Purchase Register, Journal Register under Accounts Books, Bill Outstanding Reports of Sundry Debtors and Creditors, Stock Items, Stock Transfers, Physical Stock Register under Inventory Books and Memorandum Vouchers under Exception Reports, as it is not required.

Cost Categories

• The Cash Book is displaying cost centre details only when printed from Multi Column Cash/Bank and not from Account Books of Multi Account Printing menu.

This issue has been resolved.

Crash/MAV

• While Filtering the Stock Items with Stock Groups from Sales Register, the application crashes with the error message “Memory Access Violation”.

This issue has been resolved.

• While Printing any report if the Key combination Alt+U is pressed instead of Alt+I to select the print preview option in the Print Configuration screen, the application crashes with the error message “Memory Access Violation”.

This issue has been resolved.

Data/TCP Migration

• On migrating data from Tally 7.2 to Tally 9, the order reference number entered in supplementary details of some of the sales invoices are getting changed.

This issue has been resolved and the order reference number entered in every sales invoice is now being retained even after migrating data from Tally 7.2 to Tally.ERP 9.

Excise for Dealers

• When multiple Purchases pertaining to a single Item are adjusted in a Excise Sales Invoice, the values of such entries are capturing only the first item in the Excise Stock Register/ Excise Purchase Bill Register.

This issue has been resolved.

• In the detailed format of Excise Stock Register and Purchase Bill Register report, the address of the party is not being displayed in the Name and Address of the Party column only for the first entry.

This Issue has been resolved and the address of the party is now being displayed for all entries in the detailed format of Excise Stock Register and Purchase Bill Register.

• Excise Opening Stock Entry details do not appear in the Excise Stock Register and when the sales invoice raised against the opening stock is printed, Excise Pass on Duty Values and Excise Purchase Section Duty Values do not appear in the printed Sales invoice.

This issues have been Resolved

Export/Import

• When Stock Items with Part Numbers are exported using Excel (spreadsheet) format, the Part Numbers are displayed with a negative sign in the Excel sheet.

This issue has been resolved and the part numbers of the stock items are now being displayed correctly in the Excel sheet.

• On exporting any of the Ledger vouchers from Tally to Excel Spread Sheet, the Debit/Credit Balances are interchanged (Debit balance is shown as credit and the credit balance is shown as debit) in Excel.

This issue has been resolved.

• When Vouchers without Effective Date are imported in SDF format, the application displays the error message crashes with error message Memory Access Violation.

This issue has been resolved and vouchers can now be imported even when the effective date is not mentioned in the voucher.

• When Ledgers are exported in ASCII format from Multi Account Printing as Group of Accounts by enabling the option Start fresh page for each Account in Print Configuration screen, the exported text file displays the group ledger which was debited even in the Credit field.

This issue has been resolved.

• When the Bank Reconciliation Statement is exported using Excel Format, the details are not being displayed in the appropriate columns and the Balance as per Bank and Company Books is being displayed twice.

This issue has been resolved.

• Compound Units are not getting exported to Excel.

This issue has been resolved and compound units can now be exported to excel as text and not as a number.

Final Accounts

• The column heading separator lines do not appear when a new column is inserted in the Profit and Loss Account.

This issue has been resolved and the column heading separator lines appear in the Profit and Loss Account.

Fringe Benefit Tax

• FBT Challan Reconciliation displays even the Reconciled Vouchers, when the option Show Reconciled vouchers is not activated in F12: Configure.

This issue has been resolved.

• When a FBT Payment entry is passed without using the FBT helper, the application allows the entry in the To field, a date prior to the date mentioned in the From field in the FBT Payment Details screen.

This issue has been resolved.

• On entering only the month in FBT Filters, the first day of the month was being displayed as date in both From Date and To Date fields.

This issue has now been resolved. Colors kannada serials.

• The Additional Education Cess @ 1% applicable only from April 2008, is being calculated and displayed in the FBT Computation report generated for the period 2006-07.

This issue has been resolved and now the Additional Education Cess @ 1% is not considered in the FBT Computation report of the previous year.

• While generating the FBT Computation report for a financial year, the application hangs if the volume of data is high.

This issue has been resolved and the FBT Computation report now displays the details like any other report regardless of data size.

• In the FBT Computation Report, Tax is being calculated even on the Credit Value of Expenditure and as a result the Grand Total of Net expenditure amount is being displayed with a negative sign.

This issue has been resolved.

• FBT Ledger created in FBT Filters sub screen is not displayed in the List of FBT Ledgers for selection.

This issue has been resolved.

• The FBT Payment entry marked as optional is affecting the FBT Computation report as it was being considered as a regular payment entry.

This issue has now been resolved.

• The value calculated by using FBT Filters in Payment voucher was more than the amount displayed in FBT Computation report. On restoring the data backup of company enabled for FBT, the Company FBT Assessee Details were missing in both Statutory & Taxation Features and FBT Challan. On activating the FBT feature, the amount displayed in FBT Challan is more than the amount displayed in the FBT Computation report.

This issue has been resolved. The value displayed in FBT Computation report is captured in FBT Payment voucher on using the auto fill option and the Company FBT Assessee Details are also retained even after restoring the data.

• FBT Computation amount is not matching with the FBT payment amount during FBT Payment Entry. It shows a difference of Rs.1/-. This happens due to rounding off.

This issue has been resolved.

• FBT Computation report captures and prints the period including the post dated voucher date, when the post dated entry is passed using the ledgers for which FBT option is not enabled.

This issue has been resolved.

Inventory Masters

• After deleting the components/items used in Bill of Material (BOM), the application has to be reloaded or the item has to be renamed.

This issue has been resolved, and the Components/items can now be deleted without reloading the application or renaming the item.

• When Use expiry dates option is changed from Yes to No and again to Yes, the tag name of Allow use of expired batches does not appear.

This issues has been resolved and Allow use of expired batches is now displayed when Use expiry dates is changed.

• In the Stock Ageing Analysis report Company Name and Address is not getting printed from the second page onwards.

This issue has been resolved

Inventory Vouchers

• The voucher number of Sales Order is getting reflected in Delivery Note. Hence, the voucher number subsequent to that of sales order is being displayed as the reference number in delivery note.

This issue has been resolved.

• On printing a sales invoice in simple format with tracking details for more than one Delivery Note, only one delivery note number was being captured and printed.

This issue has been resolved. Multiple delivery note numbers are now being printed in a single sales invoice.

• In the stock item allocation screen of sales order, when Any was selected under godown for a particular stock item, a warning message Negative Stock! is displayed even though there is a closing balance of that item in other godowns.

This issue has been resolved. On selecting Any as godown, the warning message Negative Stock! is not displayed if there is closing balance of stock items in other godowns.

• The reference number entered in sales invoice is not being captured in the Bill-wise details screen, if the method of voucher numbering is set to None in the sales voucher type alteration screen.

This issue has been resolved.

• In a Manufacturing Journal, for a Stock Item with Component List details (BOM) if the amount is entered for the Component item without defining the rate, then Rate of the Component item is not being calculated automatically (Left blank) based on the quantity and amount.

This issue has been resolved and Rate is calculated based on the Quantity and amount specified.

• When a Stock item, allocated with the amount of Expenses on purchase is transferred from one godown to another using Stock Journal, the Rate displayed for the item in Destination Column does not include the expenses on purchase.

This issue has been resolved.

• When a Sales Invoice is printed in simple format, Delivery Notedate is not being printed, even when the details are entered in the invoice dispatch details.

This issue has been resolved and the Delivery Note date is printed in the sales invoice.

• In a sales invoice, if a reference is provided and if 'Use defaults for bill allocation' is set to No then reference is captured in Bill wise window. If reference is not provided then the voucher number is captured.

This issue has been resolved.

• The Tracking number used in ‘Rejection In’ is not being displayed in Item Allocation screen of Credit note (As Voucher mode).

This issue has been resolved.

• For a Company in which VAT and Use different Actual & Billed Quantity features are enabled, 'Calculate MRP on billed quantity' option is not being saved in F12: Invoice / Orders Entry configuration once you quit the application and reopen it.

This issue has been resolved.

• On making a sales entry by selecting multiple godowns in the Inventory allocation screen, a warning message showing wrong negative stock is displayed.

This issue has been resolved and the warning message displays the correct negative stock value.

• After enabling “Use Common Table for stock items” using CTRL+ALT+F12 from Gateway of Tally, quantity was being displayed in “List of items” in the following voucher types:

• Stock journal

• Rejection in

• Rejection out

• Physical Stock

This issue has been resolved and the List of Items is not displayed in the above Vouche types when the option Use Common table for stock items is enabled.

• On taking a printout of the Rejection In voucher, it prints the heading as Rejection In number instead of Order No.

This issue has been resolved.

Inventory Reports

• On viewing the stock summary report through F9: Inventory Reports from the Ledger Report screen, the closing stock value is displayed as NIL.

This issue has been fixed.

Job Costing

• In the Job Work Analysis report, the Consumption does not consider the Cost of Sales.

This issue has been resolved.

Licensing

• Multi-Account Printing menu is not being refreshed when the license is activated or surrendered. It takes effect only when the application is restarted.

This issue has been resolved. Sccm software center uninstall button greyed out.

Multi-currency

• In the Bank Ledger Voucher report, if a voucher is altered by drilling down from the report, the Opening and Closing Balances of Ledger Voucher report are displayed in the base currency instead of the Foreign currency, if 'Show Forex details' also' and 'Show Forex Transactions only’ are enabled in F12: Configure.

This issue has been resolved and on altering a voucher containing foreign currency, opening and closing balances appear in foreign currency only.

• On reconciling a bank account containing foreign currency transaction, the Balance is different as per Company Books.

This issue is resolved and now it displays the correct reconciled values.

• On viewing any ledger account with the Show Forex Transactions option set to 'Yes', it displays the transacted values in foreign currency but opening and closing balances are displayed in the base currency.

This has been resolved and it now displays the opening and closing balance in foreign currency.

ODBC/Export/Import

• A Purchase Invoice consisting details of Company’s Address and E-Mail ID, when exported in HTML format displays the error message 'Part:EXPINV Purchaser'.

This issue has been resolved. The Purchase Invoice is now being exported in HTML format along with the Company’s address & Email-ID.

• When Sales Register is exported in HTML or Excel (Spreadsheet) format or printed by enabling Show Columnar Register with Type of Column as All Items (in one col.) the report was being exported/printed in multiple columns.

This issue has been resolved.

• On exporting Employee masters in XML format from List of Accounts, all the accounts and payroll masters were also being exported along with employee masters.

This issue has been resolved.

Optional & Scenario management

• In the Post Dated Voucher Report, optional voucher is also being displayed.

This issue has been resolved.

Payroll & Statutory

• Drill down in Expat Reports, displays the repeated information.

This issue has been resolved and the option to drill down from Expat Reports has been removed.

• The option to drill down from Attendance Sheet to Attendance voucher is not functioning.

This issue has been resolved

• The Payment Advice is displaying the monthly instalment of loan amount recovered from employee’s salary, even though it is not included in payment voucher.

This issue has been resolved

• In the Pay Head creation screen, if the pay head name is entered and then altered, the changed name is not being displayed in the field Name to appear in Payslip.

This issue has now been resolved.

• When the positive attendance type is used in the Pay Head, Payroll was not being calculated for employeeswho resign before/priorto the date for which the attendance voucher was recorded.

This issue has been resolved.

• When Payslips are printed through Multi Payslip Printing by enabling the option Remove Zero Entries, the application still prints blank payslips for deactivated/zero entry employees.

This Issue has been resolved and now only the payslips with the entries are printed, when the option Remove Zero Entries is enabled in Multi Payslip Printing.

• When you drill down from the attendance value of the employee in Attendance sheet, Voucher Details are not being displayed in the Attendance Voucher

This issue has been resolved.

• When the Employee Voucher Report is printed, the title of the report is getting printed as Cost Centre instead of Employee.

This issue has been resolved.

• Print Configuration Screen of Multi Payslip Printing is not aligned properly.

The alignment has now been rectified.

POS

• After recording a POS transaction, the Sales Invoice Printing configuration screen title, is being displayed as ‘POS Invoice Printing Configuration’ instead of “Invoice Printing Configuration”.

This issue has been resolved.

• In the alteration mode, List of Ledgers Accounts is not being displayed, when the cursor is in the Credit/Debit Card payment field in a POS Voucher with a Class.

This issue has been resolved.

• When the Rate of Expense is altered in a POS voucher with class in the alteration Mode, the Amount is not being calculated properly.

This issue has been resolved.

• In the alteration mode, when the Sales Ledger is changed in a POS invoice, the VAT/Tax Class is not being refreshed as applicable to the changed sales ledger. In addition to this, on changing the VAT Ledger the VAT Percentage is Not being changed.

This issue has been resolved.

• The application malfunctions when a POS Invoice with a Class (voucher Class is created with ‘Type of Calculation’ set to “As Total Amount Rounding” under Additional Accounting Entries) is altered.

This issue has been resolved.

• On creating a POS Invoice in multi-payment mode with the same bank ledger selected for Credit /Debit Card Payment and Cheque fields with different values, and then opening it in the alteration mode, the amount is repeated in the Credit/Debit Card Payment and Cheque fields.

This issue is resolved and amount name does not get repeated.

Printing

• Documents are not printed correctly on HP 1005, 3050 & 2600 N, Samsung ML-4600 Printer and Canon LBP 1120 printers.

This issue has been resolved.

• The report title of a Credit Note is being displayed as Cash Voucher, when printed from Multi Voucher Printing option of Multi Account Printing menu.

This issue has been resolved and the report titles now display the names of the respective vouchers selected in the Printing Vouchers screen.

• In Day Book – Sales Register, if the Sorting Method was set to Alphabetical (Decreasing/Increasing), the vouchers were displayed in the order set, but the same was not being reflected in printed format.

This issue has been resolved.

• When the invoice title is not defined either in the Sales Voucher Type or in the F12: Invoice Print Configuration, Sales Invoice is printed without title.

This issue has been resolved and now “Invoice” is set as Default Title, when the title is not defined in the Voucher Type or in the F12: Invoice Printing Configuration.

• In Multi Account Printing, if the ledger is printed as Group of Account with Debit/Credit entriesonly, by setting the option Start fresh page for each Account to No, a blank report is being displayed.

This issue has been resolved.

• Changes made to Print Configuration settings for Debit Note are not affecting the print.

This issue has been resolved.

• While printing a cheque with a ledger grouped under secured/unsecured loans in the payment voucher, the Ledger name does not get printed on the cheque.

This issue has been resolved.

• When a credit note is printed by enabling the option ‘Print Quantity Column’ in Print configuration, the Quantity Column was not getting printed in the credit note.

This issue has been resolved.

• While printing the Confirmation of Accounts for Sundry Creditors, the purchase Voucher number is getting printed instead of purchase reference details.

This issue has been resolved.

• While printing the Group of Accounts from Multi Account Printing with the option Start fresh page for each Account set to No, the references and inventory details are not printed, even if the options Show Bill wise Details also & Show Inventory Details also are set to Yes.

This issue has been resolved.

• Heading in the Print Preview of Rejection In voucher type is displayed as Order No instead of Rejection In No.

This issue has been resolved.

• While printing the Rejection In/Rejection Out vouchers, the Batch Number, Manufacturing Date and Expiry Date is not being printed.

This issue has been resolved.

• While printing multiple vouchers using Multi Account Printing, from page three onwards, the vouchers are carried over to the next page.

This issue has been resolved.

• When we are printing from Multi Account Printing > Account Books > Ledger > All Accounts or Group of Accounts and set Yes to Start fresh page for each Account in the Page Details section, Page: 1 of 1 is displayed even though number of Ledgers to print are more than one.

This issue has been resolved.

• When the Page Range is set to Odd/Even or Front /Back, user should be able to navigate between the pages. Currently, only 'Home' and 'End' buttons work i.e. user can go only to first page or last page. Page-up, Page-down, and arrow keys are not working in the Print Preview mode.

This issue has been resolved.

Rewrite/Backup/Restore/Split

• On successfully taking a backup on a removable device it is found that all the files in the removable files drive are deleted.

This issue is now resolved and on successfully taking backup on the removable drive, the Tally backup file gets added to the device.

Service Tax

• In the process of Splitting the company data of two financial years (2006-2008), wherein Service Tax sale and receipt records are in One financial Year (2006-2007) and The Service Tax payment records are in another financial year (2007-2008), Service Tax paid is displayed as Input Credit in the new company split from 1-4-2007.

This issue has been resolved.

• The Service Tax amount is not being captured in the Bill wise Details screen while passing a Journal Voucher.

This issue has been resolved and the Service Tax Amount is captured in the bill-wise details screen.

Synchronization

• When the user tries to synchronize the data containing the ‘<’ or ‘>’ symbol specified either in narration or ledger or stock item name field or in any other field, the application displays the XML tag (< or >) in the calculator panel without terminating the Synchronization process.

This issue has been resolved.

Tax Collected at Source

• When a TCS payment entry is recorded using TCS Helper with the option Show Bill wise details in F12: Configure enabled, Bill-wise details for TCS Tax Ledger displays TDS Details for instead of TCS Details for.

This issue has been resolved.

• In the alteration screen of sales invoice, on changing the sale value, the TCS surcharge amount is not being changed as per the new gross value.

This issue has been resolved.

• When TCS (Tax) Ledger is included in a Sales Invoice in alteration mode, the TCS amount is not being calculated.

This issue has been resolved.

TDL issues

• Rate type is not working in Batch wise details during Stock item creation, but is working in the alteration mode.

This issue has been resolved and Support for using Rate type in batch-wise details in Creation mode has now been provided.

VAT

• In a sales invoice of a company with Accounts Only feature, the Output VAT amount of transaction involving two different VAT rates is calculated on the current sub-totals and not the assessable value.

This issue has been resolved and now the output VAT amount is being calculated on the
assessable valueof respective sales ledgers.

• On switching from a company with Accounts with Inventory feature to a company with Accounts only feature, when a Sales transaction using an Accounting Invoice with multiple VAT rates is entered, the Output VAT for the second VAT classification appears incorrectly and an incorrect value is displayed in the Computation statement.

This issue has been resolved and the Output VAT values are being displayed correctly.