web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Clearing data from an ...
Microsoft Dynamics GP (Archived)

Clearing data from an Extender Detail Form

(0) ShareShare
ReportReport
Posted on by Community Member

I imported 80000+ records into an Extender Detail Form last night and found that something had gone wrong in the import this morning, fouling some of the records. Obviously, I am going to have to wipe the data and start over. It may take several iterations before I get it all right.

How do I clear the data? Do I need to go to the SQL server? There doesn't seem to be any mechanism within GP to do this.

*This post is locked for comments

I have the same question (0)
  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at

    I havent seen a utility from extender to perform what you wanted. theres another option inside GP file maintenance>sql, select the database and product. but you will not be able to select which record to clear. if you are familiar with the tables my suggestion is use sql query. always do a back up.

  • Community Member Profile Picture
    Community Member on at

    I don't want to delete one record. If you would have read my whole post, you would have seen that I want to clear the whole table.

  • Community Member Profile Picture
    Community Member on at

    I believe, you may have to take SQL approach to do it simpler and faster.

    All extender detail form records are stored in tables EXT00700 (Form Master), EXT00701 (String Values), EXT00702 (Date Values), EXT00703 (Numeric Values), EXT00704 (Time Values).

    You have to run following query(ies) against the relevant company DB, if this is the first time that you had imported records for this Extender form:

    DELETE EXT00700 WHERE PT_Window_ID = '[your extender detail form ID]'

    DELETE EXT00701 WHERE PT_Window_ID = '[your extender detail form ID]'

    and so on... depending on what kind of fields that you have used on this extender detail form

    As always, take a backup first before you carry out this task.

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    Frank there are a lot of tables you are going to need to check. Did you by chance make a backup before you did the import? That would be my recommendation if you did. Otherwise here is a list of tables you may need to check:

    EXT00700 Extender Detail Form IDs

    EXT00701 Detail Form Field Strings

    EXT00702 Detail Form Field Dates

    EXT00703 Detail Form Field Numbers

    EXT00704 Detail Form Field Times

    EXT00711 Detail Form Extra Window Strings

    EXT00712 Detail Form Extra Window Dates

    EXT00713 Detail Form Extra Window Numbers

    EXT00714 Detail Form Extra Notes

    EXT00715 Detail Form Extra Window Times

    EXT40160 Extender Detail Form Templates

    EXT43100 Extender Detail Forms

    EXT43101 Extender Detail Form Extra Windows

    EXT43102 Extender Detail Form Lists

    EXT43103 Extender Detail Form Details

    EXT43105 Extender Detail Form Next Fields

    EXT43106 Extender Detail Form Field Link Settings

    EXT43107 Extender Detail Form String Formats

    EXT43109 Extender Detail Form Template Setup

    EXT43110 Extender Detail Form Templates

    EXT43111 Extender Detail Form Template Fields

    EXT43112 Extender Detail Form Template Lines

    EXT43113 Extender Detail Form Template Line Fields

    Good luck!

  • Community Member Profile Picture
    Community Member on at

    Jonathan - thanks for the table list, but what is it that I am checking?

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    That is the tricky part Frank as you will need to know what you are looking for. This really isn't a forum question as the forums are meant for quick questions that don't require a lot of research or testing. I did think of another option you could do which is if you don't have a backup you could reinstall the Extender module which will delete all Extender data. You would then need to recreate any Extender objects that you need but at this point this is the only other option beside opening up a Professional Services case for data fixing.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Jonathan - yes I know the forum is intended to provide a way for users to get quick answers for simple questions (because I have a very good $300+/hr consultant I can call on for more complexe issues). But never mind we solved the issue by deleting the form and starting over. All of the offending data were automatically wiped without having to mess with SQL server. It took maybe fifteen minutes to recreate the form.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans