webERP Forum

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.

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

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

(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:


Tim