FrontAccounting forum — Sales Order Inquiry Sort Descending?

Re: Sales Order Inquiry Sort Descending?

null@example.com (apmuthu) — Mon, 20 Jan 2020 03:16:43 +0000

@paul: highlighting the the two similar lines will expose trailing spaces in the one to be removed.

Re: Sales Order Inquiry Sort Descending?

null@example.com (paul) — Mon, 20 Jan 2020 03:01:07 +0000

Thank you very much. I thought I would get a notice of more replies to this post, but don't remember getting one. Anyways, thank you. I will apply patch when I can. The last line to add looks like the one above it to remove. ??

Re: Sales Order Inquiry Sort Descending?

null@example.com (apmuthu) — Tue, 14 Jan 2020 00:28:06 +0000

Thanks @joe.

Whilst we are on this, we might as well optimise the sql in the last function in sales/includes/db/sales_order_db.inc with:

--- sales/includes/db/sales_order_db.inc    Tue Jan 14 05:30:15 2020
+++ sales/includes/db/sales_order_db.inc    Tue Jan 14 05:42:21 2020
@@ -632,11 +632,9 @@
 {
         $sql = "SELECT $field
             FROM ".TB_PREF."sales_order_details d
-            WHERE order_no =
-            (SELECT order_no FROM ".TB_PREF."sales_orders o
+            LEFT JOIN " .TB_PREF."sales_orders o on d.order_no=o.order_no
             WHERE debtor_no=" . db_escape($order->customer_id) . "
-            ORDER BY order_no DESC LIMIT 1)
-            ORDER BY d.id DESC LIMIT 1";        
+            ORDER BY d.id DESC LIMIT 1";
 
         $last_query=db_query($sql, "Could not retrieve last order detail");
         $row = db_fetch_row($last_query);

Re: Sales Order Inquiry Sort Descending?

null@example.com (joe) — Mon, 13 Jan 2020 14:55:39 +0000

This has been committed to 2.4.7 stable repo.

/Joe

Re: Sales Order Inquiry Sort Descending?

null@example.com (joe) — Mon, 13 Jan 2020 14:19:00 +0000

I will have a look at it later.

Joe

Re: Sales Order Inquiry Sort Descending?

null@example.com (apmuthu) — Mon, 13 Jan 2020 08:50:11 +0000

@joe: can this be incorporated into the core?

Re: Sales Order Inquiry Sort Descending?

null@example.com (rafat) — Tue, 07 Jan 2020 14:20:55 +0000

@paul

You are right.. I believe it should be as you described it.. Its more user friendly.. (logical).

Re: Sales Order Inquiry Sort Descending?

null@example.com (paul) — Tue, 07 Jan 2020 14:17:47 +0000

@rafat

Yes, thank you. That is what I do now, but since I need it that way every time, I wanted to make it "stick" so I didn't have to click on the Order Date twice.

Re: Sales Order Inquiry Sort Descending?

null@example.com (rafat) — Tue, 07 Jan 2020 14:15:06 +0000

@paul

Click on the Order Date (I think Twice) and it will be sorted by the latest date.

Sales Order Inquiry Sort Descending?

null@example.com (paul) — Tue, 07 Jan 2020 14:07:23 +0000

When I select Sales Order Inquiry, I would like the most recent orders on top just like the Work Order Inquiry returns newest Work Orders on top. When I watch the sql query for the Work Order Inquiry, I get an idea how it works with the "ORDER BY workorder.id DESC" portion of the statement, but after going through the included files for the Sales Order Inquiry, I cannot seem to find the correct area to sort my Sales Orders.

Could someone point me in the right direction? Thanks in advance.