It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Banking and General Ledger → Journal Inquiry Dates
Hi Guys,
Downloaded the above file and replaced it on my 247 installation the following is observed.:
1. Customer / Supplier names are not showing.. Just numbers 1, 2 ..etc
2. QE names not showing but numbers as well.
3. Misc entries are shown properly.
4. The Funds Transfer is showing correctly.
@rafat
I forget to mention that you still need the new gl/inquiry/journal_inquiry.php file as well. Download that and you should be good.
Thanks @Braath Waate
I will download and test and come back to you.
Hello, Today I was just checking and found that in Journal Inquiry 2.4.8 the Counter Party column is not showing the Customer Name for Sales Invoices.
Here is the Screen Shot
Similarly for Supplier Invoices it is showing for some invoices and not for all. What could be the reason.
Extracting persons out of the gl file is tricky because FA nulls these fields out, leading to very obscure SQL. Try:
--- a/core/gl/includes/db/gl_db_trans.inc
+++ b/core/gl/includes/db/gl_db_trans.inc
@@ -619,13 +619,13 @@ function get_sql_for_journal_inquiry($filter, $from, $to, $ref='', $memo='', $al
gl.tran_date,
gl.type as trans_type,
gl.type_no as trans_no,
- IFNULL(gl.person_id, IFNULL(st.supplier_id, IFNULL(grn.supplier_id, IFNULL(dt.debtor_no, bt.person_id)))) as person_id,
+ IF(MAX(gl.person_id), MAX(gl.person_id), IFNULL(st.supplier_id, IFNULL(grn.supplier_id, IFNULL(dt.debtor_no, bt.person_id)))) as person_id,
IF(ISNULL(st.supp_reference), '', st.supp_reference) AS supp_reference,
refs.reference,
IF(gl.type=".ST_BANKTRANSFER.",MAX(gl.amount),SUM(IF(gl.amount>0, gl.amount,0))) as amount,
com.memo_,
IF(ISNULL(u.user_id),'',u.user_id) as user_id,
- IF(gl.person_id, gl.person_type_id, IF(!ISNULL(st.supplier_id) OR !ISNULL(grn.supplier_id),". PT_SUPPLIER . "," . "IF(dt.debtor_no," . PT_CUSTOMER . "," .
+ IF(MAX(gl.person_id), MAX(gl.person_type_id), IF(!ISNULL(st.supplier_id) OR !ISNULL(grn.supplier_id),". PT_SUPPLIER . "," . "IF(dt.debtor_no," . PT_CUSTOMER . "," .
"IF(bt.person_id != '' AND !ISNULL(bt.person_id), bt.person_type_id, -1)))) as person_type_id
FROM ".TB_PREF."gl_trans as gl
LEFT JOIN ".TB_PREF."audit_trail as a ONThanks Braath.. It seems OK with your change.
Sales Invoice and Supplier Invoices samples attached...
It worked bro!!
@joe
Can this be included in core if it does not cause any conflicts?
Thanks.
/gl/view/gl_payment_view.php?trans_no=3
Field Pay To is empty
Also in Bank statement Person/Item not showing
Is it happening for everyone?
FrontAccounting forum → Banking and General Ledger → Journal Inquiry Dates
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.