That is indeed perseverance! Thanks. When all works well, kindly send a link to the zipped module for inclusion in the FA24extensions repo. It currently is in GitHub for the FA 2.3.x branch.
1,202 02/23/2019 05:51:43 am
Re: need some advice about sql is this bug or error on my end? (1 replies, posted in Report Bugs here)
Have you included the file that defines the said function? Check if the function exists and is in scope at that point.
1,203 02/23/2019 05:49:15 am
Re: Password not working for new company(1) (8 replies, posted in Setup)
You used the same database for the second company. Wonder how the admin user record did not get created in it's users table.
1,204 02/23/2019 05:47:35 am
Re: Duplicated Invoice Numbers if 2 users generating invoices at same time (23 replies, posted in Accounts Receivable)
Setup => Transaction References => Edit the "Pattern" field to include {UU} somewhere in it so that each user will have their own numbering.
1,205 02/19/2019 06:09:10 pm
Re: RepGen (4 replies, posted in Modules Add-on's)
Follow instructions in the docs folder of the module.
Basically try to generate some sample reports that are pre-populated in the sql folder which gets executed on activation and is usable on enablement of permissions for the desired role.
1,206 02/19/2019 04:21:30 am
Re: RepGen (4 replies, posted in Modules Add-on's)
Use the version in the FA24extensions repo. The official one does not work for FA 2.4 properly
Your issue is with the path not properly set in the official version of the extension and possibly permissions issue with the said folder if it still persists.
1,207 02/19/2019 04:18:18 am
Re: Last Visit Date with Time (2 replies, posted in Wish List)
@joe: This can be included in the core.
Setup => User Accounts Setup
Top Listing.
1,208 02/16/2019 05:15:25 am
Re: Duplicate entry on the GL Trial Balance (1 replies, posted in Banking and General Ledger)
Check the document number to see if the debt was doubly entered.
1,209 02/15/2019 02:47:15 pm
Re: Can't Find Dashboard Extension in 2.4.6 under Installed Extensions (2 replies, posted in FA Modifications)
Dashboard is now integrated in FA 2.4.x. There are a few themes that have been updated to partake of these new hooks to render them. One or two standard themes too leverage them.
1,210 02/13/2019 11:39:51 pm
Re: Password not working for new company(1) (8 replies, posted in Setup)
The users db seems okay.
Even though you could not log into the company 1, the errors would still be available in the tmp/*.logs files as well as the apache error logs at /var/log/....
The key error that appears is the lack of the en_AU locale from:
"Missing system locale: en_AU.iso-8859-1"
that the chart wants.
On a fresh install of FA 2.4.6+ Git Master code base, create company 0 and company 1 using the en_US-new and demo sql files as the chart of accounts.
Set the default "C" or en_US language locales to start with - do not make any changes for the Australian locale now.
Now see if you can login to both companies.
If all goes well, then install the en_AU locale in the server OS and then reboot the server for good measure and try with en_AU chart of accounts drawn from the FA24extensions repo - the official chart may not have been updated as yet.
The IP Hijacking code is listed in the wiki and referred to in a few posts in the forum but that addresses a connectivity recognition issue that may mostly not be directly relevant here.
The use of the bleeding edge MariaDB may have issues with FA's use of zero dates where strict date mode may need to be switched off. Assume you are using Ubuntu 18.04.
1,211 02/13/2019 03:40:09 pm
Re: couple of queries regarding 'Process Depreciation' (7 replies, posted in Fixed Assets)
@itronics: I hope this has not affected the depreciation / fixed assets reports
1,212 02/13/2019 03:26:23 pm
Re: Bank Account Charges (5 replies, posted in Banking and General Ledger)
Bank Account Charge is where you would have the contra entry for transactions that the bank injects like Account Maintenance Charges, Interest on Loan Account, Credit Card charges (not the direct spend), instrument clearing charges, exchange conversion fees, etc.
1,213 02/13/2019 03:10:14 am
Re: Password not working for new company(1) (8 replies, posted in Setup)
Logout
Clear browser cache
Close all instances of the browser
Login
List the contents of the users table.
Check if the IP Hijack code is causing issues with your PHP version.
Your diagnostics are for company 0 - list it for the company 1 or whichever failed.
1,214 02/13/2019 03:08:30 am
Re: Bank Account Charges (5 replies, posted in Banking and General Ledger)
Provide example of GL Entries you wish to achieve - voucher specifics.
1,215 02/13/2019 03:07:46 am
Re: Front Hrm 500 Internal Server Error (15 replies, posted in Installation)
Enable the openSSL extension in PHP and restart the webserver.
1,216 02/12/2019 07:16:06 am
Re: Front Hrm 500 Internal Server Error (15 replies, posted in Installation)
Folder write permissions issue?
1,217 02/11/2019 03:18:38 am
Re: Different behaviour Main vs. Secondary Company (10 replies, posted in Banking and General Ledger)
The field ordering for some tables do not match the en_US-new.sql. The table sys_types is no longer used in FA 2.4.x. There are other tables / fields in FA 2.4.6 with some dropped. The official charts have been reasonably updated to comply with table names and field presence and ordering in the FA24extensions repo.
1,218 02/11/2019 03:08:48 am
Re: How to process depreciation of assets created 2-3 financial years back (2 replies, posted in Fixed Assets)
@joe: Any fixes for non calendar year fiscals in dealing with depreciation?
1,219 02/07/2019 02:36:00 pm
Re: Project Accounting (3 replies, posted in Reporting)
Use an Open Sales Order for each Project till completion. Keep delivering as needed. Then on project completion, create a single sales invoice for all such deliveries. Use dimensions/tags as needed otherwise.
1,220 02/07/2019 03:57:49 am
Re: Project Accounting (3 replies, posted in Reporting)
Read the Wiki and search the forum or post your bounty in the Jobs forum for FA assistance.
1,221 02/05/2019 03:13:50 am
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
@joe: any commit needed?
@sledge: The existing CoA you are using must be compared with the one in my repo and suitable changes done to synch it with the latter among possibly others.
1,222 02/05/2019 03:12:45 am
Re: Bug when adding assets (access rights) (6 replies, posted in Fixed Assets)
Anyone else having this issue?
1,223 02/05/2019 03:12:11 am
Re: How to run depreciation for all assets (9 replies, posted in Fixed Assets)
It is not a solution. It will provide inputs to make an extension to accommodate it as a functionality even possibly in the core, whilst providing you a means of quickly getting the work done in the meanwhile.
1,224 02/04/2019 10:12:16 am
Re: How to run depreciation for all assets (9 replies, posted in Fixed Assets)
1. Take a backup 1.
2. Make one depreciation entry manually.
3. Make a list of all other assets you wish to depreciate in a similar manner.
4. Take backup 2.
5. Compare backup 1 and backup 2 and see what SQLs are needed to arrive at the latter from the former.
6. Make such SQL statements for other similarly depreciable items and execute it enblock
7. If anything breaks, revert to either backup 2 or 1 as appropriate.
1,225 02/04/2019 10:09:18 am
Re: Bug when adding assets (access rights) (6 replies, posted in Fixed Assets)
Will need to logout and login again after closing all browser instances and clearing the cache.