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, Tim |