Hi Joe

It's working fine now.

Thanks

Hi Joe

The payment to suppliers is working fine. If possible we need customer payment exactly the same.

Thanks

Hi
There is a bug in enter customer payment form. Once you have updated customer payment and then when you select "Enter another customer payment", the same customer comes up but with empty list. Even the customer has more than one outstanding invoice, it doesn't show. It only shows after you have changed to another customer and then choose the same one again. Basically the page is not being refreshed after updating a payment then going for another payment for the same customer. I think this was working fine in version 2.3.12/13.

Hi

There is a bug in enter customer payment form. Once you have updated customer payment and then when you select "Enter another customer payment", the same customer comes up but with empty list. Even the customer has more than one outstanding invoice, it doesn't show. It only shows after you have changed to another customer and then choose the same one again. Basically the page is not being refreshed after updating a payment then going for another payment for the same customer.

Hi Joe

Yep. That fixed the bug.

Thanks

Hi

I am getting this error when I am editing customer payment.

DATABASE ERROR : The debtor transaction record could not be inserted
error code : 1366
error message : Incorrect integer value: '' for column 'payment_terms' at row 1
sql that failed was : UPDATE 0_debtor_trans SET debtor_no='7' , branch_code='7', tran_date='2013-02-12', due_date='0000-00-00', reference='CPT000375', tpe='0', order_='0', ov_amount=182, ov_discount='0', ov_gst=0, ov_freight='0', ov_freight_tax=0, rate=1, ship_via='0', alloc=0, dimension_id='0', dimension2_id='0', payment_terms='' WHERE trans_no='416' AND type='12'

57

(3 replies, posted in Report Bugs here)

Hi Joe

It's fix.

Thanks

58

(3 replies, posted in Report Bugs here)

Hi

There is a bug when crediting a sales invoice. The field "Invoice Date" shows my working date rather than actual invoice date.

Thanks

59

(7 replies, posted in Accounts Receivable)

Hi Joe

I wrote a note in memo in direct purchase invoice but I can't see memo in view supplier invoice. Is that a bug?

Thanks

60

(8 replies, posted in Report Bugs here)

Hi Joe

The fix has solve the bug.

Thanks

61

(8 replies, posted in Report Bugs here)

Hi

after updating the .inc file, I am now getting this error

DATABASE ERROR : Can't update record status
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 '0 WHERE id='6'' at line 1
sql that failed was : 0 WHERE id='6'

62

(8 replies, posted in Report Bugs here)

I am using 2.3.15

63

(8 replies, posted in Report Bugs here)

There is a bug on bank accounts. When I untick inactive box I am getting this error. I am also getting this type when I make taxes active from inactive status.

DATABASE ERROR : Can't update record status
error code : 1366
error message : Incorrect integer value: '' for column 'inactive' at row 1
sql that failed was : UPDATE 0_bank_accounts SET inactive = '' WHERE id='6'

64

(1 replies, posted in Accounts Payable)

Hi

I am trying to make £3000 cash payment to a supplier but FA has limit restriction. could anyone let me know how to overide this limit?

Thanks

65

(2 replies, posted in FA Modifications)

Hi Joe

As soon as I choose quick entry in "Pay to" from changes to "Cash".

66

(1 replies, posted in Setup)

Hi

I am setting up FA from year starting from 01/04/2012. I want to enter balance sheet (closing balances) as of 31/03/2012 on 31 March 2012 so that they become opening balances on 01/04/2012. Could you please suggest me how to do this.

Thanks

67

(2 replies, posted in FA Modifications)

Hi

I think it we should be able to set bank account in quick entries. Every month I want to do set up quick entry for direct debit payment from one of my bank accounts. At present when I bring up quick entry, by default it "From" comes up with "cash" account which I have to manual change to my bank account. It would be very nice if we are able to setup bank account in quick entries for bank payments and deposits.

Thanks

Hi

I need urgent help on how to remove OD limit on cash account. I am setting up new system and doing payment entries first. when I post a payment from cash I am getting error "The bank transaction would result in exceed of authorized overdraft limit for transaction: # on 09/01/2013." Please suggest where is this limit set.

Thanks

69

(9 replies, posted in FA Modifications)

Because tax lines posted in tax_trans_details table are not exactly the figures in purchase invoice, adding a service line does not work. When you enter VAT only line say for £0.02, the logic which posts the line to the above table will calculate net amount on £0.02 VAT (£0.10 @ 20% VAT) and post in the tax table which is wrong. There is not extra net purchase. It's just the VAT difference on the supplier invoice of few pence which I want to adjust so that my system purchase invoice agrees to supplier's invoice. In UK you have to show all VATable & Zero VATable sales & purchases excluding VAT on VAT return. FA also ignores zero VAT/tax transactions being posted to tax_trans_details table if you post invoice using form "Suppliers Invoice". So for UK purpose, only use "Direct Invoices" and make all suppliers as UK VAT registered (assign 20% VAT tax). I still do not agree with the logic of posting it's own calculation for tax purpose.

Thanks

70

(1 replies, posted in Wish List)

I think we should have "Supplier's Reference" (which is supplier's invoice number) in Supplier Balances Report. At present it shows FA system voucher number (which is useful to us to find filed hard copy invoice/credit note) on this report but it doesn't make sense to supplier (they will only recognize their invoice number) when we send them our report in case of reconciliation. So we need both these columns on this report.

Thanks

71

(1 replies, posted in Accounts Payable)

When I create supplier credit note on an invoice from supplier transaction inquiry, the field "Supplier's Ref."  is grayed (uneditable) on credit note form. It shows reference as invoice reference number. I need to enter supplier's credit note number in this field. I think this is a bug.

72

(4 replies, posted in Report Bugs here)

Hi

There is a bug in customer balances report. The credit amount (payment from customer) is showing positive figure instead of negative amount. Total if "allocated" is wrong.

Thanks

73

(4 replies, posted in Banking and General Ledger)

I have created a bank account. Bank account name is my company's name & bank name is HSBC. Now in supplier payment entry & Bank Account Payment Entry, field "From Bank Account" & field "From" resp., I see my company name which is bank account name. I think this is wrong as you want to see bank name in the list and not your bank account name.

74

(4 replies, posted in Banking and General Ledger)

Hi

At present in supplier payment entry & Bank Account Payment Entry, field "From Bank Account" shows bank account name (which is usually the company name). This is very confusing. I think we should have bank name showing in both places rather then bank account name.

75

(9 replies, posted in FA Modifications)

Hi

I want to make tax field editable on direct purchase invoice & supplier invoice so that I can adjust few pence difference to match VAT on supplier's invoice (after update of tax, total amount should also update). Could you please let me guide how to do this or can this be done on next release of frontaccounting.

Thanks