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

How to filter dimensions value for particular customer/vendor

(1) Share

Report

Posted on by SalbaZamam

I have created one field on dimension value table as customer no where user will select customer against dimensions value.So how can i see only those dimension value for that particular dimensions code on sales order for that customer.Only those dimension value will be visible to customer where customers selected in dimension value of dimension code.

Any idea.

Thanks in advance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

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

Like (0)

Report

Hi, You can add the filters you need in the page OnOpenPage Trigger. Here is a simple example

Dynamics 365 Business Central: How to make some filters mandatory on the list page (users can not change or remove)

https://yzhums.com/8427/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,772 Super User 2025 Season 2 on at

Like (0)

Report

You can use standard option for each Customer, just provide which Dimension Values can be used for him.

Was this reply helpful? Yes No
SalbaZamam 90 on at

Like (1)

Report

Actually issue that

When I am clicking dimensions on sales order it open by "dimension set id" not by customer filter..So.there is no customer No.on dimension (under sales order) If i create customer field and modify customer number in it on basis of "dimension set Id" So when i select new dimension code the "Dimension set Id" got reset so filter will apply on blank customer No.

Actually I want something like this

when I will add new dimension(On sales order) then only those value which is linked to that dimensions and customer should show.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

As far as I know, this is a bit difficult. First of all, there is no Customer No. in this table. If you need to do this, you need to add a field first and pass the Customer No. from the Sales Order. The second problem is that this value is set through the TableRelation Property, and there are restrictions on the extension of this property. More details: Dynamics 365 Business Central: Can we extend TableRelation Property through a table extension??? (Yes, But…)

https://yzhums.com/26939/

If you want to do it, you can only add a new field.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No