1 Reply by Nibbik

(3 replies, posted in Banking and General Ledger)

Shortly my hosting won't allow downgrade to PHP 7.x anymore, I do hope this bug is to be fixed very soon.

Go to forum: Banking and General Ledger

2 Reply by Nibbik

(3 replies, posted in Wish List)

How can I add an image (screenshot) on this forum?

Go to forum: Wish List

3 Reply by Nibbik

(10 replies, posted in Report Bugs here)

Is not only about exchange rate, also languages, templates, add ons
PHP below 7.3 is not provided anymore by my host because of security polucy, sorry.

Go to forum: Report Bugs here

4 Reply by Nibbik

(10 replies, posted in Report Bugs here)

Problem occurs in these clients:
- Microsoft Edge Versie 89.0.774.45 (Officiële build) (64-bits),
- Microsoft Internet Explorer Versie 20H2 (Build van besturingssyteem 19042.844),
- Firefox Browser 85.0.2 (64-bits)  and  Firefox Browser 86.0 (64-bits),
all on Windows 10 Pro 20H2 (19042.844) NL.
By the way, also occurs when I try Safari on my iPhone.
So more or less on any client I can find at the moment

So it looks like a server-side error.
Server information:
- PHP: version 7.3.27, Apache server,
- MySQL: 5.5.5-10.3.27-MariaDB-1:10.3.27+maria~focal,
- Linux 5.4.0-29-generic #33-Ubuntu platform.
Updated PHP-version to 8.0 just to try if that solves anything, but that didn't help.

Could it be because of script-breaking changes in PHP 5 -> 7 ?
Unfortunately I cannot test that since my host won't allow versions below 7.3 anymore.

For your information:
In my Frontaccounting instance, System check (under Settings tab) gives all Ok's in the table, but mentions this information on top of the page:

Deprecated: Required parameter $memo follows optional parameter $date in .../frontaccounting/gl/includes/db/gl_db_banking.inc on line 146 
Deprecated: Required parameter $date follows optional parameter $provider in .../frontaccounting/gl/includes/db/gl_db_rates.inc on line 129 
Deprecated: Required parameter $settled follows optional parameter $supplier_id in .../frontaccounting/purchasing/includes/db/suppalloc_db.inc on line 103 
Deprecated: Required parameter $settled follows optional parameter $customer_id in .../frontaccounting/sales/includes/db/custalloc_db.inc on line 101 
Deprecated: Required parameter $data follows optional parameter $key in .../frontaccounting/includes/db/class.data_set.inc on line 100 
Deprecated: Required parameter $sales_account follows optional parameter $units in .../frontaccounting/inventory/includes/db/items_db.inc on line 12 
Deprecated: Required parameter $date_ follows optional parameter $from_currency in .../frontaccounting/includes/ui/ui_view.inc on line 273

Go to forum: Report Bugs here

5 Reply by Nibbik

(10 replies, posted in Report Bugs here)

I updated to 2.4.9 and also get "Kan het repo index-bestand niet downloaden." (Dutch for cannot download repo index file".
I have php 7.3 and have OpenSSL 1.1.1f available in my php info.

What to do now?

Go to forum: Report Bugs here

6 Reply by Nibbik

(13 replies, posted in Reporting)

@apmuthu
Thank you for your comment, but please help me: I don't understand fully.
How can a duplicate line exist, as the combination $trans_type and $trans_no together is a unique identifier for a transaction? Within one transaction, if a counterparty is either a debtor or a supplier, then person_type_id cannot be 0.

By the way: first two parts are original, I only added third part for the case where counterpart is not known in debtor/supplier-administrations but is only mentioned as "miscellaneous" - in this case the original routine would not show the counterpart at all.

Yours sincerely, etc. Nibbik

Go to forum: Reporting

7 Reply by Nibbik

(13 replies, posted in Reporting)

I think I solved it with this solution
(file: frontaccounting/admin/db/transactions_db.inc, from line 115 onward):

        case ST_BANKPAYMENT :
        case ST_BANKDEPOSIT :
            $sql = "SELECT trans.debtor_no as person_id, CONVERT(debtor.name using utf8) as name
            FROM ".TB_PREF."debtor_trans trans, ".TB_PREF."debtors_master debtor
            WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
            ." AND trans.debtor_no=debtor.debtor_no
            UNION
                SELECT trans.supplier_id as person_id, CONVERT(supp.supp_name using utf8) as name
            FROM ".TB_PREF."supp_trans trans, ".TB_PREF."suppliers supp
            WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
            ." AND trans.supplier_id=supp.supplier_id
            UNION
                SELECT IF (person_type_id=0, 0 ,NULL) as person_id, 
            IF (person_type_id=0, CONVERT(person_id using utf8),NULL) as name 
            FROM ".TB_PREF."bank_trans WHERE type=".db_escape($trans_type)." 
            AND trans_no=".db_escape($trans_no);
            break;

/*            $sql = "SELECT trans.debtor_no as person_id, debtor.name as name
            FROM ".TB_PREF."debtor_trans trans, ".TB_PREF."debtors_master debtor
            WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
            ." AND trans.debtor_no=debtor.debtor_no
            UNION
                SELECT trans.supplier_id as person_id, supp.supp_name as name
            FROM ".TB_PREF."supp_trans trans, ".TB_PREF."suppliers supp
            WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
            ." AND trans.supplier_id=supp.supplier_id";
            break;
*/

Go to forum: Reporting

8 Reply by Nibbik

(2 replies, posted in Banking and General Ledger)

Solved! Thanks a lot.

Go to forum: Banking and General Ledger

9 Topic by Nibbik

(2 replies, posted in Banking and General Ledger)

Since update to version 2.4.4, on -Reconcile bank account- I only see registered Customer/Supplier relations, no Miscellaneous relations. Any information entered in Bank Deposit Entry or Bank Payment Entry under From/To-Miscellaneous-Name seems to be discarded in the reconciliation view. Same problem with -Bank Statement- (pdf/printing or Excel-sheet generation under Banking - Inquiries - Banking Reports).
The entered information is not lost, since it is shown in -Bank Account Inquiry- (under Banking - Inquiries), it's merely not shown in Reconciliation and Bank-Statement-PDFs.
How to make it being shown? It is relevant.

Go to forum: Banking and General Ledger

10 Topic by Nibbik

(1 replies, posted in Report Bugs here)

Import transactions extension version 2.4.0-5 won't start, and I discovered why:
in the file 'modules/import_transactions/hooks.php' line 7 states:
        $this->module_name = 'import_transations';
Mind the typo! Since line 19 says
$path_to_root.'/modules/'.$this->module_name.'/import_transactions.php', 'SA_CSVTRANSACTIONS');
the link to this extension in the "Banking and General Ledger" (Maintainance-tab) is corrupted and the file is not found because of this error.

When I correct the type-error on line 7 in the file 'modules/import_transactions/hooks.php' to

        $this->module_name = 'import_transactions';

the module displays normally

I would like to report this bug in the Mantis bug tracking system, but it won't let me create an account, so perhaps someone else can report it for me.

Go to forum: Report Bugs here

11 Topic by Nibbik

(2 replies, posted in Report Bugs here)

Hello there,

I would like to report a bug in the Mantis bug system, but the CAPTCHA system failes.
Instead of a picture with a code, now it says "[X] visual captcha".
How to create an account now?

Go to forum: Report Bugs here

12 Topic by Nibbik

(3 replies, posted in Wish List)

FA has a system of budgets: given entries of targets for each ledger account.
I would like to see on giving entries how the sum of that account (in current fiscal year) is doing compared to the given budget.
I need to see the budget for my decision for agreement or disagreement with an expense. Of course I can generate a report to see how I'm doing, but it would be very nice to have it available on the fly.

Go to forum: Wish List

13 Reply by Nibbik

(5 replies, posted in Wish List)

Agree - also on incoming/outgoing bank entries: please allow negative values (as long as the cumulative result of the entry isn't negative, of course).

Go to forum: Wish List