Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Increasing length of C...
Finance | Project Operations, Human Resources, ...
Answered

Increasing length of Customer requisition EDT (CustPurchaseOrder)

(0) ShareShare
ReportReport
Posted on by Nastaran 288
We need to ensure that we can accommodate 60 characters in most customer requisition fields, across various forms such as shipment, sales orders, BOL, etc., in D365FO. Given the widespread use of this field, do you think it's worthwhile to increase the character limit from 20 to 60? The alternative option would be to create a custom field, which would require a significant amount of work and customization. Could you please outline the potential risks, particularly related to increasing the character limit of the CustPurchaseOrder EDT?
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Increasing length of Customer requisition EDT (CustPurchaseOrder)
    Hi,

    Here are some considerations to take into account:

    1. Database storage: Increasing the field length will consume more database storage space. This could result in increased database size, impacting performance and backup/restore processes.
    2. Data consistency: The field is used in existing systems and custom reports. If the field length changes, corresponding modifications and adjustments may be required in these systems and reports to ensure data consistency.
    3. Integration and migration: Increasing the field length can introduce complexity in integration with other systems or during data migration processes.
    4. User interface: Increasing the field length may pose challenges in displaying and inputting the field in the user interface. The interface needs to accommodate the new field length.
    Best regards,
    Kevin
  • Verified answer
    Layan Jwei Profile Picture
    Layan Jwei 7,347 Super User 2024 Season 2 on at
    Increasing length of Customer requisition EDT (CustPurchaseOrder)
    Hi Nastaran,
     
    A similar question was discussed here:
     
    Changing the EDT string size, means it will affect all places that uses it. So if that's your intention and you need to increase it then go ahead.
     
    If you would like to only increase it in few tables, then I think there is no need to create a custom field. Create a new EDT that extends the base EDT and change the EDT on the fields of those tables.
     
     
    Thanks,
    Layan Jweihan
    Please mark the answer as "Verified" if it solved your question. In order to help others as well

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans