How we Generate the query-country of FinalDestination it show Port Discharg

[Former Member]

Hi,

To create a FMS Query to generate this when we choose Country of final destination like USA than - it shows the Port of Discharge list according to Country of final destination like- Any other Port.

And query is apply it to the UDF's Fields which is made in Export Module - form sales Quotation.

But i am enable to make the query of this requirement.

Can u plz guide me. How it can be made through the Query Generator.

[Former Member]

Hi,

Please review all your previous postings and close them if questions had been answered. Otherwise, response to others' help.

Thanks,

Gordon

[Former Member]

Hi

Create a UDT as Country UDF type as Master Data, and another UDF as Country Ports as Master Data Lines,

Register objects as Master and Master Data lines and give country as header and Ports init as Lines..then u can

write FMS from Query generator..

Regards

NKS

[Former Member]

Sir,

Help me in generating the Query b'coz i have made the UDF's in the Export Module of Title fields -

Country of final destination and Port of discharge. I am not able to create it i dont know the table name.

So, plz guide me .

[Former Member]

Sir,

I have made the UDF's Country of Final Destination Query :

SELECT T0.[Name] FROM OCRY T0

and for Port of Discharge table name : @EXP_POLM

i counldn't find the actual data which i want to it.

plz help me.

[Former Member]

Hi jyotasna,

As per my understanding you create both UDF at title level in Sales Quatation

When Select First UDF Final Destination then Second UDF Display Port of discharge according to first UDF selection

Thanks,

Srujal Patel

[Former Member]

Sir,

Yes Sir, I have made the UDF's both in Export Module in Sales Quotation when we make .

We use this in country of final destination which is an UDF field and another one is Port of Discharge.

So, please help me to create this requirement query. As per requirement when i choose country of final destination

so on this base i want to list out port of discharge.

Now, can you reply my question.

[Former Member]

For that you create both UDF drop down & in first UDF Code are put with particular logic in UDT

Second UDF code(UDT) start with the first character of First UDT code that means Second UDF filter with First UDF selection code.

Hope you will get it.....

Declare @AA as Nvarchar(10)
set @AA = ($[OITM.U_Group1])
select * from [@GROUP2] where Code like  @AA + '%'

Thanks,

Srujal Patel

Edited by: Srujal Patel 77 on Feb 10, 2012 11:41 AM