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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / My new latest is not a...
Small and medium business | Business Central, N...
Answered

My new latest is not allowing after 10 new custom tables

(0) ShareShare
ReportReport
Posted on by Krishna Kodidala 465

Hi,

I have custom tables 30,  when I load my license of  BC200, I am not getting any permission tables after 50009. it is accepting 50000 to 50009 only.

Does anyone help me, as per Microsoft there is no control over custom tables?

Warm Regards

Kris

I have the same question (0)
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 95,329 Super User 2025 Season 2 on at

    Hi, Looks like you're using the On-Pre version?
    Please note that the object ID range of the On-Pre version needs to be purchased, not free, which is the same as the NAV.

    Only for SaaS version and Docker version, the range of 50000~99999 can be used for free.

    more details: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-object-ranges#50000-99999

    pastedimage1657499614225v1.png

    Hope this helps.
    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,698 Moderator on at

    Hi,

    Seems that you have limited table purchased in your license, I would recommend you to please check what are objects permission allowed in your license before development, please refer the below video, where they are showing exactly the way how to check object permission range.

    (12) Find your License Permissions in Business Central NA V14 and Earlier - YouTube

  • Krishna Kodidala Profile Picture
    Krishna Kodidala 465 on at

    Hi,

    Thank you.

    Actually, I missed to tell you that, this is Business Central latest version. BC 20.  Microsoft partner who sold the license told me that, for a new BC license, we don't need to buy any extra tables. this is not mylicense.flf, it is mylicense. license

    I am using 30 tables, in the case required, I will buy

    Please suggest any solution

    warm regards

    Krish

  • Krishna Kodidala Profile Picture
    Krishna Kodidala 465 on at

    Hi,

    Thank you.

    Actually, I missed to tell you that, this is Business Central latest version. BC 20.  Microsoft partner who sold the license told me that, for a new BC license, we don't need to buy any extra tables. this is not mylicense.flf, it is mylicense. license

    I am using 30 tables, in the case required, I will buy

    Please suggest any solution

    warm regards

    Krish

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,698 Moderator on at

    Please refer the link which I shared, by using that you will understand in what range you have other tables.

    Thanks.

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 95,329 Super User 2025 Season 2 on at

    Hi, I think you are talking about new .BCLICENSE type license.

    Hope the following helps.

    https://blog.kine.cz/posts/bclicensestructure/

    And sorry, I also don't know much about this new license type. If you can't solve it, it is recommended to ask your Partner to contact Microsoft.

    Hope this helps.

    Thanks.

    ZHU

  • Krishna Kodidala Profile Picture
    Krishna Kodidala 465 on at

    Thanks, ZHU

    This is the on-promise version. Just now migrated from 14 to 20. we have a license for 20. In BC 20, the partner says, no objects are required to run BC 20

    During data upgrade I did not find any errors.

    You do not have the following permissions on Table Cash Collection: Execute.

    To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '32'.

    Internal session id:

    501778aa-4f04-4505-96a8-7b1c7e34d225

    Application Insights session id:

    72b4e9a3-26ee-4053-8b3d-797dd8fe6fbe

    Client activity id:

    8bbf4c1a-03a9-7719-75e4-3209d4c05a19

    Timestamp:

    2022-07-11T08:18:20.6156389Z

    AL call stack:

    "Cash Collection"(Report 50036).OnPreReport(Trigger) line 56 - SalonSoftPOS1 by JITS Salon

    "Salon Sales Invoice ListK"(Page 50080)."Cash Collection - OnAction"(Trigger) line 7 - SalonSoftPOS1 by JITS Salon

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 95,329 Super User 2025 Season 2 on at

    Hi, just to rule out another possibility, did you execute the following command when your app was packaged?

    pastedimage1657528504822v1.png

    This will generate the PermissionSet (Role) file.

    pastedimage1657528557513v2.png

    When installed, you can assign this role to users.

    pastedimage1657528668363v3.png

    Then try again.

    If it still cannot be resolved, there may be a license issue.

    And hope other experts can give you better advice.

    Thanks.

    ZHU

  • Krishna Kodidala Profile Picture
    Krishna Kodidala 465 on at

    Thanks i Advance

  • Krishna Kodidala Profile Picture
    Krishna Kodidala 465 on at

    You do not have the following permissions on Table Cash Collection: Execute.

    To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '3'.

    Internal session id:

    816bf145-3a38-45ee-865d-561b2483a15f

    Application Insights session id:

    9dc8467b-5601-4a56-8f48-7b4ea541baf9

    Client activity id:

    2bc0f97b-a295-49a9-29c6-120aa680a584

    Timestamp:

    2022-07-11T10:31:09.4930882Z

    AL call stack:

    "Cash Collection"(Report 50036).OnPreReport(Trigger) line 56 - SalonSoftPOS1 by JITS Salon

    "Salon Sales Invoice ListK"(Page 50080)."Cash Collection - OnAction"(Trigger) line 7 - SalonSoftPOS1 by JITS Salon

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,226

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,047 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,257 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans