User Codes in Selection Lists

Kinetic ERP
10

I made these notes for using UD codes in a combo:

-UserCode Combo (NOTE: This method returns the CodeID field not CodeDesc):
Kinetic Combo Box Binding UDCodes Blank - #3 by josecgomez
Kinetic Combo Box Binding UDCodes Blank - #6 by josecgomez
and Kinetic Combo Box Binding UDCodes Blank - #15 by Dhanalakshmi

  Data > EpBinding = View.Column 
  Reusable Combo > Type = UserCodes.UserCodesCombo
  Reusable Combo > Sub Type = default
  Reusable Combo > Filters Params	= "CodeTypeParam=CodeTypeID" (no quotes)
  
  -To filter out inactive records: 
  	Reusable Combo > Hidden Columns Append: IsActive
  	Advanced >  Row Filter: "IsActive = true" (no quotes) 

  -To Return CodeDesc instead: 
  	Reusable Combo > 
  		Type: leave blank 
  		Sub Type: leave blank 
  		ComboID: leave blank 
  		Service: Ice.BO.UserCodessvc
  		Service Method: GetRows
  		Table Name: UDCodes
  		Sort: CodeID 
  		Retrieve Columns: CodeDesc		
  		
  	Advanced >
  		Drop Down Style: DropDown 
  		TextField: CodeDesc
  		Value Field: CodeDesc
  		Search Filter: CodeTypeID = 'CodeTypeID'
7 Likes