Any of the professional support consultants can help you. Check out the Support page in the Wiki.
5,252 12/01/2013 03:04:46 am
Re: Currency And Tax (4 replies, posted in Setup)
There is only one stable community supported version (now at v2.3.19+) of FrontAccounting for all to use. There is no Professional version but a Beta / unstable / testing version of the 2.4 stream is available.
What version of FA are you using now? Or are you using some other accounting software (which)?
You can use the Assembly/Kit concept of Front Accounting. You can choose to define a Zero Tax associated with all products.
Wish every country was like Dubai as far as tax is concerned - each individual's business should be no one else's business, not even the governments' as well. Blundering bureaucrats and greedy politicians would soon be history! No, alas, the power to wage war and rule by instilling fear in the citizens would still make it attractive for them to survive....
"When you see that in order to produce, you need to obtain permission from (wo)men who produce nothing - When you see that money is flowing to those who deal, not in goods, but in favors - When you see that (wo)men get richer by graft and by pull than by work, and your laws don’t protect you against them, but protect them against you - When you see corruption being rewarded and honesty becoming a self-sacrifice - You may know that your society is doomed." -- Ayn Rand, "Atlas Shrugged", 1957
5,253 11/30/2013 02:51:30 pm
Re: Printing in FA (3 replies, posted in Setup)
Linux CUPS printing is used on the server and any printer capable of CUPS interfacing can be entered in the printing profile setup in FA and then used in the logged in user's printer profile.
5,254 11/30/2013 02:48:33 pm
Re: Meanings of values in System and General GL Setup (5 replies, posted in Setup)
Thankyou for the link. I have included it in the main Wiki Page - Accounting Primers
5,255 11/30/2013 02:20:39 pm
Re: meta_forward (10 replies, posted in FA Modifications)
Clear Browser cache and server cache - company/#/js/*.js and the template cache on the server and try it by logging in freshly - no stale sessions.
5,256 11/29/2013 04:07:53 pm
Re: Meanings of values in System and General GL Setup (5 replies, posted in Setup)
Here may be some more waste of your time - have you tried the Wiki's config page? Please explain what you would like to see explained better in the Wiki's Systema and GL Setup page? It certainly is not a tutorial on Accounting principles which I'm sure you know is outside the scope of this application's knowledgebase.
5,257 11/29/2013 03:58:04 pm
Re: meta_forward (10 replies, posted in FA Modifications)
Try all lowercase and switching quotes:
echo '<meta http-equiv="refresh" content="20; url=' . $forward_to . '?' . $params . '">' . "\n";
5,258 11/29/2013 05:28:41 am
Re: check-box to select multiple options for deletions (12 replies, posted in FA Modifications)
1. Take a backup of the company sql from the gui.
2. Delete one product from gui
3. Take another backup of the comapny sql from the gui
4. Compare the differences between the sql dumps
5. Make an ALTER / DELETE set of constructs to go from one to the other sql state
Post your findings and then we can try to accomodate your request in the best way possible.
Quite a few updates from the forums are still pending with the devs as they are possibly busy. One such update to the FA core is in my personal repo at https://github.com/apmuthu/frontaccounting and has yet to be included in the mainstream.
5,259 11/29/2013 05:19:57 am
Re: meta_forward (10 replies, posted in FA Modifications)
If it is called by ajax, then each ajax call will appear at the frequency by which it is called.
5,260 11/29/2013 05:17:19 am
Re: Tax problem for implement FrontAccounting in my country (7 replies, posted in Accounts Receivable)
These are what we refer to as price inclusive of taxes and these taxes are non cascading (levied on the same base amount). If you make one tax as (IT+IVA) as 16% and make it as tax inclusive on price, then when you enter 100 as the price, automatically it would split it up into 86.21+13.79=100 where 13.79 will be the 16% of the base value of 86.21. I do not recollect offhand if two such taxes on the same base amount for a single product is available in FA - possibly so - Joe/Janusz?
5,261 11/29/2013 05:12:44 am
Re: Meanings of values in System and General GL Setup (5 replies, posted in Setup)
Get an accountant or become one by mastering this tutorial.
5,262 11/28/2013 02:51:55 pm
Re: meta_forward (10 replies, posted in FA Modifications)
In the said file includes/ui/ui_control.inc did you alter line 138:
echo "<meta http-equiv='Refresh' content='0; url=$forward_to?$params'>\n";
to be
echo "<meta http-equiv='Refresh' content='20; url=$forward_to?$params'>\n";
?
What did you want to achieve?
The function meta_forward() is used in 32 files in FA - which one are you referring to?
5,263 11/28/2013 02:45:19 pm
Re: check-box to select multiple options for deletions (12 replies, posted in FA Modifications)
Products can have attributes and values. They can also be already used as part of some invoices. Do you want to cascade deletes across invoices or orphan them? FA is not just a CRUD (Create, Replace, Update and Delete) front-end. It is a full fledged Financial Accounting and basic ERP package.
5,264 11/24/2013 09:13:41 pm
Re: mysqli usage (17 replies, posted in FA Modifications)
Any reason for capitalising the DB in DB_escape_string() function name?
5,265 11/24/2013 12:19:18 pm
Re: attachments file view (7 replies, posted in Report Bugs here)
This is a useful addition to the FA core. Hope Joe/Janusz add it.
Also since the function delete_attachment($id) is available in the said file admin/db/attachments_db.inc, it can be used in admin/db/fiscalyears_db.inc to replace lines 198-199 in function delete_attachments_and_comments():
$sql = "DELETE FROM ".TB_PREF."attachments WHERE type_no = $type_no AND trans_no = $trans_no";
db_query($sql, "Could not delete attachment");
with
delete_attachment($row['id']);
provided the file admin/db/attachments_db.inc has been included beforehand.
Furthermore, the error strings in admin/db/attachments_db.inc need to get into the translation files (*.po/*.mo) as well.
5,266 11/24/2013 11:40:41 am
Re: Cannot place a Purchase Order (19 replies, posted in Accounts Payable)
The relevant lines in the respective COAs and existing installs should be line:
INSERT INTO `0_sys_prefs` VALUES ('no_item_list', 'setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES ('no_customer_list', 'setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES ('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
5,267 11/24/2013 10:55:31 am
Re: Sorting Item List (8 replies, posted in Setup)
Which is the wiki page?
* Wiki Page Item - Add an option to sort item lists by item name
// To Joe/Janusz
Should it not be part of the core FA by being a config flag to switch between them?
5,268 11/24/2013 10:52:04 am
Re: How to Email Purchase Orders (4 replies, posted in Setup)
Thanks. Wiki-ed it.
5,269 11/24/2013 10:37:45 am
Re: Better UI for customer management (mockup inside) (11 replies, posted in Wish List)
Multiple Search boxes to be strung together with "and/or" would be useful too.
The Amazon Account Number could be in another table related to the customer table (more than one Amazon Account Number per client) and the module made into an extension so that it may be installed at will without disturbing the existing schema.
5,270 11/22/2013 06:46:22 am
Re: Customisation on Upgrade (4 replies, posted in Modules Add-on's)
Easiest is to setup an account in GitHub and fork my repo - it has the extensions as well but not the unstable version nor does it have a commit by commit differential though it sports a release to release commit differential.
Use TortoiseGit on your Windows PC and synch with your read/write Github (or official Git readonly) repo.
To synch with the pristine Mercurial repo, use TortoiseHg on your Windows PC and synch with it albeit in readonly mode.
5,271 11/22/2013 06:38:03 am
Re: Slow query in Invoice Against Sales Delivery menu (3 replies, posted in Report Bugs here)
Updated my personal GitHub Repo.
Patch attached here.
5,272 11/21/2013 06:06:51 pm
Re: New Version 2.3.19 (10 replies, posted in Report Bugs here)
Check if the modules/_cache is writeable by the webserver process.
To do it manually, follow instructions in the Wiki.
5,273 11/21/2013 06:03:00 pm
Re: supplier payment (5 replies, posted in Report Bugs here)
Yes it is fixed in the HG Repo and the consolidated list of files have been uploaded in the Release Posting.
https://frontaccounting.com/punbb/viewtopic.php?pid=18494#p18494
5,274 11/21/2013 05:52:38 pm
Re: supplier payment (5 replies, posted in Report Bugs here)
Function Lines 14 to 26 in purchasing/includes/db/suppalloc_db.inc are called in files includes/ui/allocation_cart.inc (lines 203-205) and purchasing/includes/db/invoice_db.inc (lines 357-358) and are:
function add_supp_allocation($amount, $trans_type_from, $trans_no_from,
$trans_type_to, $trans_no_to, $date_)
{
$date = date2sql($date_);
$sql = "INSERT INTO ".TB_PREF."supp_allocations (
amt, date_alloc,
trans_type_from, trans_no_from, trans_no_to, trans_type_to)
VALUES (".db_escape($amount).", '$date', "
.db_escape($trans_type_from).", ".db_escape($trans_no_from).", "
.db_escape($trans_no_to).", ".db_escape($trans_type_to).")";
db_query($sql, "A supplier allocation could not be added to the database");
}
Somewhere the date2sql() function seems to fail or the $date_ variable does not have any value and no default is available.
5,275 11/21/2013 05:28:01 pm
Re: Upgrade problems (2 replies, posted in Setup)
It is possible you overwrote your config.php file