display a field from another table

(0) Share

Report

Posted on by Rupali

335

Hi all,

I have a requirement where I want to display a field (Item no.) from Item list page on Purchase order list page.Both are having different tables.

How can I do that? Can somebody please help me with the code.

Regards,

Rupali

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Salah Eddine BENOUALA 485 on at

Like (0)

Report

Hi Rupali,

You need customizations to get the field from another table.

-----------------------------------------

Best Regards,

Salah Eddine BENOUALA

Dynamics NAV & 365 Business Central Consultant

Please verify my answer, if you find it helpful.

Doing so you'll show others that there was found a solution and you credit my help.

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

The simple option is a flowfield: docs.microsoft.com/.../devenv-creating-flowfields-and-flowfilters

Problem there being a PO and the item table other than a Vendor No. don’t have much of a relationship. Do you mean get an item from the purchase lines related to the PO? If so the flowfield would be for the purchase line table and would only ever be able to show one result.

There is another pattern where you use a codeunit on open of the page to iterate through each record it finds a match with. At least with this one you can define how much data the field holds. So you could pull in more item numbers. Examples of a codeunit being used to pull in information from other places can be seen in factboxes. Check out the purchase/saws line details

Was this reply helpful? Yes No
Suggested answer

Anks27 1,085 on at

Like (2)

Report

Hello,

If you want to show item number from Item List to Purchase Order list then you must create extension for that.

Big Question is what if the purchase order have more than 1 item number? In that scenario do you want to show first item number or all item numbers with | (Pipe). Anyway I am adding the code for multiple as well single item number.

Code for single Item Number:

Solution:

Code for Multiple Item Numbers:

Solution:

Signed, Sealed and Delivered.

Don't forget to help the community by Verifying the answer and Like it if your question has been answered. It will let others know that the topic has verified answer.

Thanks & Regards,

Ankit Shah(MCT-Microsoft Certified Trainer || Dynamics 365/Business Development Manager)

Follow/Connect 101 on below

LinkedIn:-   https://linkedin.com/in/dynamicpower101/

Twitter:-     https://twitter.com/Dynamicpower101

Facebook:- https://facebook.com/DynamicPower101/

Telegram:- https://t.me/dynamicpower101

Medium:-   https://medium.com/dynamicpower101

Was this reply helpful? Yes No
Rupali 335 on at

Like (0)

Report

Hi Ankit,

Thank you so much.

I tried your solution it did create the field on Purchase order list page but Its not fetching /displaying the item numbers from the item list page.

To answer ypur question ,Yes PO has more than one item numbers and i want all of them to be displayed on Purchase order list page with pipe.

Thanks,

Rupali

Was this reply helpful? Yes No
Netjacker2097 286 on at

Like (0)

Report

Thanks for this, this is exactly what I needed...you Rock!

Was this reply helpful? Yes No
Mat B 130 on at

Like (0)

Report

Thanks for this code snippet. It helped me on a similar requirement on a different page!

Was this reply helpful? Yes No
liki 5 on at

Like (0)

Report

Thank you, It helped me also.

Was this reply helpful? Yes No
AAndras on at

Like (0)

Report

Ankit Shah

Just a questions:

If I want see the page in Edit in Excel than the derived field is not appears in the Excel. Is there a way to make it visible?

Was this reply helpful? Yes No