2,101

(4 replies, posted in Reporting)

The said error can come in when the "Preferences" link (Setup => Display Setup) cannot be saved since there would have been no Profit & Loss Account defined or defined wrongly (line 66 of admin/gl_setup.php).

This error can also come when a fiscal year is closed without any Profit & Loss Account defined as seen in line 137 of admin/db/fiscalyears_db.inc.

Assume you are using FA 2.4.x.

Which Chart of Accounts did you start with?

Upgrade to FA 2.4.3+ latest codebase along with the fix for backups and see if the same issue remains. This issue was fixed in a commit on 2017-10-10 which was way after FA v2.4.2 was released but a month before FA 2.4.3 came out.

2,103

(7 replies, posted in Report Bugs here)

@joe / @ itronics: can commit this.

2,104

(8 replies, posted in Accounts Payable)

In the original code, if $_POST['order_price'.$n] == 0, then a divide by zero error would still not occur as the second part is not evaluated at all. But the error stated in the first post here would occur.

In your code, what if a negative order_price got in along with a negative ChgPrice?

The "!=0" should be ">0" in your code with a possible abs() for the LHS of the second check.

2,105

(7 replies, posted in Report Bugs here)

Yes, there is no file uploaded since the $_FILES is empty on upload. The $_REQUEST is like:

Array
(
    [comments] => 
    [comp] => no
    [protect] => 1
    [uploadfile] => frontac24_1_1_20171206_1551.sql
    [upload] => Upload file
    [_focus] => comments
    [_modified] => 0
    [_confirmed] => 
    [_token] => pZNU0jkQsPSi05HaQyLGAQxx
    [FA9d3e45269bea7dab23238a920d251e93] => 33ebcyesul0lgdnms17d8nna35
)

The $_POST array does not have the last element above.

The fix is to make the start_form a multipart one - it was inadvertently changed during the last commit to this file.
Change line 190 in admin/backups.php

start_form(false, true);

to be:

start_form(true, true);

2,106

(10 replies, posted in Items and Inventory)

https://frontaccounting.com/fawiki/index.php?n=Help.ReportsAndAnalysis

2,107

(1 replies, posted in Banking and General Ledger)

Setup => Company Setup => Login Timeout (time in seconds)

Also checkout lines 425-432 of includes/session.inc:

/*
    Uncomment the setting below when using FA on shared hosting
    to avoid unexpeced session timeouts.
    Make sure this directory exists and is writable!
*/
// ini_set('session.save_path', VARLIB_PATH.'/');

ini_set('session.gc_maxlifetime', 36000); // 10hrs

2,108

(10 replies, posted in Items and Inventory)

The same item (stock_id) may be referred to as different items by different suppliers.
Suppress the item code display in the reports (invoices) by editing out the line items in the appropriate reports (reporting/repXXX.php)

2,109

(30 replies, posted in Fixed Assets)

Rather than change the function, change it to a call to another function by making line 135 in fixed_assets/process_depreciation.php:

  check_db_has_stock_items('There are no active fixed asset defined in the system.');

to be:

   check_db_has_depreciable_fixed_assets('There are no active fixed asset defined in the system.');

@joe: commit if okay.

2,110

(30 replies, posted in Fixed Assets)

The normal stock items are not Fixed Assets and no such change is needed.

You need to look at the function db_has_depreciable_fixed_assets() in the same file - includes/data_checks.inc. You probably need to set the fixed asset as depreciable and choose what method of depreciation you want and make sure you have completed the year for it to be able to process depreciation.

2,111

(10 replies, posted in Items and Inventory)

Is it that you want to change the item itself in say an invoice or sales order? Editing them are available in FA.

After you have made transactions using one item code, you cannot change the item code in the stock_master, but you can change it's name description to suit the correct one. You can also make a new item code for another item and then edit the old transactions accordingly. The item_code like the stock_id are identifying keys in the tables and foreign keys in others like the transaction tables.

MySQL and dBASE III / FoxPro are the same as far as data storage visibility are concerned. Only the relations are set in the sql command in MySQL. The relations are set as separate statements in dBASE III / FoxPro in the operational area.

Does this have anything to do with RTL string manipulation?

2,113

(7 replies, posted in Report Bugs here)

Since you have pressed the upload button without selecting any flie to upload, the error arises. Hence change line 169 in admin/backups.php:

if (get_post('upload'))

to be:

if (get_post('upload') && isset($_FILES['uploadfile']) && array_key_exists('tmp_name', $_FILES['uploadfile']))

When you buy for yourself (non stocked items like hosting) directly take it into expenses.
If these are stocked items then issue to your expenses account or have an own use customer with no tax.

2,115

(1 replies, posted in Setup)

Browser cache? Logout and login again and see your error logs in FA/tmp/ and in WebServer (eg., Apache) logs.

2,116

(5 replies, posted in Report Bugs here)

Check in the company/#/pdf_files if the pdfs are generated and saved there. Then check the browser preferences for display of PDFs / popups for the domain.

2,117

(30 replies, posted in Fixed Assets)

Precisely that - enter the fixed assets into FA first. Enable those permissions in the Setup => Roles for the user role you want those permissions for, logout and then login again and the said use with the appropriate role will be able to create fixed assets.

(100 * 5) / 105 = 4.76%

2,119

(3 replies, posted in Translations)

https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages
https://frontaccounting.com/fawiki/index.php?n=Main.Usage

@joe: any Standard Operating Procedure for this in FA?

A really "kludgy" workaround is to duplicate the company stanza in config_db.inc file and put in a different user / password with restricted credentials! Alternatively, hack the save() function for the cart and/or tweak the insert statements for adding in a where clause to see if the session current_user is either admin or matches the record owner.

Otherwise, post your bounty in the Job Offers board with a clear description of what you want.

Sell it to the charity at 0 cost or 100% discount.

FA allows all locations to sell all products. If you want to restrict items sold at each shop, setup a separate POS for each shop outside of FA and import transactions into FA or make a separate extension for the same. Warehouse locations may be a filter that might be useful.

2,123

(6 replies, posted in Reporting)

@joe: can the wiki notes be clarified?

2,124

(6 replies, posted in Reporting)

Refer any report where you find a centered field and provide screenshot. We can then trace what works for alignment in Arabic.

2,125

(6 replies, posted in Reporting)

Read the Wiki.