PLD for Delivery Document

[Former Member]

Hi All,

i am facing a problem to fetch the TIN number of the customer in the PLD for BP.

I have selected the table crd7 from the bp with the taxid11. As soon as I select this, the field above this, which is the bill to address, disappears. Please let me know how can I get the TIN no. of the customer in the PLD.

Thanks in advance,

Joseph

[Former Member]

Hi Joseph,

TIN No. will not able to retrive in PLD.

Try to Create 1 UDF and assign the FMS in UDF.

->> Create UDF(TIN No.) and assign this FMS Query.

SELECT  Max(T0.[TINNo]) 
FROM CRD7 T0  
INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode 
WHERE 
T1.[CardCode] =$[ODLN.Cardcode]

Assign this FMS Query in UDF(TIN No.)

Auto Refresh of Card Code and Check the Display Saved Values,

Do you want to print the TIN No? You can able to retrive the TIN No. in UDF(TIN No.) field.

Check the thread, you will be get some idea or solution.

Regards,

Madhan.

[Former Member]

Hi Madhan,

We managed to get the TIN number of the customer on PLD without FS. We got this through DLN12 table -->taxid11.

Thanks a lot guys.

regards,

Joseph

[former_member325312]

Helo Anthony

select CRD7 as table name and taxidNum11 as colum u will get ur customer TIN NO.and for

company TIN NO ADM1as table name and TaxIdNum6 as ur column name to get ur TIN NOon delivery document. I think this will solve ur problem.if s pls do close the thread

and find this query to find ur TIN NO

SELECT T0.[CardCode], T0.[CardName], T1.[TaxId11] FROM OCRD T0 INNER JOIN CRD7 T1 ON T0.CardCode = T1.CardCode WHERE T0.[CardCode] = T1.[CardCode] and T1.[TaxId11] =[%0] GROUP BY T0.[CardCode], T0.[CardName], T1.[TaxId11]

Regards

Jenny

Edited by: Jennifer Anderson on Nov 30, 2009 12:23 PM

Edited by: Jennifer Anderson on Nov 30, 2009 12:44 PM

Edited by: Jennifer Anderson on Nov 30, 2009 12:51 PM

[Former Member]

Hi Jennifer,

I want to get the TIN number of the customer which we update in BP>Accounting tab>Tax-->TIN No.

If i select the taxid11 from crd7 table, and place this field, the customer name field disappears and also, it does not show the TIN no.

Thanks,

Joseph

[Former Member]

Hi Joseph,

Check the thread,

Regards,

Madhan.

[Former Member]

Hi Madhan Babu,

Thanks but I need to get the TIN Number on the delivery document.

thanks,

Joseph