Thanks for the explanation on how to do this.
I have PM'd you.
Marc
1 09/25/2015 04:09:34 pm
Re: Charge HST on Fees and Withholding Pension and Union dues on Same Fees (2 replies, posted in Banking and General Ledger)
2 09/23/2015 06:15:15 am
Re: Withholding tax deducted (13 replies, posted in FA Modifications)
Is this the same as in my example here? https://frontaccounting.com/punbb/viewtopic.php?id=5950. I have to withhold Union dues and pay Pension dues from musicians fees.
3 09/22/2015 08:58:58 pm
Topic: Charge HST on Fees and Withholding Pension and Union dues on Same Fees (2 replies, posted in Banking and General Ledger)
I wonder if anyone could suggest a way to do this, I manage a music group and pay musicians the following (the following rates are just to illustrate my situation):
$100 + 13%HST (in Canada-Ontario = 5%GST + 8%PST) = $113.00
From the same $100 I also have to withhold 2% in musicians union dues= $2.00 (*this amount is then remitted to the musicians union)
From the same $100 I also have to pay 8.5% pension = $8.50 (*this amount is then remitted to the musicians union pension plan)
Is there a way to set FrontAccounting to do these transactions all at the same time?
I am new to FrontAccounting.
Marc
4 09/21/2015 09:19:35 am
Re: Dimensions and liabilites (5 replies, posted in Dimensions)
Hi Joe,
I did read most of the wiki ... but also took the advice of this thread with regards to non-profit use of FrontAccounting here: https://frontaccounting.com/punbb/viewtopic.php?id=2628
I think this would work with tracking our costs/expenses for our concerts, is this not correct?
Marc
5 09/21/2015 04:52:02 am
Re: Dimensions and liabilites (5 replies, posted in Dimensions)
Would it be better though to use dimensions if I am going to have a budget for my "Bach Bites"? I am also tracking the ticket income as well as grants/donations.
I was going to group all of my concerts with each its own dimension so that we can budget appropriately for each concert (we are doing around 8 concerts/yr.
6 09/20/2015 07:33:46 am
Topic: Dimensions and liabilites (5 replies, posted in Dimensions)
I am trying to understand the use of dimensions and am liking the way it works for our non-profit. I just have this question about how this would work out:
I manage a non-profit music group and wondered how I would work this out (or if what I am doing is right). From time to time, during a particular concert run, and to accommodate the flow of money I do the following (I am using "Bach Bites" as a concert example):
* I personally cover the expenses of the concert "Bach Bites" till the tickets sales income is deposited into our bank account (I have set up a dimension in FA called "Bach Bites"
* I have set up "items" with "Bach Bites" chosen as dimension
Now here is where I get a little confused, I would like to track my costs of the "Bach Bites" concerts using the dimensions, but how do I make sure that my payments to the items where I have covered the costs are also properly noted in FA?
Marc
7 09/18/2015 09:03:44 am
Re: Restoring from Backup (7 replies, posted in Setup)
Thanks! Nice to know this and really helps.
Thanks again for all of your wonderful help.
Marc
8 09/17/2015 01:54:50 am
Re: Restoring from Backup (7 replies, posted in Setup)
Yes, the companies are all on the same database. All three are related to music groups and, to keep the number of databases down on my shared server, they need to share the same database -- I do not have many more number of MySQL database left on my host service.
For now, I have re-installed FA and restored the Backup.
However, here is an example to demonstrate the issue I see with the restoration process with FA.
IF ...
* a FA user creates (let's say) 3 FA accounts on one database with the table-prefixes of "0", "1", and "2"
* and then has issues with a damaged FA account "1" and is forced to erase it (so the FA account table-prefix "1" is now erased
* it does not look like there is an easy way of restoring that account "1" as the FA restoration process will only allow you to restore databases that still exist
* in addition FA will only let you create a database account with a table-prefix of "x+1" (starting from the last prefix number) ... so in this case, the only option in creating an account is to create a FA database table-prefix of "3" and not "1" -- FA will not allow the creation of a database table-prefix of "1", but will only allow the creation of a new database account with a table-prefix of "4"
* FA does not allow you to create a database with a table-prefix of "1", so, that the user is able to restore the table-prefix "1".
I suspect the only way to fix this example would be to create a new FA database account with table-prefix "4", do the restoration of the backup of the table-prefix "1" account and then go into the database and physically change the table-prefix name of each table by hand to "4" so that the information may then be used with the new FA account table-prefix "4".
In my case, for example, it was easier to delete my database (with all 3 companies with table-prefix "0", "1", and "2"), recreate the same 3 companies in the right order and then restore all from my backups
I am wondering if there could be a more elegant way of allowing the FA user to recreate a FA account with a table-prefix that is less than what FA normally allows? Or another way, would be for FA, when asked to create a company, it would scan the table-prefixes in use and if there are any gaps in "free" prefixes, then FA could allow the user to create a company with these prefixes as well as the usual "x-last-prefixused + 1" formula.
Sorry if this all sounds confusing. Let me know if you need me to make my example clearer or if you can see any other way of solving such a situation.
Thanks for your help and patience ... FA is a wonderful piece of software!
Cheers,
Marc
9 09/16/2015 11:51:25 am
Re: Restoring from Backup (7 replies, posted in Setup)
Thanks for the quick reply.
I am going to treat this as a learning exercise for myself and try to understand how to fix.
I have now created 4 more companies and can no longer pick "Table Pref: 1" from the admin setup tab -- "Create Update company". When I now click on the "Table Pref:" it will only let me choose "6" as the "Table Pref". If I drop all of the tables except of course for "0" does this then reset the "Table Pref" to "1"?
Is there a way to force a "Create" to a particular "Table Pref" number? My backup was done on a table prefix of "1".
Marc
10 09/16/2015 10:08:11 am
Topic: Restoring from Backup (7 replies, posted in Setup)
I am not sure what I am doing wrong. I am new to FrontAccounting.
I had created my company and wanted to roll-back to a previous backup. For some reason, the restore took a very long time ... which never happened when I tested FrontAccounting.
So, I created a new company with the same name, but the original company had the "Table Pref: 1 and now the new company has the "Table Pref:2"
When I try to restore from my backup, it doesn't seem to work. I made sure the fiscal years matched. But, I wonder, when a backup is restored, should it not restore ALL of the files, regardless of the previous database table pref or fiscal years? Should it not just overwrite all?
In my case, it does seem to overwrite anything and my new copy of the company is empty of data (or at least I can't seem to see any).
Any ideas?
Just to add, if the issue is that I need to have the same "Table Pref: 1" as the original company, how would I reset FrontAccounting to allow me to create a new company, but going back to "Table Pref: 1" ... where would I be able to change the database file to reset the numbering count for "Table Pref"?
Marc
11 06/30/2015 08:23:54 pm
Re: Problem with editing customer contacts (15 replies, posted in Report Bugs here)
Eek! Thanks for this fix from me too! I was wondering if I was doing something wrong.
Marc
12 06/30/2015 08:07:09 pm
Re: COA Canadian non-profit (5 replies, posted in Misc. Charts of Accounts)
That would be just wonderful! Do I need to submit anything or is the link to the .pdf enough for the devs to work from?
Marc
13 06/30/2015 08:05:42 pm
Re: New installation and default Admin email address (3 replies, posted in Installation)
Should this then be suggested as a bug? of request? or, is it just OK to leave this comment here for someone at FrontAccounting to pick up the suggestion and make the change?
I am new to FrontAccounting and am not sure if there is a protocol on how to submit these.
Marc
14 06/29/2015 09:58:04 am
Topic: New installation and default Admin email address (3 replies, posted in Installation)
I am not sure if anyone is aware of this, but, when a new FA company is set up, the default admin email is "adm@adm.com". However, the domain "adm.com" is already a sold domain. I am just wondering that, if a new FA user is not aware of the immediate need to change her/his admin email, there is the possibility that an email could be sent in error to "adm@adm.com".
Would it be better to have the default admin email address be something more like "Please@ChangeThisEmail.address" or "ChangeThis@Admin.EmailAddress" or some "dead" email address where the likelyhood of an email sent in error to "adm@adm.com" NOT be sent?
It would not surprise me if the site "adm.com" would have a "catch-all email" setup for "*@adm.com" to catch any stray emails sent to their domain address.
Marc
15 06/29/2015 09:46:49 am
Re: COA Canadian non-profit (5 replies, posted in Misc. Charts of Accounts)
I am just now, finally getting back to this.
I have entered my chart of accounts and wonder this:
* For North America (Canada/USA): Is there a numbering scheme or convention, that N. American Chartered Accountants follow when adding additional Chart of Accounts (COA) categories? Is the numbering scheme mentioned in this link (1) valid category numbers to use in a new FA Canadian setup? I used the FA "English Canadian COA - General" and added the extra account categories to it.
* If the numbering for these new categories is OK, I wonder then, would it then be possible for me to send a blank backup of my setup to someone at FA so that it may be changed and offered as "English Canadian COA - NFP Charitable Medium-Sized Orchestra"? I think the setup may be of value as a FA COA to anyone else who may be looking at FA to manage a medium-sized orchestra. At least it will set them up quickly for their orchestra with Canadian categories.
Marc
16 05/12/2015 08:43:12 pm
Re: Time zone issue (15 replies, posted in Setup)
That is wonderful news! Thanks!
Marc
17 05/12/2015 05:06:05 pm
Re: Time zone issue (15 replies, posted in Setup)
I am a little confused with your message. Are you saying that it has already been implemented and that the time-zone can be changed in FA?
Otherwise, IMO, for most users, going into the config.php or anything else is just going to increase the frustration when they are at the very beginning of using FA. It would seem to make more sense to remove the item of frustration by adding the ability to change the time-zone inside FA setup.
Marc
18 05/10/2015 12:27:38 pm
Topic: COA Canadian non-profit (5 replies, posted in Misc. Charts of Accounts)
Does anyone have a suggestion for a new installation of a Canadian non-profit COA? Is there a COA for Canadian non-profit available for FA?
I am new to FA and would like to set it up for our group.
I have found this recent resource that suggests the setup for a COA for a medium sized orchestra non-profit which looks like it would suit our group. The document can be found here http://orchestrascanada.org/wp-content/ … counts.pdf
Any suggestions?
Marc
19 05/10/2015 12:16:16 pm
Re: Time zone issue (15 replies, posted in Setup)
I would also be in favour of Raj's suggestion of adding a table with times zones where a user could pick her/his timezone. It would then make it unnecessary for a user to be forced to update the timezone in the config.php or php.ini or any other file. I suspect many users will not have easy access to those files nor have enough PHP knowledge to modify them.
IMO, best to do such changes inside the FrontAccounting setup.
Wonderful package. I have just installed it and will start using it soon.
Marc