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

All responses (5)

Answers (0)

Suggested answer

Suresh Kulla 47,789 on at

Like (0)

Report

RE: Vendor List

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.
ManishS 80 on at

Like (0)

Report

RE: Vendor List

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.
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Vendor List

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
jsshivalik 3,099 on at

Like (0)

Report

RE: Vendor List

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
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Vendor List

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