FrontAccounting forum — Manufacture BOM

Re: Manufacture BOM

null@example.com (apmuthu) — Mon, 12 Aug 2024 05:12:27 +0000

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

Re: Manufacture BOM

null@example.com (tom) — Sun, 11 Aug 2024 23:18:40 +0000

I figured out the problem!

I have some items in my BOM that have a 0 quantity this seems to no longer work.

If I remove the q=0 items I can assemble them again!

Re: Manufacture BOM

null@example.com (tom) — Sun, 11 Aug 2024 19:55:39 +0000

I think I am getting closer to seeing what the issue is.

On the old site if I open the database in phpmyadmin the wo_requirements table has 8000 records and on the imported site only 300

I also get an error from myphpadmin when browsing that table that looks like a php issue

I am going to try mysqldump and see if I get all 8000 records for that table

--- error below

Warning in ./libraries/sql.lib.php#613
count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#2062: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'gotgrit_fa24',
string '0_wo_requirements',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `0_wo_requirements`',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'gotgrit_fa24',
string '0_wo_requirements',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `0_wo_requirements`',
NULL,
NULL,
)

Re: Manufacture BOM

null@example.com (apmuthu) — Fri, 09 Aug 2024 05:15:24 +0000

The basic FA has just 80 tables.
Make a fresh install of latest FA and manually import differences taking care to adjust the Primary Key and it's references.
Then copy over the relevant images/files renaming them for ID related differences in the new dispensation.

Re: Manufacture BOM

null@example.com (tom) — Thu, 08 Aug 2024 23:31:39 +0000

Humm... I did delete a handfull of closed fiscal years, but other than that not much.

I'll look at a known good backup and see what that table looks like..

Might I need to recreate the BOMs used to manufacture that product?

Re: Manufacture BOM

null@example.com (apmuthu) — Thu, 08 Aug 2024 17:28:57 +0000

It is possible that many IDs may be missing due to deletion but the AUTO_INCREMENT value may have advanced.

Re: Manufacture BOM

null@example.com (tom) — Wed, 07 Aug 2024 23:06:59 +0000

> wo_requirements the highest id is 8616 and the SQL refers to 8652

The SQL refers to id = 8652 and the highest id in the table is 8616, what could cause the code to refer to a non-existent record?

Re: Manufacture BOM

null@example.com (apmuthu) — Wed, 07 Aug 2024 16:57:31 +0000

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.

Manufacture BOM

null@example.com (tom) — Sun, 04 Aug 2024 19:45:53 +0000

I have ported my db from 2.4.6 to 2.4.18

I have a number of products are are assembled with a BOM and when I have all the items required I get the following error

DATABASE ERROR : The work requirements issued quantity couldn't be updated
error code : 1048
error message : Column 'unit_cost' cannot be null
sql that failed was : UPDATE 0_wo_requirements SET
unit_cost = (units_issued*unit_cost+0)/(units_issued+0),
units_issued = units_issued + '0'
WHERE id = '8652'

I am am able to enter other work orders

in wo_requirements the highest id is 8616 and the SQL refers to 8652

strange

I am using PHP 7.4.33 and mysql 8.0