Plz correct my cost center code

Dear Experts,

I created two extra fields one for cost category and other is for cost center but after selection of cost category when i select cost center it shows complete list of cost centers but i need when i select cost category it shows only particular cost centers related to cost category. please help me to resolve this issue.


My code is

[Field : MCCT]
Use : Name Field
Table : Voucher Cost Category VchExtract
width : 18

Storage : udfMCCT
Skip : If $$IsSysnameEqual:EndofList:$StockItemName then Yes Else No

[Field : MCC]
Use : Name Field
Table : Cost Centre Table
Show Table : Always



Skip : If $$IsSysnameEqual:EndofList:$StockItemName then Yes Else No
width : 18

Storage : udfMCC


[System : UDF]
udfMCCT : String : 21709
udfMCC : String : 21710


[Collection: Cost Centre Table]
Type: Cost Centre
Source Collection: List Of CostCentres
Child Of: $$udfMCCT

 

Made a minor Change

[Field : MCC]
Use : Name Field
Table : Cost Centre VchExtract
Show Table : Always​

 

Thanks alot Vijay Shetye but it does not work. please review and guide me how to get the required results.

 

can you give me the systems access and show me what you are trying to achieve
you can contact me on 9820309919