Data Analysis Tally Prime | Best Reports of Tally Prime | Generate Important reports without TDL

19 August 2022

Friends we all use Tally because of it’s simplicity and powerful reporting system. With Tally we can do our accounting easily. Tally have lots of reporting system that we use on daily basis. But some reports we generate via TDL Files, and we don’t know that Tally already have this type reports. So Today I have something special for your reporting systems and MIS .Today I have Data Analysis system of Tally that can fulfill your lots of MIS requirements. Data Analysis facilitates is conducting internal analysis and verification of the company’s financial data. Data Analysis will help in identifying exceptional areas and thereby ease the process of verification. With the help of Data analysis we can create our important MIS reports also. Data Analysis facilities have both Tally Prime and Tally ERP9. But in Tally Prime have more features with easy to use modules. So in this post you will read about Tally Prime Data Analysis. How to view Data Analysis Report in Tally Prime: There is two methods to find data analysis reports: Gateway of Tally > Display More Reports > Analysis & Verification > Data Analysis. 2. Alternatively, press Alt+G (Go To) > type or select Data Analysis Reports > and press Enter Various tools are available in Data analysis section of Tally Prime that can be use for various purpose. Follow below sections/tab of Tally to know more: Verification of Chart of Accounts Verification of Stock Items Verification of Balances Analytical Procedures Pending Documents Periodic Payments and Receipts Repeated Transactions Relative Size factor (RSF) Inter Bank Transactions Cash Withdrawals/ Deposits to Bank Fixed Assets Analysis Transaction on holiday Highest and Lowest Value Transactions Pending Advances Stale Cheque /Instruments (Please watch the above video to see another use of Data Analysis Facility of Tally Pirme and how to use other options and buttons of Data Analysis Facility of Tally Pirme.) Verification of Chart of Accounts – Drill down into this report will help to scrutinize the Chart of Accounts and compare this with previous year Chart of Accounts and suggest the necessary corrections if required. Verification of Stock Items – Drill down into this report will help to scrutinize various Stock Items and compare the Stock Items list with the previous year. This will help in taking necessary decisions and provide necessary corrections. Verification of Balances – Drill down into this report will help to scrutinize the difference in Opening Balances and transaction details during the selected year and suggest necessary corrections based on the exceptions highlighted. The user can also generate the ledger wise variance report for the Closing Balances. Analytical Procedures – This report can be used to analyse the data based on various parameters (e.g. Group, Cost Centre etc.) by a detailed comparison mechanism available. The user can take of note areas where more attention is required. Pending Documents – This report will display all the Pending Bills, Sales Orders, Purchase Orders and Receivables & Payables during the analysis year. Periodic Payments and Receipts – This report provides the list of recurring Ledger Vouchers based on the Periodic Ledgers identified by the users. Repeated Transactions – Drill down into this report will display the transactions for which the same amount is repeated more than once for each Ledger during the analysis year. The user can use this report to check the intentional errors while passing the entries. Relative Size factor (RSF) – Drill down into this report will display the Relative Size Factor for each Ledger Voucher which is arrived by dividing the highest Voucher amount to the second-highest Voucher amount for the Ledger Vouchers. Inter Bank Transactions – This report will display all the transactions carried out between the Banks during the analysis period Cash Withdrawals/ Deposits to Bank – Drill down to this report will display the bank ledgers from which the cash is withdrawn or deposits are made. This report also displays the Total Amount of transaction and the Number of vouchers through which the withdrawal or deposits are made during the selected year. Fixed Assets Analysis – This report provides the details of all the Fixed Assets possessed by the selected Company at the end of the analysis Year. Transaction on holiday – Drill down to this report displays all the transactions recorded on Weekly Off or Declared Holidays in the analysis year. Highest and Lowest Value Transactions – This report provides ledger wise Highest and Lowest value transactions carried out during the selected period along with Difference Range and Difference Range Percentage details. Pending Advances – Drill down to this report will display the ledgers for which the advances made (Loan given) are pending during the analysis year. Stale Cheque /Instruments – Drill down to this report will display the Bank Ledgers with stale cheque/ Instruments. This report also displays the Total amount and count of stale cheques/ Instruments. Also can use another buttons like, Basic of Value, Change View, Exception Reports etc. from side bar buttons of Tally to generate more type detailed reports.

5. TDLTutorial: Rules for Writing Good TDL Code

18 August 2022

We would have fostered different codes for many activities. A venture is good when the codes created are valuable independent of whether they are little or huge. A decent quality code is characterized by its result and the time taken for the result, i.e., the presentation: lesser the time, more joyful the client. Further, assume the code is more straightforward to keep up with and fast to explore for any changes. All things considered, it will prompt a cheerful developer. Purpose of Writing Good TDL Code: A decent code influences two segments of the Tally environment the developers and users. Advantages to User : Easy to use interface Consistent route Ideal execution Advantages to Tally Developers : Fast to explore code Simple to keep up with code Quicker to fix any bug inside code Fast to any progressions in a future delivery as well as in reverse similarity Quicker and faster changes to clients endless necessities Lesser objections from clients Diminished working hours Project Creation Rules: The codes of a task should be kept up with in an envelope with the sequencing of documents and organizers. The undertaking organizer gives total lucidity on code creation and advancement. Folder Creation:Any new task made ought to be made in another Folder for each client. The folder name ought to be the client name. The organized folder makes it more straightforward to find and keep up with client wise code. Project File Creation:The task name ought to have an improvement organization name as a prefix. This naming show will stay away from any struggles with some other TDLs the client is right now utilizing or may use in the future from some other engineer. Giving substantial names guarantees there would be no conflict with some other future customisation as it has your organization’s initials. Extra Files:A tree-like organizer design ought to be kept up with for the Folder, and the File and the name ought to recommend the movement of the code. The folder design would make it simpler for the developer to find the code for change instead of looking over the whole venture code. It makes it more straightforward to track down the area of the code that needs upgrade. A different document for keeping up with fields ought to be kept up with under the module’s organizer of the individual container when many new fields are added. The record framework guarantees there would be no conflicts with any framework components when they are roofed together under a document. Project Properties:Build Option (File > Active Project Properties > Build Options) The task’s name ought to be a significant name that would recommend the kind of module created. The name would be noticeable on Tally Product and Features screen. It would make it more straightforward for the client to figure out the need/motivation behind the module.Give ‘Creator name’ as Company Name – Contact Number; alternatively, you might give developer name. The client would see these subtleties in the Tally’ TDL Management’ screen (F1:Help > TDLs and Add-ons > Alt + F5: Detailed Mode). The subtleties will make it simpler for the client to associate with you later on. Giving a variant to a task would make it simpler to distinguish the code form that is presently dynamic in the client framework. The form subtleties will help recognize when the client reports an issue or another prerequisite.A preliminary mode for the code ought to be given. This office would permit the client to approve the conveyed item for a period. The quantity of days for preliminary mode ought to be chosen in view of the kind of module. For more modest advancements like Invoice Print or Simple detailing could be three days for greater tasks could be 90 days. On receipt of affirmation from the work client, you might give an interminable code to the client.Chronic quantities of the clients ought to be kept up with under a gathering, making it simpler for you to incorporate records as and when conveyed. TDL Coding Standard: Composing a code is a workmanship that each developer ought to create. The TDL designers can accomplish this range of abilities by observing the underneath given guidelines. Header:The document header ought to give subtleties of the record’s code, creation subtleties, modified subtleties, refreshed subtleties, TallyPrime Release the code made for, later refreshed to and changes made. By giving subtleties to each record, it makes it more straightforward for any designer to grasp its motivation. Different subtleties gave would be expected to future references. Enablement of Feature/Capsule:An arrangement to empower the module/case ought to be given in Add-On screen (F1:Help > TDLs and AddOns > F6:Add-On Features). Try not to give enablement choices at some other area like Company Alteration Screen or Gateway of Tally. This game plan makes it plausible to investigate when the client reports an issue. Every one of the applicable elements and capabilities ought to be covered up or dormant until the choice is empowered. Code Commenting:Legitimate remarking ought to be given at each conceivable code to figure out the usefulness of the code. At the point when changes are made, giving remarking makes it more straightforward to the engineer for future reference to reason out the progressions made and what changes were made, and why. The remarking saves a lot of time for the designer for approving code on an experimentation premise. Naming Conventions:The name of the definition ought to recommend the usefulness of the definition prefixed with your organization name initials to keep away from future crashes with other TDLs or Default TDLs. Definitions and Attributes Indentation:There ought to be one line separating when a definition for the coherence of the code.Each essential definition like Report, Form, essential Part, Collection, Function, Border, Style, Function, Button, Menu, Name set, Resource, Query box, System, Variable, and Ruleset ought to be starting from the furthest left section ascribes one TAB indented. This styling facilitates the clarity of the code and less complex to troubleshoot.The space ought

To Do Reminder List in Tally Prime | 2022 Best Free Tally Prime TDL

23 March 2022

Sometime in our life we forget important things and can not finish our work on time.Same things we do at business. We forget to file returns on time, We forget to collect outstanding, We forget to join important meetings, We forget to sign cheques on time, and many more things we can not do on time. To avoid this we maintain manually notes, that is not proper solution. In mostly business to maintain our books we use Tally. And in Tally we can create reminder list or Todo list to solve this problem.So today I have very special free To-Do List Tally Prime TDL for your Tally.With this To-Do Tally TDL we can maintain our to do list in Tally and can excess every time from any screen from Tally. In this we can maintain important notes about our work. We can maintain reconciliation notes about our customers.These things make it must have Tally TDL for Tally Prime.With this Free Tally Prime TDL, Now we can add To-Do List in toolbar button that will help to remember our work and help in finish works on time. HOW TO USE: Copy TDL code Make a text file and save in your computer Load in Tally ERP9 or in Tally Prime (Method provided below) Now go to To Do button provided in toolbar section beside Goto button. Open it and add important work lists with there dates. This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime. Watch above video to learn : How to add toolbar button. How to create reminder list. FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Copy above TDL Code in Text Document Save Text file in your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Party Detail.txt) Open Tally ERP9  OR Tally Prime Press F12 and goto Product and Features (for Tally ERP9) Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box)  Load TDL file on Startup – Yes Paste The path in blank space Press enter and save  Now your TDL is ready to use. 

2. TDLTutorial- Installing Tally Prime Developer

29 October 2021

TDL codes we can write in note pad or any text editor software, but Tally Prime Developer is best option for writing TDL codes for Tally Prime and Tally ERP9. At time of creating Tally TDL in Tally Prime Developer, it provide instructions to create a correct TDL file and save our lots of time. And also can use lot’s of sample files provided with Tally Prime developer. TallyPrime Developer TallyPrime Developer is a comprehensive development environment designed for Tally Definition Language (TDL). Tally Definition Language or TDL is the development language of TallyPrime. Benefits of TallyPrime Developer: Easy programming by syntax colouring, tagging and navigation of code, auto-completion, project management, and so on. Ease of debugging, with error listing and diagnosis. Build, compilation/validation/execution of code from within the product. Authorization techniques for TCP ( Tally Compliant Product ) ensuring IP protection, controlled license usage, and minimized revenue leakage. Easy distribution mechanism using licensing and subscription renewals. Easy customer serial number management. Access to the complete Tally source code, as a reference. Ability to load multiple versions of the source code. Instant references to TDL API’s such as schema, definition and attributes, functions, actions and so on.  Ability to extend multilingual support to the product, customisation, modules in localized languages with the powerful dictonery manager tool Tools that help to develop and test external application integration with TallyPrime (Tally connector). How to Start Using TallyPrime Developer.  You can start using TallyPrime Developer in a matter of minutes. All you need to do is download the setup file, install TallyPrime Developer, and then, activate the license. If you want to try TallyPrime before buying it, or you are a student, then you can use the Educational version. Download and Install TallyPrime Developer Downloading the application setup from download button or click on image provided in starting of this post. Downloading Setup is the first step in starting TallyPrime Developer. Once you download TallyPrime Developer setup file, you can install the application on your computer. Installation steps remain the same regardless of the TallyPrime Developer edition. Download the setup file. Install TallyPrime Developer. Double-click setup.exe. Double-click Install New. Configure Application Path, if needed.By default, the application will be installed at C:\Program Files\TallyPrimeDeveloper. Click Configure. Double-click Application Path change the path as needed. Close the List of Configurations window. Click Install.The application gets installed, and the following window opens. Click Start Developer to launch TallyPrime Developer. You can now Update, Uninstall, Alter, and Repair from the same setup as given below: You can activate the license, and thereafter, you can start using TallyPrime Developer. Activate New License Start your TallyPrime Developer.  Go to License > Activate. If you have a Single-Site license, then enter your TallyPrime Developer Serial Number, Activation Key, and Administrator e-mail IDHowever, if you have a Multi-Site license, then refer to Multi-Site Licensing in TallyPrime Developer for further details.Note: The e-mail ID provided here will be linked to your account, and used for all future communication and licensing activities. Press Enter to proceed. The Unlock License screen appears. Enter the Unlock Key sent to your e-mail ID.Note: If you have not received the unlock key, then press F2 (Get Unlock Key). Press Enter to unlock your license. Once your license is unlocked, the activation successful message appears. Once you activate the license, then you can start writing your first TDL program and go ahead. How to Start TallyPrime Developer in Educational Version | Try it for free If you want to try TallyPrime Developer before you buy, or just want to learn how to use the product, then you can use the Educational version for free. In this case, you can try all features in the product. However, there will be a few restrictions on using some of the features.  After installation you can start your TallyPrime Developer in Educational mode. Once you do that, you will observe that the staus bar of the application shows Educational Version. Free 90 days Evaluation Version: You can use all the features of the product for 90 days. However, you cannot analyse and check the version compatibility in this version. Users of Tally.Developer 9 – Move to TallyPrime Developer If you are an existing user of Tally.Developer 9 and if your subscription is active, then you can upgrade to TallyPrime Developer. Install TallyPrime Developer in a new folder. Once the license is configured, you can continue to use TallyPrime Developer. Update/Configure Using Tally.Developer 9 License Start your TallyPrime Developer. Click License > Reactivate Enter the Administrator e-mail ID and Tally.NET password in the Reactivate License screen, as shown below: Click Submit to reactivate. A confirmation message ‘License reactivated successfully’ appears once your license is reactivated. Note: If you are the administrator of more than one site, the Reactivate License screen displays a list of sites that can be reactivated. If you want to work in Tally.Developer 9, configure the license with the same IP address and port of the Tally Gateway Server where the TallyPrime Developer License is running. Steps to configure the TallyPrime Developer license for Tally.Developer 9 Open Tally.Developer 9 Go to License > Configure existing license If you know the computer name or IP address and port number of the installed Tally Gateway Server, enter the details manually. OR Click the option Search Gateway Server(s) and select the appropriate license from the List of Compatible Tally Gateway Server screen. LearnTDL:

1. TDLTutorial- Create First TDL

28 October 2021

The description, usage and detailed explanation of each component will be taken up in the subsequent chapters. If you want to use your first TDL(Tally Developer Language) , must use basic structure of TDL. The Report is executed from the existing Menu ‘Gateway of Tally’. Purpose: To invoke a new Report displaying the text “Welcome to the world of Engage to Tech ” from the main Menu ‘Gateway Of Tally’: This code adds a new Menu Item First TDL in the ‘Gateway Of Tally’ menu. When the Menu Item has selected the report, the Report ‘First TDL Report’ is displayed. The report is in ‘Display’ mode, as the action ‘Display’ is specified while adding the menu item ‘First TDL’. User inputs are not accepted in this report. The text ‘Welcome to the world of Engage to Tech’ is displayed in the Report, since it contains only one field. In this you will find that : in a bracket [..] is definition Display is action keyword. It mean you want to display your report in main screen (Gateway of Tally). Report is your definition type. Where “My Report” – action keyword should be same name as in action display keyword After definition word used like : Part, Line, Field called attribute and after that given name called attribute value. As under field definition we used “Use”, called attribute modifier. And as formula we used “My Formula”, called formula name And at end we can show our comment with ; semicolon. That’s all So watching after above image we know writing module of a TDL code: First give name about Report and create it’s definition. Second give name of form and it’s definition. Third give name of Part and it’s definition. Fourth give name of Line and it’s definition. the in last give name of Field and it’s definition. In the field we can show our report as we want. So after understanding above TDL module, we can say: First write Report – Under Report is Form – Under Form is Part – Under Part is Line – Under Line is Field. If we under stand above module of TDL we can write any TDL code.