Finance | Project Operations, Human Resources, ...

Warning BP Rule: [BPErrorTableFieldNotDefinedUsingType] Field must be defined using a type

(0) Share

Report

Posted on by junior AX

1,552

I created a field with type int. And i'm getting this warning. So it says i must put an extended data type.

but i don't what type of EDT should i assign it to?

So i'm thinking to use integer.

My question is , integer EDT has display length =6

1. does that mean my field fit numbers with 6 digits? like it can reach 999999?

2. how much does int64 fit?

3. I also have a dateTime field. What kind of EDT is suitable to use for it?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You should always use EDTs. Quite often you need to create a new EDT.

For max values, please check the docmentation: docs.microsoft.com/.../xpp-data-primitive

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Nikolaos,

is creating a new EDT with extended data type integer better than just adding a field with EDT integer.

I know that one of the reasons that EDT is better. is that if you use this EDT more than once. there is no need to put the label on the field multiple times. Also there in no need to keep creating new fields then assign EDT. just drag and drop.

Other than that there is no harm of just putting integer as and EDT right?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I strongly recommend to use EDTs. You will make your life much easier, as well as the life of any future developer who needs to work with this table.

EDTs offer a centralized and reusable way of defining data types, including labels, config keys, some validation rules etc.

But, technically you don't need to use it, it's just a best practice. Do you want to develop solutions that follow the best practices or not? How about your customer? Do they want to have a solution that follows the best practices. Basically it boils down to that.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi junior AX,

It depends on what you are you are using this field for. If you can find an EDT that serves the purpose, you should use it. There are many EDTs derived from Integer like "NumOfDays", Counter etc. that you can check.

Same goes for DateTime as well. There are existing EDTs like FromDateTime that can be used. But none of the existing EDTs meet your requirement, you can create a new one.

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Nikolaos and Gunjan,

if i create a new EDT then i can make it extend integer right? (this would be considered a best practice)

but if i'm going to create a new EDT for dateTime what should it extend? I took a look at FromDateTime and it seems it doesn't extend anything? is that considered as a best practice?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

For integer based EDTs, you create a new EDT integer.

For date time based EDTs, you create a new EDT Utc date time.

Actually you can see all the available types when you create new objects in your VS project.

Right click the project -> Add -> New item...

Then select Dynamics 365 Items -> Data Types.

Try it out!

The "Extends" property is filled only if your EDT extends another EDT, instead of the primitive base type. This way the EDT inherits all properties from the parent, but you can change any of them by defining label, help text etc.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Warning BP Rule: [BPErrorTableFieldNotDefinedUsingType] Field must be defined using a type

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Warning BP Rule: [BPErrorTableFieldNotDefinedUsingType] Field must be defined using a type

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates