This has now been implemented. HG repository updated. Will also go to next minor release.
/Joe
1,627 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,628 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,629 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,630 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,631 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,632 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,633 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,634 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
1,635 03/28/2014 11:19:06 am
Re: how can i add new Item Type (21 replies, posted in Items and Inventory)
I am not sure if we have an extension for this. Maybe sombody in the audience can help us.
Joe
1,636 03/28/2014 05:52:04 am
Re: how can i add new Item Type (21 replies, posted in Items and Inventory)
Have you considered using Manufacturing. You could use simple assembling. These assembled items could also be bought if needed.
Joe
1,637 03/24/2014 06:57:49 am
Re: buying tools and equipment (5 replies, posted in Banking and General Ledger)
In this case you buy the tool by entering the asset account. At year end (or periodically) you do your depreciations on a depreciations account.
Please talk to a local accountant for these type of questions.
/Joe
1,638 03/23/2014 10:25:40 pm
Re: buying tools and equipment (5 replies, posted in Banking and General Ledger)
Tools and Equipment is here an inventory account (assets). Expense accounts for minor tools are placed in Expense and should be used for minor purchases.
Joe
1,639 03/23/2014 07:53:51 pm
Re: buying tools and equipment (5 replies, posted in Banking and General Ledger)
Check that your account 1821 is belonging to the correct account group.
Joe
1,640 03/18/2014 09:55:26 am
Re: Standard cost for manufactured item (10 replies, posted in Manufactoring)
As I told you before I am no expert on this. Maybe someone in the audience can convince me to change the algorithms.
1,641 03/18/2014 08:15:35 am
Re: Standard cost for manufactured item (10 replies, posted in Manufactoring)
The else part is for use when you have accepted negative stock in system and general GL setup and the current stock is below 0.
Joe
1,642 03/15/2014 09:08:59 pm
Re: Profit & Loss in a Project (3 replies, posted in Dimensions)
Please read about how to use dimensions in the wiki.
Joe
1,643 03/13/2014 06:30:58 am
Re: Can't Delete a company (11 replies, posted in Report Bugs here)
You should also remove it from the file, config_db.php. Be careful, however, to delete the right things.
/Joe
1,644 03/13/2014 06:28:45 am
Re: WO journal seems strange (4 replies, posted in Manufactoring)
Well, as I told in another topic, I am not an expert in Manufacturing. These routines were written by somebody else several years ago.
Maybe someone in the audience can help us, or you may be the guy 
. Just try to explain in simple terms what should be changed. Thank you in advance.
/Joe
1,645 03/13/2014 06:25:39 am
Re: Work in progress (1 replies, posted in Manufactoring)
Well, I am no expert in Manufacturing. Somebody else wrote these routines many years ago. Couldn't this be an accounting issue?
/Joe
1,646 03/13/2014 06:23:46 am
Re: On going delivery (3 replies, posted in Accounts Payable)
I am not sure, but maybe this is an accounting question. Which accounts should be used during the process.
/Joe
1,647 03/13/2014 05:46:43 am
Re: Negative tax (3 replies, posted in Banking and General Ledger)
Well, if it works, this is the way to go. What about the tax report? Does it work too?
If everything works, then we could consider to give a warning instead of an error.
Joe
1,648 03/11/2014 11:12:40 pm
Re: 0 Decimal (3 replies, posted in Report Bugs here)
This has now been fixed and sent to the HG repository. Please go here and download this file (link up left).
Replace the file in the /admin folder.
/Joe
1,649 03/11/2014 08:56:12 am
Re: 0 Decimal (3 replies, posted in Report Bugs here)
Thanks dvarsani. I will have a look at this.
Joe
1,650 03/10/2014 07:26:57 pm
Re: Version 2.3.20 not displayed after upgrade (4 replies, posted in Installation)
Check that the version.php file in the root folder contains the version 2.3.20 inside the code.
Do you use a theme that write its own version number?
Joe