Vendor List

(0) Share

Report

Posted on by jsshivalik

3,099

I am using Posted WareHouse Receipt Header & Posted WareHouse Receipt Line Table. In Posted Warehouse Receipt Header i have field Source No in which Vendor Id is stored. In Request Page in this report it displays dropdown but list of Vendors is not displayed. I want Unique Vendors List to be displayed.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

You need to write code on OnLookup trigger by using Vendor table to display the list of unique vendor

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

Can u pls help me in detail where i should write the code. Field is displayed by adding filter from Posted Warehouse Receipt Line

Thanks

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello,

Already we discussed earlier, see below link:

https://community.dynamics.com/nav/f/34/t/251684

Only the variable is different. In this you have to filter your table instead of "CustomerPostingGroups " and pass your table.

CustomerPostingGroupG - OnLookup(VAR Text : Text) : Boolean
//>>Sbinesh
// CustomerPostingGroups is a record variable of TABLE Customer Posting Groups
// CustomerPostingGroupG is a global variable [you can use that variable/field you want to lookup]

//filter CustomerPostingGroups as you want and finally pass this Record variable.
IF PAGE.RUNMODAL(110,CustomerPostingGroups) = ACTION::LookupOK THEN BEGIN
CustomerPostingGroupG := CustomerPostingGroups.Code;
END ELSE CLEAR(CustomerPostingGroups);
//<<Sbinesh

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

Create a global variable vendor of code 20, show this field on request page & in property of this field set table relation to vendor table.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Create a new global variable for Vendor No. and use that in the request page for filtering, set the tablerelation for that variable to vendor and use that value to filter the Source No. onPreDataItem of the DataItem.

Was this reply helpful? Yes No