Used and not used Objects in Business Central license

I publish a simple APP that allows you to see not Used objects compared to those assigned in customer license (useful on BC On-premise).

For example, the customer can extract the list of all objects loaded in the APP as customizations. Even if the objects numbered 50000 are practically free to use for the Cloud, the Onpremise ones are licensed; with a specific report it is possible to identify those already used with respect to those assigned.

Licenza Software per Computer Software Microsoft Software Assurance &  Software di Produttività - altri scaricare png - Disegno png trasparente  Angolo png scaricare.

Used Tables:

  • “License Permission”
  • “AllObj”
  • “AllObjWithCaption”

🡪 About “Application Object Metadata” table

This table unfortunately is not usable for the Cloud (Target ‘OnPrem’, although it would have been very convenient to use). How does it work By crossing the two tables indicated above, you get what you need, applying filters at the launch of the extraction and after the extraction of the data.

Search for report “Export Used and Not Used Objects”

Run report and apply filters (example)

Extract “ALL Objects” or filter objects by Object Type

Results in Page with Views

Filter by Object Types

Sample Filters (Both Used and Not Used Objects)

Sample Filter “50000..”

Available Views – ALL Used and ALL Not Used Objects

Code Link on GitHub

rstefanetti/AL-Code-Samples-Education at AL—Free-and-used-Objects-in-Business-Central (github.com)

One thought on “Used and not used Objects in Business Central license

  • 14 June 2022 at 10:59 AM
    Permalink

    Good,

    Before seeing this blog I already created a similar process, my problem is that I have a client that is in Saas and that comes from other partners, I cannot see the objects and I would like to know how to replace the “Application Object Metadata” table so that it works in Saas .

    Might you help me?

    Reply

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.