top of page
Writer's pictureDan

Dual Write GAB & D365 CE First Party Apps: Bridging the Functional Knowledge Gap - Part 2

Welcome to Part 2 of this blog series on Dual Write, the Global Address Book solution and the impact on D365 first party applications.


As a quick recap, at the end of Part 1 we have an environment in which we can create company records (legal entities) that allows us to create records in the system.

So that's great but it's only one part of the puzzle from a data perspective. We could go ahead and look at the different new tables that have been created and muddle through creating elements of the master data as we go. The challenge here is that you won't necessarily know the data that you are creating or have examples of what the data usually looks like or means.


To get some meaningful data into out environment we are going to delve into D365 Finance & Operations. This will help us to enhance and bring our environment to life a little bit and make it representative of real life data.


Model Driven App Site Map Extension


Before we do delve into the data side, lets make life a little bit easier for ourselves and make some enhancements to the model driven application.


I would suggest creating a new area on the site map named Dual Write Master Data or similar. In here we are going to add in tables that we will be using to populate data and update/create a view to make the process more efficient.


I have sectioned my area into the groups to cover miscellaneous data, customer and vendor data, contact data, address data and unused data (more on that one later).



I have then updated the views to show the relevant fields that we require, this will enable us to user the Export to Excel either Open In Excel Online or Export and Import processes to get data into the system. I will leave which method you want to chose to your own personal preference, manual entry may give you an understanding of the data links. It's worth noting that GUIDs will need to be used for records of the same name for different companies. I am assuming a level of understanding of getting data into the system as these area's won't be covered. Also be aware that some form modifications may be required if going down a manual data entry route.


For each table I've shown the view that I created below and the field order that was most beneficial for record creation via the Export to Excel or Import/Export feature.


Companies



  1. Company Code

  2. Name

  3. Default Owning Team (system populated)

  4. Is Enabled for Dual Write


Currencies



  1. Currency Name

  2. Currency Code

  3. Currency Symbol

  4. Exchange Rate

  5. Currency Precision


Customer Groups



  1. Company

  2. Customer Group Id

  3. Description

  4. PaymentTermId

  5. Time between invoice due data and payment date

  6. Is Sales Tax Included in Price

  7. Write Off Company

  8. Write Off Reason


Customer Payment Method



  1. Company

  2. Name

  3. Period

  4. Description

  5. Grace Period Days

  6. Payment Status

  7. Payment Type

  8. Last File Number

  9. Last File Number Today

  10. Account Type

  11. Bridging Posting

  12. Postdated Check Clearing Posting

  13. SEPA

  14. Bill Of Exchange Type of Draft

  15. DirectDebit

  16. Invoice Update


Name Affixes



  1. Affix

  2. Type

  3. Description


Payment Days



  1. Company

  2. Name

  3. Description


Payment Day Lines



  1. Company

  2. Payment Day

  3. Line Number

  4. Frequency

  5. Day of Week

  6. Day of Month


Payment Schedules



  1. Company

  2. Name

  3. Description

  4. Allocation Method

  5. Payment Frequency Unit

  6. Payment Frequency

  7. Number of Payments

  8. Sales Tax Allocation Method

  9. Fixed Payment Amount

  10. Minimum Payment Amount

  11. Note


Payment Schedule Lines



  1. Company

  2. Payment Schedule

  3. Line Number

  4. Periods After Due Date

  5. Percent or Amount

  6. Percent of Amount Value


Payment Terms



  1. Company

  2. Name

  3. Description

  4. Payment Method

  5. Cash Payment

  6. Number of Months

  7. Days

  8. Payment Schedule

  9. Payment Day

  10. CutOffDay

  11. Default Terms of Payment

  12. Customer Due Date Update

  13. Certified Company Check

  14. Payment Type

  15. Credit Card Check


Vendor Group



  1. Company

  2. Vendor Group

  3. Description

  4. Payment Terms

  5. Time Between Invoice Due Date and Payment Date


Vendor Payment Method



  1. Company

  2. Name

  3. Description

  4. Grace Period Days

  5. Payment Status

  6. Payment Type

  7. Allow Payment Copies

  8. Last File Number

  9. Last File Number Today

  10. Account Type

  11. Bridging Posting

  12. Postdated Check Clearing Posting

  13. Promissory Note Draft Type

  14. Direct Debit

  15. Payment Method


Complimentary Closings



  1. Company

  2. Complimentary Close

Decision Making Roles



  1. Company

  2. Decision

  3. Description


Employment Job Functions



  1. Company

  2. Function

  3. Description


Loyalty Levels



  1. Company

  2. Loyalty

  3. Level Description


Personal Character Types



  1. Company

  2. Character

  3. Description


Sales Contact Person



  1. Company

  2. Title

  3. Person Title Alias


Salutations



  1. Company

  2. Salutation


Address Roles



  1. Name

  2. Is Postal Address Role


Obtaining Finance & Operations Data


Now we need to go and get some data to put into our environment, but before you do it may be worth reading this Microsoft Learn module named Navigate finance and operations apps. If you don't want to do this then look at the image below from the module for a high level view and pay attention to the company (legal entity) picker.



We also need to get access to a Finance and Operations environment. Microsoft seem to have closed off the demo route I used previously so we will utilise one of the F&O VM instances available for Microsoft Learn lab exercises. Here is one such module that has a lab exercise. Note these expire after 2 hours.


I've hyperlinked the dual write map links to each of the headings for ease of reference, here you can check the data used if required. Data will either be displayed on screen in forms or in a table within F&O, if data is in a table then use the export all rows functionality (right click on the header) to speed up the process and copy the data to a local spreadsheet. When the data is in forms either key this in via the forms or use the Open in Excel Online to create data and import it.


There are some elements you will need to sequence, I have purposely not called these out to allow you to get more familiar with the data.


I'm sure some D365 CE users will feel this way, but there's nothing to fear!



I personally chose to take data for these three legal entities, but if you have more time then feel free to do more but three should be the minimum.


  • USSI

  • USMF

  • USRT


USSI is the only one that I found with a data set for each table, so I suggest using this as a base.


Use the search bar at the top and search for legal entities and select the option below.



As you will see legal entities are complex but in Dataverse we only require the minimum data set so just capture the code and name.




Use the search bar at the top and search for currencies and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Currencies are not company/legal entity specific so this only needs to be done once.




Use the search bar at the top and search for customer groups and select the option below under accounts receivable (customers = accounts receivable and vendors = accounts payable).



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Customer Groups are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for methods of payment and select the one below under accounts receivable.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Customer Payment Methods are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for name title and suffix and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Name Affixes are not company/legal entity specific so this only needs to be done once.




Use the search bar at the top and search for payment days and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Payment Days and Payment Day Lines are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for payment schedules and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Payment Schedules and Payment Schedule Lines are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for terms of payment and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Payment Terms are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for vendor group and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Vendor Groups are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for methods of payment and select the option below under accounts payable.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Vendor Payment Methods are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for complimentary close and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Complimentary Closings are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for decision and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Decision Making Roles are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for job functions and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Employment Job Functions are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for loyalty and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Loyalty Levels are company/legal entity specific so this only needs to be done multiple times.




Use the search bar at the top and search for character, and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Personal Character Types are company/legal entity specific, so this needs to be done multiple times.




Use the search bar at the top and search for contact person titles and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Sales Contact Persons are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for salutation and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Salutations are company/legal entity specific so this needs to be done multiple times.




Use the search bar at the top and search for address and contact information purpose, and select the option below.



The data required will be on the screen below (check the mapping table referenced in the title hyperlink where required).


Address Roles are not company/legal entity specific so this only needs to be done once.



Internal Organisations


I mentioned these sections earlier when they were added under unused in the site map. When you try in D365 CE to create these records you get the same kind of error that we got on the company record, unfortunately when we try to disable the offending plugin step we get the below error message.



These elements aren't critical to the functionality that we are going to cover in subsequent blogs but for completeness I will cover what they are later in the series.


So there we have it, two blogs down and if you've followed the series so far you will now have a D365 CE environment not only populated with company/legal entities but also now with master data for the various tables. Having this data in the system in a structured meaningful manner is far more beneficial than creating data on the fly and it not representing the process.


Thanks again for taking the time to read this article and I hope you have found it useful. Next in the series we will start to explain the new data structure in more detail and bring it to life with the data that we have just added.


Dan

bottom of page