Read the Wiki and search the forum or post your bounty in the Jobs forum for FA assistance.
1,277 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,278 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,279 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,280 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,281 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.
1,282 02/04/2019 10:06:57 am
Re: couple of queries regarding 'Process Depreciation' (7 replies, posted in Fixed Assets)
Looks like we need to make this feature generic to be based on the fiscal year start and end dates.
1,283 02/04/2019 09:54:20 am
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
FA 2.3.26 release version has the same rep709.php as the v2.3.25 has. Ignoring whitespace changes, the effective diff between the FA 2.3.26 version and FA 2.4.6+ version is attached to experiment with.
1,284 02/03/2019 11:09:05 am
Re: New user: understanding dimensions and tags (10 replies, posted in Dimensions)
The Wiki lists all resources needed and searching the forums would be a start.
FA24extensions Repo
GL Account Groups Post
GL Sub Ledger Post | Alternative Post
1,285 02/02/2019 11:33:10 am
Re: New user: understanding dimensions and tags (10 replies, posted in Dimensions)
Use Sub-Ledger for properties and brokerage main accounts. The Wiki has only skeletal info on this as of now but some Charts in the official pkg repos and in the FA24extensions repo have examples of such usage.
1,286 02/02/2019 11:28:28 am
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
The official Dutch (nl_NL) Chart has been updated to match the fields and field orders in the FA24extensions repo.
1,287 01/31/2019 03:29:04 am
Re: Modularizing the Dashboard (82 replies, posted in FA Modifications)
In the 2.5 alpha, make provisions in the db for the bin concept in the warehousing for inventory - long overdue.
1,288 01/28/2019 06:34:17 pm
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
Official Dutch CoA has some infirmities is excess/missing fields as also some other CoAs. In my unofficial FA24extensions repo, I have corrected all of them thus far:
There was no difference between the official nl_NL-default.sql and the one in my unofficial FA24extensions repo except that the lone fiscal year start date has been advanced from 2017 to 2018 and the presence of a missing sys_prefs flag:
('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'),It has since been updated in my repo to have the corrections for missing fields, not needed fields as well.
Furthermore, there are some differences between the official chart and the one auto-generated from my script.
Official:
INSERT INTO `0_bank_accounts` VALUES
('1010', '2', 'XYZ Bank betaalrekening', '12345678', 'XYZ Bank', 'Adres bank 1\n1234 AB PLAATS BANK', 'EUR', '1', '1', '9040', '0000-00-00 00:00:00', '0', '0'),
('1000', '3', 'Kas', 'N/A', 'N/A', 'N/A', 'EUR', '0', '2', '9040', '0000-00-00 00:00:00', '0', '0'),
('1020', '0', 'XYZ Bank spaarrekening', '12345678', 'XYZ Bank', 'Adres bank 1 \n1234 AB PLAATS BANK', 'EUR', '0', '4', '9040', '0000-00-00 00:00:00', '0', '0');
Generated:
INSERT INTO `0_bank_accounts` (`account_code`,`account_type`,`bank_account_name`,`bank_account_number`,`bank_name`,`bank_address`,`bank_curr_code`,`dflt_curr_act`,`id`,`bank_charge_act`,`last_reconciled_date`,`ending_reconcile_balance`,`inactive`) VALUES
('1060', '0', 'Current account', 'N/A', 'N/A', NULL, 'EUR', '1', '1', '5690', '0000-00-00 00:00:00', '0', '0')
,('1065', '3', 'Petty Cash account', 'N/A', 'N/A', NULL, 'EUR', '0', '2', '5690', '0000-00-00 00:00:00', '0', '0');
Similar data changes in chart class, chart_master, etc.
Official audit_trail: `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
Generated audit_trail: `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
Official bank_trans: `bank_trans_type_id` int(10) unsigned DEFAULT NULL,
Generated bank_trans: No such field in FA 2.4
Official bom: fields parent, component, loc_code are all CHAR fields.
Redundant: KEY `parent` (`parent`,`loc_code`),
PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
Generated bom: The above fields are all VARCHAR
No KEY: `parent`
PRIMARY KEY (`parent`,`loc_code`,`component`,`workcentre_added`),
Official budget_trans: No memo_ field after `account` field
Generated budget_trans: `memo_` tinytext NOT NULL,1,289 01/28/2019 05:59:57 pm
Re: Email Recurrent Invoice (2 replies, posted in Report Bugs here)
Both links in your post above are the same. Try to inspect the code behind the browser display of the link - you might find another link is some js.
It is possible that the email was being spooled if there are many in the range or that the range is not properly made to be ascending (from/to).
Anyone else getting this issue?
1,290 01/27/2019 03:54:33 pm
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
@joe: In the light of discussions here and in the other thread, please set this issue to rest.
1,291 01/27/2019 02:22:26 pm
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
Applying CoA differences between the official one and mine is trivial as it mostly just has schema changes in field ordering. The real issue comes when using the new pattern of document numbering from FA 2.3.x to FA 2.4.x. If your FA 2.4.x has errors on using my CoA but no errors on using the official CoA, then your official CoA schema will need to be compared with mine in a diff tool like WinMerge or directly in a MySQL client like SQLyog.
The FA userbase would be sad to see a longtime user like you go if you do! We are here to do any hand holding as required.
1,292 01/27/2019 02:08:04 pm
Re: small bug item units db (2 replies, posted in Report Bugs here)
@anoopmb: good catch. Needs to be corrected in FA 2.3 as well. Where did you have to use this function?
Whether a new field is necessary and whether the function name should be changed accordingly needs to be ascertained.
Note that this function is not used in FA 2.3.26 and in FA 2.4.6 as well and see if it needs to be removed. Neither is it used in any official theme / extension and those in my FA24extensions repo.
@joe: can commit it.
1,293 01/26/2019 07:08:25 am
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
The menus appear very cluttered (when expanded out) for accounting usage. A nice attempt though and maybe the finished version will be better.
1,294 01/26/2019 07:01:37 am
Re: Posting A/P JE without referencing a Supplier (7 replies, posted in Accounts Payable)
Upgrade to FA v2.4.6+ Git Master and hopefully your issue was fixed.
1,295 01/25/2019 06:38:19 pm
Re: Posting A/P JE without referencing a Supplier (7 replies, posted in Accounts Payable)
version.php and at the bottom of your FA Web User Interface.
1,296 01/25/2019 06:30:58 pm
Re: Posting A/P JE without referencing a Supplier (7 replies, posted in Accounts Payable)
FA version used?
1,297 01/25/2019 06:29:58 pm
Re: Can we make 1 master copy of any company! (1 replies, posted in Setup)
https://www.youtube.com/watch?v=7qW_ReF60aU
https://www.howtoforge.com/one_machine_mysql_replication
https://www.toptal.com/mysql/mysql-master-slave-replication-tutorial
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql
https://dba.stackexchange.com/questions/63159/fastest-way-to-create-local-copy-of-live-innodb-mysql-database
1,298 01/25/2019 03:23:51 pm
Re: close year 2017 (3 replies, posted in Banking and General Ledger)
As all your data is in ar_EG, what is the account code for your P&L Account? The sys_prefs table shows it as: 9990. There is also such an account in the chart_master table. Why did you have other accounts after the P&L account like:
,('9990','','الربح / الخسارة للعام','23',0)
,('9991','','م. سولار وبنزين السيارات','22',0)
,('9992','','مصروفات نثرية متنوعة','50',0)
,('9994','','محمد سلطان - دائنون','41',0)
,('9995','','م. كهرباء','50',0)
,('9996','','صيانة عقار','50',0)
,('9997','','م. مياة','50',0)
,('9998','9998','غرامات ','50',0)
,('99982','','اغلاق العام','23',0)
,('9999','9999','م كارته ','50',0);
-- Translation
, ('9990', '', 'profit / loss for the year', '23', 0)
, (1999), M. Solar and Benzin Motor, 22, 0)
, ('9992', 'Miscellaneous sundry expenses', '50', 0)
, (9994', '' Mohamed Sultan - creditors', '41', 0)
, ('9995', '', 'M. electricity', '50', 0)
, ('9996', '', 'maintenance of property', '50', 0)
, ('9997', '', 'M. water', '50', 0)
, ('9998', '9998', 'Fines', '50', 0)
, ('99982', '', 'General Fines', '23', 0)
, ('9999', '9999', 'M Karate', '50', 0);?
You cannot have sub-ledger accounts across different chart classes.
1,299 01/24/2019 11:00:18 am
Re: close year 2017 (3 replies, posted in Banking and General Ledger)
File not visible in BSNL, India
1,300 01/24/2019 10:58:18 am
Re: Supervising remotely Deployment of FRONTACCOUNTING for two programmers (2 replies, posted in Jobs wanted/offered, non-free offers)
Fork the project on GitHub and commit your changes with notes - good development model. Your changes can also be pulled into the core for sustainable upgradation.