Skip to main content

Notifications

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) / How can an Extender Wi...
Microsoft Dynamics GP (Archived)

How can an Extender Window be placed onto SOP?

(0) ShareShare
ReportReport
Posted on by Dale Coulthard 3,055

We have Extender, but have only used it for one situation/need in our organization and we hired a consultant to implement that. I am now trying to learn Extender since we have a new need.  We need a window placed on each Address ID at the customer level.  So, I have created the window using the Customer Address Maintenance for form and windown and created just one field (as a long string) and used the Key Fields of Address Code and Customer Number.  I have gone to the customer address maintenance window and have populated the new window with information for a few addresses on a given customer.

I now want to pull this new field onto a SOP document if this field is populated related to the ship to address id side of the SOP document.  This is where I am lost.  I have read the KB articles 898983 and 935385 which helped me.  I did create in report writer a new calculated field for this extender window, but the information is not being reflected on the SOP document.  I know that I have not told report writer to pull in the information when there is information related to the SOP's ship to address id.  My thinking right now is that the calculated field cannot pull the information onto the SOP document because it does not know what address id is being used since I have at no time given a relationship to match against.  The only change that I made to report writer was to create two new calculated fields: (a) the first was to concatenate the Address Code and Customer Number and (b) the second was to create a new field using the rw_TableHeaderString function and pulling in the calculated field from (a). 

I would be greatful if you could provide me some advice on how to make this work.  My assumption is that I am missing just one step (ie, to link the SOP ship to address id to the Extender window within report writer), but maybe this is a lot more complicated than I realize.  Do I need to somehow link the Extender table and associate the customer number between the extender and GP tables (I don't know if that is even possible, or if it is, how to do it)?

Thanks,

Dale

*This post is locked for comments

  • Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: How can an Extender Window be placed onto SOP?

    Jonathan,

    Thank you for the response.  Literally, not an hour ago, I finished working with our VAR and it will work.  The KB articles are helpful, but there is an adjustment to the calculated field where you concantenate and strip two fields toghether which is then pulled into the calculated field for pulling the extender window field.  

    So, to get mine to work, I must concantenate the SOP_HDR_Work.PrimaryShiptoAddressCode field with the SOP_Document_HDR_Temp.CustomerNumber.  The customer number is also a key field on our Extender Field.  This enables Report Writer to find the correct address id and then note to pull onto the document.  I've just finished testing and it is pulling in correctly.  The only problem that we have is that we need more than 80 characters sometimes, so we will have to work around Report Writer's issue regarding not allowing more than 80 characters to be printed from one field.  We most likely will go the route of having multiple fields in Extender then try to Concantenate them in RW.  We will just have to find a way around RW's limitation on this one (we do not have VBA or modifier license, so this is not a project that would justify us going this route).  

    Best regards,

    Dale

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    Re: How can an Extender Window be placed onto SOP?

    Dale this setup will not work. You need to be linking the information from the BIll to field not Ship to if I am understanding you correctly. I recently had a customer with this same issue and my explanation to them was simply you will never send a bill to the ship to field, but rather the bill to.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans