Need help for filtering data in table

Dear all,
I'm looking for help.
In tally we can create pricing level more than one but in party ledger master, we can select only one pricing level.
Now I have customised ledger master and create field where I can select pricing level more than one.
In sale voucher all pricing level showing.
Now my requirement is.
For example: if have select 2 pricing level in Mr. X ledger master then at the time of sales entry only these two pricing level show.
How i use filter in collection to obtain the requirement.
Pls help me .
Thanks

 

THANKS SIR BUT IT DIDN'T WORK
I Tell you what I did...

first I have created an another field just below the " Pricing Level Applicable Field". now we have two field for selecting the price level.
code:
[#Part: MST LED Explode Sundry]

ADD: Line : after: LED Price Level: Price Level 1

[LinericeLevel 1]
Field : Long Prompt , LED PriceLevel 1
Local : Field : Long Prompt : Setas: $$LocaleString:"Pricing level applicable:"
Local : Field : Long Prompt : Inactive: NOT @@DebtorOrCreditor AND @@IsNonCashBankGroups
Invisible : (NOT $UsePriceLevels:Company:##SVCurrentCompany OR ($$NumPriceLevels = 0)) OR NOT ##UsePricingLevels

[Field: LED Price Level 1]
Use : Short Name Field
Storage : Price Level 1
Table : Price Levels 10, NotApplicable
ShowTable : Always
Inactive : NOT @@DebtorOrCreditor AND @@IsNonCashBankGroups

collection : This is default tally collection ,i just change the name of collection.

[Collection: Price Levels 10]
Title : $$LocaleString:"List of Price Levels "
Type : Price Level : Company
Childof : ##SVCurrentCompany
Format : $PriceLevel,15
Option : Refresh Price Levels Coll : ##PriceLevelsIsRefresh


now in sale voucher we are using same collection but name is different.

[#Field: EI PriceLevel]

Delete: Table
Add: Table: Price Levels 11,Not Applicable

[Collection: Price Levels 11]
Title : $$LocaleString:"List of Price Levels Sales "
Type : Price Level : Company
Childof : ##SVCurrentCompany
Format : $PriceLevel,15

Option : Refresh Price Levels Coll : ##PriceLevelsIsRefresh
here i want only those pricing level that i have been selected in ledger master.
pls suggest me how i solve this problem .

thanks & Regards.
rishi

 

Sir,

Ok sir but my another query is
I have 4 parties and 4 price level
To Mr a price level 1
To Mr b price level2
To Mr c price level3 and so on allotted
At the time of sale entry at the price level field all 4 price level showing . I want when Mr A to sell only price level 1 show and so on.
The collection used at price level field is as below
[Collection: pricelevel]
Title: list of price level
Typericelevel:company
Child of: ##svcurrent company
Formats: $price level,15

Sir how I filter price list to obtain require price list.
Pls help

 

Firstly, you have done nothing to associate Price Level selected in Led Master with Price Level Field in Voucher Entry



[Collection: Price Levels 11]
Title : $$LocaleString:"List of Price Levels Sales "
Compute : PriceLevel : $PriceLevel1:Ledger:#EIConsignee
Format : $PriceLevel,15


Or your can filter use Filter


[Collection: Price Levels 11]
Title : $$LocaleString:"List of Price Levels Sales "
Type : Price Level : Company
Childof : ##SVCurrentCompany
Format : $PriceLevel,15
Filter : FltPriceLevelTmp

[System : Formula]
FltPriceLevelTmp : $PriceLevel = $PriceLevel1:Ledger:#EIConsignee