web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Reports with at least ...

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

Suggested answer

Reports with at least two linked tables

(0) Share

Report

Report

Posted on by SalvadorGtz777

5

I have a problem to write my first report from "invoice sales" and obtain the "invoice sales lines", Do you know some link with examples of that or documentation of linking two tables in a report?, I write code en AL for BCS365 in Visual Studio Code. Thank you in advance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

divyeshchitte 968 on at

Like (0)

Report

RE: Reports with at least two linked tables

You can try this data link.

dataitem("Sales Invoice Line"; "Sales Invoice Line")

{

DataItemLink = "Document No." = FIELD("No.");

DataItemLinkReference = "Sales Invoice Header";

DataItemTableView = SORTING("Document No.", "Line No.");

You can also refer to default report 206 for the same.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,921

#2

YUN ZHU 2,012 Super User 2025 Season 2

#3

Jainam M. Kothari 1,999 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans