@joe: is this desirable in the default FA?
2,602 10/19/2017 02:11:05 am
Re: Direct Email Customer Payment (8 replies, posted in Reporting)
Since a different construct was used in sending the email, it may have been possible that the return from the sending routine is different and that return is what needs to be investigated.
2,603 10/17/2017 01:05:37 pm
Re: Direct Email Customer Payment (8 replies, posted in Reporting)
I have updated the mod file with your changes in #2 post.
The job of the function End() is to provide the said notification which comes but in another page. Lines 1037-1038 in the said function in reporting/includes/pdf_report.inc are:
display_notification($this->title . " " . $this->formData['document_number'] . " "
. _("has been sent by email to destination.") . " " . _("Email:") . $emails);Try to replace the 2 submenu_print statements (in the Add and Update sections) in sales/customer_payments.php with the following and provide feedback:
display_note(print_document_link($payment_no."-".$trans_type, _("&Email This Receipt"), true, ST_CUSTPAYMENT, false, "printlink", "", 1),1);You may need to echo "<br>"; to adjust spacing of the links.
2,604 10/16/2017 05:35:11 pm
Re: Direct Email Customer Payment (8 replies, posted in Reporting)
Try the fixes in my previous post.
2,605 10/16/2017 04:21:58 pm
Re: Direct Email Customer Payment (8 replies, posted in Reporting)
The following at line 100 in sales/customer_payments.php does not work.
display_note(print_document_link($payment_no."-".$trans_type, _("&Email This Receipt"), true, ST_CUSTPAYMENT, false, "printlink", "", 1),1);The following too does not work:
submenu_print(_("&Email This Receipt"), ST_CUSTPAYMENT, $payment_no, null, 1);The above alone does not work even with necessary changes made to use $email in reporting.inc and rep112.php.
Try the consolidated changes for the bleeding edge attached and provide feedback.
2,606 10/16/2017 04:19:10 pm
Re: Please help with the design modification (5 replies, posted in FA Modifications)
$hide_inaccessible_menu_items is for hiding menu items inside the tabs .
The commenting out of the add_application() is for hiding menu tabs at the top.
2,607 10/15/2017 10:23:09 am
Topic: db connection scripts fixes (5 replies, posted in Report Bugs here)
The db connection scripts reside in the includes/db/ folder.
The currently acceptable db drivers there are:
connect_db_mysqli.inc
connect_db_mysql.incLine 15 in the MySQLi driver file above is:
$db_last_inserted_id = 0;This needs to be ported to the MySQL driver too.
The function db_query() in both driver files have a line (78/79):
if ($SysPrefs->select_trail || (strstr($sql, 'SELECT') === false)) {It is better coded to make the SELECT be the beginning part of the search string and case insensitive as well (stristr ?) like:
$sql = trim($sql);
if ($SysPrefs->select_trail || (preg_match('/^SELECT/i', $sql) === 0)) {According to the PHP Manual:
preg_match() returns the number of times pattern matches. That will be either 0 times (no match) or 1 time because preg_match() will stop searching after the first match.
2,608 10/15/2017 10:11:35 am
Re: How to use FA for Restaurant Point-of Sale transactions (3 replies, posted in Banking and General Ledger)
The Bank does not care if there is an invoice or not but the Account books do.
The standalone POS's data in an excel sheet needs to be appropriately imported into FA and invoices printed there from.
2,609 10/15/2017 03:39:09 am
Re: How to use FA for Restaurant Point-of Sale transactions (3 replies, posted in Banking and General Ledger)
Sales -> Direct Invoice automatically generates the Sales Quotation, Sales Order, Delivery Order and the Sales Invoice.
You might want to use a POS like OSPOS and then run a cron job / db trigger to keep importing the transactions from time to time into FA.
2,610 10/15/2017 03:37:13 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
@BraathWatte/bdika: what a way to "cheat" the system. Needs a pure blooded accountant to wade thru this without getting confused.
I'll now await the outcome.
Refer this post for case sensitivity of the 'SELECT' part of the sql.
Just wiki-ed the presence of the good old secondary repo at http://devel.frontaccounting.com/git/ where some old extensions reside - maybe someone can polish them for use in FA 2.4.x.
2,611 10/14/2017 03:39:00 am
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
@itronics: looks like every entry screen that has a reference needs to be fixed in a similar way and the empty.po generated again.
2,612 10/14/2017 03:36:24 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Looks like the id's start from 1 each time.
2,613 10/13/2017 05:14:43 am
Re: A new forum about Fixed Assets has been created. (7 replies, posted in Announcements)
Thanks @joe.
2,614 10/13/2017 05:12:09 am
Re: Backup/Resore vs import/export (7 replies, posted in Installation)
Take a backup from FileZilla before uploading the new files.
2,615 10/12/2017 08:48:26 pm
Re: Release 2.4.2 (11 replies, posted in Announcements)
Post Releases fixes for FA 2.4.2.
Pending Fixes:
1. db connection scripts fixes - Not accepted due to unwritten coding policy of uppercase SQL keywords.
2. Unable to Edit or Void a Credit Note - Development postponed to later minor release.
3. Xchg Rate fix and other PHP 5.6.32+ and 7+ issues - Will get fixed along with other PHP 7 issues in upcoming minor release.
4. Multiple Sales Orders into Single Delivery - Feature Request - Currently keep editing a Single Sales Order till delivery. Development postponed to later minor release.
5. Move add_access_extensions(); to header.inc from all themes and extensions - being studied for Ajax and related security issues.
Users are encouraged to test and comment in the appropriate forum topics on my proposed changes to the DB Schema for index optimisation and field type rationalisation.
2,616 10/12/2017 08:44:25 pm
Re: Backup/Resore vs import/export (7 replies, posted in Installation)
Setup -> Backup/Restore will provide the sql backup.
Copying the webroot of FA in FTP mode (or zip the web folder that has the FA code) will save the FA codebase your are using.
The changed files zip is available in the announcement for FA 2.4.2 - see posts #4 and #12.
2,617 10/12/2017 07:56:13 pm
Re: Backup/Resore vs import/export (7 replies, posted in Installation)
In general, overwriting with the FA 2.4.2 code for FA 2.4.1 should do the job. Backup (FA code and mysql) and try it..... Take the cutting edge one from Git/Github.
2,618 10/12/2017 07:49:01 pm
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
@itronics, thanks for the reason behind the slight inconvenience of re-submission. When would one want to change the reference the form automatically provides?
2,619 10/12/2017 07:45:49 pm
Re: A new forum about Fixed Assets has been created. (7 replies, posted in Announcements)
The wiki too needs it in the sidebar.
2,620 10/12/2017 07:37:41 pm
Re: Transaction References (6 replies, posted in Banking and General Ledger)
The lines 55-67 of includes/references.inc
$refline_placeholders = array(
'MM' => 'date',
'YY' => 'date',
'YYYY' => 'date',
'UU' => 'user',
'P' => 'pos',
// FIXME: for placeholders below all the code should work, but as the ref length is variable,
// length specification in placeholder format should be implemented.
// 'C' => 'customer',
// 'B' => 'branch',
// 'S' => 'supplier',
// 'L' => 'location'
);Hence {UU} is the logged in user.
The method function _parse_next() gets the next formatted reference.
2,621 10/12/2017 07:31:27 pm
Re: Now Importing of Inventory is Possible. (3 replies, posted in Items and Inventory)
You can upload files anywhere and provide the link in the forum too.
2,622 10/11/2017 02:28:58 pm
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
Should it not just save with the next available reference by itself and then inform the user of the new reference number it saved it as?
2,623 10/11/2017 02:27:27 pm
Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)
FA is built for "non" computer programming professional users accustomed to the very permissive and then loosely typed PHP versions from PHP 4.x onwards to 5.3.x. Many have been long time users of FA and stability and easy understand-ability are more important than esoteric latest is greatest paradigms. I subscribe to the old fashioned procedural style where individual files are not combined by "less" and "autoloaded" by the likes of composer. To each his own.... When Sun took PHP/MySQL over they tried to make it a clone of Java/JSP. When Oracle took that over from them, they tried to make it really complex by changing even the simple array construct to practically break everything hitherto.
2,624 10/11/2017 02:18:52 pm
Re: void transactions not working (5 replies, posted in Setup)
There is another thread on this topic. The actual commit that removed it is discussed here.
2,625 10/10/2017 04:45:32 pm
Re: void transactions not working (5 replies, posted in Setup)
They were usable in FA 2.3 and the feature is no longer in FA 2.4 and is awaited to come in with some new tweaks...