Topic: Sorting the Outstanding work order screen...or any option for filters

Hi,

Is it possible to put filters in the columns in outstanding work order sheet something similar to Excel....for eg. filter for item name, item number etc.

Or maybe simply sorting options such sort by item name or sort by item code. The only sorting options are date and required by.

Any ideas?

Re: Sorting the Outstanding work order screen...or any option for filters

This sounds resonable. Sorting by number or name is useful. Will have a look at this.

Joe

Re: Sorting the Outstanding work order screen...or any option for filters

This in fact, is the case in any of the other inquiry display.

Re: Sorting the Outstanding work order screen...or any option for filters

I am not quite sure about that. Often the date values is sufficient. You can often use the qbove fields for filtering.

We will take this inquiry first,

Joe

Re: Sorting the Outstanding work order screen...or any option for filters

This has been fixed. You can download a new file, /manufacturing/search_work_orders.php, here.

The HG repository is updated and the fix will be included in the next minor release.

/Joe

Re: Sorting the Outstanding work order screen...or any option for filters

joe wrote:

This has been fixed. You can download a new file, /manufacturing/search_work_orders.php, here.

The HG repository is updated and the fix will be included in the next minor release.

/Joe

Thank you so much for your fast response. Will try this and update you soon.

Re: Sorting the Outstanding work order screen...or any option for filters

Hi, can we include search by '#' in this?

Re: Sorting the Outstanding work order screen...or any option for filters

By "#" do you mean id or wildcard "*"?

Re: Sorting the Outstanding work order screen...or any option for filters

I mean 'id', which is the first column.

Re: Sorting the Outstanding work order screen...or any option for filters

This is already implemented in release 2.3.22.

/Joe

Re: Sorting the Outstanding work order screen...or any option for filters

Upgrade your install by overwriting with the changed files from this post.

Re: Sorting the Outstanding work order screen...or any option for filters

There is sort by reference, but we need sort by first column in work order inquiry. Please advise.

Re: Sorting the Outstanding work order screen...or any option for filters

Just press the # label.

Joe

Re: Sorting the Outstanding work order screen...or any option for filters

Sorry, my bad! I meant "search by".

Re: Sorting the Outstanding work order screen...or any option for filters

Oh, I see. Sorry we do not consider this as needed. As you say you can search by reference.

Joe

Re: Sorting the Outstanding work order screen...or any option for filters

Well, this is an operational requirement for my shop floor people. Even the Sales Orders can be searched by ID apart from reference. I guess I'll have to find a way to configure it myself, since you don't consider it necessary.

Re: Sorting the Outstanding work order screen...or any option for filters

Hold your horses wink. I didn't realize this as that important.

I will have a look again.

Joe

Re: Sorting the Outstanding work order screen...or any option for filters

This issue has now been implemented in 2.3.23 release.

If you can't wait you can download the files /manufacturing/search_work_orders.php1 (rename to .php) and /manufacturing/includes/db/work_orders_db.inc. Please replace the files in your setup.

/Joe

Post's attachments

search_work_orders.php1 5.5 kb, 1 downloads since 2015-02-19 

work_orders_db.inc 18 kb, 1 downloads since 2015-02-19 

You don't have the permssions to download the attachments of this post.

19 (edited by sachinkhatri 02/19/2015 12:26:56 pm)

Re: Sorting the Outstanding work order screen...or any option for filters

@apmuthu, after upgrading from 2.3.21 to 2.3.22, I am getting error on item location transfer. When I try to transfer stock from one location to another, it shows that "The quantity entered is greater than the available quantity for this item at the source location". But the Item status is showing the stock is there. This is happening for every item.

Edit: Reverted to 2.3.21, now the error is not coming.

Re: Sorting the Outstanding work order screen...or any option for filters

Thanks @joe for the support. smile