Hello, good day everyone,
i tried to print the report...
AR > Reports > Transactions > Customer > [History by Transaction]
then i get and error "Type CustLedgerTrans contains several data methods to use as a data source by the name of billingClassLookup."
This is our one particular AX Application environment;
MS Dynamics AX 2012 Feature Pack.
Kernel & Application version 6.0.1108.670
License information > Feature sets > code description ->> [Public sector] = no license code (which means Public Sector configuration key is Disabled).
We have another AOS MS Dynamics AX 2012 Feature Pack where [Public sector] = have license code ( Public Sector configuration key is Enabled), and the Report Customer > [History by Transaction] works Fine and prints informations successfully.
Using MS Visual Studio 2010 report editor, i examined the report object CustLedgerTrans to be exactly the same as that of the AOS=Public Sector configuration key is Disabled and the Enabled one.
In the AOS = Public Sector configuration key is Disabled, i tried to modify the report by taking out the datasource CustBillingClassification and data methods billingClassLookup and tried modify other things. But did not work, so i made back the report to it's original components.
Does this mean for this particular AOS i have to Enable Public Sector configuration key, where [Public sector] = should have license code, in order to successfully print Report Customer > [History by Transaction]?
But what if this particular Client should not have certain features where Public Sector configuration key needs to be Disabled?
Yes we need to disable Public Sector configuration key for this specific client.
Any ideas you can share regarding this error "Type CustLedgerTrans contains several data methods to use as a data source by the name of billingClassLookup."
Any shared ideas is greatly appreciated.
Thank you very much.
Mel.
*This post is locked for comments
I fixed it by "hacking" the report in VS report editor.
Only applies to AOS App where Public Sector configuration key is Disabled.
What i did?
the report has a data method called billingClassLookup.
this data method is the query of the report DataSource called CustBillingClassification.
so i delete the datasource CustBillingClassification.
modified the parameter "BillingClassification" values property to null.
modifed the report items that reference to the deleted datasource.
And then in th AX AOT, the temp table CustLedgerTransTmp, modified the properties, TableType and configuratioKey.
I can't say this is the best practice. But the report did work ok now.
you experiment.
Good luck.
Mel. :)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156