AOT report help. Repeating same line

Dynamics 365 for Finance and Operations/AX Developer Forum
1

I’m not sure If I’m posting to the correct place??

I’ve written a report that shows PO’s, po created date, and various other PO detail also along with that they wanted the related PR number and PR submitted date. I have managed to get all the required fields from Purchtable and PurchreqTable but now I have first line of 1 PO repeating several times but this PO has say 8 lines.

Can anyone offer suggestion of what I’ve done wrong?

2

Hi

Welcome to DUG

Which version are you using? NAV/AX?

RTC/Classic?

3

AOT is AX. Topic moved from NAV Developers forum to AX Developers forum.

4

can you please send the query which u have used for report

5

Hi All,

Thank you all for your response, it’s much appreciated. I ended up figuring it out it turned out it was the joins between my tables