Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Adding new Field In Physical inventory by Inventory dimension Report

Posted on by 95

hi experts,
I want to add New Field (UnitPrice) in Physical Inventory By inventory Dimension Report {Inventory Management >> Reports >>Physical Inventory By inventory Dimension}
I want to know how can we add new field in this report ??? It's design is auto design
And what changes are apply on ClassDP To get UnitPrice???
I'm not able to understand how to made changes in this report
please Guide me

  • WillWU Profile Picture
    WillWU 22,344 on at
    RE: Adding new Field In Physical inventory by Inventory dimension Report

    Hi AXx,

    The report uses the InventDimPhysDP class as data provider.

    Please check the getInventSumDateTransReport method, it returns the result of the InventSumDateTransReport tmptable(from InventSumDateTrans ).

    You could try to use a display method, save calculated values to a temp table(based on the CostAmountPosted field on the table InventSumDateTrans).

    docs.microsoft.com/.../using-the-display-method-modifier

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Adding new Field In Physical inventory by Inventory dimension Report

    Hi AXx,

    That's an old report that had a couple of issues. MS suggests using the inventory value report instead. Can't you use this new inventory value report, which has a unit price field available by default?!

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans