Solutions with TDL

Discussion in 'Tally Developer' started by tdlexperts, Feb 9, 2012.

         
  1. tdlexperts

    tdlexperts Administrator


    The TDL language capabilities allow the TDL programmer to build complete solutions and deploy them with ease. Listed below are a few capabilities

    • Rapid Report Design and development using various formats.
    • Advanced Data Processing Capabilities using Collections.
    • Complex Report generation using Tally Database.
    • User defined additional storage fields within the Tally database.
    • Customising Voucher Entry and printing in multiple formats
    • Multiple Output Capability like email, print, display etc
    • Modifying existing default Reports to incorporate/ alter required fields
    • Modify the existing user entry screens as required
    • Non-procedural language with procedural capability with User Defined Functions
    • Remote Access Capability using Collections.
    • Advanced Integration Capabilities of the Language

    Using the capabilities listed above, we can achieve the following
    • Invoice Printing, Payment Advice Printing, Voucher Printing, etc. in user desired
    pre-preprinted or plain formats
    • Various Columnar reports like Batch wise Item wise Reports, Item wise Party wise
    Outward and Inward Movement Analysis
    • Various security related controls like Voucher Type wise Entry Control, control the
    table of selection based on users like Sales persons can view only Debtors Ledgers, etc.
    • Customisation of Synchronization i.e., One way sync, Masters Only, Voucher Type wise Sync
    between various branches and HO
    • Creation of multiple Approval Levels
    • Labels and Bar Code Printing
    • Auto creation of Masters/ Transactions as required

    Basic Customisations

    • In Item Master, Description has to be entered more than once.
    • In Configuration Screen, an option must be added "Require Multiple Lines
    for Description" & based on the value set, behavior must change.
    • Alter the Description and activate/deactivate Batches Info for all Items falling
    under a particular Stock Group.
    • Default allows Stock Group wise price List Updation. To enable Updation of the
    same Stock Item Wise.
    • Exporting a report in the required XML Format
    • Barcode printing in Tally

    Voucher/Invoice Customisation & Reports

    • While entering Sales Voucher, all the Description set in the Item Master should be
    set in the User Description Field on selecting the Item.
    • Altering Payment/Receipt/Contra Vouchers to have additional UDFs for Bank Name,
    Cheque No. and Date if the Bank Ledger is transacted with.
    • Providing Amount wise discount column in Pricelist as well as Sales Invoice
    • Alter the concerned Voucher Printing Formats to print the above details
    • Preprinted Invoice Format
    • Convert the above Format to Plain Invoice Format
    • Convert the above Format to both preprinted as well as plain format based on
    user choice
    • Tracking the Voucher right from creation to details of last alteration like User Name,
    Reason for Altering, altered date, etc
    • Number of Times PO is Altered and Reason for the same to be recorded
    • Printing Sales Invoice (above format) and Packing List i.e., Multiple Forms
    • Purchase Order Print Format similar to the above Sales format.
    • Alteration of Default Sales Invoice Format to include Stock Groups and grouping the
    relevant Stock Items under them.
    • Cash Receipt and Payment report
    • Label Printing
    • Item Wise Party Wise Sales
    • Cost Centrewise (Salesman) Bills Outstanding Report

    Work Flow Customisation

    • Create Provisional Entries (Post Dated) like Rent for the next 12 months.
    • From a Purchase Entry, alter the Purchase Orders Quantity
    • Add a Logical UDF next to PO No accepting input to Close PO
    • All the POs against which YES is mentioned should be altered to the Qty received till date
    so that the PO will be knocked off from the Pending list for the respective Items.
    • Convert Multiple Delivery Notes (of a Party) to single Sales Invoice automatically
    (based on user selection in report displaying list of delivery notes pending)
    • A subset of Material Requirement Planning (Based on Sales Order entered and BOM)
    • Control bills of a customer based on overdue period
    • Automatic Bank Reconciliation from external sources
    • Also to accept the location of files from the user
    • From the above path, Bank Dates need to be automatically updated

    Sync Customisation & Security Control

    • Voucher Type wise Sync Filter
    • One Way Sync
    • Masters Only Sync
    • Vouchers Only Sync
    • Applying Transformations during Sync using XSLT ( PO to SO etc)
    • Security Control for Master wise security
    • Voucher Type wise Security Control
    • Providing additional security control over default security control. For e.g., Disabling
    of creation/alteration/deletion privilege though the user has got admin rights
     
    gellavenugopal and G Vijay like this.



  2. HVPatel

    HVPatel Active Member


    Hello Sir,
    Can we get Webinars for tdl learning for first learning stage.
    Thanks a Lot
     



  3. sandeep kelkar

    sandeep kelkar New Member


    i need a tdl file where in i can show two different discount in invoice
     



  4. Gunasekaran

    Gunasekaran Member


    Mr.Sandeep

    Please give the Details in your query.

    Thank and regards
    Gunasekaran.S
     



  5. Waheed Khan

    Waheed Khan Member


    How to create new menu ”Stock Type” in inventory master like “stock item” with all menu like create alter and display and also use in Voucher entry and reporting
    Anyone can help me
     



  6. admin

    admin Administrator Staff Member


    [#Menu : Inventory Info.]
    Add : Key Item : Before : @@LocQuit: Stock Type: T : Menu: MnuStockType

    [Menu : MnuStockType]
    Title: "Stock Type"
    Key Item: Create:<Your coding for Calling Report/Collection/Function>
    Key Item: Alter:<Your coding for Calling Report/Collection/Function>
    Key Item: Display:<Your coding for Calling Report/Collection/Function>
     



  7. Waheed Khan

    Waheed Khan Member


    Thanks for reply
    but how to coding for Calling Report/Collection/Function
    pls explain me
     



  8. admin

    admin Administrator Staff Member

    RAMESH PATEL likes this.



  9. Waheed Khan

    Waheed Khan Member


    Thanks sir
    i read reference manual but not getting proper can you give me any sample code for reference so i can try
     



  10. HVPatel

    HVPatel Active Member


    A Sample Folder for reference available with Tallly.ERP 9
    Sample Folder > Attribute Enhancements > ToolTip text file
    This is for your reference, change some code in it to get what your require.
     

    Attached Files:




  11. Waheed Khan

    Waheed Khan Member


    thanks
    i try and get any difficult i get back again
     



  12. Waheed Khan

    Waheed Khan Member


    Dear Sir
    How to Specify TDL code for Particular Voucher Type
    i.e. I create new sales invoice format like report form but its applicable in all sales invoice I want to is show only in particular Voucher type mean I use this TDL only Tax Invoice Voucher Type not all Sales Voucher

    Thanks you
     



  13. K.M.RAJESH

    K.M.RAJESH New Member


    SIR,

    SINGLE PASSWORD OPENING GROUP COMPANIES FOR ADMIN, ANY IDEA HOW TO START WITH CODING
     



  14. K.M.RAJESH

    K.M.RAJESH New Member


    SIR,

    HOW TO WRITE TDL FOR DELETING UNWANTED (ZERO BALANCE LEDGER) WHILE SPLITING A COMPANY

    THANKS
     



  15. pullarao

    pullarao New Member


    Hi,

    we can do these using triggers..
     



  16. admin

    admin Administrator Staff Member


    In stead writing a program during split, you can write a seperate program and run that program in new split company.

    1.You can write a program to list all Ledgers which contains Opening balance as Zero.
    2. Write a button with action as delete and select scope lines as All.
    3. Whenever u press that button, it will prompt you to delete the ledgers.

    :)
     



  17. Suresh

    Suresh New Member


    Hi, can anyone tell me usage of Function $$DLLValue ?
     



  18. Basha

    Basha Member


    i want salesman wise report pls help me
     



  19. Suresh

    Suresh New Member


    Hi, can any one used $$DllValue function ? any example please ?
     



  20. admin

    admin Administrator Staff Member


    Re
    Start a new thread in request forum.
     



  21. sandeep kelkar

    sandeep kelkar New Member


    example

    product name :acb
    price rs. 100
    total sold 500
    distributor discount 0.5%
    retailer discount 2.5%
    so 100x500=50000
    100x3%=rs. 3
    actually he will get the product for rs. 97

    but he want to no the wht value (discount) is retailer is getting & distributor is getting
    normaly we take 3% discount and make to invoice with the discounted value
    but i need the retailer discount also with discount given to distributor
     



  22. Ajitsinh Babariya

    Ajitsinh Babariya New Member


    Dear Experts,

    I want to generate payment sheet for bank from payment voucher (As like we can generate payment advice).

    Means when i make payment sheet, i want to add one option PAYMENT SHEET, as like payment advice.

    Payment sheet format:
    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    Dt. xx.xx.xxxx

    To,
    The Bank Manager,
    BANK NAME FROM PAYMENT VOUCHER

    Sub: Transfer of payment by CHQ. NO. FROM PAYMENT VOUCHER.

    Dear Sir,


    We are enclosing herewith our Cheque Number FROM PAYMENT VOUCHER dated FROM PAYMENT VOUCHER for amount Rs. FROM PAYMENT VOUCHER in words Rupees FROM PAYMENT VOUCHER

    We request you to kindly transfer the amount as per the following details

    Sr No. Party Name Bank Account No. Amount Rs.
    xx ABCDE XXXXXXXXXXX XXXXX.XX
    xx PQR XXXXXXXXXXX XXXXX.XX
    xx xyz XXXXXXXXXXX XXXXX.XX​

    Thanking you.
    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -​
    Now i requesting you to help me for preparing its TDL.


    Thanks.​
     





  23. Tally 4.5 on words having this feature inbuilt
     



  24. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member


    Sir,

    please tell me in Report- B ;how to get value of variable which is local to 'Report-A'
     



  25. admin

    admin Administrator Staff Member


    That variable should be Volatile and Need to declare that variable in Report - B at definition level
     



Share This Page