Also sometime if I try to edit the journal entry not responding in some companies and reflecting in others.

I don’t know what’s the problem it was working good.

Please help.

IS THERE ANY WAY TO CONVERT MULTIPLE SALES ORDERS TO SINGLE DELIVER ? as we can have multiple delivery notes to invoice ?

Look forward for any of your help

Regads

Roshan

As a contribution for this forum included the customisation files to show the bank account then user consult customer transactions, type: Payment.

For those who are interested, insert the files at this address

sales/inquiry/customer_inquiry.php
sales/includes/db/cust_trans_db.inc

function last_sales_order_detail($order, $field)
{
        $sql = "SELECT $field
            FROM ".TB_PREF."sales_order_details d
            WHERE order_no =
            (SELECT order_no FROM ".TB_PREF."sales_orders o
            WHERE debtor_no=" . db_escape($order->customer_id) . "
            ORDER BY order_no 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);
        return $row == false ? false : $row[0];
}

Kindly change it to:

function last_sales_order_detail($order, $field)
{
        $sql = "SELECT $field
            FROM ".TB_PREF."sales_order_details d
            LEFT JOIN " .TB_PREF."sales_orders o on d.order_no=o.order_no
            WHERE debtor_no=" . db_escape($order->customer_id) . "
            ORDER BY d.id DESC LIMIT 1";

        $last_query=db_query($sql, "Could not retrieve last order detail");
        $row = db_fetch_row($last_query);
        return $row == false ? false : $row[0];
}

It uses a left join instead of a secondary select.

The on d.order_no=o.order_no can become USING (order_no) to further optimise it.

Creation of dynamic property front_accounting::$renderer is deprecated in file: /home/mydomain/public_html/accounts/frontaccounting.php at line 66

When I switch back to php 8.1 it goes away.

we have two instances of frontaccounting , one which was installed 3-4 years back version 2.3.21 and a newer one with version 2.4.15, We  have a column called "RB" in customer transaction enquiry window (see attached screenshot) in the older version which is very useful to see how much total payment was received in a month or during a period.

However the same is not seen in the newer versions like 2.4.15 (attaching screenshot) and cant see the same in demo version of FA also, let us know how we can have the "RB" for the newer versions ?

Thanks..

As can be seen from the two attachments, the Customer balance shows correctly whilst the Aged Customer analysis does not.

The Customer balance sees the journal as a credit, while the Aged Customer Analysis see the same journal as a debit.

I cannot upload the second file.

this is the error msg i got.

/home/ufitflyn/public_html/fly/sales/includes/db/cust_trans_db.inc:214:     display_backtrace()
/home/ufitflyn/public_html/fly/reporting/rep107.php:126:     get_customer_trans('2','10')
/home/ufitflyn/public_html/fly/reporting/rep107.php:57:     print_invoices()
/home/ufitflyn/public_html/fly/modules/KvcodesInvoices/reporting/rep107.php:25:     include_once('/home/ufitflyn/public_html/fly/reporting/rep107.php')
/home/ufitflyn/public_html/fly/reporting/prn_redirect.php:58:     require('/home/ufitflyn/public_html/fly/modules/KvcodesInvoices/reporting/rep107.php')
DATABASE ERROR : duplicate debtor transactions found for given params
sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.debtor_ref, cust.curr_code, cust.tax_id, trans.prep_amount>0 as prepaid,com.memo_, 0_shippers.shipper_name, 0_sales_types.sales_type, 0_sales_types.tax_included, branch.*, cust.discount, 0_tax_groups.name AS tax_group_name, 0_tax_groups.id AS tax_group_id FROM 0_debtor_trans trans LEFT JOIN 0_comments com ON trans.type=com.type AND trans.trans_no=com.id LEFT JOIN 0_shippers ON 0_shippers.shipper_id=trans.ship_via, 0_debtors_master cust, 0_sales_types, 0_cust_branch branch, 0_tax_groups WHERE trans.trans_no='2' AND trans.type='10' AND trans.debtor_no=cust.debtor_no AND 0_sales_types.id = trans.tpe AND branch.branch_code = trans.branch_code AND branch.tax_group_id = 0_tax_groups.id

It appears like it wants to, but is limited to "one line of text" on the Invoice.  I cant get the legal_text to span multi-lines...

Am I missing something here?

Please help a newbie...Thanks FA...

Im using version 2.4.16 installed on a shared host with Hostgator....just FYI.

When I select any client I get the following error although the information is still displaying.

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 116

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 131

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 132

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 133

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 134

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 135

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 136

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 137

What would cause this issue?

What I have done is created an invoice for the first day of the next fiscal year. I also added a new GL account “membership23-24”. I then accept payment on the date it occurred (So that the bank balances work out for the month).

Have I done this the best way?

One problem my client was having was an incorrect balance on the customer statement that looks like it resulted from a journal entry (currently at 2.4.8). Looking at 2.4.16, the outstanding balance is something completely different, but still wrong. In both versions, the customer transactions show the correct outstanding balance, *AND* the statement debits and credits are correct. If you just add them up, you get the correct balance ... it is just the aging balance report at the bottom that is wrong.

The customer I'm looking at has journal transactions, sales (invoices) and normal payments against invoices. They have 3 outstanding, unpaid invoices for a total of $318, but the aging balance is $520 (?) In the previous version, it was $117 (?).

I'm going to take a deeper look, so I can file a proper bug report, but the most confusing thing about FA is the way it sums transactions with some amounts being reversed, etc. I'm just wondering if anyone else is seeing this problem?

How do I include sales discount on Invoice. I know that there is discount in the customer payment module. My challenge there is that when the customer's statement is generated, the discount in not included. So customers are complaining that the discount they are given is not reflected in the Invoice nor their Statement.
How do I correct this?

Thanks.

Popsicles12