Wednesday, March 4, 2020

MSDYN365BC 2019 Wave 2 - Upgrading an Modified C/AL Database - Part 1.

Hi Readers,

In this article, we will do some quick customization in a Business Central Spring 2019 Release(14) and we will use that database in this series to upgrade to Business Central 2019 Wave 2 (15).

As I said earlier I will be using Business Central 14 (Cumulative Update 08) and that is the only version that I can use to Upgrade to Business Central 15 (Cumulative Update 03).

If you have a different version of Business Central 14, then refer to the compatible version of 15.

#MSDYN365BC #BC2019Wave2

For other Articles in this series Refer Here.
  1. To start with, I restored a Base Microsoft Cronus Database from the Business Central 14 Product DVD.
  2. I named the database as UPG_CustomApp_14_15.

What Custom I am doing - 
  • Adding a field in Master & Transaction Tables listed Below with Three Fields - 
    • Tables - G/L Account, Item, Sales Line, Resource, Fixed Asset & Item Charge.
    • Fields  - Test Text Field, Test Boolean Fields, Test Integer Field.

  • Adding those fields in Master and Transaction Pages Below with Three Fields.
    • Pages - G/L Account Card, Item Card, Sales Order Subform, Resource Card, Fixed Asset Card & Item Charges.
    • Fields - Test Text Field, Test Boolean Fields, Test Integer Field.

  • Also Added Some Custom Code in Sales Line Table.
    • Functions - CopyFromGLAccount, CopyFromResource, CopyFromFixedAsset, CopyFromItem & CopyFromItemCharge.
    • The Idea with these custom Lines is to copy those three fields values from Master Table to Transaction Table.

** Again as I said earlier, This customization is just for Demo. This can be easily converted to an AL Extension. I am not suggesting to use this approach, I am just using this for this demo.

Later I created a Batch to add data into these fields as shown below.

So, in the end, you should have the following objects modified. In Total a 12 Objects were Modified.

In the Next Article, we will discuss merging these modifications in the Business Central 2019 Wave 2 Base Application and then do data Upgrades.

Stay tuned for more.

Hope you find it useful.

Let me know your views as a comment on this article.

Saurav Dhyani

No comments:

Post a Comment