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
Make 2 Collections one with ............ [System:Formula] GSTR2AIsWithValueNot ($$IsEmpty:$VCHGSTR_AccVal)) and one without..............
i make 2 collection and make 2 filter but one issue coming..if a single voucher purchase exempted then its not showing...