Small and medium business | Business Central, N...

relationships fields between tables in business central

(0) Share

Report

Posted on by Manuel Lozada

373

Hi community,

Could you help me, how I can populated 1 : N Relationships?

For example I have a field in sales quote (Quote name), and I want after created the order populate the same data in sales order field (Order name)

Thanks

All responses (4)

Answers (0)

Sort by

Suggested answer

Amit 2,563 on at

Like (0)

Report
Copy link

Link copied!

Hi,

use this event for achieving the functionality.

OnBeforeInsertSalesOrderHeader(SalesOrderHeader, SalesHeader);

and for use of Eventscriber. Refer the below link

https://erpconsultors.com/onafterinsertevent-dynamics365/

Regards

Amit Sharma

www.erpconsultors.com
Suggested answer

YUN ZHU 103,157 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, If you want to transfer the data on Sales Quote to Sales Order when creating Order. Please refer to Amit's suggestion. You need to add the code when creating the order.

If you just associate some data, such as master data. Consider using TableRelationship or Flowfield.

Hope the following helps.

https://yzhums.com/22220/

And

FlowFields (Sum, Average, Exist, Count, Min, Max, Lookup)

https://yzhums.com/5802/

How to create a Lookup, Drop-Down, or Option list (Single and Multi select)

https://yzhums.com/5985/

How to enter any value in a TableRelation field (Without validating the table relationship)

https://yzhums.com/17582/

Thanks.

ZHU
Suggested answer

DAnny3211 11,423 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

you should ask your partner to develop a customisation.
the part involved is this:

codeunit 86 "Sales-Quote to Order" - > local procedure CreateSalesHeader -> OnBeforeModifySalesOrderHeader

you should latch on to this event

DAniele
Suggested answer

pankaj.k 1,020 on at

Like (0)

Report
Copy link

Link copied!

Hi Manuel Lozada,

if you want to Transfer your New Field Data form "Sales Quote" to "Sales Order" then you need to Write Code on (EventSubscriber OnAfterInsertSalesOrderHeader). Use below code...

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Quote to Order", 'OnAfterInsertSalesOrderHeader', '', false, false)]

local procedure OnAfterInsertSalesOrderHeader(var SalesOrderHeader: Record "Sales Header"; SalesQuoteHeader: Record "Sales Header");

begin

SalesOrderHeader.YourField := SalesQuoteHeader.YourField;

salesorderheader.Modify();

end;

Thanks