You’re offline. This is a read only version of the page.
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
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
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
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
But i don't Know about how to write the queries and finding the relations
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
Hai sohaib cheema,
You know how to do this in the morphx reports ?
Please help me.
not exactly i don't know the purpose, but they wanted to display the charge codes in the 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
i am developing this report using AoT Reports
hi martin,
Actualy Prevousialy other guys are developing this report By using AOT Reports Node, I am Just Customizing this Report.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (