Share
ReportHow could i install HITB Report on SSRS?
*This post is locked for comments
You’re offline. This is a read only version of the page.
How could i install HITB Report on SSRS?
*This post is locked for comments
Thanks for your kind response on post
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
Hope this helps!!!
Khawaja,
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).
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (