The associated Extender record is not deleted when you delete a Microsoft Great Plains record

SYMPTOMS

You add Microsoft Business Solutions - Great Plains Extender fields to a Microsoft Great Plains window. When you delete the Microsoft Great Plains record, the associated Extender record for the window is not deleted.

RESOLUTION

You must delete the associated Extender record from the Extender table.

MORE INFORMATION

Steps to reproduce the issue

1.

Create an Extender window that is associated with the Item Maintenance window.

2.

Create an item, and then add Extender information to the item.

3.

In the Item Maintenance window, select the item, and then delete the item.

4.

Create a new item that has the same item number.

The Extender information that was attached to the deleted item still appears for the new item.

Extender information is linked to the window and not to the tables. Therefore, because there are no triggers on the tables, the Extender table is not affected when the data is deleted from the Microsoft Great Plains table.

The following list describes where each Window field type is stored:

• EXT00101: Short string, telephone number, e-mail address, long string, and the number in a list.

For example, a record that could be contained in this table is a list that contains the color names Red, Yellow, and Blue. Suppose that you have Blue selected. The table will show 3 because Blue is third in the list.
• EXT00102: Date
• EXT00103: Currency, percentage, and quantity
• EXT00104: Time

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×