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

Filter in dropdown

(0) Share

Report

Posted on by Community Member

Hello!

I have made a dropdown at Purchase order for a page "Fiscal Purchase" (created by me) every vendor at this page has a amount, now i want that at purchase order dropdown must have vendors with positive (+) amount and at Purchase credit memo must have vendors with negativ (-) amount.

The table relation that I have is working

TableRelation=IF ("Import from fiscalization"=const(true))"Fiscal Purchase" where ("Vendor No."=field("Buy-from Vendor No."));

I know that is something with document type , I have tried in different ways but none of them isn't working.

Thank uu for ur time!

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 81,757 Super User 2025 Season 1 on at

Like (0)

Report

RE: Filter in dropdown

Hi, Just adding another idea, hope this can give you some tips.

If you need more flexible control, you can create two variables that collect data when the page is opened. Then use the OnDrillDown (Page Field) Trigger to display the content you need.

Thanks.

ZHU
Suggested answer

Shathika Karunaratne on at

Like (0)

Report

RE: Filter in dropdown

It can be work with a separate page with an action where you can display the vendors with the particulars filter. Or else you can use a Flow Field with a COUNT calculation formula in the table as below

Hope this will help you.

Thanks.

Shathika
Suggested answer

Nitin Verma 21,544 Moderator on at

Like (0)

Report

RE: Filter in dropdown

Instead of table relation you can declare CALCFORMULA property and sent your conditions there with Lookup or sum method. You can take an idea how to declare from Item Table.
Community Member on at

Like (0)

Report

RE: Filter in dropdown

It's not the amount of sistem is another field amount that I added
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: Filter in dropdown

Vendor balances are negative by default with credit memos being positive. Not sure what you are asking....