We are aware of this problem. We had to escape all the input database fields in FrontAccounting to eliminate spammer injections. Spammers could add html code into the fields and thereby inject the script.
/Joe
4,702 09/08/2008 07:07:07 am
Re: Line wrapping for long fields (1 replies, posted in Reporting)
Instead of using the class-member TextCol, you can use TextColLines. This will wrap the column. But you must keep track of the row counter yourself to get a nice layout. Ex.
Before:
$rep->TextCol(0, 1, $myrow2['stock_id'], -2);
$rep->TextCol(1, 2, $myrow2['StockDescription'], -2);
$rep->TextCol(2, 3, $DisplayQty, -2);
$rep->TextCol(3, 4, $myrow2['units'], -2);
$rep->TextCol(4, 5, $DisplayPrice, -2);
$rep->TextCol(5, 6, $DisplayDiscount, -2);
$rep->TextCol(6, 7, $DisplayNet, -2);
$rep->NewLine(1);
After:
$rep->TextCol(0, 1, $myrow2['stock_id'], -2);
$row = $rep->row;
$rep->TextColLines(1, 2, $myrow2['StockDescription'], -2);
$next_row = $rep->row;
$rep->row = $row;
$rep->TextCol(2, 3, $DisplayQty, -2);
$rep->TextCol(3, 4, $myrow2['units'], -2);
$rep->TextCol(4, 5, $DisplayPrice, -2);
$rep->TextCol(5, 6, $DisplayDiscount, -2);
$rep->TextCol(6, 7, $DisplayNet, -2);
$rep->row = $next_row;
$rep->NewLine(1);This will wrap the description nicely.
If you want to use the long description from the stock_master, you have to change the function get_customer_trans_details in the file /sales/includes/db/cust_trans_details_db.inc, line 5. You have to add the field long_description from stock_master table.
/Joe
4,703 09/07/2008 10:48:45 pm
Re: How To remove some sales transactions (7 replies, posted in Items and Inventory)
Well, Alvin, when we are in a catch 22 situation, it is good to be able to do this 
. We can then use the order for another occation, maybe use it as a template
/Joe
4,704 09/07/2008 09:17:43 pm
Re: How To remove some sales transactions (7 replies, posted in Items and Inventory)
The sales orders can be deleted by edit - cancel order, in sales order inquiry.
/Joe
4,705 09/07/2008 09:03:28 pm
Re: search list (11 replies, posted in Report Bugs here)
Is Javascript disabled?
/Joe
4,706 09/07/2008 09:00:04 pm
Re: How To remove some sales transactions (7 replies, posted in Items and Inventory)
But all the critical transactions are voided, right? GL Postings and Item movements and corresponding sales invoices and delivery notes?
4,707 09/07/2008 07:59:50 pm
Re: slash marks in memo field (5 replies, posted in Report Bugs here)
This has something to do with the spam injection avoidance we did a while ago. We had to escape all the database entry fields for html to avoid injections from spammers. Maybe Janusz can comment more on that.
/Joe
4,708 09/07/2008 07:56:41 pm
Re: search list (11 replies, posted in Report Bugs here)
The search functions only works for items, customers and suppliers lists.
But when you enter account characters/digits the account list will try to follow your entrance where there is a fit for your entry.
/Joe
4,709 09/07/2008 07:48:20 pm
Re: How to add more than one company? (19 replies, posted in Setup)
It is often practically to use just one database and use table prefixes when creating new clients. Then you avoid these problems.
Another approach is to first create the database with phpMyAdmin before using the 'Install New Company'. This way you avoid the install break down.
/Joe
4,710 09/07/2008 07:43:13 pm
Re: Mail Server Setup (6 replies, posted in Setup)
I am not sure if it works, but probably it does. I haven't tried. Try to do a test.
/Joe
4,711 09/07/2008 07:41:13 pm
Re: Turn off tax/tax groups ? (2 replies, posted in Setup)
If you don't use the tax, just create a tax group called 'Not Used' or something like that. and select none of the taxes (just like tax-free).
If you only have this one tax group, it will always be default when creating customers/suppliers. Do a similar thing for the Item Tax Types, and you are free of the tax. It will not be written on any documents and no tax transactions are done.
/Joe
4,712 09/07/2008 07:34:05 pm
Re: Printing and Email of PDF Invoices/Credit Notes (1 replies, posted in Installation)
The reason for the backward numbering in document printing is that you normally will print the latest ones, and therefore it is easier to find them this way. But as you found out, they have to be select in ascending order
No it is not possible to only select invoices from one customer.
4,713 09/07/2008 07:28:52 pm
Re: How To remove some sales transactions (7 replies, posted in Items and Inventory)
The best and safest thing to do, is to void the sales transactions. You do that in Setup tab, Void transactions. First look in the inquiries to pick up the numbers first. Remember to void both sales invoice, delivery notes and sales orders. If there are GL postings and Inventory movements they will automatically be voided as well.
There are so many links between the tables that is is almost impossible to remember them all by doing this in phpMyAdmin.
/Joe
BTW, if you try to void a sales order, that is also a template, it will not be voided, but this has no influence over the critical postings.
4,714 09/06/2008 09:18:08 pm
Re: Mail Server Setup (6 replies, posted in Setup)
FA2 uses the PHP built-in mail function to send mail so you should be able to use it transparently. The messages are in doctext.inc and doctext2.inc, that are included by pdf_report.inc in /reporting/includes folder.
/Joe
4,715 09/05/2008 07:08:06 am
Re: Template Invoice (2 replies, posted in Installation)
You do that in Sales - Sales Order Inquiry. Mark the Tmpl checkbox for the items you want to be templates. Then they will show up when selecting Template Delivery/Invoice.
4,716 09/04/2008 04:31:45 pm
Re: Custom Field Name (2 replies, posted in Setup)
Those company extra fields are not used by FA, but more to extra info for yourself.
In the company setup, you place your VAT no in Tax Authority Reference field
In the customer setup, you place the customers VAT no in th GSTno field. Sorry for the different words.
If these fields are filled then the info will come on the documents.
/Joe
4,717 09/04/2008 12:37:28 am
Re: Inquiries and Reports (5 replies, posted in Banking and General Ledger)
You should see, that if this is a bank account, this bank account is updated as well, right?
/Joe
4,718 09/04/2008 12:32:17 am
Re: Banking reports (2 replies, posted in Reporting)
This is on our priority list
/Joe
4,719 09/03/2008 07:00:50 am
Re: Inquiries and Reports (5 replies, posted in Banking and General Ledger)
It looks like your files are out of sync.
Inside the file /gl/includes/db/gl_trans_db.inc there is a function, add_journal_entries. This function inserts the bank account transactions as well if the GL account is also a bank account. Look for yourself in the function.
Anyhow, when investigating this, I found another minor update bug. The Bank Account Title wasn't updated on screen.
/Joe
4,720 09/02/2008 09:26:12 pm
Re: Inquiries and Reports (5 replies, posted in Banking and General Ledger)
You should be able to see them in the Bank Account Inquiry. If the Bank Accounts are created correctly, the GL entries will always be posted to Bank Accounts as well.
Are you sure the bank account is created?
I think this was implemented way back in release 1.xx something, so if you are using release 2.0 it should definitely work.
/Joe
BTW, the entry of Bank Accounts in Journal Entry was implemented mostly so administrators could enter an initial balance.
4,721 09/02/2008 01:35:20 pm
Re: Changing languages (22 replies, posted in Report Bugs here)
Try to give full privilegies on /es_MX/LC_MESSAGES folder (write enable). If gettext is not installed, then PHP will create a .php file to use for the language.
/Joe
4,722 09/02/2008 07:56:30 am
Re: How to add more than one company? (19 replies, posted in Setup)
Look in the user table for your company with phpMyAdmin. See if admin has correct Administrator priviligies.
/Joe
4,723 09/02/2008 06:49:47 am
Re: Changing languages (22 replies, posted in Report Bugs here)
Are you sure that both the .mo and .po file is in the language folder on the server? The .po file is used by PHP to create a .php file, when gettext is not installed on the server.
/Joe
4,724 09/02/2008 06:43:45 am
Re: How to add more than one company? (19 replies, posted in Setup)
You must login as an Administrator to create new companies.
/Joe
4,725 09/01/2008 10:20:14 am
Re: Chinese Characters appear as question marks in FA2 but not FA1 (6 replies, posted in Report Bugs here)
Yes, you should probably set the character set to the right one in MySql. Maybe the default en_US-demo.sql is not adequate to start a Chinese client. You should probably create your own script file for this.
If you do, please share it with us
/Joe