1 Reply by bd

(7 replies, posted in Installation)

I found these steps, but I am at version 2.3.18, not 2.3.24, so I am not sure if I need to update to 2.3.24 first

Steps to Upgrade it

1. Backup the database from your current version FA 2.3.24 .
2. Install a new fresh FA 2.3.26 on separate directory.
3. Restore the database which you backed up on FA2.3.24 and login as admin in FA 2.3.26
4. Again here Backup database  from 2.3.26 and save it on your pc
5. Download Fresh New FA copy, 2.4.4 and install it fresh.
6. Now you need to Restore the backup you exported from FA2.3.26
7. Now when you login as administrator, FA will ask you to update your database. 
8. Now go to Software Upgrade.  You can see Update option, Just click and update the Database.

Once these steps done successfully, everything will be alright with new version.

Go to forum: Installation

2 Reply by bd

(7 replies, posted in Installation)

OK, do you have the instructions? I have been looking, but I am not sure I found the right ones.

Go to forum: Installation

3 Reply by bd

(7 replies, posted in Installation)

I am not actualy doing it, I am looking for someone to do it for me smile

Go to forum: Installation

4 Topic by bd

(7 replies, posted in Installation)

As you can tell from my current version, I haven't updated FA for a while. If anyone could assist with upgrading to 2.4.6 I would be very grateful, and willing to pay smile

Go to forum: Installation

5 Topic by bd

(7 replies, posted in Dimensions)

Is there a way to modify FA so that Dimensions are carried over to balance accounts in all instances?

I need to be able to create department balance sheets (departments = dimensions) as well as profit loss sheets. Profit loss works fine, but not balance sheets.

Go to forum: Dimensions

6 Topic by bd

(1 replies, posted in Banking and General Ledger)

Hi,

I have a lot of different currency accounts and at least once a year I need to revaluate the accounts to match the year end exchange rates. I have posted a journal entry to the GL account concerned-  as I normally would in most other software, but have recently found that this actually affects at least one of the currency accounts. Later I found there is a  'Revaluation of Currency Accounts' option in the 'Banking and General Ledger' section. This, however, doesn't work.

Using the 'Revaluation of Currency Accounts' I get this error:

DATABASE ERROR : could not test for unique reference
error code : 1054
error message : Unknown column '0_refs' in 'field list'
sql that failed was : SELECT 0_refs FROM 0_gl_trans LEFT JOIN 0_voided v ON 0_gl_trans.type=v.type AND 0_gl_trans.id=v.id WHERE 0_gl_trans.0_refs='185' AND ISNULL(v.id) AND 0_gl_trans.type='0'

I have posted this to the bug tracker.

How can I adjust the value of my GL accounts related to Bank Accounts without affecting the bank account? And why does a journal entry to a GL account affect a Bank Account?

Thank you.

Go to forum: Banking and General Ledger

7 Topic by bd

(1 replies, posted in Report Bugs here)

Hi,

Is there anywhere one can download all bug fixes for a release (before a new version is available). I am using FrontAccounting 2.3RC3 built 07.12.2010 but have already seen a few bugs which may have been resolved. Therefore it would be handy to have a place to find the latest bug fixes.

Go to forum: Report Bugs here

8 Reply by bd

(2 replies, posted in Reporting)

2.3 RC3 as stated in the subject smile

Downloaded 02.12.2010.

Bent

Go to forum: Reporting

9 Topic by bd

(2 replies, posted in Reporting)

Hello,

I hope someone can help. I have searched the forum, but couldn't find a solution to my problem.

When I try to send reports using the email function, i.e. Reports and Analysis > Print Invoices/Credit Notes, select Yes in email Customers, I always get "Sending document by email failed".

I have checked that mail() is working properly, first by using my own mailing script, later by changing this line:

           $ret = mail($mail, $this->subject, "", $this->header);

in class.mail.inc to

           $ret = mail("somerecipient@somedomain.com", "Test subject", "Test body", "From: sender@mydomain.com");

That worked - but of course wouldn't enable me to send anything useful.

I am on Win 2003, SP2, using IIS6. PHP 5.2.6, MySQL 5.0.45-community-nt.

Thank you in advance.

Go to forum: Reporting

10 Reply by bd

(7 replies, posted in Setup)

Thank you, but I tried this and it returned an empty string...

Go to forum: Setup

11 Reply by bd

(7 replies, posted in Setup)

Thank you.

I am still having problems finding the variable which will show the company name. I guess there is a global variable for that.

Go to forum: Setup

12 Topic by bd

(7 replies, posted in Setup)

Hi,

Is it possble to add Company Name to the page title? I am often having several different companies open at the same time, and it would be convenient to be able to see the name of the company as part of the poage title. I have looked in many of the files, but have been unable to determine where this is set.

Thank you.

Go to forum: Setup

13 Reply by bd

(4 replies, posted in Accounts Receivable)

I am aware that joe wrote in 2009 that 'you would want all transactions' to show on a customer statement. However, if you have regular transactions with a customer over several years, you definitely do not want to show all transactions. My questions is, have the plans changed, so that we may get an option choose if we want all transactions or not? smile

Go to forum: Accounts Receivable

14 Topic by bd

(1 replies, posted in Reporting)

Hi,

Great software. I only have a few issues with it.

Some of our customers have an '&' in their name, and we have an '&' in our address. When sending reports via email the '&' prints as '&':

'Corner of Graduate Crescent & Bachelor Avenue'

Rather than

'Corner of Graduate Crescent & Bachelor Avenue'


The TO in the header of the email also looks wrong - even though the emails do get through to the recipients:

To: Customer Name part 1@localhost.domain.tld, &@localhost.domain.tld;Customer Name part 2 <email@email.tld>

Should have looked something like:

To: Customer Name part 1 & Customer Name part 2 <email@email.tld>

I am running FA 2.2.10 on CentOS Linux 5.3

Go to forum: Reporting