Extended Properties Field Format

Epicor ERP 10
,
1

Hi,

Wonder if we are able to change the field format in Epicor.

There is a request to increase the Revision Number in the Job Entry from 12 Chars to 13 Chars.

I tried in Job Entry developer mode and select the Tools → Customization.
Highlight on the “Rev” field and confirm the format is 12.

Next I launch the customization wizard → Modify Extended Properties and changed the RevisionNum to x(13).

I save and restart Epicor and confirmed it’s changed to x(13)

image
image781×575 36 KB

However, When I try to key in new job entry on Rev, it prompted me max is 12
image

Wonder if I miss out any steps.

Also in the extended property maintenance, the default is still showing x(12) and I am not able to change to x(13).
It will prompt “Format cannot be wider than schema width of 12.”

image
image909×705 41.9 KB

2

Hi Heng,

You cant change the length of a system field - you will need to create a new UD field to store this data
Hope this helps

Thanks

Mark

3

Thanks Mark.

In that case, may just leave it at x(12) for now as new UD fields will need to apply to all past reports or BAQ and may missed update them.

Just wonder if there is a quick way to find out a particular field being use by custom report or BAQ.such that if a new UD is used to replace a particular system field, there is a way to identify and made changes to all affect custom report/baq.

4

Hi Heng,
It should be pretty easy to sort old data out - just create a BAQ - export to excel, add the new UD field in and copy the column from RevisionNum to RevisionNum_c and DMT the data back in.

Mark

5

Hi Mark,

Thanks for the guidance on how to copy the date from existing field to the new UD field.

I believe not only that I will need to take care of migrating the old data to the new UD field.

All the existing reports/ BAQ tables query/criteria that reference to RevisionNum will need to manually change to RevisionNum_c

That’s the main concern as I have yet to have the visibility on which report or BAQ Query ID is using RevisionNum.

6

Hi Heng,

No problem - I guess only you know where you are using RevisionNum in your Company, and where it needs to be visible. It shouldn’t be a large tasks to do this though.

Mark