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!

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Dallefeld 225 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,788 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Shathika Karunaratne 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,242 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No