1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to fetch overdue days in group Outstanding?

Discussion in 'Free Source Codes' started by Abisha, Sep 5, 2023.

    
  1. Abisha

    Abisha New Member


    In my below code I was not able to complete the OverDue Days Feild & also not able to get the Vouchertype

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>TGOutstandingGroup Details</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVCURRENTCOMPANY>${company}</SVCURRENTCOMPANY>
    <SVFROMDATE>${fromDate}</SVFROMDATE>
    <SVTODATE>${toDate}</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <REPORT NAME="TGOutstandingGroup Details">
    <FORMS>TGOutstandingGroup Details</FORMS>
    <TITLE>TGOutstandingGroup Details</TITLE>
    </REPORT>
    <FORM NAME="TGOutstandingGroup Details">
    <TOPPARTS>TGOutstandingGroup Details Part</TOPPARTS>
    <XMLTAG>"ENVELOPE"</XMLTAG>
    </FORM>
    <PART NAME="TGOutstandingGroup Details Part">
    <TOPLINES>TGOutstandingGroup Details Line Title, TGOutstandingGroup Details Details </TOPLINES>
    <REPEAT>TGOutstandingGroup Details Details : TGLedgerwiseBills</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    <COMMONBORDERS>Yes</COMMONBORDERS>
    </PART>
    <LINE NAME="TGOutstandingGroup Details Line Title">
    <USE>TGOutstandingGroup Details Details</USE>
    <LOCAL>Field : Default : Type : String </LOCAL>
    </LINE>
    <LINE NAME="TGOutstandingGroup Details Details">
    <LEFTFIELDS>BILLDate,BILLREF,BILLParty</LEFTFIELDS>
    <XMLTAG>BILLFIXED</XMLTAG>
    <Rightfields>BILLOP,BILLCL,BILLDUE,BILLOVERDUE,BillVch</Rightfields>
    </LINE>
    <FIELD NAME="BILLDate">
    <USE>Name Field</USE>
    <SET>$BILLDate</SET>
    </FIELD>
    <FIELD NAME="BILLREF">
    <USE>Name Field</USE>
    <SET>$Name </SET>
    </FIELD>
    <FIELD NAME="BILLParty">
    <USE>Name Field</USE>
    <SET>$LedgerName</SET>
    </FIELD>
    <FIELD NAME="BILLCL">
    <USE>Amount Field</USE>
    <SET>$ClosingBalance</SET>
    </FIELD>
    <FIELD NAME="BILLOP">
    <USE>Amount Field</USE>
    <SET>$OpeningBalance</SET>
    </FIELD>
    <FIELD NAME="BILLDUE">
    <USE>Long Date Field</USE>
    <SET>$$DueDateByDate:$BillDueDate</SET>
    </FIELD>
    <FIELD NAME="BILLOVERDUE">
    <USE>Amount Field</USE>
    <SET>$__________________</SET>
    </FIELD>
    <FIELD NAME="BillVch">
    <USE>Name Field</USE>
    <SET>$_______________________</SET>
    </FIELD>
    <COLLECTION NAME="TGLedgerwiseBills" ISMODIFY="No">
    <Type>Bills</Type>
    <Fetch>.*.</Fetch>
    <Filter>LedgerGroupFilter</Filter>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="LedgerGroupFilter">$$IsLedOfGrp:$LedgerName:$$GroupSundryDebtors</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    Abisha, Sep 5, 2023
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    I dont know pin point but
    Currentdate - DueDate(Billdate+Graceperiod) should work
     
    Sai Vineeth, Sep 5, 2023
    #2


Share This Page