[#Menu: Display Menu] Add: Key Item : Before: @locQuit: GST Report : G : Menu : GSTR2 report : $$IsAccountingOn:$$CurrentCompany Add: Item: Before: GST Report : Blank [Menu: GSTR2 report] Key Item: Party wise Purchase : P : Display: GSTR2 Report [Field: SNO] Set as : $$Line Width : if $$inprintmode then 3 else 4 Align : Center Border : Thin Left Right Style :small Color :red [Field: NAME] Use : Name Field Set as : $Partyledgername;, $Name Variable : LedgerName Display : Ledger Vouchers FullWidth : Yes Quick Search:Yes Border: thin Right [Field: filingdate] Use: Uni Date Field [Field: claimdate] Use: Uni Date Field [Field: taxableamt] Use: Number Field Width: 15 Set as: $$CollectionFieldByKey:$TotalTaxableValue:#NameartywisePurchase Border: Thin Left Format: "Nozero,Decimal:2" [Field: Expensesamt] Use: Number Field Width: 15 Set as: $$CollectionFieldByKey:$TotalExpenses:#NameartywisePurchase Border: Thin Left Format: "Nozero,Decimal:2" [Field: igstamt] Use: Amount Field Width: 15 Set as: $$CollectionFieldByKey:$TotalIGSTTaxAmount:#NameartywisePurchase Border: Thin Left Format: "Nozero,Decimal:2" [Field: cgstamt] Width: 15 Use: Amount Field Set as: $$CollectionFieldByKey:$TotalCGSTTaxAmount:#NameartywisePurchase Border: Thin Left Format: "Nozero,Decimal:2" [Field: sgstamt] Use: Amount Field Width: 15 Set as: $$CollectionFieldByKey:$TotalSGSTTaxAmount:#NameartywisePurchase Border: Thin Left Format: "Nozero,Decimal:2" [Field: invamt] Use: Amount Field Width: 15 Set as: $$CollectionFieldByKey:$PartyAmt:#NameartywisePurchase Border: Thin Left Format: "Nozero,Decimal:2" [Report:GSTR2 Report] Use : DSP Template Form: GSTR2 Report Title: "GSTR2 Partywise Summary" Variables : SV FromDate, SV ToDate Set : SV From Date : $$MonthStart:##SVFromDate Set : SV To Date : $$MonthEnd:##SVCurrentDate [Form:GSTR2 Report] Parts:Top Part, Body Part ;Part : WEXPTitle,WEXPPeriod,WEXPDetails Height:100% screen;Yes ;100% Screen Width: 100% Screen Button: PrintButton, ExportButton,ChangePeriod background : Light Grey Space Bottom: .25 Space Top: .5 Space Left:.5 Space Right: .5 [Part: Top Part] Top Line: TopCmpName,topTitle,TopPeriod;, BodyCol, BodyCol1 Border: Thin Bottom [Line: TopCmpName] Field: Simple Field Local: Field: Simple Field : Set as: @@Cmpmailname;"Party wise Sales & Receipt" Local: Field: Simple Field : Skip: Yes Local: Field: Simple Field : Style:Large Bold ;Small Bold Local: Field: Simple Field : Full Width: Yes Local: Field: Simple Field : Align: Centre Space Bottom: 1 [Line: Toptitle] Field: Simple Field Local: Field: Simple Field : Set as: "Party wise purchase Report" Local: Field: Simple Field : Skip: Yes Local: Field: Simple Field : Style: Large Local: Field: Simple Field : Full Width: Yes Local: Field: Simple Field : Align: Centre Space Bottom: .5 [Line: TopPeriod] Right Field: Name Field Local: Field: Name Field : Set as: "For the Period : " + @@DSPDateStr Local: Field: Name Field : Style: small Bold Local: Field: Name Field : Skip: Yes Local: Field: Name Field : Align: Centre Local: Field: Name Field : Full Width: Yes;Width: 60% Screen [Part: ColPart] Lines: GSTR2 Title [Part: Body Part] Lines:GSTR2 Title, GSTR2 Detail Repeat: GSTR2 Detail: PartywisePurchase ;Bottom Line: Bottom Part1 Scroll: Both Common Border: Yes Border: Thin Top Bottom ;Total:ApSal, ApRec, MaySal, MayRec, JunSal, [Line: GSTR2 Detail] Fields: sno, name,filingdate, claimdate Right Fields: taxableamt, Expensesamt, igstamt, cgstamt, sgstamt, invamt Local: Field: Default : Style: Small Bold Local: Field: Default : Skip: Yes Local: Field: Default : Align: Centre Local: Field: LedNm : Set as: "Party" Border: Thin Top [Line : GSTR2 Title] Use: GSTR2 Detail Local: Field: Default: Type: String Local: Field: Default : Skip: Yes Local: Field: Default : Lines: 2 Local: Field: Default : Align: Centre Local: Field: sno : Set as: "S No" Local: Field: name : Set as: "Party Name" Local: Field: filingdate : Set as: "GSTR1 Filing Date" Local: Field: claimdate : Set as: "GSTR2 Claim Date" Local: Field: taxableamt : Set as: "taxable amt" Local: Field: Expensesamt : Set as: "Expenses amt" Local: Field: igstamt: Set as: "igst amt" Local: Field: cgstamt: Set as: "cgst amt" Local: Field: sgstamt: Set as: "sgst amt" Local: Field: invamt: Set as: "inv amt" [Collectionurvch] Type : Vouchers : VoucherType Child of : $$VchTypePurchase Fetch : *.*, InventoryEntries.*.*, , LedgerEntries.*.* [Collection: PartywisePurchase] Source Collection: purvch ; GSTRTrglVchBase By: Partyledgername : $Partyledgername Aggr Compute :TotalTaxableValue : Sum : $$CollAmtTotal:InventoryEntries:$Amount Aggr Compute :TotalExpenses : Sum : $LedgerEntries[1,@@Expenses].Amount Aggr Compute : TotalIGSTTaxAmount : SUM : $LedgerEntries[1,@@IGSTAmt].Amount Aggr Compute : TotalCGSTTaxAmount : SUM : $LedgerEntries[1,@@CGSTAmt].Amount Aggr Compute : TotalSGSTTaxAmount : SUM : $LedgerEntries[1,@@SGSTAmt].Amount Aggr Compute: PartyAmt: Sum:$Amount;Amount Fetch : *.*, InventoryEntries.*.*, LedgerEntries.*.* Search Key: $PartyLedgerName [System: Formula] purvch: $Parent:Vouchertype:$VoucherTypeName= "Purchase" MonthFilter: $$FullMonthName:$date = "April" IGSTAmt : $LedgerName Contains "IGST" SGSTAmt : $LedgerName Contains "SGST" CGSTAmt : $LedgerName Contains "CGST" Expenses : $$IsLedOfGrp:$LedgerName:$$GroupDirectExpenses ; Contains "Sale"