Form Customization Problem

Epicor ERP 10
1

I customized the Sales Order Entry form, and now the tabs (#1 in pict below)) don’t respond unless I first select the Order Number in the tree (#2 in pict)

When the form first loads (i.e. no Order selected, I cannot select the other tabs. I can do this with the base form.

And when I open the form in developer mode, I can’t select the Header, Lines, or One Time Ship To tabs, to customize their content.

I tracked it down to a function being called in SalesOrderForm_Load()

The function is to auto-populate a dropdown with data from UD05. Here’s the code

Private Sub setPMCombo()
        Dim recSelected as Boolean
        Dim whereClause as String = "Checkbox01 = False"
        
        'MessageBox.Show(whereClause)
        'Dim dsSetPMCombo as Dataset = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"UD05Adapter", recSelected, False, whereClause)
		Dim dsSetPMCombo as Dataset = Ice.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"UD05Adapter", recSelected, False, whereClause)
        if (recSelected) Then
            epiUltraComboC1.ValueMember = "ShortChar01"
            epiUltraComboC1.DataSource = dsSetPMCombo
            epiUltraComboC1.DisplayMember = "ShortChar01"
            Dim fields as String() = New String() {"ShortChar01"}
            epiUltraComboC1.SetColumnFilter(fields)
            epiUltraComboC1.LimitToList = true
        end if
    end sub

The control epiUltraComboC1 is bound to OrderHed.ProjManager_c

UD05.Checkbox01 is a flag to filter records selected from the table.

  1. Is that not the way to populate a dropdown?
  2. Should this be called in Form _Load, or some other event?
2

@ckrusen

We use User Codes to create lists for epiCombo drop downs like this:

image.png1306×775 78 KB

3

I tried using an epiRetrieverComb control ( selecting my UD table). But the dropdown list does not autopopulate from the UD table entries.

It shows a large blank list with scrollbars.

image.png1444×283 13.4 KB

I scrolled around the dropdown, but there’s no text in it.

Shouldn’t the retriverCombo control have a property to select which fields in the UD table are displayed?

4

Whoops …

I only selected “UD05” from the retrieve selection. I forgot to expand it, and select “UD05 Combo”

5

Well that wasn’t it. I get the same results (the retrieverCombo dropdown is still blank).

6

Randy - We need to use the UD table as it has more info than just the one field selected on Order Entry.

7

Hmm, have you tried a BAQ combo?

8

I actually got it working by using a regular epiCombo (not an epUltraCombo), and set the EpiBOName to Ice:BO:UD05.

Also had to set the DisplayMember, EpiColums, EpiSort, and ValueMember fields to ShortChar01 (thats the UD filed that shows on the form and needs to bestored in the OrderHed.PM_c UD field.

Getting rid of that custom code (that ran at Form_Load) fixed the issue with the tab not being selectable.

Still not happy that the epiRetrieverCombo control didn’t work as expected.

1 Like
9

Glad you got it working! I’ve never been able to get the retrievercombo to do what I’ve wanted either. We use the EpiCombos or BAQCombos mostly.