search

prashants / webzash

Easy to use web based double entry accounting software in PHP - MySQL under MIT License
http://webzash.org
Other
211 stars 108 forks source link

Order accounts with legder code #124

Closed lakuapik closed 3 years ago

lakuapik commented 6 years ago

Hi,

I recently use Webzash, and i dont see a menu/button to sort accounts by its ledger code.

How can we order accounts by ledger code?

Thanks in advance.

s-mcdonald commented 4 years ago

Hi Lakuapik. I have recently started using this software also and have the same issue.

When I look at SQL database there doesnt seem to be a way of sorting these values. I assumed that it should sort on the Account/Ledger Code but it doesnt. I will see if I can make a fix for this and post the solution to prashants

prashants commented 4 years ago

https://github.com/prashants/webzash/blob/master/Lib/AccountList.php#L192

Change the order by clause to order by 'Ledge.code' instead of 'Ledger.name'