How to Fetch Table Heading in Customized Report

Discussion in 'Tally Developer' started by Taufeeq Shaikh, Dec 22, 2020.

    
  1. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear All,

    I want to fetch the report head of GSTR-1 in Customized Report.

    (i.e.) GST Type of the Transaction....

    I tried this but it is showing Numeric

    Compute : TSGsttype : $GSTVchTransTypeCode



    upload_2020-12-22_12-41-37.png

    upload_2020-12-22_12-41-52.png
     
    Last edited: Dec 22, 2020


  2. raviashani

    raviashani New Member



  3. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear Experts,

    I tried to find out from where the Name Headings are coming. Later i came to know that it is Rule Set... I am totally unaware of Rule Set. Please help me to create my own for my UDF Report.



    [Rule Set: GSTR1TablewiseSummary]

    Break On : Yes
    Walk On : Yes

    Rule : IsTable5 : @IsTable5
    Rule : IsTable6 : @IsTable6

    Rule : IsTable7 : @IsTable7

    Rule : IsTable8 : @IsTable8
    Rule : IsTable8URD : @IsTable8URD

    Rule : IsTable9 : @IsTable9

    Rule : IsTable10 : @IsTable10

    ;; advance receipts related rules
    Rule : IsTable11 : @IsTable11
    Rule : IsTable12 : @IsTable12


    Aggr Rule : IsParticipatesInTable : AnyTrue
    Aggr Rule : IsTablewithErrors : AnyTrue : 2

    NameSet : GSTR1TableWiseSummary
    Local Formula : IsEmptyGSTNatofRet : If @@IsDebitNoteVch OR @@IsCreditNoteVch Then $$IsEmpty:$GSTNatureofReturn Else Yes
    Local Formula : IsTable5 : ($GSTVchTransTypeCode = 2 AND @IsEmptyGSTNatofRet) AND (($GSTR_TransNatureEx CONTAINS "Deemed Export") OR +
    (($GSTR_TransNatureEx In ("Sales Taxable", "Interstate Sales - Taxable", "Interstate Sales to Embassy/UN Body Taxable") OR $GSTR_TransNatureEx CONTAINS "Sales to SEZ") AND +
    ($$IsEmpty:##vGSTPartyDealerType OR (##vGSTPartyDealerType IN ($$SysName:Regular, $$SysName:Composition)))))

    Local Formula : IsTable6 : ($GSTVchTransTypeCode = 2 AND @IsEmptyGSTNatofRet) AND $GSTR_TransNatureEx = "Interstate Sales - Taxable" AND +
    ((##vGSTPartyDealerType IN ($$SysName:Unregistered, $$SysName:Consumer))) AND +
    ($$Abs:##vPartyLedAmount > $$Number:250000)
    Local Formula : IsTable7 : (($GSTVchTransTypeCode IN (2,4)) AND (((##vGSTPartyDealerType IN ($$SysName:Unregistered, $$SysName:Consumer)) AND +
    (($GSTR_TransNatureEx = "Interstate Sales - Taxable" AND +
    ((NOT $$IsEmpty:$GSTROriginalInvoiceValue AND $$Number:$GSTROriginalInvoiceValue <= $$Number:250000) OR $$IsSysNameEqual:LesserthanTwoHalfLakhs:$GSTOriginalSaleValue OR ($GSTVchTransTypeCode = 2 AND @IsEmptyGSTNatofRet))) OR $GSTR_TransNatureEx = "Sales Taxable")) OR ($GSTR_TransNatureEx In ("Sales to Consumer - Taxable", "Sales to Consumer - Exempt", "Sales to consumer Nil Rated")))) OR +
    ($GSTVchTransTypeCode = 7 AND $$IsSysNameEqual:RBGSTFlagDecreaseTaxliabilty:$TaxAdjustment AND $GSTAdditionalDetails IN ($$SysName:GSTCancelledSEZAdvance, $$SysName:RBGSTFlagCancelofAdvReceipts) AND $PlaceOfSupply = ##vCMPPlaceOfSupply AND +
    (##vGSTPartyDealerType IN ($$SysName:Unregistered, $$SysName:Consumer)))

    Local Formula : IsTable8 : (($GSTVchTransTypeCode = 4 OR ($GSTVchTransTypeCode = 2 AND NOT @IsEmptyGSTNatofRet)) AND +
    (($GSTR_TransNatureEx CONTAINS "Deemed Export") OR (($GSTR_TransNatureEx In ("Sales Taxable", "Interstate Sales - Taxable", "Interstate Sales to Embassy/UN Body Taxable") OR $GSTR_TransNatureEx CONTAINS "Sales to SEZ") AND +
    ($$IsEmpty:##vGSTPartyDealerType OR ##vGSTPartyDealerType IN ($$SysName:Regular, $$SysName:Composition))))) +
    OR ($GSTVchTransTypeCode = 7 AND $$IsSysNameEqual:RBGSTFlagDecreaseTaxliabilty:$TaxAdjustment AND $GSTAdditionalDetails IN ($$SysName:GSTCancelledSEZAdvance, $$SysName:RBGSTFlagCancelofAdvReceipts) +
    AND ($$IsEmpty:##vGSTPartyDealerType OR ##vGSTPartyDealerType IN ($$SysName:Regular, $$SysName:Composition)))

    Local Formula : IsTable8URD : (((($GSTVchTransTypeCode = 4 OR ($GSTVchTransTypeCode = 2 AND NOT @IsEmptyGSTNatofRet)) AND ($GSTR_TransNatureEx = "Interstate Sales - Taxable" AND ($$IsEmpty:$GSTROriginalInvoiceValue OR $$Number:$GSTROriginalInvoiceValue > $$Number:250000 OR $$IsSysNameEqual:GreaterthanTwoHalfLakhs:$GSTOriginalSaleValue))) OR +
    ($GSTVchTransTypeCode = 7 AND $$IsSysNameEqual:RBGSTFlagDecreaseTaxliabilty:$TaxAdjustment AND $GSTAdditionalDetails IN ($$SysName:GSTCancelledSEZAdvance, $$SysName:RBGSTFlagCancelofAdvReceipts) AND $PlaceOfSupply != ##vCMPPlaceOfSupply)) AND +
    (##vGSTPartyDealerType IN ($$SysName:Unregistered, $$SysName:Consumer))) OR (($GSTVchTransTypeCode = 4 OR ($GSTVchTransTypeCode = 2 AND NOT @IsEmptyGSTNatofRet)) AND $GSTR_TransNatureEx IN ("Exports Taxable", "Exports Exempt", "Exports LUT/Bond", "Exports Nil Rated"))

    Local Formula : IsTable9 : ($GSTVchTransTypeCode IN (2,4)) AND ($GSTR_TransNatureEx In ("Sales Exempt", "Interstate Sales Exempt", "Sales Nil Rated", "Interstate Sales Nil Rated", "Interstate Sales to Embassy/UN Body Exempt", "Interstate Sales to Embassy/UN Body Nil Rated") OR +
    $IsNonGSTGoods)

    Local Formula : IsTable10 : ($GSTVchTransTypeCode = 2 AND @IsEmptyGSTNatofRet) AND (($GSTR_TransNatureEx In ("Exports Taxable", "Exports Exempt", "Exports LUT/Bond", "Exports Nil Rated")))
    Local Formula : IsTable11 : ($GSTVchTransTypeCode = 7 AND $$IsSysNameEqual:RBVATFlagIncrTaxLiability:$TaxAdjustment AND $GSTAdditionalDetails IN ($$SysName:RBGSTFlagAdvanceReceipts, $$SysName:GSTAdvRcptsSEZ))

    Local Formula : IsTable12 : ($GSTVchTransTypeCode = 7 AND $$IsSysNameEqual:RBGSTFlagDecreaseTaxliabilty:$TaxAdjustment AND $GSTAdditionalDetails IN ($$SysName:GSTSaleAgnstAdvRcpts, $$SysName:GSTSaleAgnstAdvRcptsSEZ))




    [Name Set: GSTR1TableWiseSummary]

    Localise : Yes

    List Name : IsTable5 : "5 B2B Invoices - 4A, 4B, 4C, 6B, 6C"
    List Name : IsTable6 : "6 B2C(Large) Invoices - 5A, 5B"
    List Name : IsTable7 : "7 B2C(Small) Invoices - 7"
    List Name : IsTable8 : "8 Credit/Debit Notes(Registered) - 9B"
    List Name : IsTable8URD : "8A Credit/Debit Notes(Unregistered) - 9B"
    List Name : IsTable10 : "10 Exports Invoices - 6A"
    List Name : IsTable11 : "11 Tax Liability(Advances received) - 11A(1), 11A(2)"
    List Name : IsTable12 : "12 Adjustment of Advances - 11B(1), 11B(2)"
    List Name : IsTable9 : "9 Nil Rated Invoices - 8A, 8B, 8C, 8D"
    List Name : Total : "14 Total"
    List Name : HSNSummary : "13 HSN/SAC Summary - 12"
    List Name : DocSummary : "14 Document Summary - 13"
     


  4. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Rule Sets are very use.. It's like Octopus using all its hands/legs to accomplish a task.. This like using multiple functions at one go..

    best part is you can parse a collection using a rule set and then convert results into a new collection and then use it for reports..

    there are already good examples in sample TDL..
     
    Taufeeq Shaikh likes this.


Share This Page