I'm trying to add an item from Inventory to part in a workorder. I have a list of items in my inventory, however, I'm not seeing this list when I try to add(part checkout) an item. The log showed that it's querying off the in_type table, I also have data in this table.
2009-04-22 12:55:42,154 DEBUG CalemSoapRequest - Invoking the BulkFetch, param=stdClass::__set_state(array(
'in_type' =>
stdClass::__set_state(array(
'table' => 'in_type',
'type' => 'GET',
'sql' => 'SELECT in_type.* FROM in_type ORDER BY type ASC',
'countSql' => 'SELECT count(*) FROM in_type ',
'localTime' => '2009-04-22 11:54:42',
)),
'uom' =>
stdClass::__set_state(array(
'table' => 'uom',
'type' => 'GET',
'sql' => 'SELECT uom.* FROM uom ORDER BY uom ASC',
'countSql' => 'SELECT count(*) FROM uom ',
'localTime' => '2009-04-22 11:54:42',
)),
))
2009-04-22 12:55:42,154 DEBUG CalemPDOStatement - Query time:0.0002, the query=SELECT count(*) FROM in_type , params=NULL
2009-04-22 12:55:42,154 DEBUG CalemPDOStatement - Query time:0.0007, the query=SELECT in_type.* FROM in_type ORDER BY type ASC, params=NULL
2009-04-22 12:55:42,154 DEBUG CalemPDOStatement - Query time:0.0001, the query=SELECT count(*) FROM uom , params=NULL
2009-04-22 12:55:42,154 DEBUG CalemPDOStatement - Query time:0.0001, the query=SELECT uom.* FROM uom ORDER BY uom ASC, params=NULL
2009-04-22 12:55:42,154 DEBUG CalemSoapRequest - Zip contents from 7025 to 1423