web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Type CustLedgerTrans contains several data methods to use as a data source by the name of billingClassLookup.

(0) ShareShare
ReportReport
Posted on by 425

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 have the same question (0)
  • Suggested answer
    Mel Cabillada III Profile Picture
    425 on at
    RE: Type CustLedgerTrans contains several data methods to use as a data source by the name of billingClassLookup.

    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. :)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans