2,576 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,577 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,578 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,579 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,580 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,581 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,582 Reply by apmuthu

(7 replies, posted in Announcements)

Thanks @joe.

Go to forum: Announcements

2,583 Reply by apmuthu

(7 replies, posted in Installation)

Take a backup from FileZilla before uploading the new files.

Go to forum: Installation

2,584 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,585 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,586 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,587 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,588 Reply by apmuthu

(7 replies, posted in Announcements)

The wiki too needs it in the sidebar.

Go to forum: Announcements

2,589 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,590 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,591 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,592 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,593 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,594 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,595 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,596 Reply by apmuthu

(5 replies, posted in Setup)

Audit Trail.....

Go to forum: Setup

2,597 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,598 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

2,599 Reply by apmuthu

(4 replies, posted in Report Bugs here)

You would do well to use the Git master latest code that has many bugs fixed.

Go to forum: Report Bugs here

2,600 Reply by apmuthu

(6 replies, posted in Reporting)

Is your server running Windows or Linux? If on linux, you will need to have the Arabic locale installed in the OS along with the English one (UTF-8).

https://frontaccounting.com/punbb/viewtopic.php?id=3423

Go to forum: Reporting