1

(2 replies, posted in Fixed Assets)

Thanks KV

2

(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.  ;-)

rafat wrote:

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

You get an answer to this?  It's pretty easy, but don't want to answer if you already have your answer.  Confusing.

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

(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.


rafat wrote:

what did you find and how you solved it?

gotcha.  Thanks.

thanks for this, but I'm not seeing any archived messages.

joe wrote:

After some initial statical problems while converting to Archives, it seems to work now.

Joe

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;) 

aletheamartinez wrote:

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

(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.

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

(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. 

advocaat.pollet wrote:

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.

Were you able to get this resolved?  I think it happened to me once.

cedricktshiyoyo wrote:

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

I'm happy to report that I was able to get this working.  I still have NO IDEA why it abended before. 

itronics wrote:

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

(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?

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.

brucek@pelhamhs.org wrote:

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 balances

I 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

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:   

seahawk wrote:

In RSA you have to declare Discounts received from a supplier and discounts Given to Clients.

17

(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.  :-)

mawulitse wrote:

I was missing two tables, and found them based on this thread:
https://frontaccounting.com/punbb/viewtopic.php?id=7241

Below 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_suppliers   

3. 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_suppliers

That's it. Company 1 should now have all the contacts from Company 0.

18

(10 replies, posted in FA Modifications)

**************************
I found this.  SOLVED!
**************************

19

(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

No problem. I like FA and will continue to be involved.

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.


seahawk wrote:

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 Item

No discount option.

The purchase discount isn't working?  Mine works.  Explain more please.

seahawk wrote:

Why is there no discount option on Supplier or Direct Supplier Invoices global or per line item?

How do we indicate these discounts received?

MacKenzie, not Mackensie.  I appreciate it.

24

(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!

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.



advocaat.pollet wrote:

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.