4 May’18

D365 Business CentralHow to update the selected line in the Subform on click of an action button in the Mainform in NAV

Introduction:

  • The requirement was such that , the user will select a line in the subform.
  • The subform has fields like the Customer ID, Customer Name, and a field Recieved Crates.
  • On click of the action button in the Main form, a page opens which contains the details of the selected line in the subform  like Customer ID and Customer Name also a field Crate recieved(Integer Datatype).
  • User will enter Crate Recieved and click on OK. The number entered in the Crate received will modify in the Recieved crates field in the subform.

This blog explains the step wise procedure to achieve the above output.

Pre-Requisites:

Microsoft Dynamics NAV 2017

Steps:

1. Open the Developement Environment of Microsoft Dynamics NAV and open the Main form(card Page) and create an action button Received Crate and write the below code.

Here, “Crate Lines” is the Page control (subform), Here a call is made to CallLinesfromCard  function with Parameter CratesLine.

CallLinesfromCard is a global function made in “Crate Lines”Subform.

2. In the function CallLinesfromCard  in the subform. Below is the code.

Here ReceiveCrate is a page. Its the page that open on click of the action button. A function is called CrateReceivedFromCust with parameter CrateLinesTable.

3. A global function is made CrateReceivedfromCust in the page ReceiveCrate. Here global fields variables are made CustomerID,CustomerName,NoOfcratesShipped.

Theses fields are autopopulated with values from the selected line.

A field Crates Received is also created where the user will enter data.

4. OnQueryClosePage of Receive Page, below code is written to modify the Record of the Subform.

5. Set the property RefreshOnactive to yes on the Subform and Mainform.

Written by

Chris D'Silva

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Expenses in PSA for Fixed Bid and T&M contracts

    23 August’ 2019

    Problem Definition: One of my clients decided to use Expense module in PSA and to his surprise he could see the amount v...

    Read more
  • Setup Dockers

    23 August’ 2019

    Docker is an independent container platform that enables organizations to seamlessly build, share and run any applicatio...

    Read more
  • Qualify Lead in D365 CE: Select which entity records should be created

    20 August’ 2019

    Wave 2019 Updates brought some really sought-after features. Another one which I would like to bring up is the Lead Qual...

    Read more
  • Early Opt-in for October 2019 Wave 2 Updates

    20 August’ 2019

    August 2, 2019 was when the Wave 2 Updates were to be out. And here we are! By now, you should have gotten the option to...

    Read more
  • Setting Unified Interface App Icons

    20 August’ 2019

    Default App Icons for typical D365 environment look like these.But here’s what you can do to change these to put...

    Read more
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.