Solved

Profit and loss - Expenses sorting high to low

  • 5 December 2022
  • 4 replies
  • 67 views
T
Rank

Good day

 

I am seeking assistance on how to sort my expense items on the Profit and loss report high to low.

 

This needs to sort automatically each time the report is generated.

 

Is this at all possible? Help will be appriciated.

 

Regards 

icon

Best answer by Laura02 5 December 2022, 16:39

View original

4 replies

Laura02
Rank
Badge +18

Yes, the SortD command can be used in financial reports to sort by a column in descending order.

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
T
Rank

Do you input this formula in Colum sets or Row sets?

Laura02
Rank
Badge +18

I have always used the Sort command in the ROW.  Example below, where a group of expenses is sorted by column C declining, Where Column C represents the $$ column used as the basis for the sort.

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
T
Rank

Hey

 

Thanks for the help.

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