• Registered: 09/19/2013
  • Posts: 3

Topic: Query Stock Error

Hi, i want to ask, when i've add item to items , and want to look at it again, it show error

Database salah : could not query stock usage
error code : 1146
error message : Table 'sologlob_fa.0_bom' doesn't exist
sql that failed was : SELECT COUNT(*) FROM 0_bom WHERE component='VT'

PS : Database salah is indonesian translation from wrong database

the error shown when i select on drop down box, it mean it has been successfully added items

  • From: Indonesia, Jakarta
  • Registered: 05/08/2013
  • Posts: 28

Re: Query Stock Error

from the error message, there is no table 0_bom in your database.
you can copy the query to create table 0_bom from en_US-new.sql script at about line 159.

table 0_bom is used in manufactured items.