Thursday, November 15, 2012

TDL Specifications in XML Request

Report specification in TDL. 

<HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Data</TYPE>
        <ID>Report Name </ID>
</HEADER>

In the above header format the value of Tally Request is Export and the Type is data. Specifying the value of ID is Report Name. This report name should come inside the tag <REPORT> within the <TDL> tag.

Example : 

<TDL>
          <TDLMESSAGE>
                    <REPORT NAME="TDL Report" ISMODIFY="No" ISFIXED="No"
                                                 ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
                              <FORMS>First TDL Form</FORMS>
                    </REPORT>
                             .
                             .
          </TDLMESSAGE>
</TDL>

Collection specification in TDL.

<HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Collection</TYPE>
        <ID>Collection Name</ID>
</HEADER>

In the above template the value of Tally Request is Export and the Type is Collection. Specifying the value of ID is Collection Name. This collection name should come inside the tag <COLLECTION > within the <TDL> tag.

Example :

<TDL>
         <TDLMESSAGE>
                   <COLLECTION NAME="Collection of Ledgers"
                                                ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No"
                                                ISOPTION="No" ISINTERNAL="No">
                             <TYPE>Ledger</TYPE>
                   </COLLECTION>
                               .
                               .
                               .
         </TDLMESSAGE>
</TDL>

Object specification in TDL.

<HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Object</TYPE>
        <ID>Object Name</ID>
</HEADER>

In the above template the value of Tally Request is Export and the Type is Object. Specifying the value of ID is Object Name. This object name should come inside the tag <OBJECT> within the <TDL> tag.

Example :

<TDL>
        <TDLMESSAGE>
                  <OBJECT NAME="Ledger" ISINITIALIZE="Yes">
                             <LOCALFORMULA> TNetBalance: $$AsPositive: $$AmountSubtract:
                                                                                         $ClosingBalance: $OpeningBalance
                             </LOCALFORMULA>
                  </OBJECT>
        </TDLMESSAGE>
</TDL>

Function specification in TDL.

<HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Function</TYPE>
        <ID>Function Name</ID>
</HEADER>

In the above template the value of Tally Request is Export and the Type is Function. Specifying the value of ID is Function Name.

Example :
 
<DESC>
        <FUNCPARAMLIST>
                   <PARAM>@@FirstParameter</PARAM>
                   <PARAM TYPE="Number">0.10</PARAM>
        </FUNCPARAMLIST>
        <TDL>
                  <TDLMESSAGE>
                            <SYSTEM TYPE="Formulae" NAME="FirstParameter" >
                                          1242849 / 1000
                            </SYSTEM>
                  </TDLMESSAGE>
        </TDL>
</DESC>

In the above example, the function parameter list enclosed with the tag <FUNCPARAMLIST>. The formula which is used inside the Function parameter list is specified inside TDL Tag.

5 comments:

  1. Hi,
    kindly suggest how to write xml if i want perticular stock item from stock item master as response.

    thank you

    ReplyDelete
  2. Thank you for your valuable xml tags, But trial balance detail tag is not displaying all ledgers.

    ReplyDelete
  3. Sir Example : Request for a detailed Trial Balance in XML Format from Tally.
    in your blog not showing Ledgers under Sundry Creditors or Debtors.
    Please help

    ReplyDelete
  4. Hi,
    kindly suggest how to Modify in Default Tally Xml Format.?.I want to Required Specific Field in Xml Format. how to write in tdl code.?

    thank you

    ReplyDelete
  5. Wynn Las Vegas - MapyRO
    Wynn Las Vegas and Encore Tower 충주 출장안마 Suite Parlor. 제천 출장마사지 Amenities Include: Valet parking; Fitness Center; Concierge 남원 출장안마 access to gym and public spaces; Fitness center; Room service  충청남도 출장샵 Rating: 익산 출장마사지 7/10 · ‎2,821 reviews

    ReplyDelete