How could i install HITB Report on SSRS?
*This post is locked for comments
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'
select
rtrim(hi.ITEMNMBR) Item_Number,
rtrim(im.ITEMDESC) Item_Description,
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
Khawaja,
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
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.
www.azurecurve.co.uk/.../how-to-deploy-ssrs-reports-in-microsoft-dynamics-gp-2010-r2
channel9.msdn.com/.../01
Hope this helps!!!
Thanks for your kind response on post
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
