Skip to main content

Notifications

Announcements

No record found.

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

  • Suggested answer
    Mel Cabillada III Profile Picture
    Mel Cabillada III 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

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