Update Line table from the Header table

Dynamics 365 Business Central/NAV User Group Developers Forum
#1

Hello,

I need to automatically update a field in the table Commission Release Line.

E.g.

Table: Commission Release Header

Field: Sales No.

I add another field in Commission Release Line because there is no “Sales No.” in that table. How can I make it automatically update and get the value in “Sales No.” from Commission Release Header?

#2

Write code In OnInsert Trigger of the Commission line to copy the sale no from the header.

#3

You mean whenever you update SalesNo in Header table the same has to be updated in All Lines table also,right?

What did you ntry this now?

#4

Yes Mohana, actually the “Sales No.” is already there in “Sales No.” (header)., but it is not updating in “Sales No.” in line (the one that I added). I declared RCDCommReleaseHeaderTbl in global to get the Comm. Release Header Tbl. I used this code in

Sales No. - OnValidate()

RCDCommReleaseHeaderTbl.GET(“Sales No.”);

"Sales No." := RCDCommReleaseHeaderTbl.“Sales No.”;

But it still not updating in the lines

#5

If it’s a part of key in Line Table, you may try set property “TableRelation” on that field.

This update the foreign keys while the parent primary key changes… ( most likely )

#6

in header table or line table or header form or line form trigger?

Read help to know about Get function…when it should be used and how…

#7

Sales No is not your primary key.so u cannot use it in get functoin.

#8

And also investigate whether this can be done via FlowField…

#9

Write code in the “Sales No” -onValidate TRigger of the header.

Filter all the line with same document no and modify them all with Header sale No

#10

Can you give us a sample code?? we dont have idea what to code. :frowning:

#11

CommLine - Variable for Line

“Sales No.”- Onvlidate()

CommLine.getrange(CommLine.“Document No.”,“No.”) // Header “No.”

if CommLine.findfirst then

repeat

CommLine.“sale No.”:=“sale No.” // Header Sales No

CommLine.modify;

Until CommLine.next=0

or u can folwfield functionality in the Sales no in the line

#12

Why dont you ask for proper training in office?

When do you learn If we provide code to you?

#13

Hello Ruby,

IF u want to insert sales no in line also wen ever u insert into header, Just make document form and wen ever u insert no in header then it automatically inserts into line by setting subformlink Property.

#14

Hello,

Thank you for the idea of “SubformLink”.

But What I did is…

  1. Ctrl + F2 in the form of Comm. Release Header

  2. Select the Subform ->Sales Comm. Wksht Line

  3. press F9 then you’ll see the

InsertCommReleaseLine(codPTeamMemberID : Code[20];intPLineNo : Integer;decPCommRate : Decimal;txtPDescription : Text[30])

  • add

recLCommReleaseLine.“Sales No.” := “Sales No.”; - under recLCommReleaseLine.“Release No.” := “Release No.”;

Compile - and it automatically captures the sales no from the header!

Example:

InsertCommReleaseLine(codPTeamMemberID : Code[20];intPLineNo : Integer;decPCommRate : Decimal;txtPDescription : Text[30])

intLLineNo := intPLineNo;

recLCommReleaseLine.INIT;

recLCommReleaseLine.“Release No.” := “Release No.”;

recLCommReleaseLine.“Sales No.” := “Sales No.”;//inserted by rubi

recLCommReleaseLine.“Line No.” := intLLineNo;

recLCommReleaseLine.“Team Member ID” := recLTeamMember.ID;

recLCommReleaseLine.“Team Member Name” := recLTeamMember.Name;

recLCommReleaseLine.“Team Member Designation” := recLTeamMember.Designation;

recLCommReleaseLine.Description := txtPDescription;

recLCommReleaseLine.“Rate %” := decLCommRatePerc;

recLCommReleaseLine.“Gross Amount” := decLGrossAmt;

THANK YOU!