You’re offline. This is a read only version of the page.
Announcements
What's the source of those fields?
And what if you run the query directly (such as in a job or DEV_QueryBrowser) and check field values? It would be easier to debug than if you put a report between you and the query.
:) I am doing a dry run already. Will share the results, in case i run into something significant. Thanks :)
Oh Sorry! Didn't realize that.
Anyway, i have posted another picture of the same to which you should have access. :)
I am in middle of conf call - so most definitely would not be able to look at the code/AOT. But if you can do one thing for me that would be wonderful - can you look at the tables and do basic dry run to see if it is picking the correct records from teh Cust Invoice Trans table?
Otherwise, you have martin on the thread and he and I actually mean it is the "Guru of AX " :)
We don't see the original image because you inadvertently linked it from your email account (and we obviously don't have access there).
I didn't really modify any code per say. I just added CustInvoiceTrans as the child data set of CustGrossMarginbyItem_NA.
I created a relation between the two based on InvoiceId.
Also, the Dynamic Property of the Fields is set to 'Yes'.
So, i selected the 'Line Amount' field from the CustInvoiceTrans table and that is the one displayed as Sales Balance - Source Currency.
Also, i have modified the 'Sales Balance' on the original report to appear as 'Sales Balance - Reporting Currency' (only Label modification)
That is pretty much it.
As per my understanding the values should be the same for Sales Balance - Source Currency same Sales Balance - Reporting Currency.
Isn't it?
Okay - better now. Can you share the piece of code that you modified?
Oh is it? It is an embedded image not a link.
I am going to post it again here :
Hi Nidhi,
I would like to help - but your image link seems to be broken.
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...
290,142
Super User 2024 Season 2
#2
Martin Dráb
227,979
Super User 2024 Season 2
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (