2,626 Reply by apmuthu

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

Go to forum: Reporting

2,627 Reply by apmuthu

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

Go to forum: FA Modifications

2,628 Topic by apmuthu

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

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

Go to forum: Report Bugs here

2,629 Reply by apmuthu

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

Go to forum: Banking and General Ledger

2,630 Reply by apmuthu

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

Go to forum: Banking and General Ledger

2,631 Reply by apmuthu

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

Go to forum: Modules Add-on's

2,632 Reply by apmuthu

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

Go to forum: Setup

2,633 Reply by apmuthu

(154 replies, posted in Modules Add-on's)

Looks like the id's start from 1 each time.

Go to forum: Modules Add-on's

2,634 Reply by apmuthu

(7 replies, posted in Announcements)

Thanks @joe.

Go to forum: Announcements

2,635 Reply by apmuthu

(7 replies, posted in Installation)

Take a backup from FileZilla before uploading the new files.

Go to forum: Installation

2,636 Reply by apmuthu

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

Go to forum: Announcements

2,637 Reply by apmuthu

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

Go to forum: Installation

2,638 Reply by apmuthu

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

Go to forum: Installation

2,639 Reply by apmuthu

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

Go to forum: Setup

2,640 Reply by apmuthu

(7 replies, posted in Announcements)

The wiki too needs it in the sidebar.

Go to forum: Announcements

2,641 Reply by apmuthu

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

Go to forum: Banking and General Ledger

2,642 Reply by apmuthu

(3 replies, posted in Items and Inventory)

You can upload files anywhere and provide the link in the forum too.

Go to forum: Items and Inventory

2,643 Reply by apmuthu

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

Go to forum: Setup

2,644 Reply by apmuthu

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

Go to forum: Accounts Receivable

2,645 Reply by apmuthu

(5 replies, posted in Setup)

There is another thread on this topic. The actual commit that removed it is discussed here.

Go to forum: Setup

2,646 Reply by apmuthu

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

Go to forum: Setup

2,647 Reply by apmuthu

(5 replies, posted in Wish List)

For now, I have added a link to your page in the Wiki's General page and added a few screenshots.

Go to forum: Wish List

2,648 Reply by apmuthu

(5 replies, posted in Setup)

Audit Trail.....

Go to forum: Setup

2,649 Reply by apmuthu

(1 replies, posted in Fixed Assets)

You need to enable permissions for Fixed Assets for the appropriate user role.

Go to forum: Fixed Assets

2,650 Reply by apmuthu

(6 replies, posted in Report Bugs here)

@joe: If this works on older PHP versions, it can make it to the core.

Go to forum: Report Bugs here