Our Product Specialist, Nicole Albertson, dives deeper into Table Links in Extender for this week's Tech Tuesday below:
Extender includes the option for Table Links. Linking an Extender Window to a table ensures that the Extender Window's data is deleted when the corresponding table record is removed.
How many tables can you link?
A window can be linked to one or more tables. When it is linked to more than one table, the Extender Window's data will only be deleted when there is not a corresponding record in any of the linked tables.
How does it work with Work/Open/History?
If you link an Extender Window to a work table and not the corresponding history table, the Extender data will be deleted when the record is posted because the data is removed from the work table during the posting process. The key is to make sure that you link to the table for each Work, Open, and History so that the data doesn't get removed in the posting process.
Example:
If you create an Extender Window on the Item Maintenance window in Microsoft Dynamics GP, you may want to add a Table link to the Item Master. This will trigger Extender to remove the data you have entered in the Extender Window for that specific item when the Item is deleted in GP. So, for example, I have an item called '100XLG' and I have entered data into the Extender window for that item. When I delete '100XLG' from GP, the Extender data will be removed as well with the table link in place. If I don't have the table link, the Extender data would remain even though the item had been deleted.
In Extender 2013, the Table Links can be setup on a window by going to the Options button.
In Extender 10 and 2010, you can access the table links in the setup of the Extender Window by going to the Options menu and selecting Table Links.
Want more Extender information? Please feel free to reach out to us at sales@eonesolutions.com for more!
Showing posts with label Extender 2013. Show all posts
Showing posts with label Extender 2013. Show all posts
Tuesday, April 22, 2014
Tuesday, October 15, 2013
Tech Tuesday – Adding Extender Nodes to SmartConnect
This week's Tech Tuesday is from Lorren Zemke, our Director of Professional Services. He discusses a new feature that has been added to the latest SmartConnect 2013 release which is available to download here.
With the latest release of SmartConnect 2013 Service Pack 1, there are now multiple ways to add Extender Nodes to a SmartConnect integration. You are now able to add a node using the standard method in SmartConnect through Node Maintenance and also during map creation. The other awesome feature that has been added is the ability to add the same node twice, so if I have more than one Extender Window attached to a Dynamics GP Document I can update the data for both objects in the same map.
For example, I have created two Extender Windows attached to the Sales Transaction Entry window to enter some additional ordering information.
When I save each window, I answer ‘Yes’ to the question to create the Extender View as required by SmartConnect and include all of the fields as part of that view.
I will now add the Extender Nodes to my map for integration to Sales Documents. I am using an Excel Workbook that has one sheet for the header portion and one sheet for the line portion. In SmartConnect, I use an ODBC Connection and join the Header and Lines in the Query.
Below is the header portion of my Excel file that includes the Extender fields in the same row.
The new method for adding the Extender node to SmartConnect is to use the Add Extender Object button as part of the SmartConnect Destination mapping.
Click on the Add Extender Button to open the Add Extender Objects window.
Click on the Plus button to open the Add Extender Object window.
Select the appropriate Extender Type, Node Type and Extender ID. After clicking Save on the Add Extender Object window, I can add my other Extender window as an additional node using the same process as above but choosing the other Extender ID. The new nodes will appear at the end of the list within the Destination Type.
Now the process of mapping the Extender Nodes is the same as mapping any other SmartConnect node.
You will note the Window ID will default to the proper value and the actual Extender field names are shown within the destination columns so mapping these to the source is a much easier process than in previous version.
Once the Extender windows are mapped, I can import my documents and review the data has been successfully imported.
Lorren Zemke
Interested in learning about what other awesome features have been added to SmartConnect? Feel free to reach out to us at sales@eonesolutions.com for more information!
