1,626 Reply by joe

(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

Go to forum: Reporting

1,627 Reply by joe

(7 replies, posted in Reporting)

Ah, I forgot to explain that /Company/X/reporting, where X is your Company number (0, 1 etc.).

/Joe

Go to forum: Reporting

1,628 Reply by joe

(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

Go to forum: Reporting

1,629 Reply by joe

(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

Go to forum: Setup

1,630 Reply by joe

(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

Go to forum: Items and Inventory

1,631 Reply by joe

(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

Go to forum: Items and Inventory

1,632 Reply by joe

(6 replies, posted in Items and Inventory)

This has now been implemented. HG repository updated. Will also go to next minor release.

/Joe

Go to forum: Items and Inventory

1,633 Reply by joe

(6 replies, posted in Items and Inventory)

Sounds reasonable. I will look into this.

Joe

Go to forum: Items and Inventory

1,634 Reply by joe

(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

Go to forum: Setup

1,635 Reply by joe

(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.

Go to forum: Accounts Receivable

1,636 Reply by joe

(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

Go to forum: Accounts Receivable

1,637 Reply by joe

(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

Go to forum: Accounts Receivable

1,638 Reply by joe

(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

Go to forum: Accounts Receivable

1,639 Reply by joe

(7 replies, posted in Items and Inventory)

Which versions are you running? MySql, PHP and OS.

/Joe

Go to forum: Items and Inventory

1,640 Reply by joe

(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

Go to forum: Items and Inventory

1,641 Reply by joe

(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

Go to forum: Items and Inventory

1,642 Reply by joe

(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

Go to forum: Items and Inventory

1,643 Reply by joe

(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

Go to forum: Banking and General Ledger

1,644 Reply by joe

(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

Go to forum: Banking and General Ledger

1,645 Reply by joe

(5 replies, posted in Banking and General Ledger)

Check that your account 1821 is belonging to the correct account group.

Joe

Go to forum: Banking and General Ledger

1,646 Reply by joe

(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.

Go to forum: Manufactoring

1,647 Reply by joe

(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

Go to forum: Manufactoring

1,648 Reply by joe

(3 replies, posted in Dimensions)

Please read about how to use dimensions in the wiki.

Joe

Go to forum: Dimensions

1,649 Reply by joe

(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

Go to forum: Report Bugs here

1,650 Reply by joe

(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 smile. Just try to explain in simple terms what should be changed. Thank you in advance.

/Joe

Go to forum: Manufactoring