SQL: Query to sum up Batch Order Pick or report as finished Journals

Submitted by Nathan Clouse on 10/26/11.

Last modified: 

02/12/17

Tags: 

A quick and dirty SQL script to get the sum of what was placed on journals for a Work Order / Batch Order is:

select

sum(ptj.qtyGood) from PRODTABLEJOUR ptj

where

ptj.prodId = 'yourProdId' and ptj.JOURNALTYPE = journalType

-- See Below for types

0 - Material Consumption 1 - Route Consumption 2 - Report As Finished 3 - Cost 4 - Indirect Cost