Last Payment of the Party

Dear Experts,

Hello every one, i want to fetch the last paid amount by the party please can anyone help me out.
please kindly reply ASAP.

thanks in advance.

 

Dear Manthan Gandhi,

If you are showing it in report and you have large data size then use $$CollecitonFieldByKey instead of $$CollecitonField because $$CollectionFieldByKey function is giving faster result then $$CollectionField. You can use the same collection suggested by admin just add a search key to that collection.

 

Thanx alot admin & Maulik Patel

 

you are THE best, I just try to provide more knowledge as in my starting period I was also facing same issue with large data and was not able to resolve it.

 

Well reasoning and properly guided, hall mark of a matured learned counsel. Thank you

 

i want to show this on voucher creation screen how can i

 

write the code in the voucher form

 

brother can you give me code for this

 

@bollindia on which voucher you want??

 

on sales voucher

 

[Collection: My Coll]

Type : Vouchers: Ledger
Child of : $PartyLedgerName
Filter : IsRcptVoucher
Fetch : VoucherTypeName,Date,Amount
Sort : @@InCreasing: -$Date

[System: Formula]

IsRcptVoucher: $$IsReceipt:$VoucherTypeName

[#Part: EI BaseInfo]

Option : Last Pymt Det : $$Owner@isSales

[!Part : Last Pymt Det]

Add : Line : After : EI Consignee : l
Background : red

[Line : l]
Field : Medium Prompt , last Amt
Local : Field : Medium Prompt : Set as : "Last Payment"

[Field : Last Amt]

Use : Amount Field
Set as : $$CollectionField:$Amount:1:MyColl
Skip : Yes

;; end of file



try this...

 

pls see in jpg file whats i want sir

 

i want to feth last vocher entry while vocher entry