Brewsterware

March 24, 2023

Data Entities for Finance and Operations

Filed under: 365 for Finance and Operations,Data Entities — Joe Brewer @ 3:51 pm

As promised, please find the source code that generates the spreadsheets that contain the metadata for the Finance and Operations data entities here.

If you find this software useful, or have a suggestion to improve it I would love to hear from you.

January 8, 2023

10.0.31 Data Entities for Finance and Operations

Filed under: 365 for Finance and Operations,Data Entities — Joe Brewer @ 6:12 pm

Here is the latest collection of data entities for 10.0.31 in both en-GB and en-US languages.

10.0.31 Data Entities – en-US

10.0.31 Data Entities – en-GB

October 21, 2022

10.0.30 Data Entities for Finance & Operations

Filed under: 365 for Finance and Operations,Data Entities — Joe Brewer @ 4:09 pm

Here is the latest collection of data entities for 10.0.30 in both en-GB and en-US languages. I have added some new columns:

Is multi-threading enabled – if this is set to “Yes”, then the data entity can be added to the “configure entity execution parameters” which is accessed from the “Entity settings” tab of the “Framework parameters” which is accessed from the data management workspace. Multi-threading allows data from a single package to be uploaded across multiple AOSs.

Supports sets based operations – if this is set to “Yes”, then the records for the entity can be sent to the database server in a single “set”.

If config – if this is set to “Yes”, then the entity is used for “parameter” based tables.

10.0.30 Data Entities – en-US

10.0.30 Data Entities – en-GB

October 2, 2022

How to generate a list of forms with the tables and fields that are exposed on them for 365FO

Filed under: 365 for Finance and Operations — Joe Brewer @ 3:52 pm

I was recently asked if I could add the forms to the data entity spreadsheet that I produce, but unfortunately this is not really possible. This is because a single field can be exposed on multiple forms and also many forms use temporary tables which are populated “on the fly” when the form is loaded – the “Accounting Source Explorer” is one such example. What I can do, however, is to show you how to create a list of table names, field names, associated form names and the form control string that the field is associated with.

(more…)

September 12, 2022

Using VS Code and RapidAPI to call D365FO custom services

Filed under: 365 for Finance and Operations,Data Entities — Joe Brewer @ 3:59 pm

Here is a guide to install RapidAPI into VSCode.

Once you have installed RapidAPI, check out this guide for creating new requests.

Once you have created a new request for the custom service, change the request type to “POST” and put the full url to the service in the address box. For this example I am using the standard service for converting a decimal number to text.

​​https://xxx.axcloud.dynamics.com/​api/Services/SharedServices/RNumDateInWordConverterService/numeralsToAccountingCurrency

To configure a service for D365FO, click on “Auth”, and then “OAuth 2”. Click on the “Client Credentials” radio button, enter the client id and client secret from the web application in Azure AD.

The access token url is https://sts.windows.net/xxxxxxx/oauth2/v2.0/token where xxxxxxx is the tenant that the D365FO environment belongs to.

The scope is the url of the D365FO environment followed by “/.default”

The Token Prefix is “Bearer”

When you press the “Get Access Token” button, assuming the configuration is correct, you will get a pop up dialog showing the access token. Click on “Use Token” to accept and use the token. Note that once the OAuth 2 settings have been entered, the Headers tab will automatically update to show that the service will use OAuth 2 to authenticate.

Switch to the “Body” tab and enter the following JSON:

{
  "_sourceNumber": 12.34,
  "_languageId": "en-GB"
}

Pressing send will then send the request to D365FO and show the response:

Though I have not tested it yet, it appears that the request type can implement the ODATA verbs which would be very useful for testing data entities.

So, what do you think? Is this a contender for a Postman replacement for testing integration services with D365FO?

Older Posts »

Powered by WordPress