The dropdown theme is the one in the official repo for FA 2.4. Must it not match the one in the FA 2.4 repo too?
@boxygen: are you using the said theme in FA 2.3.x or in FA 2.4.x - the file path in the errors states fa24?
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
The dropdown theme is the one in the official repo for FA 2.4. Must it not match the one in the FA 2.4 repo too?
@boxygen: are you using the said theme in FA 2.3.x or in FA 2.4.x - the file path in the errors states fa24?
The add_access_extensions() is missing in a few themes such as this and was causing missing security access permissions for extensions if they exist and such a theme was chosen. Since dropdown is a core theme it should work flawlessly regardless of whether any extension is loaded or not.
You must take a backup each year. Then close the year and take another backup and then purge it and start your new year. Keep atleast one previous fiscal years data for reference and awaiting closure while the new year is online. Dont forget to backup the entire web install folder as well since it will have the item images and attachments too (company/#/*).
There is a higher probability of large databases getting corrupt more frequently than smaller ones that are properly indexed.
Whenever you need to check on older years that have since been purged, just restore them into some other cloud instance and restore from the backups and view it!
Note that the fiscal years table must have the id in sequence without any gaps and must match the Start Date order as well, otherwise closure and purging will hang / get corrupted.
Yes, you are right. There is a bug in line 173 of sales/inquiry/customer_inquiry.php which is:
if ($_POST['customer_id'] != ALL_TEXT && $_POST['filterType'] == '2')and it should be:
if ($_POST['customer_id'] != "" && $_POST['customer_id'] != ALL_TEXT)There is no use in checking for filterType=2 (Unsettled Transactions) to deny display of summary info of customer. Reverting it to the sane code as in FA 2.3 rectifies it as above.
Yes the same exists in line 156 in purchasing/inquiry/supplier_inquiry.php:
if ($_POST['supplier_id'] != ALL_TEXT && $_POST['filterType'] == '2')and it should be:
if (($_POST['supplier_id'] != "") && ($_POST['supplier_id'] != ALL_TEXT))@joe: can commit it.
The customer summary was just occupying top space which was re-allocated for more records below. ![]()
The Preferences Tamil page is attached.
There is no need to check for !$no_menu again as we are already inside an if which has already done so.
Also, the add_access_extensions(); is placed between the two divs of class fa-body and fa-content like in the other themes. If done earlier, what happens was not determined. As it is an independent check, the earlier the better but it should have necessary pre-requisites to perform it's job. If we retain it as you suggested, we lose the graphic plot display in the dashboards.
Attached is the latest version.
What about the default dropdown theme in FA 2.4.x?
@joe: must some reconciliation be done between the two?
When using the FA24Extensions repo (or any Git repo), if you want just one extension, it is advisable to paste the folder URL into GitZip to get it. It is written using jQuery and is available on GitHub.
http://kinolien.github.io/gitzip/
To vreate a download link to a specific Git subfolder, paste the URL into DownGit and get it. It is written in javascript and is available on GitHub.
https://minhaskamal.github.io/DownGit/#/home
The php-gettext wrapper project is useful for Windows Users who do not have the appropriate locale installed or gettext is not compiled in.
See the comment there.
For those who do not wish to use composer, there is a testgt folder in the attachment that merely uses normal file includes.
Walk thru the various language versions in my FA24extensions/Languages repo with:
find */_init -name config -type f -exec grep ^Version '{}' \;@itronics: Thanks for heeding this long pending request.
FA's official pkg repo now has both Tamil (ta_IN) and Hindi (hi_IN) translations of the core.
Use the GL Inquiry if you want Bank Payment and Deposit entries.
Use Tax Inquiry only for the Taxes alone.
Use this file and see (rename as php and use) for dropdown theme.
Lines 163-164:
echo "<div class='fa-body'>\n";
echo "<div class='fa-content'>\n";have been replaced with:
echo "<div class='fa-body'>\n";
if (!$no_menu)
add_access_extensions();
echo "<div class='fa-content'>\n";Schema update / synch scripts added to my repo - FA23, FA24.
FA 2.4 Schema optimisations consolidated
- @joe/@itronics can vet it for inclusion in the core.
The Dropdown theme was not updated by the author.
It is based on the Dynamic theme.
Compare the files between the two if you have issues.
Attached is the Dropdown theme after making $SysPrefs fixes.
Updated in my FA24Extensions Repo.
In MySQL 5.0 and later, TEXT/BLOB fields cannot have default values.
The only case in FA where it occurs is in the sys_prefs table and that too only in FA 2.4.x:
`value` TEXT NOT NULL DEFAULT '',It should be:
`value` TEXT NOT NULL,In FA 2.3.x it was:
`value` tinytext,There is no constant SA_CSVIMPORT in any of the themes and the FA core. It is possible you got it from one of your extensions or the official import_items extension. My extensions repo has the updated files (attached) for the official extension and see if they mitigate your issue.
After cleaning up the entire standard Chart of Accounts, we are left with the following CHAR fields (whilst all else have been mostly changed to VARCHAR):
0_bank_accounts: `bank_curr_code` char(3) NOT NULL DEFAULT '',
0_crm_persons: `lang` char(5) DEFAULT NULL,
0_currencies: `curr_abrev` char(3) NOT NULL DEFAULT '',
0_debtors_master: `curr_code` char(3) NOT NULL DEFAULT '',
0_exchange_rates: `curr_code` char(3) NOT NULL DEFAULT '',
0_journal: `currency` char(3) NOT NULL DEFAULT '',
0_prices: `curr_abrev` char(3) NOT NULL DEFAULT '',
0_stock_category: `dflt_mb_flag` char(1) NOT NULL DEFAULT 'B',
0_stock_master: `mb_flag` char(1) NOT NULL DEFAULT 'B',
0_stock_master: `depreciation_method` char(1) NOT NULL DEFAULT 'S',
0_suppliers: `curr_code` char(3) DEFAULT NULL,Attachments are a privilege permission set by the board admin.
Screenshots of web pages with mostly text are best captured in PNG format for small size and less pixelation on enlargement.
Void the Supplier Credit Note in the Setup tab and then enter a new one.
The existing SQL to debug is:
SELECT
SUM(IF(trans_type=21,-1,1) *
IF((reg_type=0) || ((trans_type IN (20,21) OR (trans_type=0 AND reg_type=1))
), net_amount*ex_rate,0)
) net_output
, SUM(IF(trans_type=21,-1,1) *
IF((reg_type=0) || ((trans_type IN (20,21) OR (trans_type=0 AND reg_type=1))
), amount*ex_rate,0)) payable
, SUM(IF(trans_type IN (21),-1,1) *
IF(reg_type=1 AND tax_type_id AND taxrec.rate, net_amount*ex_rate, 0)) net_input
, SUM(IF(trans_type IN (21),-1,1) *
IF(reg_type=1 AND tax_type_id AND taxrec.rate, amount*ex_rate, 0)) collectible,
taxrec.rate,
ttype.id,
ttype.name
FROM 0_trans_tax_details taxrec LEFT JOIN 0_tax_types ttype ON taxrec.tax_type_id=ttype.id
WHERE taxrec.trans_type IN (10, 11, 20, 21, 0)
-- AND taxrec.tran_date >= '$fromdate'
-- AND taxrec.tran_date <= '$todate'
GROUP BY ttype.id;All numbers/prices/amounts are entered as is and then the system formats it as needed.
The home currency is assumed.
input_num may be needed.
@joe: does it need to change?
Close your previous fiscal years and purge them of their data.
This issue does not prevail in FA 2.3 and hence the above fix only addresses the output and not the underlying db fetch function in FA 2.4. Attached is the FA 2.3 output without the above fix and it works perfectly.
Therefore the function get_tax_summary() in gl/includes/db/gl_db_trans.inc needs to be investigated and it is different from it's FA 2.3 counterpart.
The new avatar has an extra parameter $also_zero_purchases set to false by default.
Consequent on this commit, all existing DBs may be updated with:
ALTER TABLE `0_debtor_trans`
CHANGE `debtor_no` `debtor_no` INT(11) UNSIGNED NOT NULL,
DROP PRIMARY KEY, ADD PRIMARY KEY (`trans_no`, `type`, `debtor_no`);
ALTER TABLE `0_supp_trans`
CHANGE `supplier_id` `supplier_id` INT(11) UNSIGNED NOT NULL,
DROP PRIMARY KEY, ADD PRIMARY KEY (`trans_no`, `type`, `supplier_id`); Good catch @andijani.
The Tax Inquiry page is at gl/inquiry/tax_inquiry.php. and it's line 91:
$collectible = $tx['collectible'];should be:
$collectible = -$tx['collectible'];If the Outputs/Inputs column too should get the appropriate signs, then make line 104 show the negative value.
This issue prevails in FA 2.3.x (line 95) as well and wonder how it went unchecked for so many years.
@joe: can commit it.
The translations will be available when the lang/new_language_template/LC_MESSAGES/empty.po is refreshed in the next release. In the meanwhile you are free to change your .po file and compile it into a .mo file and use it.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.