Verify with the stock sql/en_US-new.sql for any schema changes and unused tables and field orders.
1,152 04/07/2019 04:19:39 am
Re: Withholded tax deduction at PURCHASE transactions (13 replies, posted in Accounts Payable)
Work Done - Supplier Invoice:
Cr John $98
Cr Witholding Tax Payable $2
Dr Repairs and Maintenance (Actual Invoice Amount) $100
Supplier Paid / Allocated
Dr John $98
Cr Bank/Cash $98
Witholding Tax Payment (consolidating all such payables like many $2 or such taxes)
Dr Witholding Tax Payable $2
Cr Bank/Cash $2
1,153 04/07/2019 04:12:56 am
Re: Recurrent Invoices in 2.4 is not sending (15 replies, posted in Report Bugs here)
@joe: any fixes to the core?
1,154 04/07/2019 04:10:50 am
Re: How can we change ICONS in front accounting (5 replies, posted in Setup)
Study existing themes in the FA24extensions repo.
1,155 04/06/2019 03:19:03 am
Re: How can we change ICONS in front accounting (5 replies, posted in Setup)
Create a brand new theme with your icons in place and other customisations.
1,156 04/06/2019 03:13:07 am
Re: Budget Entry - not working for new Accounts (3 replies, posted in Banking and General Ledger)
May need direct DB intervention. Test with debug turned on.
1,157 04/06/2019 03:11:33 am
Re: Translating to nl_NL (8 replies, posted in Translations)
Upload your Dutch translations and paste the link here.
Compare with those in the FA24extensions repo and in Transifex.
1,158 03/31/2019 06:31:13 pm
Re: FA session logout every time when goto any page in Mobile (3 replies, posted in Setup)
The mobile IP keeps getting changed frequently - try searching the forum for a post on disabling IP hijack code in FA.
1,159 03/31/2019 06:29:59 pm
Re: erorr (14 replies, posted in Setup)
For Windows, use the following and schedule them as desired:
FTP Code File
To transfer the file from C:\Users\Admin\Desktop\Test\myfile.zip to the /backupfolder in a remote FTP server we create a file , viz., myremote.ftp in the same folder where our file to be transferred resides having the following text contents:
open <IP of FTP Server>
<FTP Username>
<FTP Password>
lcd /D "C:\Users\Admin\Desktop\Test\"
cd /backupfolder
binary
mput <file to be backed up - wildcards accepted>
disconnect
quit
Windows Batch File
Create a file zipftp.bat to zip up the set of files to be backed up (to a remote FTP server with the above credentials) having the following text contents:
SET MYFILE="myfile.zip"
IF EXIST %MYFILE% DEL /F %MYFILE%
"C:\Program Files\7-Zip\7z.exe" a -tzip %MYFILE% myFAfolder
sleep 1
# A remote file is automatically overwritten when a local file that
# is PUT or MPUT has the same name as the remote file.
ftp -i -s:myremote.ftp
1,160 03/31/2019 06:22:58 pm
Re: How can we change ICONS in front accounting (5 replies, posted in Setup)
The various icons are in the themes/*/images folder.
1,161 03/28/2019 04:50:38 pm
Re: Opening Balances for Advances to Shareholders (1 replies, posted in Accounts Receivable)
Use a Journal Voucher. When an advance is given it will be either in cash or by bank entry or notional / abstract value like royalty / goodwill / goods. Use the appropriate contra account that was the source of funding in the first place.
1,162 03/28/2019 04:27:39 pm
Re: Variables display but empty values sent to database (9 replies, posted in FA Modifications)
Check stale session variables and the need to clear some $_GET variables and acquire it afresh in context.
There could also be several forms on a page that need to be refreshed whilst Ajax addresses only one form at a time.
1,163 03/26/2019 03:29:32 am
Re: Editing Journal Entry (1 replies, posted in Banking and General Ledger)
The file includes/errors.inc has a function frindly_db_error() that is responsible for this. Check the context in which this error appears and then trace it. The said function is called only from within the said file's other function check_db_error(). This means that you will need to watch the parameters that come into the latter function and check which db table record is duplicate based on the sql passed in.
1,164 03/26/2019 03:24:23 am
Re: Can we add more than 1 lines in Journal Entry Section (2 replies, posted in Setup)
Making the Memo field a textarea instead of text input will do the job. All memo fields are TINYTEXT and hence can support reasonably sized multi line textarea content.
# grep memo sql/en_US-new.sql
`memo_` tinytext NOT NULL,
`memo_` tinytext,
`memo_` tinytext NOT NULL,
`memo` tinytext NOT NULL,
`memo_` tinytext,
`memo` tinytext,
`memo_` tinytext NOT NULL,
1,165 03/26/2019 03:19:35 am
Re: Variables display but empty values sent to database (9 replies, posted in FA Modifications)
Unless the whole page is refreshed (no need for Ajax then) as in a regular Submit, other parts of the page are generally not refreshed.
Ajax, by it's very purpose of use is intended to address small / localised tag specific changes on the occurrence of some event generally the change in a field value.
Multiple such Ajax updates can be triggered by such a change to simulate a full page refresh but alignments and overflow of content will need to be handled gracefully.
1,166 03/25/2019 04:54:00 am
Re: Variables display but empty values sent to database (9 replies, posted in FA Modifications)
Unless the Ajax submit specifically restricts variable passing, in general, all $_POST / $_GET elements will be sent in to maintain state with the form at hand and be available globally. Any other variables needed inside of any function must suitably be brought in as arguments or be declared global with it.
1,167 03/24/2019 03:21:32 am
Re: How can i update my Arabic Language (12 replies, posted in Translations)
All strings in your screenshot are already there in the po file and hence in the mo file. The official repo provides ar_EG v2.4.1-3 but my repo provides ar_EG v2.4.3-1. This will need to be changed in the lang/installed_languages.inc file as well if manually updated.
See attachment for all strings properly translated.
The ar_EG language is part of the Transifex translations from where one can take the latest translations.
1,168 03/24/2019 02:22:04 am
Re: Variables display but empty values sent to database (9 replies, posted in FA Modifications)
Check scope and visibility of the variables concerned at the place where they should be available. Also check the case sensitivity of the parameters passed in for comparison.
1,169 03/23/2019 04:57:01 pm
Re: How can i update my Arabic Language (12 replies, posted in Translations)
Making translation changes to the .po file and then compiling the official FA strings into a .mo file and replacing them in the FA language folder will make the changes visible possibly after a restart of the webserver.
Have a look at the compiled versions in the FA24extensions repo for ar_EG.
1,170 03/23/2019 03:10:09 pm
Re: How can i update my Arabic Language (12 replies, posted in Translations)
The only Arabic translation in FA for now is the Egyptian version - ar_EG.
Unless the original string is in the empty.po, it is not referred to in the FA codebase.
empty.po should not be ordinarily edited.
A copy of the empty.po is taken and translated for each language.
If you are making a new module, then keep the language files for it in it's codebase and not in the FA core.
1,171 03/23/2019 01:54:39 pm
Re: Variables display but empty values sent to database (9 replies, posted in FA Modifications)
Must you have to urlencode the link?
1,172 03/23/2019 01:52:59 pm
Re: How can i update my Arabic Language (12 replies, posted in Translations)
There is no "Current Assets" (Google Translated الأصول الحالية) string in the official language template empty.po.
1,173 03/22/2019 03:50:58 pm
Re: Can we remove Help section from FA all pages (1 replies, posted in Setup)
Set the following variable in config.php:
$help_base_url = null;
This will suppress the Help link on the top right menu.
1,174 03/22/2019 03:39:10 pm
Re: Sales Direct Invoice has due_date and delivery_date bug (15 replies, posted in Report Bugs here)
@joe: are we using a stale session here?
1,175 03/17/2019 04:11:44 pm
Re: where can i find this get_trans_view_str function? (6 replies, posted in FA Modifications)
These are for CSS Styling classes. If the function argument is a scalar, then it goes into an array and if an array it is passed on as is.