web

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

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Create a list page fro...

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

Suggested answer

Create a list page from two different tables

(0) Share

Report

Report

Posted on by BchM

92

Hello, I would like to create a list with two fields "No." and "Bill-to name", these two fields appear in the "Sales Invoice Header" and "Sales Cr.Memo Header" tables, so I would like all the records of both tables to appear in the list. How could I do this? I'm new to Business Central, so I have no idea where to start.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Vaishnavi J 3,062 on at

Like (1)

Report

RE: Create a list page from two different tables

Hi,

You can create a flow field to show the data from the two table.

below is the link for more information.

docs.microsoft.com/.../devenv-creating-flowfields-and-flowfilters

or you can add logic onaftergetrecord trigger but you need to have filter conditions that will pull data.

you need to create appropriate fields in your list page to display the data from both the tables. Since the sales credit memo and sales invoice is link only Applies to Doc No field (is the sales credit is created using cancel or correct action in PSI page).

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

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,214

#2

Sumit Singh 2,145

#3

YUN ZHU 1,887 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans