webERP Forum
BoMs Missing Raw Material in Stock Category - SOLVED? - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: BoMs Missing Raw Material in Stock Category - SOLVED? (/showthread.php?tid=8286)



BoMs Missing Raw Material in Stock Category - SOLVED? - VortecCPI - 12-10-2018

Why do I not see Raw Materials in Stock Categories?

SQL has "WHERE stocktype='F' OR stocktype='D' OR stocktype='L'"

So all materials of type "M" (i.e., Raw Material) are being omitted.

Is there some reason we are omitting this type of material? Our BoMs are all made of Raw Materials...
I removed the SQL conditional statement in its entirety.


RE: BoMs Missing Raw Material in Stock Category? - TimSchofield - 12-10-2018

Good point Paul, looks like my mistake. Should there be any restriction on stack category? Looks to me like that whole line can come out.

Tim


RE: BoMs Missing Raw Material in Stock Category? - VortecCPI - 12-10-2018

No filter in my opinion. I removed the SQL conditional statement in its entirety.


RE: BoMs Missing Raw Material in Stock Category? - TimSchofield - 12-10-2018

(12-10-2018, 11:09 PM)VortecCPI Wrote: No filter in my opinion. I removed the SQL conditional statement in its entirety.

Agrred. Lets change that sql statement to be:

PHP Code:
        $SQL "SELECT categoryid,
                        categorydescription
                FROM stockcategory
                ORDER BY categorydescription"


Tim