Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Extender update with SQL

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We are passing create PO via web-services and want to insert extender values connected to PO Line Item scroll window.   There are 3 values we are passing to Extender. 

We are at a road block working with inserts to EXT001100 and EXT001101 and have a hard deadline.  Do anyone  have information you could share with us on how you inserted extender values with SQL?

I believe we are missing a PK that ties the Extender Window to the POP10110.  

Thank you,

Donnette

*This post is locked for comments

  • Suggested answer
    Vaidy Mohan Profile Picture
    Vaidy Mohan 351 on at
    RE: Extender update with SQL

    Sorry, the field name for PO Line Seq. is "ORD" as Tim mentioned. You would need to store ORD (if it's part of the key fields) onto any of the "Extender_Key_Values_" fields.

  • Suggested answer
    Vaidy Mohan Profile Picture
    Vaidy Mohan 351 on at
    RE: Extender update with SQL

    @Donnette: PO line sequence would be stored in EXT01100 as part of the key fields, if you have added PO Line Seq as one. All we need to have is a correct link between EXT01100 and EXT01101 tables. That's nothing but the Extender_Record_ID.

    So here it is: POP10110 (PO Line Work) table links with EXT01100 (Extender Record Header) table with key fields and an auto-generated Extender_Record_ID.

    EXT01100 table then links with EXT01101 (Extender Record String) table with Extender_Record_ID as the key. Extender_Field_ID in EXT01101 table determines the string field and value for that particular window record; storing the right value on the right field that you see in additional window.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Extender update with SQL

    Can you properly, reliably add and retrieve the values to the Extender Window via the "front end" (GP Client)?

    POP10110  has 3 key fields (PONUMBER, ORD, BRKFLD1) . Are you referencing them as keys in the definition of your Extender Window?

    Tim

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Extender update with SQL

    Hi V,

    Thank you so much  for this information.

    How is the Purchase Order line number sequence Joined to the Extender Record ID?

    Thank you,

    Donnette

  • Suggested answer
    Vaidy Mohan Profile Picture
    Vaidy Mohan 351 on at
    RE: Extender update with SQL

    A bit tricky. You will first need to create an Extender Record Header for each PO additional information record. Each record in EXT01100 would require a unique "Record ID" that you must generate at runtime based on total number of records that are already there in this table.

    I assume that all three values you want to pass are "string" values. In that case, you need only more table EXT01101. For each string value that you need to insert into EXT01101, you need the exact "Field ID". Otherwise, the whole record would become either incorrect or corrupt.

    This is probably the simplest way I could think and explain. :-)

  • Suggested answer
    Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,865 on at
    RE: Extender update with SQL

    I'm not sure if I have done any SQL update on Extender table as it's been a while. but if you have doubts in linking tables on a Particular extender window, You can create a Extender View for the same window and  then Click "Display SQL" button to see how tables are linked.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans