5,251

(4 replies, posted in Setup)

Any of the professional support consultants can help you. Check out the Support page in the Wiki.

5,252

(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

(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.

Thankyou for the link. I have included it in the main Wiki Page - Accounting Primers

5,255

(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.

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

(10 replies, posted in FA Modifications)

Try all lowercase and switching quotes:

echo '<meta http-equiv="refresh" content="20; url=' . $forward_to . '?' . $params . '">' . "\n";

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

(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.

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?

Get an accountant or become one by mastering this tutorial.

5,262

(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?

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

(17 replies, posted in FA Modifications)

MySQLi vs. PDO_mysql

Any reason for capitalising the DB in DB_escape_string() function name?

5,265

(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

(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

(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

(4 replies, posted in Setup)

Thanks. Wiki-ed it.

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

(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.

Updated my personal GitHub Repo.

Patch attached here.

5,272

(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

(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

(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

(2 replies, posted in Setup)

It is possible you overwrote your config.php file