News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Item Arrival Report Cu...

Microsoft Dynamics AX (Archived)

Item Arrival Report Customization

(0) Share

Report

Report

Posted on by Von

95

Hi,

I need to modify the printing of Item Arrival Journal to show some of the fields of its reference document.

So, for example, If the Item arrival Journal comes from "Return Order" I need to include the following field to the printout.

Customer Name
Sales Order Number
Invoice Number
Packing Slip Number

I also need some of the Purchase Order details if it came from Purchase Order.

I have checked the SSRS report and it uses Query as Datasource instead of RDP.

My first idea is to create a display method for each field to the WMSJournalTrans Table but this will surely affect the performance which I'm avoiding. Is there an easy way to do that? Appreciate any help. Thanks.

I'm Using AX 2012 R3 CU12

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Khushhal Garg 1,514 on at

Like (1)

Report

RE: Item Arrival Report Customization

I would suggest creating separate designs with-in this SSRS report and call the design based on caller. Add these specific fields to its design rather adding display methods and there won't be performance impact. Use DP over Query as that will give you much flexibility. Rather modifying standard report, create copy of this report and have your changes there and then use this new report for printing.

Helpful resources

Quick Links

Leaderboard

#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

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans