501 Topic by apmuthu

(4 replies, posted in Banking and General Ledger)

On 28th Sep 2020, @itronics made a commit that uses a combined array addressing construct valid for PHP >= 5.4 in the file gl/includes/db/gl_db_bank_accounts.inc. In order to make it's Line 347:

    $id = $row ? get_default_bank_account($row[0])['id'] : 0;

compatible with older versions of PHP like 5.3.3, etc, it should be replaced with:

    $id = 0;
    if ($a = get_default_bank_account($row[0])) {
        $id = $a['id'];
        unset ($a);
    }

Such constructs when used in javascript in FA appear valid though, but it is not so for PHP < 5.4.

This is the only one instance in FA 2.4.x of it's kind hitherto.

Refer:
https://github.com/FrontAccountingERP/FA/commit/2f3375b4493c1b1e0b17c2801298275f22f8d76e#commitcomment-44633990
https://github.com/apmuthu/frontac24/commit/ccce28d5bbdf5298ff60a6ac504747fbd177faf7#commitcomment-44634360

Go to forum: Banking and General Ledger

502 Reply by apmuthu

(3 replies, posted in Wish List)

There is a link to the FA Wiki in the Readme file.

The community is encouraged to update the wiki.

The upload date of the screenshot is available in the page history that can be mapped to the version it pertains to in case the version is not shown att the bottom of the image.

Go to forum: Wish List

503 Reply by apmuthu

(1 replies, posted in Setup)

First test if email sending works on your webserver's php. References are:
https://tecadmin.net/send-email-using-php-script/
https://www.tutorialspoint.com/php/php_sending_emails.htm
https://www.arclab.com/en/kb/php/how-to-test-and-fix-php-mail-function.html
https://conetix.com.au/support/simple-php-mail-test/

Then refer the EMail Issues @ Wiki and search the forum for assistance. Contact your hosting provider / sysadmin for further assistance.

Go to forum: Setup

504 Reply by apmuthu

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

Many SMS Gateways provide for email to sms functionality as well. Also, using SMS Modems or virtual mobile numbers, one can run their own SMS gateways in open source using kannel.org or the proprietary likes of NowSMS / Diafaan | Usage.

Run your own SMS Gateway using your Android Phone:
https://smsgateway.me/

List of SMS Gateways
https://www.liquisearch.com/list_of_sms_gateways

SMS Gateway Lookup Service
https://www.freesmsgateway.info

Go to forum: Modules Add-on's

505 Reply by apmuthu

(3 replies, posted in Fixed Assets)

Which sql Chart of Accounts did you take?
Refer line 1325 in https://github.com/FrontAccountingERP/FA/blob/master/sql/en_US-new.sql :

 `category_id` int(11) NOT NULL AUTO_INCREMENT,

Go to forum: Fixed Assets

506 Reply by apmuthu

(2 replies, posted in Banking and General Ledger)

Which version of MySQL are you using? Try to set the STRICT SQL setting off and to accept Date as 0.

Go to forum: Banking and General Ledger

507 Reply by apmuthu

(8 replies, posted in Report Bugs here)

Read the Wiki.

Go to forum: Report Bugs here

508 Reply by apmuthu

(2 replies, posted in Translations)

You will need to have logged out first after changing language settings - possibly clearing cache too - then login again.

Go to forum: Translations

509 Reply by apmuthu

(5 replies, posted in Banking and General Ledger)

@joe: any < or <= issue with date for reporting and date for processing?

Go to forum: Banking and General Ledger

510 Reply by apmuthu

(7 replies, posted in Reporting)

Just use the ledger statement for the specific Customer's Account.

Banking & General Ledger => Balance Sheet Drilldown => Current Assets => Accounts Receivable => Choose your customer Account and get your list.

@joe: Which report best provides for Customer Ledger Folio with a means of emailing out selected customers for periodical account confirmation of balances?

Go to forum: Reporting

511 Reply by apmuthu

(6 replies, posted in Reporting)

The original po file was encoded in ANSI and that will be needed to be converted to UTF-8 without BOM and then compiled which is what is done in the attachment in my earlier post.

Go to forum: Reporting

512 Reply by apmuthu

(5 replies, posted in Installation)

https://www.lifewire.com/browsing-incognito-445990

Incognito mode doesn't block or mask your IP address.
It prevents the browser from recording your session data.
Check out the ramifications of opening links in FA in a new tab / window.

Go to forum: Installation

513 Reply by apmuthu

(5 replies, posted in Installation)

Use FireFox on one window for one company and possibly Chrome or other compatible browser for the other company in another window.

Cookie and session names can be customisable and making a unique browser instance recognisable is also possible using appropriate headers but what of separate tabs / windows using the same company's instance - like opening a link in FA in a new window? How do we then differentiate the two scenarios?

Go to forum: Installation

514 Reply by apmuthu

(7 replies, posted in Reporting)

Where would you store the "total agreed contract value" in FA at the time of making the Purchase/Sales Order? Probably as free form text in the Memo field?

At the time of invoice preparation, the reporting/rep107.php (Invoice Script) can be customised to change / eliminate wordings / fields but to get data that was not stored is well nigh impossible!

Go to forum: Reporting

515 Reply by apmuthu

(2 replies, posted in Accounts Receivable)

This can be programmed as a trigger in the mysql database itself irrespective of what FA computes and enters in the DB. Beware of amendments and deletions.

Nice slab feature for FA 2.5.

Go to forum: Accounts Receivable

516 Reply by apmuthu

(6 replies, posted in Reporting)

Try the attachment and fix the encoding in the installed_extensions.php file in both the FA webroot and in the Company/# folders as well in case you had installed the iso version earlier.

Go to forum: Reporting

517 Reply by apmuthu

(1 replies, posted in Report Bugs here)

The memo field can contain the additional references.

Go to forum: Report Bugs here

518 Reply by apmuthu

(6 replies, posted in Reporting)

The above requires change of db schema.

Just put in the phone number as part of the memo / description for the invoice and search there from.

Go to forum: Reporting

519 Reply by apmuthu

(2 replies, posted in Reporting)

This is because of google analytics being used which is not compliant with the samesite attribute.
Ref:
https://www.tinstar.co.uk/studio-blog/some-cookies-are-misusing-the-recommended-samesite-attribute-how-to-fix/
https://support.google.com/tagmanager/thread/28637813?hl=en

Go to forum: Reporting

520 Reply by apmuthu

(3 replies, posted in Reporting)

This is a nice feature request for reporting/rep710.php.
Attached is the diff and modded file.
@joe: can add it into the core with improvements.

Beware of adding apples and oranges. The Action column can be "Changed" or "Closed" for which there is no filter in the form request.

Go to forum: Reporting

521 Reply by apmuthu

(1 replies, posted in Report Bugs here)

The 10th parameter comes from get_unit_cost($line->stock_id)

Go to forum: Report Bugs here

522 Reply by apmuthu

(3 replies, posted in FA Modifications)

Update the extension from the FA24extensions repo.

Go to forum: FA Modifications

523 Reply by apmuthu

(1 replies, posted in Installation)

This error line is at line 255 in includes/session.inc.. It is likely that your PHP version may be to blame (even some minor version number change has it's anomalies). Looks like no user logged in may be a blank or null interpreted by the if check wrongly in the specific version. Also check permission of files and folders and writeable tmp folder.

Go to forum: Installation

524 Reply by apmuthu

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

It is possible that the Arabic abbreviation works in the FA UI but will need to be in English (IMHO) as it is a parameter to the appropriate function through the SlimAPI (probably the way it is implemented as there is no language/theme info in the API) and not a direct variable from a translatable form.

Go to forum: Modules Add-on's

525 Reply by apmuthu

(3 replies, posted in FA Modifications)

This is entered via "Quick Entries" since the actual expense account to be allocated to is different for different expenses.

However, you can also make a set of entries you wish to enter through the Import of Journal entries extension too.

Go to forum: FA Modifications