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.

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.

Click to enlarge

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

Click to enlarge

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

Becky Lipnick

Recent Posts

Infor CSI Syteline – Paste Rows Append for Data Load

Entering Records individually into CSI will ensure that the required data is filled out for…

2 months ago

Infor VISUAL ERP: How to Future-Proof Your Manufacturing Operations

For decades, Infor VISUAL ERP has been the backbone of countless manufacturers. Its strength lies…

3 months ago

Infor CloudSuite Industrial: Features & Options

Infor CSI (Syteline) - Features & Options With the creation of Infor Configure Price Quote…

7 months ago

Infor CSI: Excel Report Output Format for Reports Without a Dataview

Infor CloudSuite Industrial (CSI) provides powerful reporting capabilities, often leveraging Dataviews for easy extraction of…

8 months ago

How Datix can help Support your Infor VISUAL ERP Platform

In today’s fast-paced manufacturing environment, efficiency, accuracy, and scalability are critical for business success. Infor…

10 months ago

Hand-Picked Digital Marketing Platforms for Manufacturers

Platform: HubSpot Where It Shines: Email marketing - easy to use email lists, automation, and…

2 years ago