Find the Collection Name and Fetch that value............ And in your FIELD -- Set As : $AllInventoryEntries[].BatchAllocations[].UDFName
You will find your collection in this PART ----- [Part: OrderAgeWiseDetail] There are many OPTIONS -- based on your data / selection find the Collection.
Dear Sir, I tried with collection but unable to fetch. i tried by writing below collection code sir [Collection: UDF1] Type: Vouchers: VoucherType Child of: $$VchTypeSalesOrder Belong to : Yes [Collection: UDF1 Summary] Source Collection: UDF1 Walk: AllInventoryEntries,BatchAllocations Compute:StockItemName:$StockItemName Compute:Rate:$Rate Compute: StkAmount:$Amount Compute: ItmBrandNames:$ItmBrandNames
TRIED This as well sir :-( failed to succeed Please suggest sir, when u r free please [Collection:SalesCollection] Type :vouchers:vouchertype Child Of :$$VchTypeSalesOrder Belongs To :Yes [Collection:SalesCollectionSource] Source Collection :Sales Orders Walk :InventoryEntries,BatchAllocations Fetch:ItmNoOfBagss6
I have given you the PART name --- from there you can find the Collection Name --- You need to enhance your search skills also
i searched as you guided me sir but only field lines and variables i found sir. please request you to give sample code for understanding further sir please. thanks in advance.
In the Part Name I have given there are many options --- which re-directs the code as per your selection (SO POS, SO Cleared, SO Negative etc ) ..... When you go to that options you will find that the LINE is repeated with its own appropriate collection -- that is the Collection name.
Dear Sir, From morning to till now i tried using the basic knowledge what i have towards TDL programming learned from this forum. As you all know i just know basic things and i am unable to get this,, request you to please help sir so that it will help me with what collection is and also i can use this suggestions in my future reports, please, Thanks in advance
[#Collection: SalePosOrderOfCompany] Fetch : PurcNoOfBags1 Compute : NoOfBags : $AllInventoryEntries[].BatchAllocations[].PurcNoOfBags1
Thanks a lot for your kind heart sir. The value is fetching but for every item its fetching same value sir [Field:Sales_Brands] Width : 8% page Setas :$NoOfBags;$AllInventoryEntries[].BatchAllocations[].NoofBags Style : Small Bold Align : Center Skip : Yes Fixed : Yes ;Full Width:Yes [#Collection: SalePosOrderOfCompany] Fetch : ItmNoOfBagss6 Compute : NoOfBags : $AllInventoryEntries[].BatchAllocations[].ItmNoOfBagss6 Please suggest sir
Inventory allocations is collection, can have multiple values directly accessing without index will return only first object so you are getting same value. you can first filter inventory allocations based on StockItemName then you can drill down to batch allocations. [#Collection: SalePosOrderOfCompany] Compute : NoOfBags :$$FilterValue:$BATCHALLOCATIONS.ItmNoOfBagss6:InventoryEntries:First:TC_InvFilter [System : Formule] TC_InvFilter : $STOCKITEMNAME = $PARENT Ref - FilterValueFunction
Thanks for the suggestion sir. Thanks both of you... and i have done few changes and report in fetching fine. Thanks a lot of kind heart and help.
ITEM WISE JOB CARD DATE AND SALES MAN NAME AND ALSO filtration option for sales man and JOB CARD SIR yet to completed working on it sir, once completed i will share here. Thank you
