Thanks KV
2 02/20/2023 09:25:41 pm
Re: Opening Year - 2017 (10 replies, posted in FA Modifications)
It's not a problem. Once I create a new company, and then run a mysql script that updates gl_classes, gl_coa, quick_entries, fiscal years and other things. Take less than 5 seconds. ;-)
I think @joe was very clear with this and I quote him:
joe wrote:Hello Sir,
I guess you are referring to an external COA. In the FA core there are 2 COAs, en_US_demo.sql and en_US_new.sql. These 2 COAs only contains two fiscal years, Currently these are 2020 and 2021.
In the next minor release these will be updated to 2021 and 2022.
All the COAs in the Extension repository are maintained by various users and some are probably not updated.
Joe
3 02/19/2023 08:48:46 pm
Re: How do I transfer an asset from a sister company? (2 replies, posted in Fixed Assets)
You get an answer to this? It's pretty easy, but don't want to answer if you already have your answer. Confusing.
4 02/19/2023 08:46:49 pm
Topic: Depreciate Fixed Assets in Batch (2 replies, posted in Fixed Assets)
If I have 100 Fixed Assets, someone please tell me I don't have to hit "process depreciation' 100 times. Where's the batch option? Thanks.
5 02/13/2023 06:54:46 pm
Re: Opening Year - 2017 (10 replies, posted in FA Modifications)
I think I was referring to something else.
My new company installations still default to 2017/2018. This is a brand new company setup (today 02132023), and clearly it doesn't really likes 2017/18. Must have been a great year! ;-) - - Not sure it matter but I got this after selecting 5-digit coa.
what did you find and how you solved it?
6 02/13/2023 06:51:17 pm
Re: A New Archive Category has been established. (5 replies, posted in Announcements)
gotcha. Thanks.
7 02/13/2023 01:36:22 pm
Re: A New Archive Category has been established. (5 replies, posted in Announcements)
thanks for this, but I'm not seeing any archived messages.
After some initial statical problems while converting to Archives, it seems to work now.
Joe
8 02/08/2023 10:25:02 pm
Re: Download the frontaccounting-2.4.8.zip (3 replies, posted in Report Bugs here)
If they aren't visible in the GL, then I doubt if they're in the proper table. It's just a read after all (select * from XX where YY = ZZ;)
I downloaded the frontaccounting-2.4.8.zip,
Enabled this function, enabled for the user. Inserted around 300 COA records in Chart table using mysql- phpmyadmin tool. I am able to see COA in Journal Entry screen. This is good.
INSERT INTO `0_chart_master` VALUES
('1010000', '', 'CASH - BOK FINANCIAL ', '1', '0'),
('1011000', '', 'CASH - AZ BIZ BANK - MM ', '1', '0'),
('1015000', '', 'CASH - PACIFIC PREMIER ', '1', '0'),
('1020000', '', 'CASH - DEPOSIT ACCOUNT ', '1', '0'),
('1021000', '', 'CASH - DEPOSIT IN TRANSIT ', '1', '0')....................Created the following csv format for journal entries,
entryid,date,reference,accountcode,dimension1,dimension2,amount,memo
000001,07/15/2020,JV000001,2000000,,,-15970.00,"0000000033 I VEND L21140 "
000001,07/15/2020,JV000001,8550010,,, 15970.00,"0000000033 I VEND L21140 "
000002,07/09/2020,JV000002,2000000,,,-06305.00,"0000000393 I VEND A19250 "
000002,07/09/2020,JV000002,8600000,,, 06305.00,"0000000393 I VEND A19250 "
000003,07/04/2020,JV000003,2000000,,,-01900.00,"0000000526 I VEND K05225 "
000003,07/04/2020,JV000003,8660000,,, 01900.00,"0000000526 I VEND K05225 "
000004,07/10/2020,JV000004,2000000,,,-01550.00,"0000000527 I VEND K05225 "
000004,07/10/2020,JV000004,8660000,,, 01550.00,"0000000527 I VEND K05225 "It is not showing any errors or message and the records are not posted in Ledger accounts.
Please help on this.
Thanks
9 02/08/2023 10:21:31 pm
Re: PunBB (6 replies, posted in Wish List)
I don't think you need a separate one. Just a chunk of this one designated for older threads. Some good info in there.
10 02/08/2023 01:16:04 am
Re: How to clean up old dandruff and past errors from closed years (4 replies, posted in Banking and General Ledger)
Hi Bruce,
I'm a CPA licensed to practice in North Carolina. I have used FA for some time. It is, as you know, extremely powerful, but it's easy to get it off track if one isn't careful. If you care to drill down a bit for me concerning the issue(s), I can noodle it better. For starters, where are you seeing the allocated balances? On a Financial Statement, Trial Balance, or a General Ledger Report? Are you pretty familiar with mysql? Ever get in there and perform queries? Do you have multi-fiscal year editing turned on? Do you see the same bank reconciliation error every month?, or different ones?
MacKenzie
11 02/08/2023 12:59:30 am
Re: Select deliveries on dimensions (4 replies, posted in Dimensions)
I look at dimensions like almost a non-accounting function. We used to keep books for a lobbying concerning. We tracked typical stuff like travel expenses, meals and entertainment, and that was fine, but at year end they also wanted to know, ok, out of all these expenses for all these projects, how much was spent on Red-Dye#2 (Grocery lobbying). That what I would use it for.
Deliveries don't have GL-bookings and the intention is to batch deliveries in an invoice, but only select the deliveries of a dimension.
F.
12 02/08/2023 12:57:13 am
Re: Not Able to find asset, update or delete from the system (3 replies, posted in Fixed Assets)
Were you able to get this resolved? I think it happened to me once.
Dear @joe I just installed new FA on Ubuntu 20.4 with PHP 7.43 MYSQL 8
After registering assets in the system, i am not able to find them again, to modify or delete them,
supposed to be under maintenance fixed Asset tab, but it only showing 2 tabs, general settings and transactions. there is no where to select existing assets to either modify the description, code or depreciation date.thanks
13 02/07/2023 09:17:50 pm
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
I'm happy to report that I was able to get this working. I still have NO IDEA why it abended before.
Thanks for your comments.
Regarding the fonts used in FA I have to agree. The themes for FrontAccounting were designed long time ago, for much lower resolution displays than current FHD standard. We will fix this soon. (In before, the application is designed for table displays, not smartphones, so - even if we received some suggestion to change this - we will stay with assuming table monitor as target display).
Regarding Hrm module by Nostrinos, I have just updated the version available from default FA extensions repo. Please test if you have any problems with this version. Frankly, in now way I could reproduce your problems with the module. Both previous as current version installed on fresh new FA installation works as expected. Yes, I could point many constrains in usage of this module in real business workflow, but bottom line is it just works. For any feature improvement please contact HRM module author.
J.
14 02/07/2023 09:16:18 pm
Re: PunBB (6 replies, posted in Wish List)
I agree with Rafat, who agees with poncho1234. It's crazy that new users can't attach a picture to their posts. Also, as I pointed out before, seeing posts 10 years old in the 'active' forum makes zero sense. I realize there is some utility in these, but move them into an historical archive directory.
It's a bad look for new users. We're trying to grow FA, right?
15 02/07/2023 09:12:18 pm
Re: How to clean up old dandruff and past errors from closed years (4 replies, posted in Banking and General Ledger)
Accountants, at least here in the United States, are taught to never purge records. If you disagree with this then have at it. But if you agree it's a good idea to keep them (audit trail purchases), then you're left with AJE's. Adjusting Journal Entries. That's what I would do personally. Good luck.
I have been using FA for about 10 years now. As I have upgraded, learned what the hell I was doing, changed my procedures, and generally used the system, there has been a slow accumulation of errors that I would like to somehow purge.
Off the top of my head:
- Unallocated payments
- unreconciled bank transactions
- default bank reconciling starting balancesI have items that are up to 10 years old that still show up (but are locked because the years are long closed) that I would like to make go away.
Any ideas?
Thanks
16 02/07/2023 09:03:08 pm
Re: No discount option on Supplier or Direct Supplier Invoices (6 replies, posted in Accounts Payable)
OK, if it's needed by the "gumment", but on the Purchases tab it has a "Purchase Discount Account". This won't work??
Accounts Payable Account:
21010001 Accounts Payable
Purchase Account:
Use Item Inventory/COGS Account
Purchase Discount Account:
In RSA you have to declare Discounts received from a supplier and discounts Given to Clients.
17 02/05/2023 08:01:47 pm
Re: Migrate contacts to new company in FA (5 replies, posted in Setup)
I think that will work. Personally, I would probably just mysql -u root - p, and insert the records in a new table. :-)
I was missing two tables, and found them based on this thread:
https://frontaccounting.com/punbb/viewtopic.php?id=7241Below are the steps for anyone with basic knowledge like me.
1. Using phpMyAdmin or similar tool, identify the company prefixes. In this example I want to transfer the data from Company 0 to Company 1.
2. Using the RENAME feature under Operations, move the following tables to different names (delete might work but something could go wrong)
1_crm_contacts --> x1_crm_contacts
1_crm_persons --> x1_crm_persons
1_cust_branch --> x1_cust_branch
1_debtors_master --> x1_debtors_master
1_suppliers --> x1_suppliers3. Use the COPY feature under Operations to bring the data from the original company to the new company:
0_crm_contacts --> 1_crm_contacts
0_crm_persons --> 1_crm_persons
0_cust_branch --> 1_cust_branch
0_debtors_master --> 1_debtors_master
0_suppliers --> 1_suppliersThat's it. Company 1 should now have all the contacts from Company 0.
18 02/05/2023 04:53:54 am
Re: Opening Year - 2017 (10 replies, posted in FA Modifications)
**************************
I found this. SOLVED!
**************************
19 02/05/2023 04:50:29 am
Re: PCN Luxembourg 2021 (1 replies, posted in Misc. Charts of Accounts)
If I wanted (and I do) to establish a revised COA for a Church, let's say, and didn't want to modify the heck out of GL_Classes, GL_Account_Groups and COA's available, where do you recommend I look for that code? In other words, after a fresh install, I want to see the Classes, GL Groups and COA of exactly what I want. Lots of churches so I don't want to re-invent this everytime.
I want to start from here on Classes. Only 5 Classes (not the 11 that is standard on some installs):
1 Assets Assets
2 Liabilities Liabilities
3 Equity Equity
4 Income Income
5 Expense Expense
and something like this for Groups where every "group" parental number ties to a major accounting component (A,L,E,I,EX)
1000 Assets Assets
1020 Current Assets Assets Assets
1040 Inventory Assets Assets Assets
1060 Capital Assets Assets Assets
2000 Liabilities Liabilities
2020 Current Liabilities Liabilities Liabilities
2040 Long Term Liabilities Liabilities Liabilities
3000 Equtiy Equity
3020 Retained Earnings Equtiy Equity
4000 Income Income
4020 Sales Income Income Income
4040 Misc Income Income Income
5000 Expenses Expense
5020 General & Administrative expenses Expenses Expense
5040 Cost of Goods Sold Expenses Expense
5070 Payroll Expenses Expense
5080 Taxes Expenses Expense
The Church needs classes/groups/COA's to be easily identified within the 5 major components of pretty simple and basic accounting system. ASSETS, LIABILITIES, EQUITY, INCOME, EXPENSE.
I went back and modified a non-profit install, but it was a TON of work, so I want to set it up as an option in the future.
Any thoughts on how to proceed.
Thanks in Advance.
MacKenzie
20 02/05/2023 04:38:28 am
Re: The entered date is out of fiscal year (oh, no sir, it's not!) (8 replies, posted in Report Bugs here)
No problem. I like FA and will continue to be involved.
21 02/05/2023 04:35:16 am
Re: No discount option on Supplier or Direct Supplier Invoices (6 replies, posted in Accounts Payable)
As a seller, you can of course provide a discount to a purchaser, hence #6 in Direct Invoice.
As a purchaser, you do not get to set the discount so it's irrelevant. In the States, your cost is your cost. Vendor A sells Wiget X for $20. Vendor B sells Wiget X (similar) for $22, but discounts it $2. I'm really not interested in tracking "so called" discounts on items purchased. Sales is a different story.
Cheers.
I do not know if it is a language "South African English" issue or what. FA 2.4.14
When you do a Direct sales/ Direct invoice/ your first line item headings Column from left to right are:
1. Item Code
2. Item Description
3. Quantity
4. Unit
5. Price after tax
6. Discount%
7. Total
8. Add item.On Purchases/ Direct Supplier Invoices/ columns are L2R:
1. Item Code
2. Item Description
3. Quantity
4. Unit
5. Price before tax
6. Line Total
7. Add ItemNo discount option.
22 02/02/2023 10:31:05 pm
Re: No discount option on Supplier or Direct Supplier Invoices (6 replies, posted in Accounts Payable)
The purchase discount isn't working? Mine works. Explain more please.
Why is there no discount option on Supplier or Direct Supplier Invoices global or per line item?
How do we indicate these discounts received?
23 02/02/2023 07:42:36 pm
Re: The entered date is out of fiscal year (oh, no sir, it's not!) (8 replies, posted in Report Bugs here)
MacKenzie, not Mackensie. I appreciate it.
24 02/02/2023 02:42:08 am
Re: use system via Android or IOS (1 replies, posted in Wish List)
It's web enabled. Android/IOS can access it via the web. Do they mean an app? Nobody in their right mind is going to do their accounting on their phone. Perhaps a tablet though. Great post!
25 02/02/2023 02:35:51 am
Re: Table '#_users' isn't restored when restoring a backup (6 replies, posted in Report Bugs here)
You got me curious with this so I thought I would test it. Besides my admin account I went ahead and set up 3 additional users. Did a backup/restore and sure enough the users didn't come over. I examined the sql backup file:
INSERT INTO `XX_users` VALUES //for some reason this doesn't work
('1', 'admin', 'blahblahblahblah', 'Administrator', '2', '', 'adm@adm.com', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2023-02-02 03:12:50', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'),
('3', 'Larry', '66f4b449b3a98abf87f2521e35513542', '', '1', '', NULL, 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', NULL, '10', '1', '1', '', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'),
('4', 'Moses', 'd41d8cd98f00b204e9800998ecf8427e', '', '9', '', NULL, 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', NULL, '10', '1', '1', '', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'),
('5', 'Curly', 'd8000efdcdd3ee172793aa6e73bcb8b4', '', '3', '', NULL, 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', NULL, '10', '1', '1', '', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');
I could see no reason why this wouldn't be restored. So I took the exact same SQL insert statement and ran it on the database using myphpadmin and it updated the XX_Users table just fine. Seems to be some kind of bug. One thing about code, there is ALWAYS a reason. Not like people who maybe are just having a bad day ;-) If you have a 'ton' of users it's easy enough to do what I did and they will restore. If you find the bug, let us all know.
Looks like it the protect security setting. Look there first perhaps.
Cheers.
Mac
Good luck.
Hi,
As the title indicates : I wanted to restore the backup of a company but it seems that the users-table isn't restored.
Kind regards,
F.