<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Query Stock Error]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=4737&amp;type=atom" />
	<updated>2014-02-12T17:36:06Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=4737</id>
		<entry>
			<title type="html"><![CDATA[Re: Query Stock Error]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19266#p19266" />
			<content type="html"><![CDATA[<p>from the error message, there is no table 0_bom in your database.<br />you can copy the query to create table 0_bom from en_US-new.sql script at about line 159.</p><p>table 0_bom is used in manufactured items.</p>]]></content>
			<author>
				<name><![CDATA[mfaa98]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=17843</uri>
			</author>
			<updated>2014-02-12T17:36:06Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19266#p19266</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Query Stock Error]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19265#p19265" />
			<content type="html"><![CDATA[<p>Hi, i want to ask, when i&#039;ve add item to items , and want to look at it again, it show error </p><p>Database salah : could not query stock usage<br />error code : 1146<br />error message : Table &#039;sologlob_fa.0_bom&#039; doesn&#039;t exist<br />sql that failed was : SELECT COUNT(*) FROM 0_bom WHERE component=&#039;VT&#039;</p><p>PS : Database salah is indonesian translation from wrong database</p><p>the error shown when i select on drop down box, it mean it has been successfully added items</p>]]></content>
			<author>
				<name><![CDATA[rendyka]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=18505</uri>
			</author>
			<updated>2014-02-12T17:28:49Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19265#p19265</id>
		</entry>
</feed>
