Joining to the Customer Table

(2) Share

Report

Posted on by JE-20081519-0

1,479

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

All responses (3)

Answers (0)

Suggested answer

Jainam M. Kothari 5,891 on at

Like (1)

Report

Joining to the Customer Table

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

Khushbu Rajvi. 14,448 Super User 2025 Season 1 on at

Like (1)

Report

Joining to the Customer Table

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

YUN ZHU 81,360 Super User 2025 Season 1 on at

Like (1)

Report

Joining to the Customer Table

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