Please Help me Experts in the Collection to get Length Column. I am Getting only First Value in SQL Query. Thank You. Code: [#Collection: Pending Purc Orders] Compute: StorageforLengthh : $$CollectionField:$StorageforLength:1:InventoryEntries ;Search Key : $Name Fetch : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, + OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, BasicPackageMarks, StorageforLength, StorageforLengthh ParmVar : pvAccountName : String : $$AccountName Parmvar : pvPartyLedgerName : String : If $$IsEmpty:($$BaseOwner:$PartyLedgerName) then $LedgerEntries[1].LedgerName Else ($$BaseOwner:$PartyLedgerName) ParmVar : pvFirstPartyLedgerName : String : IF @@IsRejIn OR @@IsRejOut Then $$BaseOwner:$PartyLedgerName Else $.LedgerEntries[1].LedgerName Parmvar : PartyLedVchmode : String : $..LedgerName ;; For Specific Voucher Types,source object is from primary owner (Report Voucher) Option : InPendingOrderwithFltItem : @@TrackEnabledVchType ;; For Other than specific Voucher Types, source object is from stock item allocation report. Option : InPendingOrderwithoutFltItem : Not @@TrackEnabledVchType Option : GatherTrackInStr : NOT @@IsOutwardType AND NOT @@IsInwardType [#Collection: VCHPo] Parm Var : pvStockItemName : String : $StockItemName Title : $$LocaleString:"List of Orders" Sub Title : $$LocaleString:"Name", $$LocaleString:"Due On", $$LocaleString:"Balance" Source Collection : Pending Purc Orders Fetch : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, + OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, BasicPackageMarks, StorageforLength, StorageforLengthh Filter : ForNotAppl,TrackOfItem Format : $Name, 8 Format : $BasicPackageMarks, 8 Format : $StorageforLength, 8 Format : $StorageforLengthh, 8 Format : $OrderDueDate, 6 : Universal Date Format : $FinalBalance, 8 : Base Client Only : Yes Keep Source : ().
Not showing Sir, Please Guide. [*Collection: Pending Purc Orders] Fetch : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, + OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, StorageforLength, StorageforLengthh Compute:StorageforLengthh: $$CollectionFieldByKey:$StorageforLength:$Name:InventoryEntries Search Key:$Name ParmVar : pvAccountName : String : $$AccountName Parmvar : pvPartyLedgerName : String : If $$IsEmpty$$BaseOwner:$PartyLedgerName) then $LedgerEntries[1].LedgerName Else ($$BaseOwner:$PartyLedgerName) ParmVar : pvFirstPartyLedgerName : String : IF @@IsRejIn OR @@IsRejOut Then $$BaseOwner:$PartyLedgerName Else $.LedgerEntries[1].LedgerName Parmvar : PartyLedVchmode : String : $..LedgerName ;; For Specific Voucher Types,source object is from primary owner (Report Voucher) Option : InPendingOrderwithFltItem : @@TrackEnabledVchType ;; For Other than specific Voucher Types, source object is from stock item allocation report. Option : InPendingOrderwithoutFltItem : Not @@TrackEnabledVchType Option : GatherTrackInStr : NOT @@IsOutwardType AND NOT @@IsInwardType
Do it Like this [Collection: InventorySearchKeyColl] Source Collection :. Walk: Inventory Entries Compute:UDF:$UDF Search Key: $VoucherNumber [Collection: Purchase Order Coll] ... Compute: Length value: $$CollectionFieldByKey:$UDF:$VoucherNumber:InventorySearchKeyColl
Concept: Inventory Entries Doesn't have a search Key By Default That is why...It wasn't working So, I created a collection where I fetched Data Of Inventory Entries and added a search Key
use this [Collection: InventorySearchKeyColl] Source Collection :. Walk: Inventory Entries Compute:UDF:$UDF Search Key: $VoucherNumber
Nahi hora hai Sir, Now its showing Like this [Collection:CollForLength] Type : Ledger Purchase Orders Fetch : VoucherNumber, Name, StorageforLength, StorageforLengthh [Collection:mycollforlength] Source Collection : CollForLength Walk : Inventory Entries ;Compute:StorageforLength:$StorageforLength ;Compute:StorageforLengthh: $$CollectionFieldByKey:$StorageforLength:$Name:mycollforlength ;Search Key: $Name Fetch : VoucherNumber, Name, StorageforLength, StorageforLengthh
1. Source Collection Should be Current Collection Example: Source Collection:. 2. If you are saving a value at Sub Object Level then You can't find it directly from main object collection. You have to walk to the sub object after that Compute the Values Tip: Computed name and Method name should be unequal. Believe me... I have wasted hours by checking Every line of codes and After Doing Everything I solved it by doing this many times. Example:- Compute:UDFVal:$UDF
S Sir i used like this but it shows nothing. [Collection: InventorySearchKeyColl] Source Collection :. Walk: Inventory Entries Compute:storageforlengthh:$storageforlength Search Key: $Name
Sir, I tried it But still not working, Now its Showing Last Line Value when using Collectionfieldbykey. Code: [Collection: InventorySearchKeyColl] Source Collection :. Walk: Inventory Entries Compute:StorageforLengthh:$StorageforLength Search Key: $Name [*Collection: Pending Purc Orders] Fetch : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, + OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, StorageforLength, StorageforLengthh, VoucherNumber Compute: StorageforLengthhh:$$CollectionFieldByKey:$StorageforLengthh:$Name:InventorySearchKeyColl ParmVar : pvAccountName : String : $$AccountName Parmvar : pvPartyLedgerName : String : If $$IsEmpty:($$BaseOwner:$PartyLedgerName) then $LedgerEntries[1].LedgerName Else ($$BaseOwner:$PartyLedgerName) ParmVar : pvFirstPartyLedgerName : String : IF @@IsRejIn OR @@IsRejOut Then $$BaseOwner:$PartyLedgerName Else $.LedgerEntries[1].LedgerName Parmvar : PartyLedVchmode : String : $..LedgerName ;; For Specific Voucher Types,source object is from primary owner (Report Voucher) Option : InPendingOrderwithFltItem : @@TrackEnabledVchType ;; For Other than specific Voucher Types, source object is from stock item allocation report. Option : InPendingOrderwithoutFltItem : Not @@TrackEnabledVchType Option : GatherTrackInStr : NOT @@IsOutwardType AND NOT @@IsInwardType ; Select $amount, $name,$StorageforLengthhh from PendingPurcOrders [*Collection: VCHPo] Parm Var : pvStockItemName : String : $StockItemName Title : $$LocaleString:"List of Orders" Sub Title : $$LocaleString:"Name", $$LocaleString:"Due On", $$LocaleString:"Balance" Source Collection : Pending Purc Orders Fetch : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, + OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, StorageforLengthhh Filter : ForNotAppl,TrackOfItem Format : $Name, 8 Format : $StorageforLengthhh, 8 Format : $OrderDueDate, 6 : Universal Date Format : $FinalBalance, 8 : Base Client Only : Yes Keep Source : ().
Search key Kaise karu Compute? [Collection: InventorySearchKeyColl] Source Collection :. Walk: Inventory Entries Walk: Batch Allocations Walk: Accounting Allocations Compute:SearchKey:$Name Compute:BasicUserDescriptionn:$BasicUserDescription Compute:StorageforLengthh:$StorageforLength Search Key: $SearchKey
[Collection : PurOrd_VchSrc] Type : Vouchers : Voucher type Child of : $$VchTypePurcOrder Belongs To : Yes Fetch : IsOptional Filter : NOTIsOptionalVoucher [Collection : PurOrd_VchSummaryColl] Source Collection : PurOrd_VchSrc Walk : ALLInventoryEntries, BatchAllocations By : Order ID : $OrderID By : StockItemName : $StockItemName Compute : MYLength : $StorageforLength Compute : MYPackageforMarks : $BasicPackageMarks Search Key : $OrderID