Dear All TDL Experts, Is there any way to extract the Last sold price for a partyledger when doing invoice. If is it possible please, let me know. please help me. Thanks in Advance. Thanking you
You can take only Stockitem's Last Sold Price in Stockitem Table/Collection. If u want Party's last Sold Price u can see $_LastsalePrice, $_LastSaleParty in Stockitem or You can find the Party's Last sols Price in Stock Query u need to create separate collections Partywise Sales vouchers n walk Inventoryentires Sort datewise you can take Last sold Rate from that collection.
Dear NAGARAJKMAR SUBRAMANIAN, Thank you For your Immediate Reply. I have written following collection, But I can't get result. please help me. I tried in many ways, i can't achieve the result. [collection : coll1] Type : vouchers:Ledger child of :#EIConsignee Fetch : voudherNumber,PartyledgerName,inventoryentries [collection : Coll2] Source Collection : coll1 Walk : inventoryentries By:voucherNumber:$voucherNumber By:MyStockitemName:$stockitemName Compute:Rate:$Rate Sort@Default:-$voucherNumber Filter :myfilter ;;==================================================================== [#line : EI Invinfo] Add:Field:mytestrate [Field:mytestrate] Use : Rate Price Field Storage : custorate Set As @Myraterusult set Always : yes [System : UDF] custorate:Rate:2365 [system : Formula] myfilter:$MystockiemName=$stockitemName Myraterusult:$$collectionfield:$Rate:1:Coll2 ;;====================================================================
sir, you have missed a character 't' in formula wrong: [system : Formula] myfilter:$MystockiemName=$stockitemName correct: [system : Formula] myfilter:$MystockitemName=$stockitemName
Dear balajimg, As per your indication I correct my code. It is still not achieving any result. please help and guide me. Thanking You,
Try This Code , Mutharasan [Collection : coll1] Type : vouchers:Ledger child of :#EIConsignee Fetch : voucherNumber,PartyledgerName Filter : ISsalesVch [collection : Coll2] Source Collection : coll1 Walk : inventoryentries By:voucherNumber :$voucherNumber By:MyStockitemName:$stockitemName Compute:Rate:$Rate SortDefault:-$voucherNumber Filter :Myfilter ;;==================================================================== [#line : EI Invinfo] Add:Field:After : VCH StockItem : Mytestrate,Testfld [Field : Mytestrate] Use : Rate Price Field ;Storage : custorate Set As : @@Myrateresult Set Always : yes Invisible : $$IsPurchase:$Vouchertypename ;Border : Thick Box [Field : testfld] Set as : $$Fulllist:Coll2:$Rate [System : UDF] Custorate:Rate:2365 [System : Formula] Myfilter:$MystockitemName=#VchStockitem ISsalesVch : $$Issales:$Vouchertypename Myrateresult:$$collectionfield:$Rate:1:Coll2
Dear Nagaraj Kumar Sir, This is working Fine. Thanks for your great help. Keep it up. Thank you very much.
D Dear Sir, Can u do 1 think, The LSP is display after saving the voucher , can we get it after select the Item. Thanks in advance .