<img src="https://secure.perk0mean.com/176329.png" alt="" style="display:none;">

How to Look up Values Behind a Static List

By Matt Schuval


How to Look up Values Behind a Static List - Epicor 9

For this Epicor tech tip, I wanted to show you how to look up the values behind a static list  I found this useful when working in  Epicor 9.05 and you need to pass a code value from one system to another and the field on the form only displays the description value.

These are the steps you will take when the static lists are used instead of the User Code reference. First, on the tool bar select Developer mode. Second, select the form containing the field you wish to see the static values. A pop up will have you select which customization to open. Then select the deployed form from the menu maintenance.

customization tools dialog box

Click to enlarge

In the Tools menu, click Customizations. This will allow you to select the filed on the form that you want to see in the static list values.

select developer mode

Click to enlarge

Now, select EpiStaticDatalist String{}Array to get the code values for the drop down field.

tools dialog box

Click to enlarge

How have you used the look up values in Epicor? Definitely let me know by sharing your experience in the comments.

Tags: Power Tips: Epicor® ERP, Technology Tips & Tricks


From start to finish, the expert consultants at Datix understand your business needs and execute software solutions that work.