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.
Code: $$CollectionField:$Amount:1:MyColl [Collection: My Coll] Type: Vouchers: Ledger Child of : $PartyLedgerName Filter: IsRcptVoucher Fetch: VoucherTypeName,Date,Amount Sort: @@InCreasing: -$Date [System: Formula] IsRcptVoucher: $$IsReceipt:$VoucherTypeName
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.
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.
[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...