Purchase Requisition Report Issue -Repeated Item IDs Showing Incorrect Descriptions

(2) Share

Report

Posted on by Basit

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...

All responses (5)

Answers (3)

Verified answer

Basit 41 on at

Like (1)

Report

Purchase Requisition Report Issue -Repeated Item IDs Showing Incorrect Descriptions

Issue resolved, thank you!

How i Fix the Issue....
I analyzed the flow of the report to understand how the data was being printed. Actually, the header line was being inserted into the second table, and the lines records were being inserted into the LineHistory table.

From there, the data was being passed to a TempTable and then printed on the report. I checked to see if there was anything unique in the line tables, and I found the SequenceNumber field to be unique.

This field was present in the LineHistory table, but it was not being shown in the report’s TempTable.

So,I passed the SequenceNumber from LineHistory to my method, where I was already passing the PurchId and ItemId — I added SequenceNumber as well.

Like:

tempbuffer.Description = this.getDescription(PurchId ,ItemId,SequenceNumber );

As a result, I got the exact description against the ItemId.
Vahid Ghafarpour 9,688 Super User 2025 Season 1 on at

Like (0)

Report

Purchase Requisition Report Issue -Repeated Item IDs Showing Incorrect Descriptions

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!
Jonas "Jones" Melgaard 3,435 Super User 2025 Season 1 on at

Like (0)

Report

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?
Verified answer

Ramesh Kumar 3,280 on at

Like (1)

Report

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.
Verified answer

CU28030750-0 16 on at

Like (1)

Report
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:

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.

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.

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.

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