FrontAccounting forum — 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (apmuthu) — Mon, 10 Sep 2018 03:37:57 +0000

This happens when there are no transactions in function get_customer_trans_version() in sales/includes/db/cust_trans_db.inc. The construct at lines 37-43:

    $sql= 'SELECT trans_no, version FROM '.TB_PREF. 'debtor_trans
            WHERE type='.db_escape($type).' AND (';

    foreach ($trans_no as $key=>$trans)
        $trans_no[$key] =     'trans_no='.db_escape($trans_no[$key]);

    $sql .= implode(' OR ', $trans_no) . ')';

can be modified to be

    $sql= 'SELECT trans_no, version FROM '.TB_PREF. 'debtor_trans
            WHERE type='.db_escape($type).' AND trans_no IN ('.implode(',', db_escape($trans_no)).')';

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (trafficpest) — Mon, 10 Sep 2018 02:17:02 +0000

Yes, unfortunately it shows voided invoices now Wished this could be removed and if you click the option to edit a voided it will throw a SQL error.

DATABASE ERROR : document version retreival
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
sql that failed was : SELECT trans_no, version FROM 2_debtor_trans WHERE type='13' AND ()

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (joe) — Thu, 30 Aug 2018 12:09:10 +0000

It is automatically mirrored to /FrontaccountingErp/FA.

Joe

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (kvvaradha) — Thu, 30 Aug 2018 11:59:05 +0000

@joe commit this to github as well.

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (joe) — Thu, 30 Aug 2018 07:00:12 +0000

This has been solved by including a checkbox in the Customer Transactions 'Zero values'. Marking this will show the voided and zero valued records.

Will be committed in a while.

/Joe

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (joe) — Wed, 29 Aug 2018 18:04:46 +0000

Yes, maybe a company flag. Will have a look.

Joe

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (apmuthu) — Wed, 29 Aug 2018 17:33:43 +0000

@joe: should a flag be used or should it simulate the old functionality with the inclusion of the said code?

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (trafficpest) — Wed, 29 Aug 2018 16:37:35 +0000

You guys are awesome and that did work.

Just to let you know it still doesn't show the delivery notes in the 0.00 amount.

Thanks again, you guys are always the greatest

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (apmuthu) — Wed, 29 Aug 2018 03:16:31 +0000

@joe: Please verify and include if okay. Why was this done in the first place - was it the remnant of some debug coding? Or must there be a flag to suppress zero entries?

Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (Braath Waate) — Wed, 29 Aug 2018 01:36:43 +0000

I didn't know it changed, but to show them,

sales/includes/db/cust_trans_db.inc
function get_sql_for_customer_inquiry

Change line 351 to:

    // exclude voided transactions :
            ." AND ISNULL(v.date_)"
        // exclude self-balancing (journal) transactions:

      ." AND (trans.type = " . ST_SALESINVOICE . "
            OR (trans.ov_amount + trans.ov_gst + trans.ov_freight + trans.ov_freight_tax + trans.ov_discount) != 0)";

2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php

null@example.com (trafficpest) — Tue, 28 Aug 2018 20:50:31 +0000

I just upgraded to 2.4.4 from 2.4.1 and it no longer shows sales invoices if they were for free i.e. 0.00

We create service invoices for 0.00 when work was guaranteed all the time and can no longer see the clients complete work history. The invoices can no longer be seen all types and I just noticed the delivery notes are missing as well.

Thank you