Problem adding a workorder

Old Perp-developers
1

hey,
a got a problem adding a workorder.
iventory is working so far and now a need to “manufacture” some assemblies.
I created a BOM for the assembly and all items on it are purchased and shipped to the right location.

now when I try to create the workorder there is no assemblie to choose.
“no match found”

can anybody help?

2

I forgot…

when try to open the workorder list a blank window appears…

3

Is this correct:
You go to Manufacturing -> Work Orders, the page is blank
You go to Manufacturing -> (Side-menu) -> New Work Order, fill out
required fields, add line, No match found

Did you set up Manufacturing under Admin -> Manufacturing -> Site
Configuration?
Do you have “Use workflow” turned off?

Items that you plan to assemble must be assemblies, and not pseudo.

Nathan Gray
nathan at goarctic dot com

Create and Deploy Rich Internet Apps outside the browser with Adobe®AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

4

Yes that’s my situation.

Use “workflow” is turned off and “pseudo” is unchecked.
In the list of BOM I can see the BOM. There’s only the one.
If I type this number in “add line” -> "no match found"
And if I search by description or something else, it appears always the same “no match found”.
My account is in the Manufacturing group.

5

Use “workflow” is turned off and “pseudo” is unchecked…
And if I search by description or something else, it appears always
the same
"no match found".

Can you try:
Inventory -> Stock
Turn on the ‘Type’ column, set it to ‘assembly’, set all other filters
to all.
Does your item show in that list?
Does it show if you enter the number or description in the search?

Nathan Gray
nathan at goarctic dot com

Create and Deploy Rich Internet Apps outside the browser with Adobe®AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

6

it appears by using your combination.
and by every other combination i tried…

Very strange. The two get their data from the same place, so
something is going wrong.

Do you have Firebug for Firefox installed, or are you willing to get it?
It will let you spy on the search parameters as they are sent from the
popup.

Nathan Gray
nathan at goarctic dot com

Create and Deploy Rich Internet Apps outside the browser with Adobe®AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

7

okay… now i got firebug installed…
how on? G

Nathan Gray schrieb:

it appears by using your combination.
and by every other combination i tried…

Very strange. The two get their data from the same place, so
something is going wrong.

Do you have Firebug for Firefox installed, or are you willing to get it?
It will let you spy on the search parameters as they are sent from the
popup.

Nathan Gray
nathan at goarctic dot com

Create and Deploy Rich Internet Apps outside the browser with Adobe®AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

8

okay now its getting terrible…

i create a new item (assembly) in the category xy
in inventory->stocklist: stockid 25-5. okay so far so good

now i take a look in my sql database for the same item:
-> perp_stock -> stock_category: 38-5

category xy is defined in “egw_categories” as 38.

how could it be?

9

okay… now i got firebug installed…
how on? G

Add a line to your new work order. See the bug in the bottom right
corner of the popup? Click it, change to Console (you may have to
enable firebug for the site).

Enter your part number into the box, you should see a POST line appear
in the Console tab. Drop that line down, I need the entire contents
of the Post tab.

Nathan Gray
nathan at goarctic dot com

Create and Deploy Rich Internet Apps outside the browser with Adobe®AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

10

okay now its getting terrible…

i create a new item (assembly) in the category xy
in inventory->stocklist: stockid 25-5. okay so far so good

now i take a look in my sql database for the same item:
-> perp_stock -> stock_category: 38-5

category xy is defined in “egw_categories” as 38.

how could it be?

Um… what? I don’t follow.
Stock IDs are an integer, don’t confuse them with stock number / codes

Nathan Gray
nathan at goarctic dot com

Create and Deploy Rich Internet Apps outside the browser with Adobe®AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

11

Hey thanks for Nathan…
…
answer:

<?xml version="1.0" encoding="utf-8" ?><!

[CDATA[remove_ajax_results(‘exec[stock_id]
[results]’)]]><!
[CDATA[add_ajax_result(‘exec[stock_id][results]’, ‘’, ‘’, ‘No matches
found’);]]>remove_ajax_results(‘exec[stock_id]
[results]’)add_ajax_result(‘exec[stock_id
][results]’, ‘’, ‘’, ‘No matches found’);

The only difference I can see is the stuff after shouldn’t be
there. That’s not causing the problem though.

All I can suggest is to poke around in perp_inventory/inc/class.
{s,b}o_perp_stock.inc.php, get_stock_list().
_debug_array($query); _debug_array($where);
in various places will be informative. It should be the nearly the
same from the stock list with type = assembly, or from a work order.
In particular, I’m interested in differences in $where between the
stock list and from the work order popup.

Nathan Gray
nathan at goarctic dot com

Create and Deploy Rich Internet Apps outside the browser with Adobe®AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

12

puuhhh…
after poking around in some data, i got enough of it…

perhaps someone could upload his working perp_inventory and perp_manufacturing directories. so i will be able to replace mine with the new in hope that it works…

thanks for the help

13

puuhhh…
after poking around in some data, i got enough of it…

Nothing jumped out at you as being different between the searches?

perhaps someone could upload his working perp_inventory and
perp_manufacturing directories. so i will be able to replace mine
with the
new in hope that it works…

You should be able to re-download the package and replace.

If that doesn’t work, you can try getting them from SVN trunk, but I
think that could be worse:
svn co https://perp.svn.sourceforge.net/svnroot/perp/trunk/perp_manufacturing
./perp_manufacturing
svn co https://perp.svn.sourceforge.net/svnroot/perp/trunk/perp_inventory
./perp_inventory

Nathan Gray
nathan at goarctic dot com

Create and Deploy Rich Internet Apps outside the browser with Adobe®AIR™
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

14

Okay,
i compared the “add BOM-Formular” with the “add work_order” via thunderbug. Both should search for the same in the db, right? Devinitively (Thunderbug: console -> post) posts are different.

“add BOM”:
xajax doXMLHTTP
xajaxargs[] perp_manufacturing.ajax_select_widget.ajax_search.etemplate
xajaxargs[] exec[stock_id][search]
xajaxargs[] Air
xajaxargs[] exec[stock_id][results]
xajaxargs[] iconperp_inventory/inventory_biglinkperp_inventory.ui_perp_stock
.stock_edit&stock_id=Arrayfilter2filtertemplate
etemplate.ajax_select_widget.rowid_fieldstock_idget_title<
/k>perp_inventory.bo_perp_stock.link_titleget_rowsperp_inventory.bo_perp_stock
.get_stock_liststock_idnullstock_type_flagA</xjxobj

xajaxr 1234460640877

“add work_order”:
xajax doXMLHTTP
xajaxargs[] perp_manufacturing.ajax_select_widget.ajax_search.etemplate
xajaxargs[] exec[stock_id][search]
xajaxargs[] Air
xajaxargs[] exec[stock_id][results]
xajaxargs[] iconnulllinknullfilter2null<e

filternulltemplateetemplate.ajax_select_widget.rowid_field
stock_idget_titleperp_inventory.bo_perp_stock.link_titleget_rows
perp_inventory.bo_perp_stock.get_stock_liststock_idnullstock_type_flag
Apseudofalse
xajaxr 1234460669575

I have to say that i’m just a user and no developer so these lines tells me absolutly nothing g.
I don’t know how to change or fix it.

any ideas… and perhaps a stepbystep howto to fix?
sorry for wasting your time with a perhaps simple problem.

thanks and bye alan

15

Okay, …

You missed a bit.
In perp_inventory/inc/class.so_perp_stock.inc.php, line 189 (should be
blank), add this:

_debug_array($query); _debug_array($where);

Then check this (it’ll be much different, and won’t work):

“add work_order”:
xajax doXMLHTTP
xajaxargs[]
perp_manufacturing.ajax_select_widget.ajax_search.etemplate
xajaxargs[] exec[stock_id][search]
xajaxargs[] Air
xajaxargs[] exec[stock_id][results]

Against the new stuff that shows up when you go to Inventory -> Stock
List
Turn on the ‘Type’ column, set it to ‘assembly’, set all other filters
to all, and search for Air.

Please copy + paste both (just the new stuff that shows up).

I have to say that i’m just a user and no developer

You’re in dangerous territory then. I’ll try to spell things out for
you, but here be dragons.

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

16

when i type air in the search form and push return it appears in red :
No matches found

More than 1 match for ‘Air’

and dont know what you mean with new stuff but i cant see anything new…
in Inventory -> Stock List nothing appears in the console -> post. i
think firebug scans the wrong frame… how can i set this?

“add work_order”:

xajax

doXMLHTTP

xajaxargs[]

perp_manufacturing.ajax_select_widget.ajax_search.etemplate

xajaxargs[]

exec[stock_id][search]

xajaxargs[]

Air

xajaxargs[]

exec[stock_id][results]

xajaxargs[]

iconnulllinknullfilter2null<e

filternulltemplateetemplate.ajax_select_widget.rowid_field
stock_idget_titleperp_inventory.bo_perp_stock.link_titleget_rows
perp_inventory.bo_perp_stock.get_stock_liststock_idnullstock_type_flag
Apseudofalse

xajaxr

1234467896287

Nathan Gray schrieb:

Okay, …

You missed a bit.
In perp_inventory/inc/class.so_perp_stock.inc.php, line 189 (should be
blank), add this:

_debug_array($query); _debug_array($where);

Then check this (it’ll be much different, and won’t work):

“add work_order”:
xajax doXMLHTTP
xajaxargs[]
perp_manufacturing.ajax_select_widget.ajax_search.etemplate
xajaxargs[] exec[stock_id][search]
xajaxargs[] Air
xajaxargs[] exec[stock_id][results]

Against the new stuff that shows up when you go to Inventory -> Stock
List
Turn on the ‘Type’ column, set it to ‘assembly’, set all other filters
to all, and search for Air.

Please copy + paste both (just the new stuff that shows up).

I have to say that i’m just a user and no developer

You’re in dangerous territory then. I’ll try to spell things out for
you, but here be dragons.

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

17

…
in Inventory -> Stock List nothing appears in the console -> post.

After adding that line, the debug should be huge, and take up most of
the page. On the stock list, it actually appears right in the page.
I’m expecting this from the stock list:
Array
(
[no_filter] => 1
[filter2_label] => Status
[filter2_no_lang] => 1
[lettersearch] => 1
[selectcols] =>
stock_type_flag
,stock_num
,short_description,stock_category,unit_of_measure,sync_modified
[default_cols] => stock_num,short_description
[get_rows] => perp_inventory.ui_perp_stock.get_stock_list
[template] => perp_inventory.stock_list.row
[cat_id] =>
[filter2] =>
[search] => air
[num_rows] => 15
[savecols] => Save
[default_prefs] => 0
[start] =>
[return] =>
[bottom_too] =>
[options-filter] =>
[filter] =>
[no_csv_export] =>
[filter_onchange] => this.form.submit();
[filter2_onchange] => this.form.submit();
[cat_app] => perp_inventory
[options-num_rows] => Array
(
[5] => 5
[15] => 15
[25] => 25
[50] => 50
[100] => 100
[200] => 200
[500] => 500
[999] => 999
)

 [options-selectcols] => Array
     (
     )

 [order] => stock_num
 [sort] => ASC
 [count] => 118

)

Array
(
[0] => (stock_num LIKE ‘%air%’ OR short_description LIKE ‘%air%’ OR
perp_stock_barcode.barcode = ‘air’)
)

And something similar, but only visible in firebug, in the work
order’s popup when you search for ‘air’.

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

18

inventory:

Array
(
[no_filter] => 1
[filter2_label] => Status
[filter2_no_lang] => 1
[lettersearch] => 1
[selectcols] => stock_type_flag,stock_num,short_description,stock_category,status_flag,inventory
[default_cols] => stock_num,short_description
[get_rows] => perp_inventory.ui_perp_stock.get_stock_list
[template] => perp_inventory.stock_list.row
[cat_id] =>
[filter2] =>
[search] => Air
[num_rows] => 15
[default_prefs] => 0
[start] =>
[return] =>
[col_filter] => Array
(
[stock_type_flag] => A
)

[bottom_too] => 
[options-filter] => 
[filter] => 
[no_csv_export] => 
[filter_onchange] => this.form.submit();
[filter2_onchange] => this.form.submit();
[cat_app] => perp_inventory
[options-num_rows] => Array
    (
        [5] => 5
        [15] => 15
        [25] => 25
        [50] => 50
        [100] => 100
        [200] => 200
        [500] => 500
        [999] => 999
    )

[options-selectcols] => Array
    (
    )

[order] => stock_num
[sort] => ASC
[count] => 2

)

Array
(
[stock_type_flag] => A
[0] => (stock_num LIKE ‘%Air%’ OR short_description LIKE ‘%Air%’ OR
perp_stock_barcode.barcode = ‘Air’)
)

add work_order:

Array
(
    [template] => etemplate.ajax_select_widget.row
    [id_field] => stock_id
    [get_title] => perp_inventory.bo_perp_stock.link_title
    [stock_type_flag] => A
    [pseudo] => false
    [search] => Air
    [selectcols] => stock_id,stock_num,short_description
    [order] => stock_num
    [sort] => ASC
    [count] => 0
)

Array
(
    [stock_type_flag] => A
    [0] => (stock_num LIKE '%Air%' OR short_description LIKE '%Air%' OR
					perp_stock_barcode.barcode = 'Air')
    [pseudo] => 1
)
<?xml version="1.0" encoding="utf-8" ?><![CDATA[remove_ajax_results('exec[stock_id]

[results]’)]]>

Nathan Gray schrieb:

…
in Inventory -> Stock List nothing appears in the console -> post.

After adding that line, the debug should be huge, and take up most of
the page. On the stock list, it actually appears right in the page.
I’m expecting this from the stock list:
Array
(
[no_filter] => 1
[filter2_label] => Status
[filter2_no_lang] => 1
[lettersearch] => 1
[selectcols] =>
stock_type_flag,stock_num,short_description,stock_category,unit_of_measure,sync_modified

[default_cols] => stock_num,short_description
[get_rows] => perp_inventory.ui_perp_stock.get_stock_list
[template] => perp_inventory.stock_list.row
[cat_id] =>
[filter2] =>
[search] => air
[num_rows] => 15
[savecols] => Save
[default_prefs] => 0
[start] =>
[return] =>
[bottom_too] =>
[options-filter] =>
[filter] =>
[no_csv_export] =>
[filter_onchange] => this.form.submit();
[filter2_onchange] => this.form.submit();
[cat_app] => perp_inventory
[options-num_rows] => Array
    (
        [5] => 5
        [15] => 15
        [25] => 25
        [50] => 50
        [100] => 100
        [200] => 200
        [500] => 500
        [999] => 999
    )

[options-selectcols] => Array
    (
    )

[order] => stock_num
[sort] => ASC
[count] => 118

)

Array
(
[0] => (stock_num LIKE ‘%air%’ OR short_description LIKE ‘%air%’ OR
perp_stock_barcode.barcode = ‘air’)
)

And something similar, but only visible in firebug, in the work
order’s popup when you search for ‘air’.

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

19

…
[pseudo] => false
[search] => Air

…

[0] => (stock_num LIKE ‘%Air%’ OR short_description LIKE ‘%Air%’ OR
perp_stock_barcode.barcode = ‘Air’)
[pseudo] => 1

There it is. Please replace etemplate/inc/
class.ajax_select_widget.inc.php with the one found here:
http://www.egroupware.org/viewvc/trunk/etemplate/inc/class.ajax_select_widget.inc.php

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

20

Hey nathan,
thanks for help… I got it working now. there was a problem with a sql table.
I reinstalled the whole database adn now it works.
this time I took your egw+perp-package.