Help me with this collection

Discussion in 'Free Source Codes' started by Jenny, Dec 3, 2022.

    
  1. Jenny

    Jenny Active Member


    I want fetch gst details for all vouchers which is related on Gst (As per 2B)
    In my collection its showing all vouchers include (sales,payment,creditnote) but if only one invoice purchase exempt its not fetch....
    Code:
    [Collection : My Voucher Rep Collection2]
    Parm Var:SVViewName : String : $$SysName:AcctgVchView
    Type : Voucher
    Fetch : VCHGSTR_AccVal,MasterID,Date,GSTentry_TaxAmount,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber,REFERENCE,ReferenceDate, GSTDutyAmount,BASICBUYERNAME,CGSTAmount,SGSTAmount,IGSTAmount,TaxableAmount,GSTVchAssesableValue
    Fetch : Allledgerentries.*,*.*
    Fetch :TaxableVal
    Compute:PurTaxableVal    :$VCHGSTR_AccVal
    Compute:PurIGSTAmount    :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100
    Compute:PurCGSTAmount     :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTCGSTRate / 100/2
    Compute:PurSGSTAmount    :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTSGSTRate / 100/2
    Filter : OnlyGSTLEDVch,GSTR2OnlyInputVchs,GSTR2AIsWithValue
    Sort    : @@Default                 : $PartyLedgerName
    
    [System:Formula]       
        GSTR2AIsWithValue:(Not ($$IsEmpty:$VCHGSTR_AccVal))
        GSTR2OnlyInputVchs:    $$IsPurchase:$VoucherTypeName OR @@IsPurchase OR $$IsDebitNote:$VoucherTypeName OR @@IsDebitNote OR $$IsJournal:$VoucherTypeName OR @@IsJournal OR $$IsPayment:$VoucherTypeName OR @@IsPayment
    
    [#Object:VOUCHER]
        Local Formula:VCHGSTR_AccVal : $$FilterAmtTotal:LedgerEntries:GSTRIsPurcLedger:$Amount
       
    
    [System:Formula]
        GSTRIsPurcLedger:@@GSTInputGroups or (($$IsSysNameEqual:Applicable:($GSTApplicable:Ledger:$LedgerName)) Or ($AppropriateFor:Ledger:$LedgerName = "GST"))
        GSTInputGroups:($$IsGrpOfGrp:($Parent:Ledger:$LedgerName):$$GroupPurchase) Or  ($$IsGrpOfGrp:($Parent:Ledger:$LedgerName):$$GroupIndirectExpenses) Or  ($$IsGrpOfGrp:($Parent:Ledger:$LedgerName):$$GroupDirectExpenses) Or  ($$IsGrpOfGrp:($Parent:Ledger:$LedgerName):$$GroupFixedAssets)
    
    OnlyGSTLEDVch : ($$FilterCount:LedgerEntries:IsLEIsGSTDutyLedger)>1    
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make 2 Collections one with ............
    [System:Formula]
    GSTR2AIsWithValue:(Not ($$IsEmpty:$VCHGSTR_AccVal))
    and one without..............
     
    Jaydeep Shah and Jenny like this.


  3. Jenny

    Jenny Active Member


    i make 2 collection and make 2 filter but one issue coming..if a single voucher purchase exempted then its not showing...
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    This is the culprit .... in case of exempted entry
     
    Jenny likes this.


  5. Jenny

    Jenny Active Member


    Sir how to fetch exempted purchase...?
     


Share This Page