Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
BoMs Missing Raw Material in Stock Category - SOLVED?
12-10-2018, 10:45 PM, (This post was last modified: 12-10-2018, 11:10 PM by VortecCPI.)
#1
BoMs Missing Raw Material in Stock Category - SOLVED?
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.
https://www.linkedin.com/in/eclipsepaulbecker
Reply
12-10-2018, 11:05 PM,
#2
RE: BoMs Missing Raw Material in Stock Category?
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
Reply
12-10-2018, 11:09 PM, (This post was last modified: 12-10-2018, 11:09 PM by VortecCPI.)
#3
RE: BoMs Missing Raw Material in Stock Category?
No filter in my opinion. I removed the SQL conditional statement in its entirety.
https://www.linkedin.com/in/eclipsepaulbecker
Reply
12-10-2018, 11:18 PM,
#4
RE: BoMs Missing Raw Material in Stock Category?
(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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)