GSTR2 SUMMARY OF TALLY

[#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"

 

Respected @garima , I am getting a violation error when I am selecting the full financial year

 

problem with purvch filter