Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : 2pfUVmxSvhwDRbGyX435R0
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Purchase Requisition R...
Finance | Project Operations, Human Resources, ...
Suggested answer

Purchase Requisition Report Issue -Repeated Item IDs Showing Incorrect Descriptions

Like (2) ShareShare
ReportReport
Posted on 28 Mar 2025 07:39:53 by CU10051122-0 4
Dear Dynamics Community,
I am working with the Procurement and Sourcing module in Dynamics AX 2012 R3 . I am facing an error in the Procurement and Sourcing module related to the Purchase Requisition Report.

Issue:
When running a report for a specific Purchase Requisition ID (PurchID), if the same Item ID is repeated in the Purchase Requisition Line table but with different descriptions/details, the report incorrectly displays the same description for both entries. However, in the table, each Item ID has a different description/detail.

How can I resolve this issue?
 
Troubleshooting: I have verified that the data in the Purchase Requisition Line table is correct. I also reviewed the report desgin and Dataset but couldn't find any obvious filtering or grouping logic that might be causing this.
What could be causing this issue in the report's data processing, and how can I ensure that each line correctly reflects its respective description?
 
Any help would be greatly appreciated.
Thanks in advance!.
Categories:
Microsoft Dynamics AX
Bug in Report.png
Itemid Same but D...
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 3,236 Super User 2025 Season 1 on 30 Mar 2025 at 20:00:16
    Purchase Requisition Report Issue -Repeated Item IDs Showing Incorrect Descriptions
    Hi, I just had a play in my AX2012 R3 out of curiosity (I don't remember a report with that design)
    I'm not seeing the report in the menus, and it's not looking like the one that's printed from the purchase requisition itself.
     
    Is this a custom report?

     
  • Suggested answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar 1,991 on 29 Mar 2025 at 19:10:51
    Purchase Requisition Report Issue -Repeated Item IDs Showing Incorrect Descriptions
    Hi,
     
    Can you please check if issue with grouping logic . Adjust the grouping logic to consider both ItemID and Description or another unique field.
     
    Please also let me know who you fixed the issue
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • CU28030750-0 Profile Picture
    CU28030750-0 2 on 28 Mar 2025 at 07:54:38
    Purchase Requisition Report Issue -Repeated Item IDs Showing Incorrect Descriptions

    This issue is likely happening because the report is grouping data based on the Item ID, which causes it to show the same description for all occurrences of that Item ID. Even though the Purchase Requisition Line table has different descriptions for the same Item ID, the report might be pulling only the first occurrence due to grouping or join conditions.

     

    Here are a few things you can check to fix this:

     

    1.  

      Review Grouping in the Report – In the report designer (SSRS), check if the report groups data by Item ID. If so, try modifying it to include the unique line identifier (like Line Num) to ensure each entry is displayed separately.


    2.  

      Check the Dataset Query – Look at the SQL query or data source feeding the report. Ensure it retrieves all distinct descriptions instead of summarizing or merging them.


    3.  

      Verify Joins in the Report Dataset – If the report is pulling data from multiple tables, check if the joins (inner or outer) are affecting how descriptions are displayed.



      4.  
     

    Try these steps and see if they resolve the issue. Let me know if you need further help!

     

     

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.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,333 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,262 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans