A solution is to run the English translation in Utf8 instead of iso-8859-1.
I guess you can change that in the language install /activate.
You may also need to change the mysql setup as well.
Maybe someone can give more advice.
Joe
1,627 04/25/2014 08:46:33 pm
Re: Item pictures in Sales order (1 replies, posted in Items and Inventory)
Well, this should be possible. Look into the Report Price List. An option here is to select the picture when printing the report.
You could just implement this algorithm in the sales document.
Joe
1,628 04/25/2014 06:59:03 am
Re: plz HELP! Chart of Accounts system with parent-children account levels (5 replies, posted in Misc. Charts of Accounts)
Use the account Groups for this.
Create Account Groups 311, 3111.
Let 3111 be a subgroup of 311
Create Account 3111_HCM and use the 3111 Account Group.
Create Account 3111_hanoi and use the 3111 Account Group.
You can even build it a level more, but the more levels the more difficult it is to read the P&L Statement.
/Joe
1,629 04/24/2014 08:13:35 pm
Re: Language installation (13 replies, posted in Translations)
No, not really. I tried it myself, and it did not work for me. I cannot recall what was wrong. Using WAMP has never caused any problems.
Joe
1,630 04/24/2014 04:52:03 am
Re: How to change the order of classes (1 replies, posted in Banking and General Ledger)
1,631 04/22/2014 02:01:33 pm
Re: Language installation (13 replies, posted in Translations)
Glad that you solved it.
I use WAMP myself without problems.
Joe
1,632 04/14/2014 10:39:00 am
Re: Download the cash / cheque voucher (3 replies, posted in Modules Add-on's)
It is not in the payment form, but in the Supplier and Purchasing Reports.
We have a journal entry form in the Banking and General Ledger setup.
Joe
1,633 04/14/2014 07:49:22 am
Re: Download the cash / cheque voucher (3 replies, posted in Modules Add-on's)
I don't know exactly what you mean.
If you are looking for a check Printing utility, please login as an admin, and goto install / activate extensions in Setup tab.
Select one of the check Printing extensions. after that activate this for the actual companu.
The report is then shown under Purchasing Reports in the Purchasing tab.
/Joe
1,634 04/14/2014 07:39:27 am
Re: Reorder level email (6 replies, posted in Items and Inventory)
@apmuthu
For these simple queries, there are no performance advantages using INNER JOIN in MySql. The WHERE clause is easier to read for not so experienced users.
/Joe
1,635 04/14/2014 06:58:06 am
Re: Custom Report (7 replies, posted in Reporting)
If you copied the file /reporting/103.php to /Company/X/reporting, where X is your Company number, then you can change this file.
FA will look in the Company/X/reporting folder for the report, Before taking the default in the /reporting folder.
It is that simple.
Creating a custom report requires more action.
/Joe
1,636 04/09/2014 08:08:56 am
Re: Custom Report (7 replies, posted in Reporting)
Just copy the existing Customer report (rep103.php) from the /reporting folder to the /company/X/reporting folder where X is the company number.
Then start modify this copied report.
Joe
1,637 04/09/2014 07:00:57 am
Re: Custom Report (7 replies, posted in Reporting)
Ah, I forgot to explain that /Company/X/reporting, where X is your Company number (0, 1 etc.).
/Joe
1,638 04/09/2014 05:54:16 am
Re: Custom Report (7 replies, posted in Reporting)
I guess the easiest way for you is to copy the existing Customer Report from /reporting to /Company/X/reporting and modify/add the info you want. That way you don't interphere with the existing report. FA Always tries to find a local report in the Company folder Before using the reports in /reporting folder.
/Joe
1,639 04/09/2014 04:53:32 am
Re: hiding un-wanted links instead if disabling (2 replies, posted in Setup)
Check the file config.php. There is a flag for doing this. I am out of office at present, so I can't recall the name.
Joe
1,640 04/08/2014 02:33:39 pm
Re: packaging and shipping costs (3 replies, posted in Items and Inventory)
Another thing. When you do a sales invoice, the shipping cost would never include a COGS account.
The shipping here is for outgoing compensation for the shipping costs that have been entered another way.
Please talk to a local accountant regarding these issues.
Joe
1,641 04/08/2014 02:18:25 pm
Re: packaging and shipping costs (3 replies, posted in Items and Inventory)
If you haven't bought the service you have no transaction to GL COGS.
If you have bought the service, the GL COGS account is updated when you made a supplier invoice.
/Joe
1,642 04/08/2014 07:25:51 am
Re: Reorder level email (6 replies, posted in Items and Inventory)
This has now been implemented. HG repository updated. Will also go to next minor release.
/Joe
1,643 04/07/2014 01:58:14 pm
Re: Reorder level email (6 replies, posted in Items and Inventory)
Sounds reasonable. I will look into this.
Joe
1,644 04/05/2014 04:10:40 pm
Re: Replicating data for test environment (4 replies, posted in Setup)
Create a backup file. Take this file into a text editor replace the table prefix, X_, where X is your company number, with the new table prefix for your test company. Use this file to be restored on your test company.
Joe
1,645 04/04/2014 09:45:45 pm
Re: Error working with Sales Quotation (7 replies, posted in Accounts Receivable)
This bug has now been fixed, and the HG repository will be updated in a while.
You can download the file /sales/sales_order_entry.php1. Rename it to sales_order_entry.php and replace the file in the /sales folder.
/Joe
ATTN.
If you downloaded the previous sales_order_entry.php1 file, then please re-download this one.
AN error in the confirm (cancel) was not performed correctly.
1,646 04/04/2014 07:36:18 pm
Re: Error working with Sales Quotation (7 replies, posted in Accounts Receivable)
Ah, now I understand what is going on.
Your version of MySql has detected a bug. When a quotation is not yet saved (not completed), FA should not try to delete the quotatin as well as update the audit trail when the quotation is not completed.
I will fix this later tonight. There are other forms needing to be fixEd as well.
In older versions of MySql it was no problems running these sql scripts.
/Joe
1,647 04/04/2014 06:27:53 am
Re: Error working with Sales Quotation (7 replies, posted in Accounts Receivable)
I cannot reproduce this error.
The error is thrown in the file /sales/includes/db/sales_order_db.inc
function delete_sales_order($order_no, $trans_type)
{
begin_transaction();
hook_db_prevoid($trans_type, $order_no);
$sql = "DELETE FROM ".TB_PREF."sales_orders WHERE order_no=" . db_escape($order_no)
. " AND trans_type=".db_escape($trans_type);
db_query($sql, "order Header Delete");
$sql = "DELETE FROM ".TB_PREF."sales_order_details WHERE order_no ="
.db_escape($order_no) . " AND trans_type=".db_escape($trans_type);
db_query($sql, "order Detail Delete");
delete_reference($trans_type, $order_no);
add_audit_trail($trans_type, $order_no, Today(), _("Deleted."));
commit_transaction();
}If the $order_no is empty, the error should have been trown in one of the prior database calls.
The file /includes/db/audit_trail_db.inc shows the
function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
{
$sql = "INSERT INTO ".TB_PREF."audit_trail"
. " (type, trans_no, user, fiscal_year, gl_date, description, gl_seq)
VALUES(".db_escape($trans_type).", ".db_escape($trans_no).","
. $_SESSION["wa_current_user"]->user. ","
. get_company_pref('f_year') .","
. "'". date2sql($trans_date) ."',"
. db_escape($descr). ", 0)";
db_query($sql, "Cannot add audit info");
// all audit records beside latest one should have gl_seq set to NULL
// to avoid need for subqueries (not existing in MySQL 3) all over the code
$sql = "UPDATE ".TB_PREF."audit_trail SET gl_seq = NULL"
. " WHERE type=".db_escape($trans_type)." AND trans_no="
.db_escape($trans_no)." AND id!=".db_insert_id();
db_query($sql, "Cannot update audit gl_seq");
}The sql sentence INSERT INTO ... throws the empty result. This is strange
Please can somebody help me to track this, if possible?
/Joe
1,648 04/03/2014 10:45:32 pm
Re: Error working with Sales Quotation (7 replies, posted in Accounts Receivable)
I just wonder how this is possible. The Sales Quotation must at leat have a number of 1.
Can you please add some information to this?
/Joe
1,649 04/03/2014 08:10:54 pm
Re: Error Adding New Item or Editing Existing Item (7 replies, posted in Items and Inventory)
Which versions are you running? MySql, PHP and OS.
/Joe
1,650 04/03/2014 02:32:30 pm
Re: Error Adding New Item or Editing Existing Item (7 replies, posted in Items and Inventory)
@apmuthu
Your solution didn't accept jpg files in my environment.
The elsif sentence was originally badly written.
Your solution has been changed from
elseif (@strtoupper(substr(trim($_FILES['pic']['name']), @in_array(strlen($_FILES['pic']['name']) - 3, array('JPG','PNG','GIF')))))
to a much more reliable sentence
elseif (!in_array(strtoupper(substr(trim($_FILES['pic']['name']), strlen($_FILES['pic']['name']) - 3)), array('JPG','PNG','GIF')))Please download the file items.php1. Rename it to items.php and replace it in /inventory/manage folder.
HG repository willbe updated in a while.
/Joe