The release tags if any are outdated as several updates in the 2 months since it's release will be available from the bleeding edge download at:
https://github.com/FrontAccountingERP/FA/archive/refs/heads/master.zip
126 09/05/2024 03:55:42 pm
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
127 08/31/2024 05:27:03 pm
Re: Frontacounting on sharepoint (1 replies, posted in Setup)
https://www.computerworld.com/article/2121520/microsoft-onedrive-cheat-sheet-using-onedrive-for-web.html
https://www.mrsharepoint.guru/sharepoint-vs-onedrive-pros-and-cons/
FA cannot be run directly off Sharepoint / OneDrive though content can be managed on them as file shares.
128 08/31/2024 05:23:53 pm
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
sf.net is the primary repo.
github is only a mirror.
@joe and @itronics are the main code repo integrators.
129 08/29/2024 06:21:58 am
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
The README.md file has a GitHub Mirror Link:
https://github.com/FrontAccountingERP/FA
130 08/28/2024 10:15:10 am
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
You can fork the project on GitHub and make changes as needed.
131 08/26/2024 08:01:25 am
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
@joe: is this okay?
132 08/22/2024 05:31:52 pm
Topic: Alternate FA forum on Spoken Tutorials (0 replies, posted in Setup)
https://forums.spoken-tutorial.org/filter/FrontAccounting-2.4.7/
133 08/22/2024 05:20:03 pm
Re: Returning Ajax Failure on Add Item (3 replies, posted in Report Bugs here)
In your php.ini:
max_execution_time = 60
post_max_size = 64M
upload_max_filesize = 64M
Do not forget to restart the web-server process.
Also check for the lines with the word "timeout" in the files js/JsHttpRequest.js and js/utils.js.
134 08/22/2024 05:15:34 pm
Re: Attachments (5 replies, posted in Setup)
File ownership to be checked for your company/0/attachments folder as it must be owned by the webserver process (www-data for Debian/Ubuntu).
135 08/20/2024 09:19:59 pm
Re: WordPress (23 replies, posted in Modules/Add-on's)
https://wordpress.com/plugins/accounting-for-woocommerce
https://woolentor.com/doc/how-to-manage-orders-in-woocommerce/
136 08/20/2024 12:08:37 pm
Re: Attachments (5 replies, posted in Setup)
What is your MySQL and PHP versions and which platform version are you on and which build version of FA v2.4 are you using?
137 08/20/2024 08:15:01 am
Re: Delivery Against SO summary showing SubTotal (2 replies, posted in Accounts Receivable)
Release Dates:
2024-06-28 - v2.4.18+
2024-04-03 - v2.4.18
2018-12-24 - v2.4.6
Last changes in sales/inquiry/sales_orders_view.php:
2024-05-14: Bug 5738 Addl Search Options and Bug 5740 Prepaid options for SO
2023-10-21: Bug 5722: Canceled Sales Orders Show Up In Sales Order Inquiry. Fixed.
2022-04-29: Invoice Prepaid Orders: Added new payments column for direct review of order invoicing status.
2020-01-13: Sales Order Inquiry Sort Descending. Fixed.
2019-07-18: Paged transaction inquiries optimized for maximum links in Sales and Purchasing and continuation
2017-09-21: Right align numbers in inquiries and lists.
None of these changes seem to indicate your predicament. Looks like some function call in the file even possibly outside these changes may have been changed in the files they were defined in.
138 08/18/2024 04:29:54 pm
Re: WordPress (23 replies, posted in Modules/Add-on's)
WordPress does not have orders by default unless you installed a WP plugin.
In WP with your preferred eCommerce plugin installed, take a DB backup, then mane an order and then take another backup and compare the differences between the two backups and you will know which tables/records were affected and you can do the same for FA and hammer out a orders transfer script / sql.
139 08/18/2024 04:27:00 pm
Re: General Ledger question or maybe COA (2 replies, posted in Banking and General Ledger)
Just 3 current accounts of shareholders.
140 08/18/2024 04:25:46 pm
Re: Sales Order enter/edit (4 replies, posted in Installation)
Check out one of the first lines in includes/session.inc file for the SECURE_ONLY constant.
141 08/18/2024 07:36:35 am
Re: Sales Order enter/edit (4 replies, posted in Installation)
Check your mouse and it's buttons. Try a new / different working mouse.
Switch chatter / bounce may be at work.
See if the same issue occurs in another similar form page.
142 08/16/2024 01:23:44 pm
Re: The deferred income GL posting could not be inserted (11 replies, posted in Banking and General Ledger)
Try to do the same transaction in a fresh install of FA in PHP 5.x and MySQL 5.1 and you will note that NULL implementation and argument order may expose causes.
Lines 756-759 in reporting/includes/pdf_report.inc are:
function TextCol($c, $n, $txt, $corr=0, $r=0, $border=0, $fill=0, $link=NULL, $stretch=1)
{
return $this->TextWrap($this->cols[$c], $this->row - $r, $this->cols[$n] - $this->cols[$c] + $corr, $txt, $this->aligns[$c], $border, $fill, $link, $stretch);
}
The above function has not changed in 15 years.
However in 2 places in the said file certain PHP 8.1 issues caused a change 2 years ago for the likes of:
$str = ($str != NULL ? strtr($str, array("\r"=>'')) : "");
which may have to be revisited.
The function / method TextWrap is also defined in the same file (changed for PHP 8.1, 2 years ago) whilst the function / method addTextWrap called therefrom is defined in the file reporting/includes/class.pdf.inc.
Check if there are any PHP version related changes between PHP 5 and 8.1 that cause this situation.
@joe: any clues?
143 08/14/2024 06:15:08 pm
Topic: Creating Extensions (0 replies, posted in FA Modifications)
There is nice article with video for creating extensions in FA at:
https://www.flpages.com/2020/07/frontaccounting-customization.html
144 08/14/2024 06:13:38 pm
Re: The deferred income GL posting could not be inserted (11 replies, posted in Banking and General Ledger)
Which version of PHP and MySQL are you using? Looks like a PHP 8 issue where arguments for functions with default values are generally pushed to the end.
145 08/14/2024 03:26:37 pm
Re: The deferred income GL posting could not be inserted (11 replies, posted in Banking and General Ledger)
Turn debug to 2 in config.php and execute the transaction and post the results.
146 08/12/2024 05:12:27 am
Re: Manufacture BOM (8 replies, posted in Manufacturing)
@joe: Should we allow 0 qty items in BOM to exist?
147 08/09/2024 05:15:24 am
Re: Manufacture BOM (8 replies, posted in Manufacturing)
The basic FA has just 80 tables.
Make a fresh install of latest FA and manually import differences taking care to adjust the Primary Key and it's references.
Then copy over the relevant images/files renaming them for ID related differences in the new dispensation.
148 08/08/2024 05:32:41 pm
Re: Dashboard (8 replies, posted in Installation)
The said function is a built-in one:
https://www.php.net/manual/en/function.imageftbbox.php
149 08/08/2024 05:28:57 pm
Re: Manufacture BOM (8 replies, posted in Manufacturing)
It is possible that many IDs may be missing due to deletion but the AUTO_INCREMENT value may have advanced.
150 08/07/2024 04:57:31 pm
Re: Manufacture BOM (8 replies, posted in Manufacturing)
The file manufacturing/includes/db/work_order_requirements_db.inc has the offending code at lines 66-*74:
function update_wo_requirement_issued($id, $quantity, $cost)
{
$sql = "UPDATE ".TB_PREF."wo_requirements SET
unit_cost = (units_issued*unit_cost+".$quantity*$cost.")/(units_issued+".$quantity."),
units_issued = units_issued + ".db_escape($quantity)."
WHERE id = ".db_escape($id);
db_query($sql, "The work requirements issued quantity couldn't be updated");
}
As 'unit_cost' is computed and assigned in the sql statement whilst being part of the RHS as well kindly look at if it was available initially in the first place.