I can edit a customer payment(this is in verson 2.3), go to Customers->Inquiries and Report->Customer Transaction Inquiry. Search the item you want to edit. You can change the bank account there. Same in bank payment. Banking and General Ledger->Inquiries and Report->Journal Inquiry then select bank payment. There is no editing feature in supplier payment. You can edit it on database safely if you know the tables affected.
1 08/26/2015 08:21:00 am
Re: Fixing wrong account mistake. (3 replies, posted in Banking and General Ledger)
2 08/26/2015 01:30:33 am
Re: Commission/provision for sales person (1 replies, posted in Accounts Receivable)
There is a report "Salesman Listing". You can view the computed commission in each invoices.
3 08/26/2015 01:17:13 am
Re: Fixing wrong account mistake. (3 replies, posted in Banking and General Ledger)
Is this a customer payment or supplier payment?
4 05/18/2015 04:58:20 am
Re: Make a vertical line on PDF report (3 replies, posted in Reporting)
Hi,
I've already managed to create it using this block of code:
$this->LineTo($col += $width, $from,$col, $to);
@tm thank you for sharing another alternative. I may use it in the future. 
5 05/12/2015 03:04:47 am
Topic: Make a vertical line on PDF report (3 replies, posted in Reporting)
Hi all,
I have my customized report for Sales invoice. We already have the printed forms so I'll just format the content to fit in. Now, those forms are running out, so I needed to add some additional format on the report. However, I could not make the vertical line to appear. I can make horizontal line using $rep->UnderlineCell or $rep->Line($rep->row) but $rep->cols is not working.
Do I misses something? Please help. Thanks!
6 01/23/2015 07:37:33 am
Re: Cannot retrieve exchange rate when invoicing, delivery, receive items (6 replies, posted in Banking and General Ledger)
Hi Joe,
It is not a bug in FA. I've made some modifications and it is my coding that causes the error. Sorry for confusion. Anyway thanks!
7 01/23/2015 03:46:48 am
Topic: Bulk/Volume Discount (1 replies, posted in Accounts Receivable)
Hi all,
Is it possible to have a volume discount? Discount is not consistent in our case. Customer discount and sales kit are not applicable, even the discount per line item. I can code bulk discount (total amount - bulk discount) just below the shipping charge. I was just confused on ov_discount column in debtor_trans table. I am not sure if I need to create another column or just use ov_discount.
8 01/23/2015 03:20:01 am
Re: Cannot retrieve exchange rate when invoicing, delivery, receive items (6 replies, posted in Banking and General Ledger)
Thanks for answering. I have already fixed this. Just some wrong passing of parameters that is why currency is read as null.
9 01/04/2015 03:03:39 am
Topic: Cannot retrieve exchange rate when invoicing, delivery, receive items (6 replies, posted in Banking and General Ledger)
Hi all.
I always receive this error every time I make transaction such as invoicing, delivery and receive of items. I also notice this error shows when I select "Cash only" on direct invoice. I have read some posts about these. They say it maybe because of broken database OR there is no cash account declared to be used in point of sale.
I've made modification on sql (chart of accounts). I follow the defaults based on my modified coa and also checked currencies, sales_pos and bank_accounts table but still the error shows. Can someone please help me?
I posted it here since currency and bank accounts are under Banking and General Ledger. Posts I've read about this error is dated 2007-2008 so I assume this is fixed in the latest version.
10 11/10/2014 01:24:44 am
Re: Subsidiary Ledger Report (3 replies, posted in Reporting)
Yes that one. I wanted to have a detailed information on each account. For example if the total of A/P is 3000, then I want a report that could breakdown this amount like
Supplier/Customer A = 1000
Supplier/Customer B = 1500
Supplier/Customer C = 500
I couldn't figure out how to query this.
11 11/07/2014 09:07:26 am
Topic: Subsidiary Ledger Report (3 replies, posted in Reporting)
Hi all,
Is it possible to make a subsidiary ledger report in fa? For example:
ACCOUNTS PAYABLE
SUPPLIER A SUPPLIER B
--------------- ----------------
DR | CR DR | CR
I am trying to make a query to show something like this. But when I checked the tables I am not sure how to connect the supplier/supplier_transaction OR customer/customer_transaction to gl_trans table.
I saw some post about this topic but I can't find any answer. Thank you.
12 10/23/2014 05:29:18 am
Re: Search Customer List and Search Supplier List (6 replies, posted in Setup)
At first it's just an empty dropdown. Pressing space tab on your keyboard will make the textbox appear. Working fine with me even in the latest version
13 10/21/2014 05:39:29 am
Re: Search Customer List and Search Supplier List (6 replies, posted in Setup)
It says "Press Space tab to filter by name fragment". In case of supplier and customer, when you press space tab, a textbox will appear where you will type a fragment of description or code. Pressing enter or tab will hide the textbox and show the dropdown with the result. You can also type * to list all customer/supplier.
14 09/18/2014 05:39:48 am
Re: Is there any time masked input field in FA? (4 replies, posted in Setup)
Please make it clear. Maybe you mean you're making an HR module?
15 09/18/2014 05:35:01 am
Re: Frontaccounting mobile insert data into database? (2 replies, posted in Setup)
Hi sir. Thank you the response.
I am using v2.3.21 of frontaccounting but the mobile version I am using is 2.3.13. I tried making another php file and I put all the insert statement there and so far it works.
Is there any update on mobile? I am still working on my code and not so confident about it. But I'll try my best. Anyway Thank you sir.
16 09/16/2014 02:58:03 am
Re: Install extensions (2 replies, posted in Installation)
Hi maybe you have no write permission to the file. This error "Could not open _init/files for writing." shows.
But If I am not mistaken is it line 327 in includes/archive.inc? If it is, try to put rtrim in name and prefix. Like this:
'name' => rtrim($temp['prefix']) . rtrim($temp['name']).
I have the same error when installing chart of accounts and found this answer. Hope this helps.
17 09/16/2014 02:44:42 am
Topic: Frontaccounting mobile insert data into database? (2 replies, posted in Setup)
Hi All,
Is it possible to insert data using frontaccounting mobile? The current mobile version is only for reading data. I would like to add sales and beginning inventory using mobile. I'm a newbie in using jquery mobile and zend framework. I have tried to recode it and put insert statement but it doesn't work.
I tried using frontaccounting mobile suitable on fa version 2.3.13 and above. I am currently using the latest fa.