Posted Invoice Report RDLC (10074) - How to Remove (or not show) the contact name in the address

(5) Share

Report

Posted on by MG-03122127-0

Hi!

I have the same question as this one Custom Layout Reports Bill To fields - I want to remove the Contact name from showing in the BillTo Address.

If I hide the field (that usually show the contact) in the report, the first line of the address is not showing if there is no contact in the customer...

But we are in 2025 now, is there any other way to manage that, or do I still need to change the Codeunit: 365 Format Address?

Thanks!

Marilyn

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (1)

Report

You can subscribe to the below event

OnBeforeSalesInvBillTo(AddrArray, SalesInvHeader, Handled);

Add the below code and it should blank

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Format Address", OnBeforeSalesInvBillTo, '', false, false)]

local procedure "Format Address_OnBeforeSalesInvBillTo"(var AddrArray: array[8] of Text[100]; var SalesInvHeader: Record "Sales Invoice Header"; var Handled: Boolean)

var

FormatAddr: Codeunit "Format Address";

begin

FormatAddr.FormatAddr(

AddrArray, SalesInvHeader."Bill-to Name", SalesInvHeader."Bill-to Name 2", '', SalesInvHeader."Bill-to Address", SalesInvHeader."Bill-to Address 2",

SalesInvHeader."Bill-to City", SalesInvHeader."Bill-to Post Code", SalesInvHeader."Bill-to County", SalesInvHeader."Bill-to Country/Region Code");

Handled := true;

end;

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 31,505 Super User 2025 Season 2 on at

Like (2)

Report

You can modify the Contact Address Format in the Countries/Regions page to display the contact name last. Then, you can hide the last address field containing the contact name.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

This array of addresses is really annoying.

I think another simple solution is to just remove the field from the layout.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

believe removing the field from the layout should resolve the issue.

If this helped you, please check the box Does this answer your question?

Was this reply helpful? Yes No
MG-03122127-0 96 on at

Like (3)

Report

The solution to change the country/region setup was accepted by my client, so I will go with this option.

I haven't test the subscription to the event in the code unit, so I can't talk about this solution, but I guess it would have been the way to go if my client didn't want to change the position of the contact.

For the others solutions about removing the field in the layout: it doesn't work. Because the way this array of address is build, if the country/region is setup to have the contact name "after company name", this field will show the contact name OR the first line of address if the contact is empty. Removing the field, means that the the first line of address won't show if the contact is empty...

Thanks!

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,505 Super User 2025 Season 2 on at

Like (1)

Report

Great, thanks for the follow up!

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No