Dear Experts, I am trying one TDL for stock movements. I am facing two problems in that. 1. I want to get the Stock Item Opening Balance of particular Godown as on Date. For Example, I have three godowns like Finished Goods -1, Finished Goods - 2, Finished Goods -3. I need, the stock Item opening balance of Finished Goods-3 godown only. How to get this.....? 2. I want to get the finished product quanity from Manufacturing Journal. I tried to get the Qty as follows, Walk: All Inventory Entries Compute : MGFR Qty : $InventoryEntriesIn[1].ActualQty Its showing all stock Items in that voucher including all Raw Materials names. But, I need only Finished Good Qty only. So, please help me....? waiting for your reply.. Regards, vanandd
Hi, For fist issue, add a button in the report on which you have to trigger a collection which will display all the godowns with the help of small report and filter out the report on selection of the Godwon (It is same like you select any voucher type in day book) For the second issue, again you are not filtering the collection on for finished items only. Just try to filter it out for the finished items only. Other experts will may also advice in a better way. Thanks!
Dear Sir, Thanks for your reply...I will try to get the Godown Name with Button sir.. But, can you please give me example for second issue...Because, I have tried with filter. Even though raw materials are appearing in that report. Waiting for your reply sir.. Regards, vanandd
Create aCollection using [collection : salescoll] Type : Vouchers: Vouchertype Child of : $$VchTypesales Belongs to Yes Fetch : voucherumber [Collection : Salesinvcoll] Source Collection : SalesColl Walk : Inventory entries Search Key : $Vouchernumber+$UDFNAME Compute: Udfname: $UDFName use Collectionfieldbykey formula using Vouchernumber+UDFNAME