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

relationships fields between tables in business central

(0) Share

Report

Posted on by Manuel Lozada

357

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Amit 2,557 on at

Like (0)

Report

RE: relationships fields between tables in business central

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (0)

Report

RE: relationships fields between tables in business central

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

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

RE: relationships fields between tables in business central

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

Was this reply helpful? Yes No
Suggested answer

pankaj.k 994 on at

Like (0)

Report

RE: relationships fields between tables in business central

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

Was this reply helpful? Yes No