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

Account Type or Bal. Account Type must be a G/L Account or Bank Account.

While posting FA G/L Journal , I encountered the below error. which says: Account Type or Bal. Account Type must be a G/L Account or Bank Account.

1. I am trying to Acquire a new Fixed Asset and passing the Acquisition Entry from FA G/L Journal
2. On the Debit Side, I have the new Fixed Asset and on Credit side, I have a Vendor
3. And I realized it is not working and throwing error. So, how to solve this error
4. Solution: I created the 2nd line entry for Credit side, which is Vendor and this has worked.

Business central 2021 Release Wave 2- What's new ?

 Remove obsolete reports 204, 205, 206, and 207 

Below reports are being deprecated. Public Preview from Sept 2021.

Remove obsolete reports 204, 205, 206, and 207 | Microsoft Docs

Enabled for	Public preview	General availability
Users, automatically	Sep 2021	Oct 2021

Deprecated report	Recommended report
204 Sales - Quote	1304 Sales - Quote
205 Order Confirmation	1305 Sales - Confirmation
206 Sales - Invoice	1306 Sales - Invoice
207 Sales - Credit Memo	1307 Sales - Credit Memo

How to Setup OAuth authentication in Business central for API

 

You might have seen this message on the User card which says the Web Service Access key is being deprecated on Saas.

Please follow the below steps to generate OAuth for API.

1. login to Azure portal https://portal.azure.com/ with ADMIN rights
2. Go to All Services and search for App registrations

3.    Click New registrations

4. Give some registration Name, and provide the return URL like https://businesscentral.dynamics.com

5. Click Register

6. Note down the Application ID

7. Select API Permissions tab 

8. Select Business central app from the list

9. Click Add permissions

10. Click on Certificates & Secrets and Click +New client secret

11. Select the option of client secret expiry, I selected 2 years and complete the form.

12. You will get Client Secret Value. Note this value as the Value will be masked later

13. Now, its time to test this in Postman application

14. Open Postman, Select Authorization Type = OAuth2.0, Keep Access Token blank as we will generate this now

15. Give some Token name BCAPP, 

Call back URL = https://businesscentral.dynamics.com

Auth URL = https://login.windows.net/<tanant ID here>/oauth2/authorize?resource=https://api.businesscentral.dynamics.com

Looks like step #15 is changed so try this URL: Auth URL : https://login.microsoftonline.com/a34f8ecc-bb42-4bcf-b12a-798d0109d2af/oauth2/authorize?resource=https://api.businesscentral.dynamics.com

Access Token URL = https://login.windows.net/<Tenant ID here>/oauth2/authorize?resource=https://api.businesscentral.dynamics.com

Try Access Token URL =https://login.microsoftonline.com/a34f8ecc-bb42-4bcf-b12a-798d0109d2af/oauth2/token?resource=https://api.businesscentral.dynamics.com

Client ID = Generated From previous steps

Client Secret value = Generated From previous steps

Select Add Authorization data to = Requests headers

 

16. Click Get New Access Token

17. You will get a pop-up window asking for Business central ID and Password

18. Enter the ADMIN ID and password which you have used in Azure directory in above steps

19. You should get sucess message. If you get an error message then ensure you have entered the Client ID and CLient secret correct.

20. You will get Access Token in Postman. Then you can use any API available in Business central and click SEND to test

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)

Dynamics 365 Business Central Launch Event

 

msdyn365bclaunchevent2021w1

Dynamics 365 Business Central Launch Event
Tuesday, April 13, 2021
8:00 AM - 9.30 AM Pacific Time

Register here: Dynamics 365 Business Central Launch Event (social27.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.

PunchOut , External catalog in D365FO

https://youtu.be/it3YDqoNAyQ

PunchOut, External catalog

Pre-requisite:  Get the cXML setup from the eCommerce shopping vendors. They will register You on their system, which allows You to connect their system. They will provide ID and PW which enables us to connect their system.

In this video, we will see PunchOut (External Catalog) functionality in D365FO. This enables us to connect with eCommerce shopping sites like Amazon, Grainger, Staples etc. Below is the video link.

https://youtu.be/it3YDqoNAyQ

Below is the cXML file format:

<?xml version="1.0" encoding="utf-8"?>

<cXML payloadID="" timestamp="" version="1.2.008" xml:lang="en-US">

  <Header>

    <From>

      <Credential domain="DUNS">

        <Identity>ID</Identity>

      </Credential>

    </From>

    <To>

      <Credential domain="DUNS">

        <Identity></Identity>

      </Credential>

    </To>

    <Sender>

      <Credential domain="NetworkID">

        <Identity>id</Identity>

        <SharedSecret>password</SharedSecret>

      </Credential>

      <UserAgent>agent</UserAgent>

    </Sender>

  </Header>

  <Request deploymentMode="test">

    <PunchOutSetupRequest operation="create">

      

      <BuyerCookie />

<Extrinsic name="UniqueUsername">Akokney</Extrinsic>

<Extrinsic name="UserEmail">Akokney@email.com</Extrinsic>

     <BrowserFormPost>

<URL>https://axurl.cloudax.dynamics.com/?mi=catExternalCatalogBasketWizard</URL>

</BrowserFormPost>

<SupplierSetup>

        <URL>https://staples.com/StaplescXML/receive11</URL>

      </SupplierSetup>

    </PunchOutSetupRequest>

  </Request>

</cXML>

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