Better still, make a separate application that uses the FA tables - this way you do not need to touch FA. PM for possibilities.
526 12/06/2020 07:11:51 am
Re: Developer Needed Urgently - Collections Module for FA (2 replies, posted in Jobs wanted/offered, non-free offers)
527 12/06/2020 07:10:36 am
Re: Display payment information in the printed invoice (8 replies, posted in FA Modifications)
What happens when the payment is edited to show it as being only partially paid.... Better still do it offline manually!
528 12/06/2020 07:09:32 am
Re: Dimensions in Balance Accounts (7 replies, posted in Dimensions)
Yes Joe. But the issue of segregated logins and customer subsets for FA usage across branches independently too is a subsequent missive here.
529 12/06/2020 07:05:58 am
Re: Exchange Variations (1 replies, posted in Report Bugs here)
Instead of a journal entry, make a discount at allocation / payment time of $2.
530 12/02/2020 07:38:08 pm
Re: Dimensions in Balance Accounts (7 replies, posted in Dimensions)
Dimensions just provide a filtered view.
Current FA does not have per branch access control.
Can be a candidate for FA 2.5 and make do with an extension / core mod for now with users / branches stored in a json as sys_prefs records.
@joe: what say you?
531 12/01/2020 11:32:40 am
Topic: PHPMailer extension for FA 2.4.x added (1 replies, posted in Modules Add-on's)
PHPMailer Extension for FA has been packaged at https://github.com/apmuthu/FA24extensio … sions/mail and attached here.
Rename the reporting/includes/class.mail.inc file and copy over the one in the extension there.
Please test and provide feedback. Note that all info are stored in the sys_prefs table and hence backup and restore exposure should be taken care of.
Credits to Serban Constantinescu and his repo for this extension is here.
532 12/01/2020 11:22:44 am
Re: Error selecting wrong customer branch when browser javascript is off (2 replies, posted in Report Bugs here)
The said branch_id is actually commented out, possibly a remnant of an old version.
533 11/30/2020 04:28:03 pm
Re: Import of Direct Sales Invoice from csv fails (18 replies, posted in Modules Add-on's)
Choose the entry that was successful and make 10 entries of the same and import them making sure the Inv Nos are different so as not to violate the primary key requirements.
If you still get the error then it has something to do with the memory setting in PHP / Webserver configs.
Also check if your PHP variables settings are high enough like 3000 or so (default is 1000 only).
534 11/30/2020 09:36:16 am
Re: Import of Direct Sales Invoice from csv fails (18 replies, posted in Modules Add-on's)
You are using backticks in item_description and delto field values. Remove them and all should be well.
535 11/29/2020 03:59:32 pm
Topic: Compatibility fix for commit on 2020-09-28 (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
536 11/28/2020 07:52:04 pm
Re: New users seem unaware we have a wiki (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.
537 11/28/2020 07:47:22 pm
Re: Send Email (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.
538 11/28/2020 07:32:51 pm
Re: SMS Gateway (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
539 11/24/2020 10:14:36 am
Re: Fixed Asset Category cannot be added (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,540 11/24/2020 10:11:39 am
Re: ALTER TABLE ADD COLUMN NOT ACCEPTING (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.
541 11/22/2020 04:04:27 am
Re: Purchase Order Receiveing (8 replies, posted in Report Bugs here)
Read the Wiki.
542 11/22/2020 03:58:16 am
Re: debian 10 translation not working (2 replies, posted in Translations)
You will need to have logged out first after changing language settings - possibly clearing cache too - then login again.
543 11/22/2020 03:56:14 am
Re: OverDraft Error Showing (GL-Bank Account Transfer Module) (5 replies, posted in Banking and General Ledger)
@joe: any < or <= issue with date for reporting and date for processing?
544 11/22/2020 03:54:38 am
Re: PDF (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?
545 11/18/2020 03:04:03 am
Re: pdf utf8 and german special chracters (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.
546 11/18/2020 03:02:24 am
Re: Work with more than one company at the same time? (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.
547 11/17/2020 02:58:23 am
Re: Work with more than one company at the same time? (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?
548 11/17/2020 02:54:50 am
Re: PDF (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!
549 11/17/2020 02:51:48 am
Re: Setting up commissions (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.
550 11/17/2020 02:49:08 am
Re: pdf utf8 and german special chracters (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.