FrontAccounting forum — Sorting Item List

Re: Sorting Item List

null@example.com (peter) — Tue, 28 Apr 2015 14:44:40 +0000

Got it. Thanks.

Re: Sorting Item List

null@example.com (apmuthu) — Fri, 27 Mar 2015 15:39:53 +0000

Take the report in Excel and sort inside the report!

Re: Sorting Item List

null@example.com (peter) — Thu, 26 Mar 2015 06:44:46 +0000

Is it possible to view the sales documents like sales orders, delivery notes, invoices where the item description is sorted in an alphabetical order instead of item code?

Thanks.

peter.

Re: Sorting Item List

null@example.com (apmuthu) — Sun, 24 Nov 2013 10:55:31 +0000

~~Which is the wiki page?~~

* Wiki Page Item - Add an option to sort item lists by item name

// To Joe/Janusz
Should it not be part of the core FA by being a config flag to switch between them?

Re: Sorting Item List

null@example.com (peter) — Sat, 23 Nov 2013 12:38:46 +0000

Hi Kerrsmith, thanks to your note that I am able to sort the item description in the sale drop dropdown menu.

I have another question to ask, how do I print the sales documents with the item description sorted in alphabetical order?

Thanks.

peace, peter.

Re: Sorting Item List

null@example.com (kerrsmith) — Wed, 17 Feb 2010 10:34:07 +0000

I have added this to the wiki on the following page:

Wishlist and future development directions for next major releases

Re: Sorting Item List

null@example.com (joe) — Tue, 16 Feb 2010 14:19:10 +0000

Yes, a good idea, kerrsmith. Will you put in on the Wiki to go for 2.3.

/Joe

Re: Sorting Item List

null@example.com (kerrsmith) — Tue, 16 Feb 2010 13:56:55 +0000

I have been looking through the code and have changed line 689 in ui_lists.inc from:

'order' => array('c.description','stock_id')

To:

'order' => array('c.description','s.description')

and line 754 from:

'order' => array('c.description','i.item_code')

'order' => array('c.description','s.description')

Where c = stock_category and s = stock_master

This seems to have worked as now my drop down item lists on the items and inventory, sales and purchase pages have been ordered by item name.

I think an option in the setup to do this would be a really useful addition.

Sorting Item List

null@example.com (kerrsmith) — Mon, 15 Feb 2010 12:24:15 +0000

Is there a way to make the drop down item list sort by item name rather than item code?

I have added many items now using the item import module but if I do not know the code it takes a while to find the item on the list as they tend to be mixed up.

I know you can enable the product search but I would prefer to just be able to scroll down the list to find what I am looking for.

Is there a place in the code I can make a change to adjust this sorting?