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

Notifications

Announcements

No record found.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans