Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Vendor Maintenance Screen (03.270.00) - reverse the document sort order

(0) ShareShare
ReportReport
Posted on by

In the Vendor Maintenance screen, Documents Tab the default sort order is Oldest to Newest.  Is there a way to reverse this sort order?

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Vendor Maintenance Screen (03.270.00) - reverse the document sort order

    Thanks for replying.  I  was gone for awhile and am back now.

    Clicking on the "Date" column will sort all documents by date but still will not fix our problem.

    Currently the vouchers and the corresponding checks are displayed together regardless of the check date.  Looks like the voucher date drives the sort.

    If it is only a few documents, not an issue to match the voucher and the check.  

    We have vendors that have multiple pages of documents and it becomes an issue matching vouchers with their corresponding check if we click on the "Date" column.

    Any other ideas?

    Thank You

    Kalban

  • Community Member Profile Picture
    on at
    RE: Vendor Maintenance Screen (03.270.00) - reverse the document sort order

    both Santhosh and Perumalsamy are correct if you are using SL 2011 but not if you are using version 6.5.  For some reason, I thought you said you were on version 6.5.

  • Ram Peru Profile Picture
    2,830 on at
    RE: Vendor Maintenance Screen (03.270.00) - reverse the document sort order

    As Santhosh suggested, You can do the sorting of grid by clicking the Grid Header under document tab of vendor maintenance.

    Some of screens in Dynamics SL is having the sorting functionality not all the standard screen.

    Hope this explains.

    Thanks,

    Perumalsamy R.

  • Community Member Profile Picture
    on at
    RE: Vendor Maintenance Screen (03.270.00) - reverse the document sort order

    Santhosh is correct when working with a PV list but not with an SAF grid like what is used on the documents tab of the vendor maintenance screen.  On some screens you can make this work by changing the SQL query behind the DBNAV control for the SAF grid but, unfortunately, this particular grid performs the equivalent of an internal DBNAV because it is populated differently depending on which view option you select (open documents, open plus current period, all documents).  Therefore, as far as I can see, you are out of luck on changing this.

  • Community Member Profile Picture
    on at
    RE: Vendor Maintenance Screen (03.270.00) - reverse the document sort order

    Hi

    No you can't set the sort order from Newest to oldest by Default.

    But you can sort the records from oldest to Newest & Newest to Oldest by clicking the column heading of the grid.

    In Detail :

    You can click on that "Date" column heading to sort by that field. First time the documents will be  sorted by Date : Ascending. If you click again on that "Date" column heading  then the documents will be  sorted by Date : Descending.

    Hope this Helps

    Thanks & Regards

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Featured topics

Product updates

Dynamics 365 release plans