ON the Historical Inventory Trial Balance Report there is a check mark for “include –items with zero quantity on as of date”, is there anyway to uncheck this box so that it doesn’t include the zero quantities?
I don't get the option to uncheck it when I run the report.
*This post is locked for comments
Sorry, no way to uncheck the box. The HITB report is too cumbersome for us, so we re-wrote it as an SRS report. Here is a script that mimics the data pull for our report so you can drop it into Excel, in case it's helpful.
DECLARE @ASOFDATE DATETIME
SET @ASOFDATE = '2012-12-31 00:00:00.000'
SELECT RTRIM(A.ITEMNMBR) ITEMNMBR
, RTRIM(C.ITEMDESC) ITEMDESC
, RTRIM(A.LOCNCODE) LOCNCODE
, RTRIM(B.ACTNUMST) ACTNUMST
, SUM(A.TRXQTYInBase) QTY
, SUM(A.EXTDCOST) EXTDCOST
FROM SEE30303 A
JOIN GL00105 B ON A.IVIVINDX = B.ACTINDX
JOIN IV00101 C ON A.ITEMNMBR = C.ITEMNMBR
WHERE GLPOSTDT <= @ASOFDATE
GROUP BY A.ITEMNMBR, C.ITEMDESC, A.LOCNCODE, B.ACTNUMST
HAVING SUM(A.TRXQTYInBase) + SUM(A.EXTDCOST) <> 0
ORDER BY ITEMNMBR, LOCNCODE
-Trevor
Share
Report
All responses (
Answers (
