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
http://tdlexpert.com/index.php?threads/new-most-powerful-tdl-functions.121/ you should try $$contextkeyword formula and try.
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"
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..