1,626

(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,627

(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,628

(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

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

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

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,632

(6 replies, posted in Items and Inventory)

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

/Joe

1,633

(6 replies, posted in Items and Inventory)

Sounds reasonable. I will look into this.

Joe

1,634

(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

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.

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

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

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

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

/Joe

@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

I am not sure if we have an extension for this. Maybe sombody in the audience can help us.

Joe

Have you considered using Manufacturing. You could use simple assembling. These assembled items could also be bought if needed.

Joe

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

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

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

Joe

As I told you before I am no expert on this. Maybe someone in the audience can convince me to change the algorithms.

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,648

(3 replies, posted in Dimensions)

Please read about how to use dimensions in the wiki.

Joe

1,649

(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,650

(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