Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Stock Usage
03-02-2018, 08:18 AM,
#3
RE: Stock Usage
You were correct in your diagnosis. The lines in the SQL statements that read:

SUM(CASE WHEN (stockmoves.type=10 Or stockmoves.type=11 OR stockmoves.type=28)

should be:

SUM(CASE WHEN (stockmoves.type=10 Or stockmoves.type=11 OR stockmoves.type=28 OR stockmoves.type=38)

and it should fix it.

Thanks
Tim
Reply


Messages In This Thread
Stock Usage - by briantmg - 03-02-2018, 05:37 AM
RE: Stock Usage - by TimSchofield - 03-02-2018, 05:39 AM
RE: Stock Usage - by TimSchofield - 03-02-2018, 08:18 AM
RE: Stock Usage - by VortecCPI - 03-03-2018, 02:48 AM
RE: Stock Usage - by TimSchofield - 03-06-2018, 07:54 PM
RE: Stock Usage - by TurboPT - 03-06-2018, 11:46 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)