You’re offline. This is a read only version of the page.
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.
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.
Share
Report
All responses (
Answers (
