Add non-inventory items on requisition and planning worksheets in Business central

 With the release of Business central Wave2, now it is possible to create Requisition and Planning worksheets for Non-Inventory Item.

Click the below link to know more:

Add non-inventory items on requisition and planning worksheets | Microsoft Docs

Standard API for Dynamics 365 Business Central SaaS

A very good documentation on APIs in Business central. So I thought of sharing the same. Below is the link, thank you YUN ZHU

Standard API for Dynamics 365 Business Central SaaS (Get, Post, Patch, Delete and Basic query parameters – filter, orderby, select…) | Dynamics 365 Lab (yzhums.com)

Error: You do not have the following permissions on TableData General Ledger Setup: Insert

Whenever I tried to create a new company in Business Central, I receive this Error message: You do not have the following permissions on TableData General Ledger Setup: Insert. 

Moreover, I won't be able to access Business Central at all, which means it won't allow us to navigate to any screen. We will have to force close the browser.

You might have tried with all possibilities like assigning SUPER permission to the User, Removing Company name for the SUPER permission set line, User Group permission, etc but it might have not fixed the issue.

Solution: 

Update the User license in Microsoft  365 Admin center https://admin.microsoft.com/Adminportal 

1. Login to Microsoft 365 Admin Center. You need to be a ADMIN or check with your Office 365 ADMINISTRATOR

2. Click on Active Users 

    3. Search the User with you tried to create the company in Business central

    4. Open the Active User card

    5. Click on Licenses and app tab

    6. Ensure User is assigned as Business central Essential license or Premium license. You will see Essential or Premium based on your subscription

7. Click on Save changes 

8. Sync the User from User card --> Business central --> Update Users from Office 365. This will update the permission assigned from 365 Admin center to Business central.

How to View a NAV table object from Visual Studio Code

 How to View a table object from an AL project in Visual Studio Code for MSDYN365BC

Import Excel file to Dynamics 365 BC using AL code

Hi All,

I find new information on how to import an Excel file into Dynamics 365 Business Central using AL code. Hence I thought of writing a blog.


Below is the code which shows importing an Excel file in D365 BC Azure/Online model.

Step 1: Create a Code unit
Step 2:Write all the logic required to Import, Read the Excel file, and Insert the data into a target table, In my case it is the Job Journal table.
Step 3: Call this Code unit from a Page Action.