Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) HITB Report

HITB Report

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: HITB Report

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