Solved

Sort AP in Alphabetical Order

  • 29 June 2023
  • 2 replies
  • 108 views
K
Rank
Userlevel 3
Badge

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. 

icon

Best answer by Laura02 29 June 2023, 16:28

View original

2 replies

Laura02
Rank
Badge +18

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.

 

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
S
Rank
Userlevel 7
Badge +10

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

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved