PHP Version 5.3 and MySQL version:5.0
1 06/04/2013 11:02:42 pm
Re: Print customer statements error (3 replies, posted in Accounts Receivable)
2 05/28/2013 03:59:30 am
Topic: Print customer statements error (3 replies, posted in Accounts Receivable)
I'm facing an error whle printing customer statement, with the following settings:
No customer filter, No currency filter, Show Also Allocated: No
below is the error mesage:
DATABASE ERROR : No transactions were returned
error code : 1305
error message : FUNCTION a2245610fa.ABS does not exist
sql that failed was : SELECT 0_debtor_trans.*, (0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) AS TotalAmount, 0_debtor_trans.alloc AS Allocated, ((0_debtor_trans.type = 10) AND 0_debtor_trans.due_date < '2013-05-27') AS OverDue FROM 0_debtor_trans WHERE 0_debtor_trans.tran_date <= '2013-05-27' AND 0_debtor_trans.debtor_no = '2' AND 0_debtor_trans.type <> 13 AND ABS(0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) > 1e-6 AND ABS (ABS(0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) - alloc) > 1e-6 ORDER BY 0_debtor_trans.tran_date
But when i use the following settings:
No customer filter, No currency filter, Show Also Allocated: Yes
There is no error encountered.
Additional information:
FA version: 2.3.16
Hosted at Godaddy
3 05/19/2013 03:16:46 pm
Topic: Bug in cancelling sales order (0 replies, posted in Accounts Receivable)
Hi all,
I'm not sure i'm the only one experiencing this:
The sales orders can be deleted by edit - cancel order, in sales order inquiry.
After pressing "Cancel Order", a dialogue box will pop up, i can press "Cancel" to cancel the action, or "OK" to confirm the action.
But whether i press "Cancel" or the ESC key, the "Cancel Order" action will still continue.
I'm using FrontAccounting 2.3.16
4 05/10/2013 09:16:16 am
Re: Cash account cannot be $0? (8 replies, posted in Banking and General Ledger)
Changing the line works.
Thanks.
But the same thing needs to be changed for "Payment entry" as well so that paying the exact same amount as the Cash Account has is possible.
Will this be fix in the next release?
5 05/09/2013 11:50:00 pm
Re: Cash account cannot be $0? (8 replies, posted in Banking and General Ledger)
It shouldn't be a rounding error because all the amount keyed in was in 2 decimal place.
And I have just changed the decimal place to 4, the amount i have is exactly 216.8500
If i transfer 1 cent less: 216.84, it's ok.
this is the code that i extracted from bank_transfer.php, not sure if it helps:
$limit = get_bank_account_limit($_POST['FromBankAccount'], $_POST['DatePaid']);
if ($limit != null && ($limit < $amnt_tr))
{
display_error(sprintf(_("The total bank amount exceeds allowed limit (%s) for source account."), price_format($limit)));
set_focus('amount');
return false;
}
6 05/09/2013 03:11:16 pm
Re: Cash account cannot be $0? (8 replies, posted in Banking and General Ledger)
Someone please help??
7 05/08/2013 03:38:48 pm
Topic: Cash account cannot be $0? (8 replies, posted in Banking and General Ledger)
I have $216.85 in the cash account and i want to transfer all the amount into a saving account. I did it at "Bank Account Transfers"
I get the following error message:
The total bank amount exceeds allowed limit (216.85) for source account.
What happened?
How can i do the transfer correctly?
8 11/20/2012 06:00:02 am
Re: Prices on Delivery Notes? (15 replies, posted in Setup)
Hi Janusz,
1. The Packing list is for internal use, it is not given to customers/buyers.
2. We get third party delivery service to deliver goods for us. If the delivery note has products prices on it, who ever that deliver and/or store the goods will know the market value hence greed in the heart grows and loss of items will also hapens
3. We don't want the delivery guys to talk about the prices with the receiving companies about the different in prices.
Another point worth noting is, adding a signature and company stamp fields at the bottom of the delivery note is important too
9 11/16/2012 12:56:57 am
Re: Changing Fiscal year from phpmyadmin (2 replies, posted in Setup)
Just tested it, it looks like everything is fine
10 11/15/2012 05:01:46 pm
Topic: Changing Fiscal year from phpmyadmin (2 replies, posted in Setup)
Hi, I have been using FA for a while now, my current fiscal year is set to
19/05/2011 to 31/12/2011
01/01/2012 to 31/12/2012
I have keyed in all transactions from 19/05/2011 to 31/07/2012
Now, i would like to change fiscal year to:
19/05/2011 to 31/05/2012
01/06/2012 to 31/05/2013
If i delete an make new fiscal year, "All transactions are deleted and converted into relevant balances.", which is what i don't want.
I'm wondering if i change the fiscal year from phpmyadmin, will i have any issue with the transactions i have already keyed in, balance sheet, profit & loss reports?
11 11/15/2012 04:49:24 pm
Re: Prices on Delivery Notes? (15 replies, posted in Setup)
I hae done a little modification on the file to turn all prices to 0.00.
open file /reporting/rep110.php
comment out the followings by adding 2 slashes:
//$Net = round2(((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]),
// user_price_dec());
//$SubTotal += $Net;
//$DisplayPrice = number_format2($myrow2["unit_price"],$dec);
add: $DisplayPrice = "0.00";
comment out the following:
/*$DisplayTotal = number_format2($myrow["ov_freight"] +$myrow["ov_freight_tax"] + $myrow["ov_gst"] +
$myrow["ov_amount"],$dec);*/
add: $DisplayTotal = "0.00";
12 10/28/2012 12:11:06 am
Re: Invoice against delivery note - editable price and discount (4 replies, posted in Accounts Receivable)
I guess it will be very helpful for all of the users if the assumption is removed.
13 10/25/2012 04:46:25 am
Re: Invoice against delivery note - editable price and discount (4 replies, posted in Accounts Receivable)
Any body?
Or is this a short coming of FA?
14 10/23/2012 02:19:33 pm
Topic: Invoice against delivery note - editable price and discount (4 replies, posted in Accounts Receivable)
We sell products to at Store X on consignment basis, we delivery goods to Store X and only issue invoice at the end of every month after receiving sales report from Store X. Sometimes Store X is having store wide discount and we have to bear the discount given by Store X to their customers. As the result, our selling price on the invoice has to be adjusted.
But when we "Invoice against delivery note", the price and discount of the items are not editable.
Any one can help?
16 06/30/2012 10:50:47 am
Re: Launch email (11 replies, posted in FA Modifications)
ok.
In this case, where can i remove the "Email this XXX" link so that users won't send it accidentaly?
Thanks
17 06/29/2012 01:54:39 pm
Topic: Launch email (11 replies, posted in FA Modifications)
Hi all,
I got the email function working, but it just sends the email in the background without allowing me to do any editing: add personal message, add other email etc
Is there a way to launch the email application (outlook/Thunderbird etc) with the attachment (invoice. PO etc) attached, so that user can add email from the address book and type the message before sending.
Thanks
18 06/25/2012 04:16:37 am
Re: login prompt again and again (1 replies, posted in Installation)
Hi all, updates for this issue.
I have tried installing FA 2.3.6 and 2.3.7, both works without any problem on the remote host.
However, i managed to solve the problem on FA 2.3.11 by using a proxy on my Firefox.
I think the problem is caused by the Dynamic IP on my internet connection, which is something that i cannot change. But by manually putting the proxy on Firefox network connection setting, the login prompts disappear.
19 06/24/2012 02:48:11 pm
Topic: login prompt again and again (1 replies, posted in Installation)
Hi all, i am using FA 2.3.11, install on Ubuntu 12.04, Xampp 1.7.7.
Every thing is running fine without any problem.
But when i uploaded it to the remote host, i encounter this problem: when ever i want to go to a new page, FA will ask me for password.
What i have tried with no help:
1. set the $go_debug variable in config.php to 1, no error message (even with browser java script support turned off)
2. replacing '$secure=null' with '$secure=false' in session.inc
3. install FA 2.3.11 fresh from the remote host (installation is successful), no error message because error log is not found in /tmp
(remote host is running a Linux server)
Can the administrator / moderator please help.