hi, admin in prime 2.1 as like above image i am getting results of GST 2B status while counter party filed or not using $GSTActivityStatus but in prime 3.0 code has changed the status storage (tally using this keyword in tally prime 3.0 $GSTReconStatus) kindly give the suggest what is the keyword to get the results
This is a sample to assist you in exploring your way to get details for 2A/2B [#Line : DSP VchAccTitles] Add : Fields : After : DSP VchAcctTitle : TtlReconStatus [Field : TtlReconStatus] Use : Name Field Set as : "Recon Status" Skip : Yes Width : 15 Style : Small Bold Italic Color : Blue Align : Centre [#Line: DSP VchDetail] Add : Right Fields : Before : DSP VchType : ReconStatus [Field : ReconStatus] Use : Name Field Skip : Yes Width : 15 Style : Small Bold Italic Color : Blue Align : Centre ; Space Right : 2 Option : DrsReconStatus : @@IsDrsGrp [!Field : DrsReconStatus] Set As : If $IsGSTR1Reconciled contains "Yes" Then "Reconciled" Else + If $IsGSTR1Exported = "Yes" Then "Exported" Else + If $IsGSTR1MisMatched = "Yes" Then "Mismatched" Else + If $IsGSTR1NotExported = "Yes" Then "Not Exported" Else "" [#Collection: Vouchers of Ledger] Source Collection : SRC Ledger Vouchers Coll, GSTR Stat DefaultVouchers ;; Add this Collection to Collection of Ledger Vouchers. Compute : IsGSTR1Reconciled : $$StatObjAny:GSTRStatIsGSTR1Reconciled Compute : IsGSTR1Exported : $$StatObjAny:GSTRStatIsGSTR1Exported Compute : IsGSTR1MisMatched : $$StatObjAny:GSTRStatIsGSTR1Mismatch Compute : IsGSTR1NotExported : $$StatObjAny:GSTRStatIsGSTR1NeverExported [System : Formula] IsDrsGrp : $$IsLedOfGrp:##LedgerName:$$GroupSundryDebtors Similarly explore for 2A/2B status from the FORMULA file --- GSTRReportsCommonFormula.tdl ... happy hunting.
If you need the same in Sales/Purchase ledgers then you can modify as under: IsDrsGrp : $$IsLedOfGrp:##LedgerName:$$GroupSundryDebtors OR $$IsLedOfGrp:##LedgerName:$$GroupSales
please help me for Stock Import method SrcOfGstDetails not set in tally 3.0 how to set this please help 1UT1 : New Object : Unit 4UT1 : Set Value : NAME : $Column17 5UT1 : Set Value : ISSIMPLEUNIT : Yes 6UT1 : Create Target 1010 : New Object : Stockitem : $Column18 : Yes 1011 : Set Value : Name : $Column18 1025 : Set Value : Parent : " Primary" 1027 : Set Value : BaseUnits : $Column17 G300 : INSERT COLLECTION OBJECT : GSTDETAILS G310 : SET TARGET : GSTDETAILS[1] G1HSN1 : Set Value : SrcOfGstDetails : "Specify Details Here" G860 : SET TARGET : .. G8601 : SET TARGET : .. 1500B : Create Target 1500C : Save Target
Dear Amit Ji, for unregistered customer its shows blank I found Another solution [!Field : DrsReconStatus] Set By Condition$$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName):$GSTR1Status [#Collection: Vouchers of Ledger] Fetch : GSTR1Status
But there is a problem in this code for unregistered customer its shows "Included" for both for current month or previous reconciled month Now my question is how to different for this two "Included" Hope you understand my query Expect your valuable feedback
Set As : If $LedGSTRegDetails[Last].GSTRegistrationType Contains "Unregistered" Then "Wotever text u need" Else $GSTR1Status
No No I want if suppose July gstr-1 filed or reconciled with books then it will show for unregistered dealer "Reconciled" else not filed or reconciled then will show "Unreconciled" for registered customer as if gstr-1 reconciled it shows "Reconciled" I want it for unregistered also now it shows "included" for reconciled or "unreconciled" trnx both Hope you understand
Can't we use If $LedGSTRegDetails[Last].GSTRegistrationType Contains "Unregistered" and $GSTR1Status = "Included" Then "Whatever text u need" Else $GSTR1Status
