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

Copy Sales Order's External Document No into Purchase Order's Vendor Invoice No

(0) Share

Report

Posted on by Suvarna

Hello,

I am new to Business Central Development and customization. I want to display Sales Order's External Document No into Purchase Order's Vendor Invoice No.

I am creating Purchase Order through Sales Order. When I click on create purchase order that time only I want to collect Sales Order's External Document No and save it on Purchase Order. Or else directly copy this External Document No into Purchase Order's Vendor Invoice No.

How to do ?

Please help...

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

RE: Copy Sales Order's External Document No into Purchase Order's Vendor Invoice No

Hi,

You can call Event OnCreatePurchaseHeaderOnBeforeInsert from Codeunit 1314. and pass the sales header field's value to Purchase Header's field.

Thanks.

Was this reply helpful? Yes No
Suvarna on at

Like (0)

Report

RE: Copy Sales Order's External Document No into Purchase Order's Vendor Invoice No

Hi Nitin,

Thanks for your reply. Can you little bit elaborate how to do it? I am new for development. Please explain step by step that how to call this code unit 1314. Then how to modify it?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: Copy Sales Order's External Document No into Purchase Order's Vendor Invoice No

Hi,

Please declare below event in any Codeunit

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Purch. Doc. From Sales Doc.", 'OnCreatePurchaseHeaderOnBeforeInsert', '', false, false)]

local procedure OnCreatePurchaseHeaderOnBeforeInsertPurch(var PurchaseHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header"; Vendor: Record Vendor)

begin

PurchaseHeader."Vendor Invoice No." := SalesHeader."External Document No.";

end;

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,448 Super User 2025 Season 2 on at

Like (0)

Report

RE: Copy Sales Order's External Document No into Purchase Order's Vendor Invoice No

This doesn't sound like a good idea. If you do what you are requesting, you will have no place to record the actual Vendor's invoice number when it comes in.

If you want to see your Customer's PO number on the Purchase Order, simply add a new field and have the External Doc. No. populate the new field.

Was this reply helpful? Yes No
Suvarna on at

Like (0)

Report

RE: Copy Sales Order's External Document No into Purchase Order's Vendor Invoice No

Hi Nitin,

it's giving error : The member referenced by event subscriber 'OnCreatePurchaseHeaderOnBeforeInsertPurch' parameter 'Vendor' is not found.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: Copy Sales Order's External Document No into Purchase Order's Vendor Invoice No

Hi,

Please try this.

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Purch. Doc. From Sales Doc.", 'OnCreatePurchaseHeaderOnBeforeInsert', '', false, false)]

local procedure OnCreatePurchaseHeaderOnBeforeInsertPurch(var PurchaseHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header")

begin

PurchaseHeader."Vendor Invoice No." := SalesHeader."External Document No.";

end;

Was this reply helpful? Yes No
Suvarna on at

Like (0)

Report

RE: Copy Sales Order's External Document No into Purchase Order's Vendor Invoice No

Hi Nitin,

I already tried but then code is not working. External Document no is not fetching in PO.

Was this reply helpful? Yes No