FrontAccounting forum — Proper Upgrade path

Re: Proper Upgrade path

null@example.com (joe) — Sun, 07 Feb 2010 16:48:16 +0000

Just remove as much of the transactions that you can see, and I will clean the rest and prepare it for a new COA. Just remember to keep the hart_master, chart_types and chart_classes and the standard accounts on the company.

/Joe

Re: Proper Upgrade path

null@example.com (shopimport) — Sun, 07 Feb 2010 15:52:58 +0000

Ok, clear how to make the dump. However before sending it I'd like to remove my transactions and don't how to perform this. I hope you do understand. Thanks.

Re: Proper Upgrade path

null@example.com (joe) — Sun, 07 Feb 2010 10:44:10 +0000

You can just send the sql dump as an attachment. They are not that big. Or you can zip it.
If there are more companies in the file, I will pick the one with 1_ as table prefix.
If they have a 1_, in front of the tables (table prefix), I will change them to 0_. 0_ is the standard in the COAs. This prefix will be replaced when you the create company in FA. If you want such a file with 1_ or other values you must first make a search and replade (1_ should be replaced by 0_). But as told, I can do that for you and I can adjust the COA as much as possible.

/Joe

Re: Proper Upgrade path

null@example.com (shopimport) — Sun, 07 Feb 2010 09:41:33 +0000

Could you refer me to instructions how to prepare the upload? I made a copy of the database with a 0_ and 1_ company. The 1_ is the correct one. However now I need to know which tables to truncate before uploading a dump? I'd like to contribute this however it would speed up if you do have some instructions.

Re: Proper Upgrade path

null@example.com (joe) — Sat, 06 Feb 2010 16:05:48 +0000

Hello again,
Remember first to make a backup of your company

You can send the sql dump to:

contributions@frontaccounting.com

/Joe

Re: Proper Upgrade path

null@example.com (shopimport) — Sat, 06 Feb 2010 13:21:20 +0000

In setup -> System and General GL setup I've entered for the Dutch situation:

Retained Earnings = 3590 Winstreserve voorgaande jaren (in English it is Retained Earnings prior years and in your demo shop it's also 3590)

Profit/Loss Year = 9990 Resultaat Boekjaar (winst/verlies) (in English it is Year Profit / Loss and in your demo shop it's also 9990)

The 3590 is already existing in the dutch chart of acconts. The 9990 needs to be created in the GL group 'General & Administrative Expenses' via General Ledger -> GL accounts.

Joe, if you can provide me instructions how to submit the Dutch chart of accounts then I will contribute mine. So far I found out it's a mysqldump of the company database, however I do already have company info which I then firts need to erase?!

Re: Proper Upgrade path

null@example.com (joe) — Fri, 05 Feb 2010 15:32:31 +0000

Hello again,
The Dutch COA from our Website - Download, have been created by others. It may need some fine-tuning. If you do this, please return a fine-tuned copy back to us. We will be appreciated.

/Joe

Re: Proper Upgrade path

null@example.com (shopimport) — Fri, 05 Feb 2010 13:35:45 +0000

Your explanation makes it more clear. I now understand that it are just two different methods.

One remark that I can also see the PL statements on closed years in my previous package. Anyway, I respect your choice.

Now I will need to find the Dutch accounts for this as the default of the Dutch chart of account which I downloaded from frontaccounting.com shows for both Retained Earnings and Profit/Loss Year and entry the BANK account which will be totally wrong.

Re: Proper Upgrade path

null@example.com (joe) — Fri, 05 Feb 2010 12:48:37 +0000

If you only use one account for the profit/Loss year, you don't have to close all the other income/expense accounts.
This way it is possible to retrieve profit/loss over several years for a dimension, acting as a project. There are other advantages to this. You can still make PL statements on closed years. Instead of a Calculated return, you will get your result in the Profit/Loss year account.

You can read more about this in under fiscal years.

/Joe

Re: Proper Upgrade path

null@example.com (shopimport) — Fri, 05 Feb 2010 11:01:45 +0000

Hi Joe,

Thanks for this explaination, however I do have a question about how frontaccounting will perform the year closure.

I didn't do a year closure yet and need to set the Retained Earnings and Profit/Loss Year. But first I need to understand the working as I was used to another method.

My previous accounting package will do indeed the credit booking on the Retained Earnings account. And it will do a lot of other bookings on the profit / loss accounts to get all to zero.

So I don't understand the meaning to enter a Profit/Loss Year account.

I hope you can explain to me

Re: Proper Upgrade path

null@example.com (joe) — Thu, 31 Dec 2009 08:57:47 +0000

Hello, I will try to explain how it works.
And I will explain it in an easy way.
After the fiscal year has come to an end and a new one is created, you may want to close the previous year when the last entries have been done.
Before that your assets have accumulated into $2000. The liabilities have reached $1500. The difference between these $2000 and $1500 is your Equity (or Net assets). $500.
Your revenues have reached $3000 and you expenses have reached $2500. Net income is $500.
Now you want to close the fiscal year. The Net Assets (or Equity) $500 is booked in credit on RETAINED EARNINGS (this account is accumulating the year net assets over years).
The Net Income, $500, will always be the same as the year net assets. So the debit booking of $500 is going to the PROFIT/LOSS YEAR.

When the fiscal year is closed you can no longer make entries into it.

/Joe

Re: Proper Upgrade path

null@example.com (tom) — Thu, 31 Dec 2009 01:49:28 +0000

In the update.html it says:

Enter 'Setup' tab, 'System and Generel GL Setup'. Set the correct Accounts for Retained Earnings, Profit/Loss Year and Bank Charge.

I think the BANK CHARGE is used for the Bank Fees for sending or receiving money

Can you give a layman's description for RETAINED EARNINGS and PROFIT/LOSS YEAR?

tom
ps. very wierd I turned on sql_trail and it completed with no errors...

Re: Proper Upgrade path

null@example.com (tom) — Thu, 31 Dec 2009 01:16:29 +0000

I will look at it, I glanced at it before posting and did not see where comments were being updated... I will dig deeper..

tom

Re: Proper Upgrade path

null@example.com (joe) — Wed, 30 Dec 2009 22:58:42 +0000

Oops. This routine is inside the file /sql/alter2.2.php that is used when running Software Upgrade.

I haven't heard about problems here, and I find no spurious things here. The memo_ field is escaped.
I guess Janusz will look at this when he is back in office again.
Do you think you can fix the error, tom?

/Joe

Re: Proper Upgrade path

null@example.com (tom) — Wed, 30 Dec 2009 16:12:48 +0000

ok.

One speed bump...

Notice the use of ' in the comments...

DATABASE ERROR : cannot update record
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
sql that failed was : UPDATE 0_comments SET `memo_`='hello, \nplease make sure that the package is mailed asap. it's critical for me to receive it before friday. I understand that priority mail takes about two days, which should work fine for me.\nthank you.\n' WHERE