Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to display the charge codes in the Morphx Report

(0) ShareShare
ReportReport
Posted on by 1,737

Hi All,


I want to do display the charge code(ex.APMC-Cla-P,Com-chr-fi,Fre-Fix,HandC-Fix) and charges value in Report., from the purchase order line -> financials dropdown->maintain charges->

see this below form to understand.

Already i am Displaying the Total Chargesvalue in report i want to dispaly the charge code description and charges value,

Please Reply me.

*This post is locked for comments

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: How to display the charge codes in the Morphx Report

    it does not matter if you add datasources in Visual Query or you add new DataSource by modifying query inside fetch method. or you add a temptable and fill this table in fatch method

    I have already specified you the relationships among tables and you can write query by yourself. if you don't know how to write x++ query kindly have a look here

    I am really not interested to spend my time to fix query for you.

    Note:

    you are right. in AX2012, there is no more this table. in ax2012 a view named as PurchLineAllVersions is being used. That's my mistake to metion vendpurchordertrans, as I was thinking in terms of AX2009

  • srinivas pamidi Profile Picture
    srinivas pamidi 1,737 on at
    RE: How to display the charge codes in the Morphx Report

    i am not talking about the aot queries  i want to write a code for displaying the tax codes in the report,

    my question is how to write the code in fetch method and in the report,  how to get the data in report.

    suppose vat@5% and Vat@5%(2%claimable) are come to under the vat tax type i want to display the total tax amount in the report.

    markup trans is temporary table, no data displaying whenever i am open the tax transcations form and personalize it showing the data method for the markup trans table.

    can you please explain me with code,

    Note there is no table called vendpurchordertrans

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: How to display the charge codes in the Morphx Report

    you must be reading msdn and TechNet for basics

    in order to add a new DataSource you right click inside query and add new DataSource. If you do add a child DataSource, you can define relationships manually or by enabling Relationship=yes (auto)

    for Purchase Order confirmation report, there ate two main Datsources VendPurchOrderJour and VendPurchOrderTrans, Both of these tables have relationship with PurchTable and PurchLine, respectively.

    Further PurchTable and PurchLine has relationship with MarkupTrans.

    any table having relationship with markupTrans is most probly based on Two fields

    1) Table.TableId == MarkupTrans.TableTableId

    2) Table.RecId == MarkupTrans.TransRecId

    you can find relationships about tables by expanding relevant table

    msdn.microsoft.com/.../bb314753.aspx

  • srinivas pamidi Profile Picture
    srinivas pamidi 1,737 on at
    RE: How to display the charge codes in the Morphx Report

    But i don't Know about how to write the queries and finding the relations

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: How to display the charge codes in the Morphx Report

    already @Darshan Patel has specified you, for ax 2012.

    if you want to do same for AX2009 morphix report, you need to modify your query of report and add a new DS, you can find records from MarkupTrans, where charges can be recorded against PurchTable as well as PurchLine

    I do not have access to 2009 AOT, right now

  • srinivas pamidi Profile Picture
    srinivas pamidi 1,737 on at
    RE: How to display the charge codes in the Morphx Report

    Hai sohaib cheema,

    You know how to do this in the morphx reports ?

    Please help me.

  • srinivas pamidi Profile Picture
    srinivas pamidi 1,737 on at
    RE: How to display the charge codes in the Morphx Report

    not exactly i don't know the purpose, but they wanted to display the charge codes in the report

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: How to display the charge codes in the Morphx Report

    you are trying to replace one important document among Trade documents, which may cost you a lot in terms of customization needed at many places in future.

    what will happen as users will confirm a PO??? will you replace code to print your Morphix report and block existing SSRS report? and lot more  

  • srinivas pamidi Profile Picture
    srinivas pamidi 1,737 on at
    RE: How to display the charge codes in the Morphx Report

    i am developing this report  using AoT Reports

  • srinivas pamidi Profile Picture
    srinivas pamidi 1,737 on at
    RE: How to display the charge codes in the Morphx Report

    hi martin,

    Actualy Prevousialy other guys are developing this report By using AOT Reports Node, I am Just Customizing this Report.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans