Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales Serial Number En...
Microsoft Dynamics GP (Archived)

Sales Serial Number Entry sort available serial numbers scrolling window by serial number.

(0) ShareShare
ReportReport
Posted on by Michael W. Smith 350

Is there a way in Dexterity or VBA to sort the Sales Serial Number Entry window.

This environment maintains a large number of serial numbers per item and find with the Available Serial Numbers scrolling window is sorted by the index number applied to the record druing the entry of the serial number, it results in the serial numbers not displaying by serial number but the order in which the serial numbers are entered.

I understand this is a function of the table keys and have experimented with changing this index integer value and find the scrolling window is sorted in this way.

My question is, is there a way to programically change this scrolling window to display the available serial numbers in 'serial number' order?

Thanks in advance to all those with suggestions.

Michael Smith

*This post is locked for comments

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Sales Serial Number Entry sort available serial numbers scrolling window by serial number.

    if someone is still looking for reply of this question, yes it can be done  grammatically.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Sales Serial Number Entry sort available serial numbers scrolling window by serial number.

    Before I did DEX or VBA, I would build a similar inquiry in Smart List Builder.  This way my inquiry would not create problems with updates, upgrades, or future 3rd party products.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Serial Number Entry sort available serial numbers scrolling window by serial number.

    I just created this code in SQL, for this task, it reassigns the Sequence number based on the Item and Site ID, sorting by Item Number and Serial Number.

    ROW 1 - ITEM A - LOCATION 1 - SERIAL 1

    ROW 2 - ITEM A - LOCATION 2 - SERIAL 2

    ROW 3 - ITEM A - LOCATION 1 - SERIAL 3

    ROW 4 - ITEM B - LOCATION 1 - SERIAL 4

    ROW 5 - ITEM B - LOCATION 2 - SERIAL 6

    ROW 6 - ITEM B - LOCATION 2 - SERIAL 5

    The result with the query is the following:

    ROW 1 - ITEM A - LOCATION 1 - SERIAL 1

    ROW 2 - ITEM A - LOCATION 1 - SERIAL 3

    ROW 1 - ITEM A - LOCATION 2 - SERIAL 2

    ROW 1 - ITEM B - LOCATION 1 - SERIAL 4

    ROW 1 - ITEM B - LOCATION 2 - SERIAL 5

    ROW 2 - ITEM B - LOCATION 2 - SERIAL 6

    Always backup, BACKUP

    WITH T

        AS (select DTSEQNUM,

    ROW_NUMBER()OVER(PARTITION BY ITEMNMBR, LOCNCODE ORDER BY (ITEMNMBR),(SERLNMBR)) as RN

    from dbo.iv00200)

    UPDATE T

    SET DTSEQNUM = RN * 16384

    Test and see if this is what you need. If you manage too many serial numbers you can create a SQL job to be executed every day, or the time you define as long as it does not impact your operation.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales Serial Number Entry sort available serial numbers scrolling window by serial number.

    Michael,

    Did you ever get get an answer to this question?  I have a client with the same request.

    Jed Perlowin

    perlowin@gmail.com

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans