How could i install HITB Report on SSRS?
Try creating an SSRS report using the following SQL query:
Declare @ReportStartDate varchar(10)
Declare @ReportStopDate varchar(10)
Set @ReportStartDate = 'YYYY-MM-DD'
Set @ReportStopDate = 'YYYY-MM-DD'
sum (hi.TRXQTYInBase) Quantity, --Transaction Quantity for this transaction in Base Units of Measure
sum (hi.EXTDCOST) Extended_Value --The Extended Cost from the HITB table
from dbo.SEE30303 hi (NOLOCK) --HITB Table (holds all transaction date for Historical Aged Trial Balance Reporting)
LEFT JOIN IV00101 im (NOLOCK) ON hi.itemnmbr = im.itemnmbr --Joining this table provides Link to Item Description
where hi.GLPOSTDT between @ReportStartDate and @ReportStopDate --Start Date should be hard coded (system start date)
group by hi.ITEMNMBR, im.ITEMDESC
order by hi.ITEMNMBR
Have you deployed Standard SSRS reports from GP through Reporting Tools Setup?
If you have deployed the reports then you can find the below reports in Inventory folder
1) HITB Detail
2) HITB Summary by Item
3) HITB Summery by Account
Nataraj S | Dynamics GP
If you created Custom SSRS HITB report then, you need to upload the report rdl file to the Reporting Manager's Inventory folder(location where all the reports deployed).
Please have a look on the below links to deploy the SSRS reports and runt the HITB reports if you not deployed the SSRS reprots.
Hope this helps!!!
Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.
Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts
Thanks for your kind response on post