Author Topic: No items to checkout in workorder->part  (Read 2582 times)

chenry

  • Newbie
  • *
  • Posts: 4
No items to checkout in workorder->part
« on: April 22, 2009, 12:59:22 pm »
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

chenry

  • Newbie
  • *
  • Posts: 4
Re: No items to checkout in workorder->part
« Reply #1 on: April 22, 2009, 01:19:53 pm »
figured it out:

my inventory needs to associate with a category: part // tool