Tax information not printing in PLD

[Former Member]

Dear all,

I want to print Customer tax information and Excise information (Like TIN No,CST No,VAT No, and ECC.No) in A/R invoice but it is not printing . Can anyone help on this. (I dont want to creat udf and FMS).

thank you

sridharan.r

[Former Member]

Dear all,

Thank you for your support. I created udf and I have done FMS. its came. (but i dont know why we need to create udf and fms even data is already in master).

Thank you

regards

sridharan.r

[former_member196081]

Hi,

Did you use INV 12 table ?

Are you printing company TIN No,PAN No..etc on same PLD.If yes then take them static and pick customer information from INV12 table.

Regards

Deepak Tyagi

[Former Member]

Dear deepak,

Thank u, It is coming(TIN,CST ,VAT). but the same time i want to print excise information(ECC No, C.E range) of the customer.

thanks

sridharan.r

Edited by: Sridharan.R on May 19, 2011 9:28 AM

[former_member196081]

Hi Sri,

as per me it is possible through udf and fms or you should use crystal report for this.....

Lets see other expert views...

Regards

Deepak Tyagi

[Former Member]

dear deepak,

is it possible in PLD?

thank u

sridharan

[Former Member]

Hi

Edited by: Lakshman Rao Pilaka on May 19, 2011 10:57 AM

[former_member206437]

Open your PLD. Create a Database field and Select that database field, Alt+Click the Table in Properties Field Window.

TIN No.

Select Table -> INV12 - Tax Extension.

Select Column -> Tax id 11.

CST No.

Select Table -> INV12 - Tax Extension.

Select Column -> Tax id 1.

but ECC No. can not able to retrive in PLD so Create 1 UDF and assign FMS in UDF.

Create UDF(ECC No.) and assign this FMS Query.

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

Assign this FMS Query in UDF(ECC No.)

Auto Refresh of Card Code and Check the Display Saved Values

Or

Has Deepak said you can go for Crystal Reports which is Flexible.

Giridharan V

Edited by: Giri dharan on May 19, 2011 2:32 PM

[former_member206488]

Hi Sri,

It is possible in PLD, best way is create UDF on Invoice header, apply formatted serach to get ECC no in UDF.

SELECT  Max(T0.[ECCNo]) FROM CRD7 T0 WHERE T0.[CardCode] =$[OINV.Cardcode]

Select UDF on PLD.

Thanks,

Neetu