Dear All,
I am trying to build a report which can take Budget Detail IV Items from PA01303 and compare the same against current stock in inventory and give the information whether there is shortage or available of items. Did anyone did this if so please share your experience or suggest what is the best way to achieve this.
thanks,
babu
*This post is locked for comments
Hi Soma,
Thanks for your reply. Yes that's what I wanted to do, have you done this or do you have SQL query for this.
thanks,
babu
Yes,
As long as you manage to group by the header in order to avoid duplications.
Hi Mahmoud will crystal report on SSRS will be a solution to this.
This will result with duplications ... Well handled ?
Hi Leslie,
Thanks for your reply. I wanted to list the item number on first column, second column with contract no.,(multiple), third column with qty for each contract, fourth column is sum of all qty, fifth column qty on hand and sixth column remaining qty available (+-). Let me know what you think.
thanks,
babu
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (