Updatable dashboard for Country of Origin on Part Master

Epicor ERP 10
1

We need to create an updatable dashboard that allows users to update the Country of Origin saved on the Part Master, from the dashboard. The problem is that the value saved under “ISOrigCountry” in the Part table is the CountryNum, not the Country description.

Is there a way for the user to enter the country “description” on the updatable dashboard, but it saves the CountryNum on the Part’s table? See below:

image
image805×251 6.39 KB

2

In the updateable BAQ, go to the Update tab, General Properties and click the Advanced Column Editor Configuration. Then you can attach things to the field.

image
image2040×1054 163 KB

This example uses a BAQ, just like you would a baqCombo on a screen.

3

I am actually trying to create an updatable dashboard to update the country of origin. After a few tests nothing works. Does it require a load via DMT or am I supposed to be able to update the country of origin via an updatable BAQ?

image
image874×301 15.4 KB

Also, I can’t update the field under the Country of Origin tab because the field is grayed out:

image
image882×387 15.5 KB

image

How can I make this work?

4

I don’t think you can without some custom code there. I would just use DMT - it has ISOrigCountryNum which is numeric and accepts the country number.

1 Like
5

The table you want to update is PartCOO the field is OrigCountry just as your field help shows. This is why the one on the Part table is read-only.

This is also how you DMT the COO.

6

You can’t change that field but you can add another Country and use that instead.

If you want to update the country of origin click on New
Then Add Country of Origin

image
image735×373 21.1 KB

Then set the new country to Primary

You can also delete COO’s here.