Share
ReportDear All,
How to change the size of field in ax 2012?
Regards,
Work
Categories:
You’re offline. This is a read only version of the page.
Dear All,
How to change the size of field in ax 2012?
Regards,
Work
Hi Workkb,
You can clean your usage data and after that restart your AOS. It might work.
Regards,
Keshav
Hi Work...
I believe changing create your own EDT and assign it to Customer Reference field in SalesTable is better idea. I've run it on my environment and it works.
I suspect you have some issues with data synchronization - as you mentioned ALTER TABLE doesn't work. Could you confirm that after changing EDT for the field and running data synchronization the field in database has still "old size"?
Best
Sebastian
Hi,
I will explain in detail.
I have one field named "Customer Reference" in SalesTable and its EDT is custRef(custRef has 60 stringsize).
So i checked custRef EDT. This extends personName and has stringsize of 60,again i checked PersonName EDT and this extends Name EDT. Finally i reached to Name with string size of 60. I tried to change stringsize of Name EDT,because that is the base. But after changing this, nothing was working properly. So i thought to create new EDT and attach it to Customer Reference field, that also not working. after changing that when i open 'All sales orders' from Sales and Marketing module,the above error is getting. So i reset it to previous one and now it is opening properly.
I tried to change it in the database also using alter table option, that also throwing error. some privilege issues.
I have done synchronization compilation everything.
I just would like to know, if any other solutions for this.
Regards,
Work
Can you please say which EDT you changed?
Did you recompile the application after the change?
When exactly the error is thrown? Are you trying to open up the specific form?
Hi Sebastian,
Yes I have done synchronize also.. But no luck.
Any other option?
Regards,
Work
Did you synchronize database after changing size of EDT? If not... please do it - I believe it will help.
Best
Sebastian
Dear All,
Sorry for the delay in reply.
Please Find Attached Below.
Regards,
Work
can you share screen shoot from error
Hi Hakim,
The string size is associated with Extended Data Types and I tried to change it in the EDT. But it is throwing some error.
Is there any other solution?
Regards,
Work
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,263
Super User 2024 Season 2
#2
Martin Dráb
228,112
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (