1 Reply by aquarius

(8 replies, posted in Installation)

Thank you!

Go to forum: Installation

2 Topic by aquarius

(8 replies, posted in Installation)

I am currently running PHP version 5.5 on my server but would like to upgrade this version to PHP 5.6. as I also have other sites on this server.

Support for PHP version 5.5 will soon be discontinued by php.net

Is it safe to upgrade my server to PHP 5.6 or even 7.0 without compromising FA?

Thanks / Frank

Go to forum: Installation

3 Reply by aquarius

(3 replies, posted in Setup)

aquarius wrote:
joe wrote:

No, but you can create a service iten, called tax free shipping. Use the new gl account for this one.

Everytime you use tax free shipping only select this service as your last item.

Thanks for the quick reply Joe.

I didn't think of that but will set it up and report back.

Frank

Perfect!! Thanks again.

Go to forum: Setup

4 Reply by aquarius

(3 replies, posted in Setup)

joe wrote:

No, but you can create a service iten, called tax free shipping. Use the new gl account for this one.

Everytime you use tax free shipping only select this service as your last item.

Thanks for the quick reply Joe.

I didn't think of that but will set it up and report back.

Frank

Go to forum: Setup

5 Topic by aquarius

(3 replies, posted in Setup)

In Setup > System and General GL Setup we have one option for Shipping Charged Account.

Mine is currently set to account 4160 Postage Charge Domestic. That account is used for parcels shipped to local Australian customers and is inclusive GST.

Because I am also filling orders from international customers I have a second account Postage Charge Export (4162). According to Australian tax regulation that charge is GST exempt.

Now, when I create a sales invoice I only have one option where I enter the Shipping Charge. Regardless of destination, be it local or export, the shipping charge is posted to account 4160 which is subject to GST.

Is it possible to create a second option for Shipping Charged Account which can be configured in Setup > System and General GL Setup to post to account 4162 (no GST) and of course a drop down in the sales invoice entry screen??

I am using FrontAccounting 2.3.24

Any help or pointer is appreciated

Thank you

Go to forum: Setup

6 Reply by aquarius

(15 replies, posted in Setup)

Can't get this time zone issue to work properly. I am located in/near Brisbane/Australia.

My config.php files show the time zone asf:

    if (!ini_get('date.timezone'))
       ini_set('date.timezone', 'Australia/Brisbane');

Yet the actual time zone displayed on the live site is UTC+1 or 'Europe/Berlin'

Frontaccounting is hosted in a subdirectory of my main site. The main site displays the correct time zone, both front and and admin.

What could be wrong?

Thanks / Frank

Edit:
-----

Fixed it by adding

date_default_timezone_set('Australia/Brisbane');

to includes/date.functions.inc

Now shows the proper time.

Go to forum: Setup

7 Reply by aquarius

(28 replies, posted in Banking and General Ledger)

That looks good Joe - certainly fills my requirements. Thank you!

Just had to make one (temporary) change as I don't have a company logo uploaded - the report threw an error (company logo missing...)

// Company logo setting
// $companylogoenable = true;
$companylogoenable = false;

Once I did that the report loaded without problems.

You may want to test if the company logo is actually present and if not then set 

$companylogoenable = false;

That would account for people like myself who don't want to show a company logo.

Another suggestion:

Allow selecting a period say 2nd quarter of the current financial year or a selected month, meaning we need a period from -->> to box (boxes)


Thanks / Frank

Go to forum: Banking and General Ledger

8 Reply by aquarius

(28 replies, posted in Banking and General Ledger)

Just curious: has any progress been made with this mod?

Go to forum: Banking and General Ledger

9 Reply by aquarius

(4 replies, posted in Accounts Receivable)

Thanks Janusz

Sorry - late reply from my side (due to personal issues) but can report that I had made a booboo when entering the payment. Erroneously (and repeatedly) entered the full payment amount into the Bank Charges field - which makes the whole transaction zero. I am sorry but I am still trying to get to grips with FA.

Noticed my error, restored a backup of the DB and re-entered the payment. Works fine....

We live and we learn!

Cheers / Frank

Go to forum: Accounts Receivable

10 Reply by aquarius

(4 replies, posted in Accounts Receivable)

I may add to the post above that I am using

FA 2.3.18 - theme Dashboard

locally:

- Linux Mint 15
- PHP Version     5.4.9-4ubuntu2.3
- mysql Client API version     5.5.32

webserver:

- CentOS Linux
- Apache version    2.2.23
- PHP version    5.2.17
- MySQL version    5.0.96-community

Australian COA

Australian language pack

Can't figure out what may have gone wrong - any takers please?

Thanks / Frank

Go to forum: Accounts Receivable

11 Topic by aquarius

(4 replies, posted in Accounts Receivable)

New to this...

Invoiced a customer and promptly received payment.

Went to sales > Customer Payments, selected the customer, entered the relevant reference, allocated the amount, hit "Add Payment" and I am getting this error:

DATABASE ERROR : no debtor trans found for given params
sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id, com.memo_,bank_act,0_bank_accounts.bank_name, 0_bank_accounts.bank_account_name, 0_bank_accounts.account_type AS BankTransType, 0_bank_accounts.bank_curr_code, 0_bank_trans.amount as bank_amount FROM 0_debtor_trans trans LEFT JOIN 0_comments com ON trans.type=com.type AND trans.trans_no=com.id LEFT JOIN 0_shippers ON 0_shippers.shipper_id=trans.ship_via, 0_debtors_master cust, 0_bank_trans, 0_bank_accounts WHERE trans.trans_no='2' AND trans.type='12' AND trans.debtor_no=cust.debtor_no AND 0_bank_trans.trans_no ='2' AND 0_bank_trans.type=12 AND 0_bank_trans.amount != 0 AND 0_bank_accounts.id=0_bank_trans.bank_act

Went to phpmyadmin and looked in 0_debtor_trans, and I am seeing type = 13

It appears that the sql is looking for type = 12 which does not exist, my transaction shows type 13 and not 12

I am stumped - could anyone please let me know what to do and why the type shows 13 and not 12

Thanks / Frank

Go to forum: Accounts Receivable

12 Reply by aquarius

(28 replies, posted in Banking and General Ledger)

That looks perfect Joe.

Guess all the required data is already present in the FA DB?? One would need to decide which method (direct or indirect) to use. My preference would be the direct method.

It would be good to have the option of a monthly, quarterly and annual report.

Cheers / Frank

Go to forum: Banking and General Ledger

13 Reply by aquarius

(28 replies, posted in Banking and General Ledger)

Hi guys,

first post, just installed and configured FA on my webserver (SSL) in an attempt to get rid of the QuickBooks tax and eventually the M$ Windows tax.

FA offers all I need with the exception of a Cash Flow Report.

I am (sort of) familiar with php having contributed a few Zencart plugins and also maintaining the German language pack for the latest ZC 1.5.1

But that is where my php coding capabilities end....

Whilst looking around the web for a php based cash flow report I found this:

http://media.wiley.com/Lux/42/310642.image0.jpg

Basically that is the report needed in FA. Would the FA devs be willing to give this a go.... ??

Thanks

Frank

Go to forum: Banking and General Ledger