It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
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
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?
Where? Did you mean CustomerID on Customer List Report?
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';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.
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.phpIn 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.
Provide screenshot of existing and wished for ...
It will not be an ERP then. Might as well have ExcelAccounting....
Make one entry for each item....... 
@joe: any help?
The FrontReport class property $companyLogoEnable needs to be enabled. It is false by default in it's class method Info().
In most if not all reporting/repXXX.php files there will be a line like:
$rep->Info($params, $cols, $headers, $aligns);Just change it to:
$rep->Info($params, $cols, $headers, $aligns, , , true);The actual prototype for it is:
function Info($params, $cols, $headers, $aligns,
$cols2 = null, $headers2 = null, $aligns2 = null,
$companylogoenable = false, $footerenable = false, $footertext = '')@joe: Should we not have a config file switch for it or atleast a preference setting on a per company basis?
1. Advance paid
2. Invoice generated and payment allocated / receipt generated.
https://frontaccounting.com/punbb/viewtopic.php?id=4382
https://frontaccounting.com/fawiki/uploads/Help/FA_PrePaid_Payments.pdf
Actually FA 2.4RC1 is already used in production by quite a few users. You will ofcourse need to be aware that database changes will possibly devolve in time for this branch though upgrade paths will exist for standard installs (but not guaranteed for the extensions).
The latest code for this branch is available here.
You can choose whichever method by passing the payment voucher or creating the invoice on the appropriate date.
Which features in FA do it automatically that affects the reporting for each method?
SMS Gateway software are available in the open source domain as well - kannel.org.
Thanks @joe.
@itronics committed it on 2015-07-10.
This now stands cross referenced. The name field / column can be backquoted in the sql.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.