26

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

31

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

No sir.  Trust me when I tell you everything in FA pointed to 2021 as the active year.  Not my first rodeo.  Weird, I know.  I have screen shots to back this up, but again I can't share them here.

I did a work around for this and this issue is now in my rear view mirror.  Not exactly sure why it happened, but since it DID happen (perhaps an anomaly) I needed a quick fix.

Anybody can do this, but I would NOT recommend it unless you know what you're doing.

Before you do anything LOG OUT of FA and then copy the gl_journal.php to to a safe place in another directory!

1.  Create a status.txt file in the gl directory.

2. Edit the status.txt file so it reads "Super Super Admin is turned off". (no quotes in the file).

3. copy file gl_journal.php to reg_gl_journal.php

4. copy file gl_journal.php to ssa_gl_journal.php

5. edit ssa_gl_journal.php and comment out (not delete) 6 lines:

        //elseif (!is_date_in_fiscalyear($_POST['date_'])) 
        //{
        //      display_error(_("The entered date is out of fiscal year or is closed for further data entry."));
        //      set_focus('date_');
        //      $input_error = 1;
        //}

5. Save the edited file as ssa_gl_journal.php (ssa = super super admin)

6.  Create a bash script named "ssa_cpa.sh" (or whatever you want)  as follows:

#!/bin/bash
read -p "Do you wish to be in Super Admin Mode? " USER_INPUT

if [[ $USER_INPUT = "yes" ]]; then
        cp ssa_gl_journal.php gl_journal.php
        sed -i 's/off/on/' status.txt
        echo "status.txt file will reflect super admin status."

elif [[ $USER_INPUT = "no" ]]; then
        cp reg_gl_journal.php gl_journal.php
        sed -i 's/on/off/' status.txt
        echo "status.txt file will reflect regular admin status."
else
        echo "Make up your mind please."

fi


7.  Save the bash script.

8.  Change rights to your bash file as:

9.  sudo chmod +x ssa_cpa.sh

10.  Just use FA as needed with your regular rights.  If you MUST have access to multi-year and can not do this through the UI, and it's an emergency then invoke the bash script.  In linux this is done as follows:

10: sudo bash ssa_cpa.sh

11. Answer the question as "yes" or "no" (no quotes, lower case response).  Anything else just ends it.   If you answer "yes" then status will be : "Super Admin is turned On."  Opposite if you answer "no".

12.  LOG BACK INTO FA

13.  When you are finished with your multi-year general journal entry, LOG OUT OF FA and immediately run the bash script again, and this time answer "no" to the question.  This will put everything back as it was, and you can then LOG BACK INTO FA.


If you ever forget what admin status you are in [keyboard] type:  cat status.txt and it will report on your terminal.  Note, all of the above requires you to be in command line in the /frontaccount/gl directory.

***DO NOT TRY THIS UNLESS YOU KNOW WHAT YOU'RE DOING.  IT'S A VERY SIMPLE WORK AROUND, BUT IT'S EASY TO FAT FINGER THIS FIX. DON'T DO IT UNLESS YOU ARE COMFORTABLE.***

***NO WARRANTIES WHATSOEVER - - USE AT YOUR OWN RISK***

:-)

No joy.

poncho1234 wrote:

Ref. screenshots: Once you have written your post go back and edit it, there should now be an option to upload an image. Not an image an attachment, but this is the end result.

******************************************************************************************************************************************************
Longer Subject:  The entered date is out of fiscal year (oh, no sir, it's not!) so you're Journal Entry ain't gonna happen (wanna bet?)
******************************************************************************************************************************************************
supportingDocs: https://imgflip.com/i/79hs43 (Images probably too small to be useful to anyone).

I hit another anomaly and  It's a bit of an issue.  An accountant needs to be unfettered when setting up a new company.  That person might be working on 2021 in 2023 - trying to enter a T/B to carry forward, etc.  Lots of reasons.  I can't apparently provide attachments to this post, but I have a 2021 fiscal year selected, and set up in the Company as active.  Under fiscal years it is also set up, and it should be good to go.  Now mind you, I'm doing this work in 2023, but FOR 2021.  This is real world stuff.  So I wanted to establish in 2021 accounts the "activity" - - profit and loss, with an entry to would encapsulate all activity for 2021.  Then the plan was to close this out, and roll into 2022 and basically do the same thing.  Even though 2021 was the ONLY active year set up, FA would not let me make the entry.    The offending code is found in gl_journal.php as follows:

// Would not let me post a journal entry in 2021, even though it was all set up for that.
        elseif (!is_date_in_fiscalyear($_POST['date_']))
        {
              display_error(_("The entered date is out of fiscal year or is closed for further data entry."));
              set_focus('date_');
              $input_error = 1;
        }
This, as I'm sure you know, calls the date_functions.inc and keys off of this code:

function is_date_in_fiscalyear($date, $convert=false)
{
        global $path_to_root;
        include_once($path_to_root . "/admin/db/fiscalyears_db.inc");

        if ($convert)
                $date2 = sql2date($date);
        else
                $date2 = $date;

        if (is_date_closed($date2))
                return 0;

        if (user_check_access('SA_MULTIFISCALYEARS')) // allow all open years for this one
                return is_date_in_fiscalyears($date2, false);

        $myrow = get_current_fiscalyear();
        $begin = sql2date($myrow['begin']);
        $end = sql2date($myrow['end']);
        if (date1_greater_date2($begin, $date2) || date1_greater_date2($date2, $end))
        {
                return 0;
        }
        return 1;
}

Not being able to post a 2021 entry to basically mimic the activity, albeit in summary, would render FA useless to me.  To get around this I simply commented out the function (last one I presented above) and ran the journal entry, and of course it worked fine once the digital hand-cuffs were removed.

My question is WHY DID THIS HAPPEN?  Trust me when I tell you everything in FA pointed to 2021 as the active year.  I have screen shots to back this up, but again I can't share them here.

Anyway, I just copy the original file (e.g., gl_journal.php -> gl_journal_original.php) and then make modifications to the gl_journal.php file.  Like I said, to comment out the handcuffs.  Once completed I just copy the original php code back into the directory.  This is a PITA so I'm hoping there is a reason for this.  If not, then it's definitely a bug.

Thanks.
Mac

36

(57 replies, posted in Installation)

Thanks.

37

(23 replies, posted in Setup)

Thanks Joe,  I reviewed the posts.  [scratching my head now].  I guess I'm not understanding what the close_period.php app is supposed to accomplish. I will continue to look at this.  I'm thinking it would be pretty easy to write an sql script that closes the books, or at least provides an easy calc page for someone to just post an adjusting journal entry.  I will continue to look at this. 

I appreciate your response.

In English this is asking:

Good morning!
Is there a Polish programmer on this forum who can make a plugin for KSeF for FA?

ksiegowosc.internetowa wrote:

Dzień dobry!
Czy jest na tym forum Polski programista który potrafi zrobić wtyczkę do KSeF dla FA ?

39

(23 replies, posted in Setup)

OK, I played around with the entire closing_gl module and I could not get it to work.   I reviewed the code, and frankly I'm not seeing HOW this could possibly close out the accounts.  Maybe I'm missing something. But we are talking about a traditional accounting closing exercise here right?  This essentially empties out the Revenue and Expense accounts and dumps the difference in a RE or SE account.  I do not see this calculation occuring anywhere in this code.  Again, maybe I'm missing something -> maybe it's calling it up somewhere else and I just missed it, but I am not now seeing how this code could possibly close out the books for a period (e.g., year).  Luckly it is an easy thing to do manually with a JE, and luckily one only has to do it once a year (in theory) per company.  Thanks

40

(7 replies, posted in Setup)

Deleting records in an accounting system is always A BAD IDEA.  You void them, so they are available for audit.

b.popoola wrote:

how do i delete customers with voided transactions. Each time i try to delete it says a cannot delete customer because it has transactions, but all the transactions has been voided

Just a note on 'fresh installations' using Educational data.  I installed it, and ran a Trial Balance (for 2017 of course ;-), and first thing I noticed was it was out of balance  -->  (the Opening Balance is not in balance, probably due to a non closed Previous Fiscalyear.) <--  by exactly $36.89.  ALL I did was install, and run the TB.  So there's a bug in this.

42

(57 replies, posted in Installation)

Well, you can change the default fiscal year, but it won't allow you to just set up a new year in 2022 I think. Seems you have to delete the intervening years first (open and then close).   Also, just a note on 'fresh installations' using Educational data.  I installed it, and ran a Trial Balance (for 2017 of course ;-), and first thing I noticed was it was out of balance (he Opening Balance is not in balance, probably due to a non closed Previous Fiscalyear.) by exactly $36.89.  ALL I did was install, and run the TB.  So there's a bug in this.  I'm going to post in the "bugs" section of the forum as well.  You guys are probably getting sick of seeing MacKenzie on all the posts, but I'm trying to get this all set up properly and identify any obvious failures up front.  Thx.

And how ridiculous is that?  I'm constantly putting screen shots up on www.imgflip.com with a link. Such as:   https://imgflip.com/i/797pxb

**********************************************************************
*****(Still no place to upload an image - but thx for trying).*****
**********************************************************************

seahawk wrote:

Thanks for the feedback.

Do not have the option to attach screenshots.

Go to Accounting and General Ledger/Deposit/ - The entry will open. You have the following three header columns from left to right:

Account Code / Account Description  /Amount / Memo(Fist Memo Entry Field) / Add Item

At the bottom, you have Memo (Second Memo Field).


The same happens on the Bank Payments entry screen.

Rafat, hope it helps.

44

(1 replies, posted in Report Bugs here)

Perhaps there is a user error.  Perhaps.  But after working with FA for some time, it does not apparently know how to close G/L entries.  This is rather easy to do manually with an adjusting journal entry, but I'm wondering what the trick is to get it to work.  Again, new users would be baffled by this.  Can anyone explain?  I left an example [picture] here --->  https://imgflip.com/i/797pxb

45

(57 replies, posted in Installation)

How can we set up a new company and have it default to 2022 or 2023?  FA defaults to 2017.

46

(10 replies, posted in FA Modifications)

This is what I'm seeing for setting up a new company.  I basically do not want to start at 2017 or 2018 or 2019, etc.  But it defaults to earlier years.  Where can I tell it I want a 2023 fiscal year??

Please see this screenshot. 

https://imgflip.com/i/797l9v

47

(10 replies, posted in FA Modifications)

I'm going to try that right now. Thanks.

48

(6 replies, posted in Setup)

Thank you my friend.  True story by the way.

PatJr wrote:
MacKenzie wrote:

"What is that CM account for?"

who says accounts don't have a sense of humor ...

49

(3 replies, posted in Wish List)

Fine.  Let's [archive] these ancient forum messages.  I suggest you look at this from a 'new user's' perspective.  That person is poking around our form and seeing messages from literally 13 years ago.  Not a good look. 

And speaking of new users, why are we still defaulting new years to 2017???  This program is better than that.  Can we PLEASE get some of this updated?  Thanks.

50

(10 replies, posted in FA Modifications)

Upon setting up a new company, one is defaulted to 2017.  This should be updated to at least 2021.  Can I get an Amen?  Thank you.