TDL Byte #16: CONVERT TO XML TDL – CASE STUDY

Discussion in 'Tally & TDL Learning HUB' started by admin, Nov 26, 2015.

    
  1. admin

    admin Administrator Staff Member


    CONVERT TO XML TDL – CASE STUDY
    [​IMG]
    TDLByte #16
    [​IMG]
    Dear Developers,
    In context to the previous TDLByte that explained the feature 'Convert to XML TDL' in
    Tally.Developer 9, this TDLByte will show how this feature can be applied via a case study.
    Case Study: A customer wants to fetch the report 'Group Outstandings' which is a default report in Tally.ERP 9 by sending a XML request from an external application. By default, this report gives the outstandings of all the subgroups and ledgers for a selected Group, but doesn't specify the type of object (Group or Ledger) and the immediate parent in the XML Response. This extra information is required by the customer in the XML Response.
    Default response of 'Group Outstandings'
    [​IMG]
    Required response of 'Group Outstandings'
    [​IMG]
    Solution: This Case Study clearly needs some customization to be done in the report 'Group Outstandings' so that, the extra information i.e. the Object Type and Parent are received in the response.
    Let us take an example of fetching the 'Group Outstandings' for the group 'Sundry Debtors'.
    Step 1
    Write a customization that will include the information –Object Type and Parent for each Line of
    'Group Outstandings'.


    Write a customization that will include the information –
    Object Type and Parent for each Line of 'Group Outstandings'.

    [​IMG]


    Step 2
    Convert the TDL to XML TDL using the feature 'Convert to XML TDL' in Tally.Developer 9.


    [​IMG]


    Step 3
    Include the Converted XML TDL in the XML Request for 'Group Outstandings' inside the tag 'DESC'.


    [​IMG]


    Step 4
    Send the XML request to Tally.ERP 9 and get the response.


    Response without TDL Tag in XML Request
    [​IMG]
    Response with TDL Tag in XML Request
    [​IMG]


    We hope you will use the case study and apply this feature in your day-to-day customisation. In our next TDLByte, we will introduce you to a new feature in Tally.Developer 9.
    Stay tuned!
     


Share This Page