Post it here for a good discussion. Mantis participation is sparse but technical. Github is for accepted code after peer review.
76 11/05/2023 04:14:03 am
Re: Import Transactions not working (19 replies, posted in Modules/Add-on's)
77 11/05/2023 04:12:39 am
Re: Is FrontAccounting right for me? (8 replies, posted in Installation)
Are you on Linux or Windows?
Check the includes/session.inc file and make the first constant NULL.
78 11/01/2023 02:20:31 pm
Re: Invoice:Figures to Words , previous code not working in version 2.4.17 (2 replies, posted in Reporting)
The various cheque extensions have this constant:
https://github.com/apmuthu/FA24extensions/blob/master/Extensions/rep_batch_check_print/reporting/rep_batch_check_print.php
https://github.com/apmuthu/FA24extensions/blob/master/Extensions/rep_check_print/reporting/rep_check_print.php
https://github.com/apmuthu/FA24extensions/blob/master/Extensions/rep_cheque_print/reporting/rep_cheque_print.php
79 11/01/2023 02:14:11 pm
Re: Emailing not setting mime-type (36 replies, posted in Reporting)
@irronics, @joe: The said patch for reporting/includes/class.mail.inc will break for all versions of PHP < 5.4.
Refer the line:
var $headers = [];
It should be changed to:
var $headers = Array();
We need to take care of legacy users so as not to break their installs.
The PHP short array syntax does not work for older versions of PHP.
As of PHP 5.4 you can also use the short array syntax, which replaces array() with [].
https://stackoverflow.com/questions/40086788/short-array-syntax-in-php-5-6-doesnt-work
In fact there is a short array sniffer to check if needed but that is too bothersome.
80 11/01/2023 02:03:07 pm
Re: Is FrontAccounting right for me? (8 replies, posted in Installation)
What is the PHP version you are using?
81 10/27/2023 07:22:12 pm
Re: Release 2.4.17 (4 replies, posted in Announcements)
Post Release Fixes attached.
Github Master (Bleeding Edge) Download Link
These fixes can be applied to (overwrite) the release version to be fully functional.
82 10/27/2023 06:47:39 pm
Topic: Better sql construct in sales/includes/db/sales_order_db.inc (3 replies, posted in Accounts Receivable)
At the end of the file sales/includes/db/sales_order_db.inc we have:
function last_sales_order_detail($order, $field)
{
$sql = "SELECT $field
FROM ".TB_PREF."sales_order_details d
WHERE order_no =
(SELECT order_no FROM ".TB_PREF."sales_orders o
WHERE debtor_no=" . db_escape($order->customer_id) . "
ORDER BY order_no DESC LIMIT 1)
ORDER BY d.id DESC LIMIT 1";
$last_query=db_query($sql, "Could not retrieve last order detail");
$row = db_fetch_row($last_query);
return $row == false ? false : $row[0];
}
Kindly change it to:
function last_sales_order_detail($order, $field)
{
$sql = "SELECT $field
FROM ".TB_PREF."sales_order_details d
LEFT JOIN " .TB_PREF."sales_orders o on d.order_no=o.order_no
WHERE debtor_no=" . db_escape($order->customer_id) . "
ORDER BY d.id DESC LIMIT 1";
$last_query=db_query($sql, "Could not retrieve last order detail");
$row = db_fetch_row($last_query);
return $row == false ? false : $row[0];
}
It uses a left join instead of a secondary select.
The on d.order_no=o.order_no can become USING (order_no) to further optimise it.
83 10/27/2023 06:21:07 pm
Re: Release 2.4.17 (4 replies, posted in Announcements)
Those with issues regarding MIME type in emailrefer this post. - Resolved
84 10/27/2023 06:14:42 pm
Re: Is FrontAccounting right for me? (8 replies, posted in Installation)
GST/HST - ok
Multi Currency - ok
Payroll - contact @notrinos for his Open Source extension and @kvvaradha's commercial extension (do not know if it needs ioncube or other coded licencing)
Reconciliation - rudimentary but sufficient for simple tasks - check the extensions.
For QB features vs FA - there may be other users whose migration experiences may be useful.
Welcome to the project!
85 10/27/2023 06:07:21 pm
Re: Item Code length limited in the box for entering. (2 replies, posted in Items and Inventory)
Clear cache in FA and in the browser and then try.
86 10/27/2023 06:06:17 pm
Re: Project Tasks (11 replies, posted in Modules/Add-on's)
Can create a separate php application using the FA Tables data and extend the existing rudimentary CRM in FA. Can also use the document upload attachment facility in FA to integrate with manual systems too.
87 10/19/2023 04:44:28 pm
Re: Release 2.4.17 (4 replies, posted in Announcements)
Release date 2023-10-09 as of GitHub commit https://github.com/FrontAccountingERP/FA/commit/4e6c60dfc8ab630d72010941b00f65b9659fe0b3
SF Download Link
MD5: ae2e009a6d89f6118d4c45fd5954ec1d
Filesize: 1,884,638 bytes
88 10/19/2023 04:35:33 pm
Re: Release 2.4.17 (4 replies, posted in Announcements)
Two new translation strings introduced in lang/new_language_template/LC_MESSAGES/empty.po
Could not retrieve %s bank account number
Could not retrieve exchange rate for %s - %s
89 10/19/2023 04:27:51 pm
Re: Project Tasks (11 replies, posted in Modules/Add-on's)
Can try to link with vTigerCRM
90 10/19/2023 04:22:01 pm
Re: Customer Portal (2 replies, posted in Modules/Add-on's)
Also consider what would happen if someone tried a negative value as payment!
91 09/16/2023 04:08:07 am
Re: A problem with the entry reference (1 replies, posted in Report Bugs here)
This is a well known race condition. The corresponding INSERT statement should be modified to make the primary key as NULL so that it is generated at runtime and then last_insert_id() should be used to populate the dependant foreign keys.
92 09/16/2023 04:05:21 am
Re: Cannot install 2.4.16 (4 replies, posted in Installation)
Check the config file for any relative / absolute urls and for directory separator issues.
State your PHP / MySQL versions.
93 09/16/2023 03:57:53 am
Re: How to round total selling price from $1,499.94 to $1,500 (7 replies, posted in Items and Inventory)
Add a negative discount of 6 cents
94 09/16/2023 03:56:45 am
Re: Aged Customer Analysis (1 replies, posted in Accounts Receivable)
Zip the 2 files and upload as single file.
95 09/16/2023 03:54:18 am
Re: Direct Purchase Invoice Entry - Change the default payment Delayed (10 replies, posted in Accounts Payable)
@joe: is this _false to false dependency on PHP version going to affect FA in general? I cannot find _false anywhere in the latest codebase.
96 09/16/2023 03:48:42 am
Re: Make edits to a sales order after it's been invoiced? (1 replies, posted in Reporting)
Summary entries in other tables are affected too.
97 09/16/2023 03:46:11 am
Re: Rep108: Statement - since when is it only emailing when overdue debits (1 replies, posted in Reporting)
The difference between the v2.4.14 and 2.4.16 for the file reporting/rep108.php in diff format is as follows:
core/reporting/rep108.php | 10 +++++++---
1 file changed, 7 insertions(+), 3 deletions(-)
diff --git a/core/reporting/rep108.php b/core/reporting/rep108.php
index abb11e7..f2d6d42 100644
--- a/core/reporting/rep108.php
+++ b/core/reporting/rep108.php
@@ -175,12 +175,16 @@ function print_statements()
for ($i = 0; $i < 5; $i++)
$rep->TextWrap($col[$i], $rep->row, $col[$i + 1] - $col[$i], $str2[$i], 'right');
if ($email == 1)
- $rep->End($email, _("Statement") . " " . _("as of") . " " . sql2date($date));
-
+ {
+ if (($CustomerRecord["Balance"]) != ($CustomerRecord["Balance"] - $CustomerRecord["Due"]))
+ $rep->End($email, _("Statement") . " " . _("as of") . " " . sql2date($date) . " " . _("from") . " " . get_company_pref('coy_name'));
+ else
+ display_notification(sprintf(_("Customer %s has no overdue debits. No e-mail is sent."), $myrow["DebtorName"]));
+ }
}
if (!isset($rep))
- display_notification("No customers with outstanding balances found");
+ display_notification(_("No customers with outstanding balances found"));
else if ($email == 0)
$rep->End();
}
The last change is that the notification text is now translated.
The "End(email..." statement is now in an "if" construct that you may revert as needed.
98 09/16/2023 03:39:08 am
Re: Looking for accounting services using Front Accounting (1 replies, posted in Jobs wanted/offered, non-free offers)
Attempting to access your domain cexpert.com results in:
Sorry, you have been blocked
You are unable to access cexpert.com
Please explain what the accounting operations entail so that the forum users can recommend or take it up.
99 08/08/2023 06:59:56 pm
Re: PHP 8.2 commits - why change $deliver_to to $delivery_to ? (3 replies, posted in Setup)
Tnx @joe
100 08/08/2023 01:54:14 pm
Topic: PHP 8.2 commits - why change $deliver_to to $delivery_to ? (3 replies, posted in Setup)
In this commit, in the file sales/includes/cart_class.inc, why was the variable $deliver_to changed to $delivery_to ?
Wonder if this is going to affect some module or other FA files.
Please note that the following files still use $cart->deliver_to, $order->deliver_to and $_SESSION['View']->deliver_to:
sales/sales_order_entry.php
sales/includes/db/sales_order_db.inc
sales/includes/ui/sales_credit_ui.inc
sales/includes/ui/sales_order_ui.inc
sales/view/view_sales_order.php