Page Size should be either A4 or Letter
5,252 12/29/2013 04:35:39 am
Re: how do we deal with default payment (10 replies, posted in Accounts Receivable)
Yes, and collect the money off the account books into your pocket! The boss will never know 
Nice work. Good Standard Operating Procedure, provided that good people manage the books and those who pay their debts after a long time do so with a view to continue to do business and not for merely avoiding long term legal hassles. That way jest above will not become real.
5,253 12/28/2013 04:31:28 pm
Re: PNG Logo format not accepted (3 replies, posted in Report Bugs here)
The affected file for company is: admin/company_preferences.php
On checking the code, only .jpg seems to be referenced everywhere for display usage.
The above anomaly will probably be there for stock item images as well and the affected file here is: inventory/manage/items.php.
The help strings indicating file types other than .jpg to be allowed for upload are in the language .po files.
The stock item image file is referenced as .jpg in
reporting/rep104.php and
reporting/rep303.php
The database entry in sql/en_US-demo.sql refers to the company logo as:
INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');5,254 12/27/2013 04:08:48 pm
Re: One installation with multiple subdomain (4 replies, posted in Installation)
1. Create an FA instance in one folder not allocated to any domain.
2. Symlink the files and folders to each of the domains' web roots.
3. Keep a separate database and config file in each domain web root folder.
4. Keep a separate company folder for each company in each domain but keep the default company 0 symlinked in all domains so as to be able to administer it from each domain as well.
5. Make necessary entries in each domain's virtual host fragments
6. Make an archive of all symlinked files for rapid creation of FA instance in each new domain.
This can be the basis for an FA Farm.
5,255 12/26/2013 04:07:06 pm
Re: void a transaction error (4 replies, posted in Installation)
Why don't you try the latest codebase from the mercurial repo or just use the difference file set to overwrite the v2.3.19 files?
Attached is the changed fileset after v2.3.19 was released.
Only one sql command needs to be executed on the existing db (change 0_ to whatever your company # is):
ALTER TABLE `0_debtor_trans` ADD INDEX `Order` (`order_`);5,256 12/25/2013 07:01:01 am
Re: void a transaction error (4 replies, posted in Installation)
The function get_bank_trans() in lines 66 to 91 in the file gl/includes/db/gl_db_bank_trans.inc has the stated SQL construct.
It is possible that some data may have not had the desired effect on being db_escaped.
Lines 77-79:
LEFT JOIN ".TB_PREF."suppliers supplier ON supplier.supplier_id = st.supplier_id,
".TB_PREF."bank_accounts act
WHERE act.id=bt.bank_act ";may be changed to:
LEFT JOIN ".TB_PREF."suppliers supplier ON supplier.supplier_id = st.supplier_id
LEFT JOIN ".TB_PREF."bank_accounts act ON act.id=bt.bank_act
WHERE 1 ";Try and let us know if this solves your issue. It may be a better construct anyway.
5,257 12/25/2013 06:42:37 am
Re: statement pdf (1 replies, posted in Report Bugs here)
You seem to have changed:
$cols = array(4, 100, 130, 190, 250, 320, 385, 450, 515);to
$cols = array(4, 90, 150, 210, 250, 320, 385, 450, 515);Notice that a sum of 10+10 units have been increased whilst the others have increased for columns 2 and 3 whilst column 5 has been shortened by 20 units - hope the output is acceptable.
5,258 12/21/2013 03:24:30 am
Re: PDF reports has stopped working (5 replies, posted in Reporting)
The default language is "C" / "POSIX" in FA
5,259 12/21/2013 03:22:42 am
Re: modification new company registration (1 replies, posted in FA Modifications)
That is a functionality of the apache config and possibly a setting in the config file.
5,260 12/21/2013 03:20:56 am
Re: Import Multiple Journal Entries results in "Internal Server Error" (3 replies, posted in Modules Add-on's)
Check your apache error logs for more info
5,261 12/21/2013 03:19:20 am
Re: Install/Update Languages&Install/Activate extensions: Could not open (2 replies, posted in Setup)
write permissions on the modules and tmp folder?
5,262 12/21/2013 03:18:12 am
Re: mageia3 (1 replies, posted in Setup)
The new Linux Distribution Mageia 3 - is it based on debian or RHEL or BSD?
5,263 12/21/2013 03:11:04 am
Re: Large number of items problem (3 replies, posted in Items and Inventory)
Probably just a browser cache issue.
5,264 12/21/2013 03:09:54 am
Re: Urgently Needed ! expert FA developer to solve issues in new module !! (3 replies, posted in Jobs wanted/offered, non-free offers)
Please fork my FA on GitHub (or the official one) and post your extension there. That way, the community will be able to help you and it can be improved by suggestions from the community besides many eyeballs on the testing front.
5,265 12/21/2013 03:06:02 am
Re: LDAP binding error. (1 replies, posted in Installation)
Please verify that you are using the latest LDAP - the individual files are available in my personal GitHub Repo.
5,266 12/21/2013 03:04:02 am
Re: attachments file view (7 replies, posted in Report Bugs here)
Thanks Joe - fixed in this commit.
5,267 12/10/2013 03:40:30 am
Re: openning balance (3 replies, posted in Banking and General Ledger)
Enter one Journal Voucher with all Balance Sheet Entries (amounts) in detail dated the beginning of the Fiscal Year (close of last Balance Sheet).
5,268 12/10/2013 03:33:33 am
Re: Indonesian Translation (13 replies, posted in Translations)
The current translation files are available at my GitHub Repo as of 2013-12-03 PKG file.
5,269 12/10/2013 03:28:59 am
Re: attachments file view (7 replies, posted in Report Bugs here)
My last post is not a new function but a rehash of the existing function to avoid redundant passes.
The diff patch for the latest Hg is:
--- old/admin/db/fiscalyears_db.inc Wed Nov 06 16:43:56 2013
+++ new/admin/db/fiscalyears_db.inc Tue Dec 10 08:53:50 2013
@@ -190,11 +190,15 @@
$sql = "SELECT * FROM ".TB_PREF."attachments WHERE type_no = $type_no AND trans_no = $trans_no";
$result = db_query($sql, "Could not retrieve attachments");
+ $delflag = false;
while ($row = db_fetch($result))
{
+ $delflag = true;
$dir = company_path(). "/attachments";
if (file_exists($dir."/".$row['unique_name']))
unlink($dir."/".$row['unique_name']);
+ }
+ if ($delflag) {
$sql = "DELETE FROM ".TB_PREF."attachments WHERE type_no = $type_no AND trans_no = $trans_no";
db_query($sql, "Could not delete attachment");
} 5,270 12/08/2013 10:05:23 am
Re: Missing system locale: nl_NL.iso-8859-1 (3 replies, posted in Translations)
Clearing the server and browser cache could well have had the same effect or atleast a restart of the webserver process. Hope you have your locale installed as well.
5,271 12/08/2013 10:03:07 am
Re: Validate fields: sales_order_entry.php modification (8 replies, posted in Accounts Receivable)
Instead of hidden names in the form, why not lookup the names from the db in the processing code?
5,272 12/08/2013 10:00:37 am
Re: Remove some items from setup tab (13 replies, posted in FA Modifications)
Can experiment with a separate restricted mysql username and password to use for all others, other than for super admin and use it by switching in the config file.......
5,273 12/08/2013 09:57:04 am
Re: internet explorer & ajax (2 replies, posted in Report Bugs here)
Methodology for module development on GitHub is in the Wiki.
5,274 12/08/2013 09:55:39 am
Re: Searching Modification (1 replies, posted in FA Modifications)
USe the tab key to get to the button and then press space or enter key
5,275 12/08/2013 09:51:14 am
Re: attachments file view (7 replies, posted in Report Bugs here)
Line 193 in admin/db/fiscalyears_db.inc :
while ($row = db_fetch($result))will make sure that all pertinent ids will be deleted one at a time, but in the existing code, all pertinent ids will get deleted in the first pass and then be redundantly executed thereafter.
To truly benefit from a single pass deletion, the function would have to be structured thus:
function delete_attachments_and_comments($type_no, $trans_no)
{
$sql = "SELECT * FROM ".TB_PREF."attachments WHERE type_no = $type_no AND trans_no = $trans_no";
$result = db_query($sql, "Could not retrieve attachments");
$delflag = false;
while ($row = db_fetch($result))
{
$delflag = true;
$dir = company_path(). "/attachments";
if (file_exists($dir."/".$row['unique_name']))
unlink($dir."/".$row['unique_name']);
}
if ($delflag) {
$sql = "DELETE FROM ".TB_PREF."attachments WHERE type_no = $type_no AND trans_no = $trans_no";
db_query($sql, "Could not delete attachment");
}
$sql = "DELETE FROM ".TB_PREF."comments WHERE type = $type_no AND id = $trans_no";
db_query($sql, "Could not delete comments");
$sql = "DELETE FROM ".TB_PREF."refs WHERE type = $type_no AND id = $trans_no";
db_query($sql, "Could not delete refs");
}