Hi Just so I don't mess this up. I presume I copy the routine into the 'modules' subdirectory? What do I do with the 'hooks' file?
Any idea how one would handle a split transaction, i.e. one amount in the bank statement allocated to 2 or more GL accounts?
Rgds
1 01/16/2020 05:00:15 pm
Re: Development of a "fancier" bank import module (4 replies, posted in Banking and General Ledger)
2 01/16/2020 04:43:50 pm
Re: Development of a "fancier" bank import module (4 replies, posted in Banking and General Ledger)
OK Thanks. I will take a look
3 01/09/2020 04:17:51 pm
Topic: Development of a "fancier" bank import module (4 replies, posted in Banking and General Ledger)
With due respect to the creators of the current bank import modules, FA has fallen behind more recent system regarding the sophistication of the important bank import functionality.
I am interested to know if anyone would be interested to adapt the current module to have the following functionality (inter alia):
- The ability to adapt to different formats of bank statements;
- The ability to identify single column debits & credits by sign;
- The ability to import debits and credits simultaneously;
- The ability to allocate transactions to appropriate GL accounts, as a lookup during the import process, including split allocations;
- Wishful thinking: To 'remember' prior allocations and to suggest these when performing a new import.
If so what kind of money are we looking at given that much of the functionality already exists in various PHP 'macros'
Regards
4 10/17/2019 05:27:43 pm
Topic: Error when printing to Excel (2 replies, posted in Banking and General Ledger)
When I print to Excel I get the message:
count(): Parameter must be an array or an object that implements Countable in file: /var/www/html/accounts/reporting/includes/excel_report.inc at line 243
and
count(): Parameter must be an array or an object that implements Countable in file: /var/www/html/accounts/reporting/includes/Workbook.php at line 6656
But the report still works.
How do I fix this please?
5 10/02/2019 11:27:31 am
Re: Import of a year of GL Transactions (7 replies, posted in Modules Add-on's)
Hi. Can you suggest how I might address the event_date problem please?
6 10/02/2019 06:58:45 am
Re: Import of a year of GL Transactions (7 replies, posted in Modules Add-on's)
Hello. I tried what you suggested and it did not work and the identical error message appears.
The specified CSV format for a Multiple Journal Entry import is:
entryid date reference accountcode dimension1 dimension2 amount memo
........................where the date refers to the transaction date. All the transaction dates are populated.
In the literature there is no requirement for an event date, although I see the SQL insert contains a number of additional columns. Can you advise me how to amend the file so as to insert a dummy event_date please?
7 10/01/2019 03:56:19 pm
Re: Import of a year of GL Transactions (7 replies, posted in Modules Add-on's)
I tried Import Multiple Journal Entries with debug on and got the following:
Undefined variable: trans_type in file: /var/www/html/accounts/modules/import_multijournalentries/import_multijournalentries.php at line 163
DATABASE ERROR : cannot add journal entry
error code : 1292
error message : Incorrect date value: '' for column `ppt`.`1_journal`.`event_date` at row 1
sql that failed was : INSERT INTO 1_journal( `type`,`trans_no`, `amount`, `currency`, `rate`, `reference`, `source_ref`, `tran_date`, `event_date`, `doc_date`) VALUES('0','4','3499.79','ZAR','1','GLImp1','','2018-03-01','','')
The import is complaining about the date value but I tried every permutation of date and it still does not work.
8 10/01/2019 01:53:31 pm
Topic: Import of a year of GL Transactions (7 replies, posted in Modules Add-on's)
Hi. Which would be the best module to achieve the import of a year's worth of GL transactions into FA? (Import transactions or Import Multiple Journal entries).
I tried the former and I get a "Green" result but nothing actually gets imported.
BTW: when invoking Import Transactions in FA 2.4.7 Theme Dynamic, the module fails to load due to a spelling mistake in the code:/modules/import_transations/import_transactions.php rather than the required /modules/import_transactions/import_transactions.php.
I am not sure whether other themes are affected or where to fix it.
9 07/30/2019 06:17:27 pm
Topic: TaxType in Import Bank Statement (2 replies, posted in Banking and General Ledger)
Can I confirm that the only alternatives in the column Tax_type in the import bank statements module, are 0 and 1 or are there other alternatives. The documentation is fairly silent on this and I am not particularly adept at interpreting php code.
Regards Barry
10 06/11/2019 12:24:35 pm
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
Hello. Excuse my ignorance but is it possible to get updated copies of the affected program files so that these can simply be overwritten in the appropriate FA subdirectories?
11 05/07/2019 01:21:22 pm
Topic: Splits on Imported transactions (1 replies, posted in Banking and General Ledger)
If one loads bank account transactions into FA via a CSV import, on occasion some of the transactions require to be split.
It appears that FA will not allow the retrospective split of deposit or payment transactions arising as a result of an import.
Is there any way to allow this please?
12 05/07/2019 01:16:04 pm
Topic: Bank Account Inquiry does not show Transaction Memo for Bank GL's (1 replies, posted in Banking and General Ledger)
Hello.
After reviewing various transactions imported via the Bank Import CSV extension, I notice that the Bank Account Inquiry does not display the Memo for transactions imported into a Bank GL account even though the individual transaction holds the detail.
Is there any way to fix this please?
13 05/05/2019 05:01:50 pm
Re: Bank Import: A non well formed numeric value encountered in file (1 replies, posted in Banking and General Ledger)
Hi. I managed to fix the problem myself. I was using LibreOffice Calc to format the CSV import file and for some reason, in the specific import file, the character formatting in 2 columns was set to an unknown locale. When I selected Format as US English for the column and save the file as a CSV the problem was eliminated.
14 05/05/2019 04:58:02 pm
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
I quite like the PuroV1 treatment. Regards
15 04/29/2019 07:53:49 pm
Topic: Bank Import: A non well formed numeric value encountered in file (1 replies, posted in Banking and General Ledger)
Hello.
I had to do a reinstall to address an incorrectly configured primary bank account.
Now when I try to import the csv files that worked before (as a Deposit or Payment import), I get:
A) 2:10601 in red where 10601 is the GL code for the current bank account, residing under the header 1060 Bank Accounts
B) Error messages: "A non well formed numeric value encountered in file: /var/www/html/accounts/modules/import_transactions/includes/import_transactions.inc at line ........" ( line numbers are mentioned)
As far as I can ascertain the format of the CSV file is correct.
Can anyone advise me on how to fix please?
Regards
16 04/11/2019 01:27:50 pm
Re: Problems with Import of statements using Bank Account Import extension (7 replies, posted in Modules Add-on's)
Hi. My apologies. The Deposit and the Payments tables are in fact showing up but are unpopulated after trial runs. All the individual transaction lines are shown in green.
17 04/10/2019 01:28:16 pm
Re: Problems with Import of statements using Bank Account Import extension (7 replies, posted in Modules Add-on's)
Hi. No table shows up at all.
18 04/09/2019 04:27:13 pm
Re: Problems with Import of statements using Bank Account Import extension (7 replies, posted in Modules Add-on's)
I'm not getting the Total line but all the line items show up green. How do I debug please?
19 04/08/2019 06:25:33 pm
Topic: Problems with Import of statements using Bank Account Import extension (7 replies, posted in Modules Add-on's)
Hello. I am having a bit of a problem in FA 2.4.6 using Import transactions (2.4.0-5). The COA in use is a modified version of English South African 5 digits COA - New (2.4.1-4).
A CSV was prepared according to the bank_en_GB.csv template
The import was tried in 2 phases: Deposit Processing and Payment Processing.
When I attempt a Trial Deposit run each line shows up in Green with the comment: "Ignoring payment. Use same csv under payment processing" and a further comment at the bottom that "Error: Debits do not equal credits." and the Trial Payment Processing also shows up in green with the expected comment " Ignoring deposit. Use same csv under deposit processing." and the same "Error: Debits do not equal credits."
When I tried an actual run after doing a backup, nothing gets posted to the DB.
Any suggestions on how to debug please?
20 10/15/2018 01:05:58 pm
Re: Conceal companies (4 replies, posted in Setup)
Thanks for your input Guys. I will use the apmuthu suggested method initially and then maybe switch to the other suggestion in time once I have worked out how to connect different copies of FA.
22 10/14/2018 10:05:41 pm
Topic: Login from web (1 replies, posted in Setup)
Hello. When I try and log in to our server from the Web, I can access the main screen but when I try and access any menu item I am immediately logged out. I believe my firewall settings to be correct but would appreciate other suggestions for a remedy.
23 10/07/2018 10:53:25 am
Topic: Conceal companies (4 replies, posted in Setup)
Hello. I am using FA to administer a number of companies. A few of the company have external users who access the server from the web. Is there any way I can set up FA so that for certain users not all the configured companies are shown on the login dropdown or would this need a second FA installation in a separate subdirectory within /var/www/html ?
(I thought I posted this before but I can't find the post)
24 07/31/2018 06:50:40 pm
Re: Recovery of old installation (5 replies, posted in Installation)
Hello:
I am still battling to log in in FA
I have access to all the respective company databases via phpmyadmin and have copied across config_db.php and also the company directory.
The FA login fails with:Incorrect Password
The user and password combination is not valid for the system.
If you are not an authorized user, please contact your system administrator to obtain an account to enable you to use the system.
Try again
and the error.log shows: [31-Jul-2018 20:39:37 Africa/Johannesburg] 0::connect_db_mysqli.inc:127:[before upgrade] mysqli_num_rows() expects parameter 1 to be mysqli_result, null given.
Can anyone suggest what else I can try please?
25 07/16/2018 12:27:11 pm
Re: Recovery of old installation (5 replies, posted in Installation)
Thanks. I'll give it a try.