Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Using Built In Gotos with SmartList Builder


With the first version of SmartList Builder from eOne Solutions for GP2013 was released, we added a new Goto type called Built in Gotos. This new Goto type replaced Advanced Gotos which were used on previous versions of Microsoft Dynamics GP. A Built in Goto will allow you to use any of the Gotos that exist on any of the default Microsoft Dynamics GP SmartLists on a custom list built with SmartList Builder. This will allow you to populate windows such as Payables Transaction Inquiry, Purchase Order Inquiry, Receivables Transaction Inquiry and Sales Inquiry which cannot be opened directly using the Open Form Goto type as the fields are locked on these windows.

In addition to these four inquiry windows there are many other default Gotos that you can easily apply to your custom SmartLists using the Built in Gotos. To setup a built in Goto you need to supply a Description, choose a default SmartList and default Goto and assign the proper parameters from your source table. The examples below show how to setup the Built in Gotos on a custom SmartList to work as Advanced Gotos did on previous versions of GP.

jared

Using the default View goto from Payables Transactions

Using the default View goto from Purchase Orders

Using the default View goto from Purchase Orders

Using the default View goto from Receivables Transactions

Using the default View goto from Receivables Transactions

Using the default View goto from Sales Transactions

Using the default View goto from Sales Transactions


Questions? Feel free to leave a comment below. Thanks for tuning into our weekly Tech Tuesday!

12 Comments

  1. Alyson Frost on October 29, 2015 at 9:30 am

    We have upgraded a customer to GP 2015 and have installed the update to smartlist builder. The new gotos work very well but I cannot remove the old “Advanced Go Tos'” because that product doesn’t exist, so they cant be deleted from the list.

    I don’t want to have to recreate the smartlists from scratch because they have all kinds of calculated fields and gotos.

    What are the tables I need to access in order to remove the old gotos , so they don’t appear in the list?

    Thanks

  2. Jared Dux on November 3, 2015 at 4:11 pm

    These gotos are in the SLB10400 table in the DYNAMICS database. You can remove them by running the following:
    delete DYNAMICS..SLB10400 where SmartList_ID = ‘Enter Your SmartList ID’ and GoTo_Number = Enter the GoTo_Number you need to remove

  3. Chad Hundley on October 19, 2016 at 4:50 pm

    I have created a Smartlist that uses a SQL view and I am trying to create a GoTo for the Sales Transaction Entry window or Sales Transaction Inquiry window. I have tried everything possible and nothing seems to work. Does list functionality work for Smartlists created from SQL views.

  4. @GP_Beat on March 30, 2017 at 2:01 pm

    Hi Jared,
    Same case as Chad.. How can you link a SQL view value with an Inquiry form (i.e. Saled Document Inquiry) to allow for end-users to view the data.. GoTo throws an error when you try this, stating the field is locked (which is true in an Inquiry form)..

  5. Patrick Roth on April 3, 2017 at 10:41 am

    Beat & Chad,

    I don’t see where the source data coming from makes any difference. But assuming it does (perhaps your View returns “Invoice” instead of 3 for the SOP Type for example) then you’d need a calculated field to change the words to an integer and then you map the calculation instead.

    As for the “GoTo throws an error when you try this stating the field is locked” – that means that you are creating your own GoTo using the “open form” method and setting fields.

    The purpose of these above Built-In GoTo’s is so that you DON’T have to create your own and can just pass the necessary params and it’ll open & correctly populate the window for you.

  6. Dominic on June 21, 2017 at 3:06 pm

    I have a smartlsit that shows every invoice and credit applied to a check. the go to should go to the view of each transactions listed. however,, they all point to the same one. any ideas?

  7. Patrick Hendriks on August 10, 2017 at 1:44 pm

    Nice article.
    I wanted to add something I learned, maybe it will help others.

    I created a Custom Aging report and provided a GoTo for it to open the Receivable Transaction in the proper window (based on Document Type.) My smartlist was based on a View. When I added the table it had asked for the Key Fields. This is important to get right or the GoTo will not work properly. My initial setup was set to CustomerNumber as the Key. When I used the GoTo, it would open the Inquiry window but with the wrong Document. (It also did not open anything other than the Receivables Trx Inq Zoom window.) I updated my Key to include CustomerNumber, DocumentNumber and RMDTYPAL. This then resolved the issue with the GoTo. It now opens the correct Inquiry window and for the right document number.

    Hope this can help others.

    -Pat

    • Jennifer on May 30, 2019 at 11:20 am

      Great point, Pat! I had not included as a key field and experienced the same issue . Thanks for posting.

      Jennifer

  8. Jen Kuntz on September 7, 2017 at 10:55 am

    If there is a third party like Wennsoft Job Cost, where there is no built-in, is there a way to trigger “clearing” a field on a window before running the field script on the “Open Form” go to?

  9. Patrick Roth on September 14, 2017 at 9:44 am

    Jen –
    there isn’t a “clear field” method on the goto. but you could make a calculation to return an empty string.
    then in the goto, just use the “set field and run script” and set it to the calculation which is empty (empty string or 0 or whatever the field needs).

  10. Kayla Worley on June 5, 2018 at 5:11 pm

    I built a smart list with account number, I would like to double click on the account and have it go to the account transaction smart list and pass the account number as a filter? Can we do that?

  11. Patrick Roth on June 7, 2018 at 11:55 am

    These 4 examples are just showing the replacement for the Advanced GoTo functionality.

    All of the existing GP smartlists that have GoTo’s everywhere should all be duplicated in the Built-In Goto functionality with SLB. Just look in the smartlist that would have this functionality (Accounts in this case) and choose the same GoTo name that you would see in normal GP Accounts and it should work the same way (View in this case).

Leave a Comment





RECENT POSTS


Happy Thanksgiving from eOne! - US Office Closed November 25 & 26
Popdock: What is your Locale?
Q4 2021 Partner All Hands Call - Recording Now Available
An Announcement regarding SmartList Builder and SmartView from eOne Solutions
Join us for the Q4 2021 Partner All Hands Call!

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.