FrontAccounting forum — ASK Codeflow workorder

Re: ASK Codeflow workorder

null@example.com (maulana) — Wed, 19 Nov 2014 04:50:41 +0000

give me some time for make another way to make it

Re: ASK Codeflow workorder

null@example.com (joe) — Tue, 18 Nov 2014 17:53:22 +0000

I can only say, that the BOM is always used as a base when the assembly/manufacturing is done.
When manufacturing, the stock is first handled when you produce the items.

Joe

Re: ASK Codeflow workorder

null@example.com (apmuthu) — Tue, 18 Nov 2014 17:48:35 +0000

@joe:
Just wanted to know if such a feature exists!
And if so, what are the menu click and entry sequences to achieve it.
Not the code behind it.

Re: ASK Codeflow workorder

null@example.com (joe) — Tue, 18 Nov 2014 17:44:17 +0000

@apmuthu

It is a bit too complicated to describe the workorder flow here. Let us just assume that the code works in the core. If you try to modify this, you are often on your own and should have some professional skill in programming.

Joe

Re: ASK Codeflow workorder

null@example.com (joe) — Tue, 18 Nov 2014 17:40:18 +0000

@maulana

Please set the variable, $go_debug to 1 in config.php to trap any errors.

Immediately I can not find any errors.

Joe

Re: ASK Codeflow workorder

null@example.com (apmuthu) — Tue, 18 Nov 2014 17:39:25 +0000

@joe: I did not mean this code. I meant:

How is the work flow managed in FA when a single BoM is used to produce a set of products and not just one product.
How does the system handle the stock moves then?

Re: ASK Codeflow workorder

null@example.com (joe) — Tue, 18 Nov 2014 17:36:13 +0000

I haven't been followed this in detail. Please give me som time to have a look. It is easy to produce some wrong code.

Joe

Re: ASK Codeflow workorder

null@example.com (apmuthu) — Tue, 18 Nov 2014 15:51:50 +0000

Your flow is wrong.
There must be a stock transfer when you use a BoM to manufacture - whether it is one or more products. In your flow, you are preventing any stock transfer in the second sql if there is only one product - if the $nope is actually one or more products made.

@joe, how is this implemented in FA for now? Should he use kits in manufacture?

Re: ASK Codeflow workorder

null@example.com (maulana) — Tue, 18 Nov 2014 13:18:53 +0000

is there any solution? or should i change my idea of this flow?

Re: ASK Codeflow workorder

null@example.com (apmuthu) — Tue, 18 Nov 2014 13:15:46 +0000

The syntax is correct. The next statement is returning from the function with an array of fields from the first sql instead of an integer that should be the last insert id of the second sql. The calling script is expecting an integer in return.

Re: ASK Codeflow workorder

null@example.com (maulana) — Tue, 18 Nov 2014 12:17:10 +0000

its on db_fetch_row($result) line, is something wrong with that?

for the if code block, i just trying like get_location_name function, i think maybe it works
but before it i try using without if statement and still like this

Re: ASK Codeflow workorder

null@example.com (apmuthu) — Tue, 18 Nov 2014 11:48:37 +0000

Check which statement is causing the blank by commenting out your code block and then working in.

Is your test case passing into the initial if code block at all? If so, it will just return (that's what your code directs) without doing anything since there is just 1 record.

Re: ASK Codeflow workorder

null@example.com (maulana) — Tue, 18 Nov 2014 11:43:38 +0000

This is the main problem right now, blank. with this problem, i cant even see the form for test a modification code
http://s25.postimg.org/xk6fplz2n/blankerror.png

what i trying to do is make modification about BoM Material, i want to make a BoM can produce more than one product.
so the idea is make additional column in stock_master named bom_quantity, then on add_stock_move function i want to make $quantity * bom_quantity
why i use discount_percent field? it's just a test for make sql statement SELECT for get bom_quantity with the same stock_id

Re: ASK Codeflow workorder

null@example.com (apmuthu) — Tue, 18 Nov 2014 11:12:56 +0000

The variable $nope is just the first record if it passes the initial single record if check when the second sql is attempted. Otherwise if there is only 1 record, the second sql will not be attempted at all. This variable is sought to fill in the discount_percent field.

What are you trying to do?

What happens if there are no results from the first sql? You will be assigning null to a not null field or boolean false to a integer field. The following may work after the initial single record if check fails.

$nope =  ($row[0] ? $row[0] : 0);

Re: ASK Codeflow workorder

null@example.com (maulana) — Tue, 18 Nov 2014 10:05:08 +0000

my version is PHP 5.5 and MySQL 5.6, is any problem with that? or should i use another version of XAMPP?

but sir, my screen on work_order_entry.php is blank,its because of two db_query, when i delete db_query, my screen back to normal
and i already change to $result