web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SmartList Goto DDL field - appears to set index rather than value

(1) ShareShare
ReportReport
Posted on by

I have created a GoTo that opens the Asset Account window. The values of the Account field get loaded and the field script is run - which loads the Account Suffix DDL with values. Then the DDL value gets placed, and the field script is run filling in all the values as it should on the form.  The issue is when one of the Account Suffix values has a status other than 1 (the account / suffix combination is no longer ACTIVE).  The Asset Account window does not display INACTIVE accounts (which is fine, it should not), so what it is doing is displaying the next account-suffix in the list.  For example, Account 4060120 has suffix values 1 through 16.  Suffix value 5 has an account status of 4, so it is NOT ACTIVE.  When a user selects 4060120, suffix 5 from the SmartList to GoTo the Asset Account Window, it opens up for Account 4060120 suffix 6.  If the user selects suffix 6, it opens up suffix 7, and so on.

As long as there are no inactive suffixes, there is no issue.

How can I resolve this, so that if a user tries to GoTo the Asset Account and it is not Active, they get the message telling them inactive accounts cannot be viewed (or whatever the message is by default).

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    The solution we decided to try is to add a field to the view

     ,ROW_NUMBER() OVER(PARTITION BY [FA00100].[ASSETID] order by case when [FA00100].[ASSETSTATUS] = 4 then 1000 else [FA00100].[ASSETIDSUF] end) AS MyRow

    and use that to link the GoTo for the Account-Suffix.  This way, items that are not on the Asset Account window end up with an index value out of range, and the user gets an appropriate error when trying to go an inactive account.

  • Verified answer
    Community Member Profile Picture
    on at

    slight correction -

     ,CAST (ROW_NUMBER() OVER(PARTITION BY [FA00100].[ASSETID] order by case when [FA00100].[ASSETSTATUS] = 4 then 1000 else [FA00100].[ASSETIDSUF] end) AS INT) AS ASSETIDSUFINDX

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans