Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 212 of 247)
Topics by apmuthu User defined search
Posts found: 5,276 to 5,300 of 6,171
As far as maintaining the software is concerned, in an Open Source project, the onus would devolve on the the members of the community of users generating a gradient for increasing the numbers of those who make quality code shares and support experiences. Joe/Janusz have done a commendable job thus far and my efforts have been to provide the extensions files for easier forking and parallel development. The alter2.3.sql is useful for existing CoAs only and existing upgrade environs - the last line in the file is the onlly one added now. The new en_US and en_US-demo sqls already have them (from the Hg/Git repo)
Please state the steps starting from the install choices and the menu navigations and work done in reaching your error status chronologically. This will help solve the issue.
Make sure that the exchange rates for the currencies involved in the transaction pre-date the transaction envisaged.
Please overwrite files in your latest install with the Post Releases Fixes from:
https://frontaccounting.com/punbb/viewtopic.php?pid=18849#p18849
Now try again and see what gives.
All Current HG Repo fixes till 2014-01-04 with full slow query fix is available in the attachment to this post.
Page Size should be either A4 or Letter
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.
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');
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.
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_`);
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.
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.
The default language is "C" / "POSIX" in FA
That is a functionality of the apache config and possibly a setting in the config file.
Check your apache error logs for more info
write permissions on the modules and tmp folder?
The new Linux Distribution Mageia 3 - is it based on debian or RHEL or BSD?
Probably just a browser cache issue.
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.
Please verify that you are using the latest LDAP - the individual files are available in my personal GitHub Repo.
Thanks Joe - fixed in this commit.
Enter one Journal Voucher with all Balance Sheet Entries (amounts) in detail dated the beginning of the Fiscal Year (close of last Balance Sheet).
The current translation files are available at my GitHub Repo as of 2013-12-03 PKG file.
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");
}
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.
Instead of hidden names in the form, why not lookup the names from the db in the processing code?
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.......
Posts found: 5,276 to 5,300 of 6,171
