In FA 2.3.x, lines 202-206 in sales/includes/db/sales_credit_db.inc:

add_stock_move_customer(ST_CUSTCREDIT,  $credit_line->stock_id,
        key($credit_note->trans_no), $credit_note->Location,
        $credit_note->document_date, $reference, -$credit_line->qty_dispatched,
        $curr_std_cost,  0, $price,
        $credit_line->discount_percent);

are duplicately executed for $credit_type WriteOff as it is present in lines 209-213 as well.

Committed in my repo's FAMods.

@joe: can update in upstream.

In FA 2.4, there appears to be no WriteOff distinction for the $credit_type and it stands committed.

3,002

(12 replies, posted in Reporting)

This issue has been test committed out in FA 2.4 unstable repo. Please provide feedback with PHP 5.3 and MySQL 5.1.

@joe: please update the FA 2.3 repo as well if it works since we do not want the stable version to have glaring bugs such as this.

3,003

(6 replies, posted in Setup)

It is possible that the Company 0 is not the default company.
It is possible that the company prefix of '0_' may be in non default company as well.
Default company is based on $def_coy variable's value in config_db.php(attached example) file.

The example attached has the default company as 0 and the 0th element of the $db_connections array has it's tb_pref element as "0_" but this may not always be the case.

3,004

(6 replies, posted in Setup)

You can create a new company only from the default company (generally 0) in any installation. Make sure you obtain the entire sql backup from your PHP 7 upgraded server (preferably pre-upgrade state) and the stanza pertaining to the company in the config_db.php file there as that would be useful to restore in the PHP 5 server instance.

I assume you are using FA v2.3.25 as the Assets tab is missing.

You want to make a Bank Payment Entry and have the reference entered into a separate form field in the Journal Entry Page. How would you know which Bank payment entry's reference you want in the Journal Entry? If it is part of the same transaction, read it from the appropriate table's field directly without having it redundantly stored.

You can also have the additional reference as part of the appropriate Memo form field.

You can use the Tags feature to link various transactions as a group.

3,006

(12 replies, posted in Reporting)

Translate the Arabic CoA into English and compare with the equivalent en_US one.

Your steps are okay.

Try the en_US-demo.sql and see if the error appears.

3,007

(12 replies, posted in Reporting)

Which version of FA are you using on what versions of PHP/MySQL and what platform?
What menu navigation steps did you use to achieve your output?

Whether Bank Payment or Customer Payment / Allocation was used?

Attached you output for forum self-sufficiency.

The Training Company (Demo Data)'s Customer Balance Report 101 is what you should have unless you customised your report and/or are using an older version of FA.

3,008

(4 replies, posted in Installation)

Whilst the Joomla project in it's latest avatar is being built for PHP7, the stable FA (v2.3.25+) is built for PHP 5.3.x and works with thru till PHP 5.6 without issues. Some users have tweaked FA to work with PHP 7 and later versions of MySQL (v5.7+) as well. Some tweaks to the Chart of Accounts will be necessary for MySQL 5.7 onwards unless the strict mode for dates is disabled.

Please note that using the appropriate version of PHP for which the application is designed will have the least issues in it's install / operation. The latest and greatest version of PHP / MySQL may not be appropriate in most cases of legacy software. Stable and proven versions and code you can understand and tweak yourself is one way forward that many will profess to.

Till this is done, try to get hold of one set of transactions' sql inserts / updates and make an sql for creating a new supplier invoice/goods_receipt/payment from the differences in the sql backups before and after it and use that in any mysql client when operating in exclusive mode during that time.

3,010

(4 replies, posted in Setup)

In the latter case of separate db / setups, the consolidation will have to be manual for the Head Office accounting.

Lines 40-41 of the file gl/view/gl_trans_view.php:

    label_cell($myrow["reference"]);
    label_cell(sql2date($myrow["tran_date"]));

can now be changed to

    label_cell($myrow["reference"], "nowrap align=center ");
    label_cell(sql2date($myrow["tran_date"]), "nowrap align=center ");

to center the Reference and Date field values.

FA 2.3.25+

Banking & GL => View or Print Transactions => Show GL

The attachment here shows the standard output when the original gl/view/gl_trans_view.php is used.

Note that the values for the Reference and Date columns are left aligned.

You are on your own if you try to run FA stable on PHP 7 though the wiki and the forum have pointers to others efforts. Later versions of MySQL have the non zero date issue as well where the '0000-00-00 00:00:00' and '0000-00-00' are not accepted in datetime / timestamps.

Also check the cache of your browser and make sure it is cleared on exit and the new user logs in from a new instance of the browser after all instances have been closed.

Last transaction template entry in Quick Entries must be "Remainder" type.
The above does not need fixing.

Quick Entry for Bank Payment does not populate Amount in Payment Entry Form.

https://github.com/FrontAccountingERP/FA/issues/21

FY 2015 was opened and a single Journal Entry was made for the closing Balance Sheet Entries.

Bank Statement Page attached shows redundant Zero entries.

https://github.com/FrontAccountingERP/FA/issues/22

3,017

(1 replies, posted in Accounts Payable)

1. Take a sql backup.
2. perform your FA Transaction
3. Take another sql backup
4. Compare both backups using diff in Linux or WinMerge in Windows.
5. You will have all the sqls that have occurred / db changes for the transaction.

When you complete a FA transaction, you will see a link to the Journal Entries.

Payable / Procure to Pay (P2P) is a SAP term.

Provide screenshot of what you want. Cannot understand you. All form elements code are common to entire FA. Which version of FA are you on and what platform?

3,019

(1 replies, posted in Setup)

Where? Did you mean CustomerID on Customer List Report?

3,020

(5 replies, posted in Reporting)

Please read @joe's post. There is a need for Header3 instead of the standard Header1 that is used.
Study the custom reports and do likewise.

This means that either you
1. skipped the install process or
2. your folder permissions did not allow the creation of the file /lang/installed_languages.inc during the install process or
3. Your path to webroot is wrongly set somewhere possibly in the extension's files.

A sample /lang/installed_languages.inc file would be like:

<?php

/* How to make new entries here for non-packaged languages:

-- 'code' should match the name of the directory for the language under \lang
.-- 'name' is the name that will be displayed in the language selection list (in Users and Display Setup)
-- 'rtl' only needs to be set for right-to-left languages like Arabic and Hebrew
-- 'encoding' used in translation file
-- 'version' always set to '' for manually installed languages.
-- 'path' installation path related to FA root (e.g. 'lang/en_US').
*/


$installed_languages = array (
  0 => 
  array (
    'code' => 'C',
    'name' => 'English',
    'encoding' => 'iso-8859-1',
  ),
);

$dflt_lang = 'C';

3,022

(14 replies, posted in Report Bugs here)

In general, yes. Sometimes there may be glitches in upgradation and user testing reports will help iron out such bugs.

As FA 2.4 is the unstable and development version, when new features are needed or issues addressed, it may require database structure  and/or data changes. Such changes are generally placed in an alter sql/php file in the sql folder that may need to be executed manually (with care as to the db_prefix) or possibly through the web interface - Setup -> Software Upgrade. The best way is to manually execute the changes in a MySQL client, line by line on a backup of the database first and then perform the actions on the live one - YMMV.

No.

3,024

(5 replies, posted in Reporting)

A case insensitive search for the word companylogoenable shows that it is present only in reporting/includes/pdf_report.inc among the core FA files. The class member is populated inside the class method Info() only.

A similar search into the extensions shows that the custom report extensions set it from within the reports as in:

rep_annual_balance_breakdown/reporting/rep_annual_balance_breakdown.php
rep_annual_expense_breakdown/reporting/rep_annual_expense_breakdown.php
rep_cash_flow_statement/reporting/rep_cash_flow_statement.php

In the above files, the following code ensues:

..
..
$companylogoenable = true;
..
..
$rep->Info($params, $cols, $headers, $aligns, $cols2, $headers2, $aligns2, $companylogoenable, $footerenable, $footertext);
$rep->SetHeaderType('Header3');
..
..

The dummy empty class method Header1() is present in reporting/includes/class.pdf.inc and not defined in the pdf_report.inc file.

The class method Header1() is defined in the TCPDF class in reporting/includes/tcpdf.php.

No approvals in default FA.
All entries stand posted on creation.