Skip to main content
Solved

Sort AP in Alphabetical Order

  • Jun 29, 2023 2:09 PM UTC
  • 4 replies
  • 432 views
  • Translate All

Forum|alt.badge.img

Hey everyone -

 

My AP report does not run in alphabetical order but rather by Vendor ID chronological order and it drives me nuts!! Tried to fix it myself on the report designer but I can’t find where the sorting feature is for the data in that column. Can someone offer some assistance? 

 

I only run AP in summary form. 

Best answer by Laura03

Hello @katiedavison ,

This example uses the AR Aged Period Sensitive:

In the Report properties, expand the Group and Sort “collection” areas to see and edit grouping and sorting.

 

 

View original

4 replies

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • Jun 29, 2023 2:28 PM UTC

Hello @katiedavison ,

This example uses the AR Aged Period Sensitive:

In the Report properties, expand the Group and Sort “collection” areas to see and edit grouping and sorting.

 

 

Translate

Forum|alt.badge.img+9
  • Semi-Pro III
  • Jun 30, 2023 6:18 AM UTC

Hi @katiedavison,

I am working with the AP aging report as an example.

In the report designer, go to the File→ Build Schema→ Sorting and Grouping tab, add the "Vendor ID" column and choose the "Ascending" option to sort the data in alphabetical order based on the vendor's ID.

 

 

Regards,

Sweta

Translate

  • Freshman I
  • Mar 10, 2025 6:15 PM UTC

this does not work

Translate

  • May 19, 2025 1:11 PM UTC

Remove the Vendor.AcctCD and just use Vendor.AcctName

 

Translate