LAST RECEIPT OF PARTY

Dear Sir i am facing a problem to get party last receipt amount

can Anyone resolve this

[#Menu: GATEWAY OF TALLY]
Add: Item: MIS REPORT : Display: Party Wise Turnover Report : NOT $$IsEmpty:$$SelectedCmps
[Report: Party Wise Turnover Report]
Title: $$LocaleString:"MIS REPORT"
Use : DSP Template
Form : Party Wise Turnover Report
Variables : SV CurrentCompany, SV FromDate, SV ToDate, SV SortMethod
Set : SV Sort Method : @@Default
Set : SV From Date :##SVCurrentDate ; if $$InPrintMode then $$MonthStart:##SVCurrentDate else ##SVCurrentDate
Set : SV To Date : ##SVCurrentDate

[Form: Party Wise Turnover Report]
Use : DSP Template
Width : 100% Page
Height: 100% Page
Part:ABCD, DETAIL
[Part:ABCD]
Line:ROI TITLE LINE12,ROI TITLE LINE2
Space Bottom:0.5
Space Top:0.25
[Line:ROI TITLE LINE12]
Field:NAME FIELD
Right Field:ABCD1
Local:Field:NAME FIELD:Set as:"RECEIPT DETAILS "
Local:Field:NAME FIELd:Style:large bold
Local:Field:NAME FIELd:Align:Center
Local:Field:NAME FIELD:Border:THIN BOTTOM
Local:Field:NAME FIELD:Full Width:Yes
[Field:ABCD1]
Set as : @@DSPDateStr

[Line:ROI TITLE LINE2]
Field:NAME FIELD
;Right Field:ABCD1
Local:Field:NAME FIELD:Set as@CMPMAILNAME
Local:Field:NAME FIELD:Align:Centre
Local:Field:NAME FIELd:Style:large bold
Local:Field:NAME FIELd:Align:Left
;Local:Field:NAME FIELD:Border:THIN BOTTOM
Local:Field:NAME FIELD:Full Width:Yes

[PartETAIL]
Line: TurnOverTitles, TurnOverDetails
Repeat: TurnOverDetails : TurnOverColl
Scroll: Vertical
Common Border:Yes
[Line: TurnOverTitles]
Use: TurnOverDetails
Local:Field:SR:Info:"SR NO."
Local:Field:SR:Border:THIN LEFT
Local:FieldartyName:Info:"PARTY NAME"
Local:FieldartyName:Border:THIN LEFT
Local:Field:grp:Info:"GROUP NAME"
Local:Field:grp:Border:THIN LEFT
Local:FieldT:Info:"DATE"
Local:FieldT:Border:THIN LEFT
Local:Field:RAMT:Info:"AMOUNT"
Local:Field:RAMT:Border:THIN LEFT
;Local: Field: RAMT : Border:THICK LEFT RIGHT
Local: Field: Default: Type: String
Local: Field: Default: Align: Center
Local: Field: Default: Style: CMPAddStyleB
Border:THIN BOX
Space Bottom: .50
Space Top: .75
[Style : CMPAddStyleB]
Font : "Calibri"
Height : "11"
Bold : Yes
[Line:TurnOverDetails]
Add:Field:SR,PartyName,GRP;,DT,RAMT
Right FieldT,RAMT

[Field:SR]
Use:name FIELD
Set as:if $$IsEmpty:#PARTYNAME then "" else $$Line
[FieldARTYNAME]
Use:NAME FIELD
;Set as:$LedgerName
;Set as:$$CollectionField:$LedgerName-1):TurnOverColl

Set as:if $LedgerName=$$PrevLine:$LedgerName AND $$IsEmpty:#PARTYNAME then "" else $LedgerName

[Field:GRP]
Use:NAME FIELD
Set as:if $$IsEmpty:#PARTYNAME then "" else $PLN

[FieldT]
Use:UNI DATE FIELD
Set as:if $$IsEmpty:#PARTYNAME then "" else $date
[Field:RAMT]
Use:AMOUNT FIELD
;Set as:$$CollectionField:$AMOUNT-1):TurnOverColl

Set as:if $$IsEmpty:#PARTYNAME then "" else $$CollectionField:$AMOUNT:$$Line:TurnOverColl
[Collection: RecptVchs]

Type : Vouchers : VoucherType
Child Of : $$VchTypeReceipt

[Collection:TurnOverColl]
Source Collection : RecptVchs
Walk : Ledger Entries
By : LedgerName : $LedgerName
;Sort : -$Date
By : Date : $Date
;Compute : Amount : $(ledger,$Amount).LAST
Computeln:$_PrimaryGroup:Ledger:$LedgerName
Compute:AMOUNT:$AMOUNT
Sort : @@SortAlphaIncr : $LedgerName
Filter:new

[System:Formulae]
NEW:$PLN="Loans & Advances (Asset)"

;; SELECT $LEDGERNAME,$DATE,$AMOUNT FROM RecptVchsSum

 

Add below in Collection

Compute:LastRcptDate:$Date
Sort : @@SortAlphaIncr : -$Date, $LedgerName

and in Field

[FieldT]
Use:UNI DATE FIELD
Set as:if $$IsEmpty:#PARTYNAME then "" else $LastRcptDate ;;$date

 

its nor fetching