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 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

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

    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

  • Community Member Profile Picture
    on at

    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.

  • Ram Peru Profile Picture
    2,830 on at

    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

    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.

  • Community Member Profile Picture
    on at

    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

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 SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans