Search options (Page 4 of 244)

@joe: Should we allow 0 qty items in BOM to exist?

The said function is a built-in one:
https://www.php.net/manual/en/function.imageftbbox.php

The file manufacturing/includes/db/work_order_requirements_db.inc has the offending code at lines 66-*74:

function update_wo_requirement_issued($id, $quantity, $cost)
{
    $sql = "UPDATE ".TB_PREF."wo_requirements SET 
                unit_cost = (units_issued*unit_cost+".$quantity*$cost.")/(units_issued+".$quantity."),
                units_issued = units_issued + ".db_escape($quantity)."
            WHERE id = ".db_escape($id);

    db_query($sql, "The work requirements issued quantity couldn't be updated");
}

As 'unit_cost' is computed and assigned in the sql statement whilst being part of  the RHS as well kindly look at if it was available initially in the first place.

Sales Orders (#_sales_orders) have an attached Sales Details table (#_sales_order_details) for the line items.
Refer the Wiki for the ERD Diagram.

Very much so.
To run FA you only need a CLI install of Linux.
Later versions of Linux will help manage various cyphers for SSL TLS v1.3.
Debian 6 (Squeeze) runs FA very well when fully updated it is quite secure provided you have a good firewall - even PPTP VPN on pfSense 2.2.6 (since removed after NetGate took it over) would suffice.
It is however imperative that the access and error logs in the firewall and the FA PHP erro logs are regularly monitors - DDoS attacks have become very rampant and iptables manually monitored (fail2ban fails in many instances) will rener it safe albeit expensive in time and effort.

Take a report the currently exists and then import into a PDF editor or Word 2016 and above or in AnyWord and then make changes as you would need them in the changed report and highlight the changes and upload somewhere and send the link here (if you cannot attach it here directly).

Check the SQL statements that affect the report and see if you can tweak it for your needs.
If you can do that offline in an excel sheet than you can make some Journal Entries to offset the differences.
How many years data do you have and what is the size of your full backup and what FA version are you on currently.
Take subset screenshot of the report marking the places for corrections.

PHP 5 is the base supported version for FA. If that is the release announcement, then it should be corrected. PHP 8 is being supported now as many mainstream distributions support it with some lag in minor versions.

Those on PHP5 have supported FA for as long as it existed and the newer installs are just being tried out predominantly by those feeling the waters.

Most developing and poor countries and those with unfavourable exchange rates still depend on older computers / servers that are still working. Most serious FA installs are still air gapped / on VPN. Even if a survey is done, the results will not be dependable as no will want to jeopardise info on their installs. It will be openly asking who did you vote for in the elections or who and what vested interests fund your campaign for what quid pro quo.

The set of changed files from FA v2.4.6 through to the current last commit on 28th June 2024 v2.4.18+ is attached herewith.
Just overwriting the existing install should be fine but keep a backup of the FA 2.4.6 fileset as well.

Then you will need 2 items: Juice Strawberries and Raw Strawberries.

Or just have 1 item as Strwaberries and don't bother to label them as for juice or for pulp.

Anyone interested in an OpenVZ or LXC template for FA can also chip in.

It can also be made into an extension.