Joining to the Customer Table

(2) Share

Report

Posted on by JE-20081519-0

3,230

Hi:

I need to display data from the "Customer" table.

When I try to join it to either the Sales Line based on Bill-To Customer No. or Item Ledger Entry based on Source No., I cannot get data form the "Customer" table to display.

Does anyone have any ideas?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

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

Like (1)

Report

It's not clear what tool your screenshots are from.

But the data you mentioned should be available, for example,

Sales Line:

Item Ledger Entry:

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,614 Super User 2025 Season 2 on at

Like (1)

Report

if this helps: https://www.youtube.com/watch?v=eYg7MMPBWxI

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-links-joins

Was this reply helpful? Yes No