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

Purchase Quote - Filtring Item No. field from Purchase Header customized field

(5) Share

Report

Posted on by Meyssa

In my project, I added a customized field to the Purchase Header table to make it a mandatory field in the Purchase Quote Card. For example, this field is called "Customized Field" and I also added the same field in the Item table. My issue is that when I want to select an Item in the Purchase Card, I want the field to be filtred with the value from "Customized Field" in the header. I cannot use SubPageLink because "Customized Field" is not a primary key in these tables. I tried adding the same field to the Purchase Line table and specifying it as a FlowField. I attempted to use CalcField, but it didn’t work.

Do you have any suggestions for a solution to this problem?

Thank you in advance.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Can you elobrate it more? Or share some screen shot.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.Gather user data using the AL data type FilterPageBuilder - Business Central Musings

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

Hi, Use the following method to add a filter at the arrow position.

More details:

https://yzhums.com/5985/

Or you can use the TableRelation property to do it

For exmaple,

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,603 Super User 2025 Season 2 on at

Like (2)

Report

You can achieve this by dynamically filtering the "Item No." lookup in the Purchase Quote Card based on the "Customized Field" from the Purchase Header. Since SubPageLink is not an option, you can use the OnLookup trigger in AL.

Was this reply helpful? Yes No