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

How can you access a Customer No by its Contact Code?

(0) Share

Report

Posted on by Community Member

How can we look up the No. value of the Customer record that matches the Contact code provided?

I know how to do this with lookup() like below, but that doesn't seem to work in this instance.

lookup(Customer."No." where("No." = field("Contact Code")))

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 98,130 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, this is because they are not directly related, you can check the table and page below.

page 5061 "Contact Business Relations"

table 5054 "Contact Business Relation"

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Zhu, however my issue is that I am trying to set the Customer No value of a Job record. The Job is being automatically created from an Opportunity, which has a Contact.

So I would like to retrieve the Customer No where Contact Code = X.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,581 on at

Like (0)

Report
Copy link

Link copied!

Hi

I am sure yzhums will provide a solution.

Just a none-developer feedback:

Each contact has a relationship with company' contact. Maybe from contact extract the company contact no. Then use that company contact no and table recommended by Mr. Yun and get the customer no.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,130 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi, try the following.

For reference only:

tableextension 50117 MyExtension11 extends Vendor { fields { field(50100; "ZY Contact No."; Code[20]) { DataClassification = CustomerContent; TableRelation = Contact where("Contact Business Relation" = filter(1)); trigger OnValidate() begin CalcFields("ZY Contact Customer No."); end; } field(50101; "ZY Contact Customer No."; Code[20]) { FieldClass = FlowField; CalcFormula = lookup("Contact Business Relation"."No." where("Contact No." = field("ZY Contact No."), "Business Relation Code" = filter('CUST'))); } } } pageextension 50117 MyExtension11 extends "Vendor Card" { layout { addafter(Name) { field("Contact No."; Rec."ZY Contact No.") { ApplicationArea = All; } field("Contact Customer No."; Rec."ZY Contact Customer No.") { ApplicationArea = All; } } } }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Zhu -

Unfortunately this does not work, as I need to set original Bill-To Customer No. value, which is not a flowfield and cannot be changed. If I created a 2nd customer no field as you've shown, how can I then set the original Bill-To Customer No field to update to the same value?

Was this reply helpful? Yes No