Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
12-10-2018, 11:05 PM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
12-10-2018, 11:09 PM (This post was last modified: 12-10-2018 11:09 PM by VortecCPI.)
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
12-10-2018, 11:18 PM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)