Dear All Tdl Experts, I need to create a method in Stock Item Master and I need to store a value from the particular collection. Later i need to retrieve the value in reports like closing Balance. I tried with following codes But I didn't get result. My Task is purchase vouchers Item wise aggregate quantity Total to store in the item Master. [collection : mycollcheck] Type :vouchers:vouchertype child of : $$vchtypePurchase Belongs To : yes [collection : mycollcheckreal] Source collection : mycollcheck Walk : Inventory Entries By:stockitemName:$stockitemName ;;By :Billedqty:$Billedqty Aggr computeBilledqty:sum:$Billedqty [System : Formula] test:$$Filtervalue:$pBilledqty:mycollcheckreal:1:myitem myitem:$Name=$stockitemName [#Object:stockitem] mystkqty@test In Report : $Mystkqty is not working Please help me. Thanks in Advance.
I wanted to clarify couple of things 1. You can not store value permanently [#Object:stockitem] mystkqty@test 2. When even u need value, u need to call method $mystkqty and object should be - stock item in the collection or in the Report level. This leads to erformance issue. If you clearly explain, why do you need this solutions with case study, then i will provide best solution for that. Thank You.
Dear Admin, Thank you very much for your immediate reply, I Want to retrieve summarized value of the stock items from one collection, and store this value in the stock item Master as method . Later I need to access this method value in the report. (I should call this method only object context of stock item) case study : - I have one voucher type Name "Stock in Transport" Under Purchase, We receive purchase bills and we account it before stock arrive. By this purchase entry , our stock summary affect. Here we need to less the qty of the particular Voucher Type "Stock in Transport" Collection. For this purpose i plan to create one report, that shows that What are the stocks in Transport, What are the stocks in stock summary. Here i need to Less the Transport qty. This my scenario.