cancel
Showing results for 
Search instead for 
Did you mean: 

how to calculate vat12.5 tax amount in PLD ???

vinayak_chavan
Participant
0 Kudos

HOW TO CALCULATE TAX AMOUNT

VAT12.5 % IN PLD??

THANKING YOU

VINAYAK

Accepted Solutions (1)

Accepted Solutions (1)

former_member218051
Active Contributor
0 Kudos

Hi Vinayak,

system stores vat amount ia a column VATSUM.

why don't u use that column in your PLD and sum on that column ?

Otherwise do as manavendra and gordon has suggested you.

Thanking you

Malhaar

vinayak_chavan
Participant
0 Kudos

could you plese explain in detail

table name----?

Former Member
0 Kudos

Hi Vinayak,

Declare @TaxAmt Decimal(16,3)
Set @TaxAmt  = ( SELECT  Sum(T0.[TaxSum])  FROM PCH4 T0 Where Docentry = (Select Docentry from OPCH 
Where DocNum = $[OPCH.DocNum] and Series = $[OPCH.Series] ) and statype = -90 )
Select  @TaxAmt

For Tax break up in PLD best way to go through UDF. Create UDF at Title level & get the tax break up.

This would give you tax break up for BED. Change the statype for other tax types & change table for other document.

You can only get the tax break up in UDF after adding document,because when you add document then only the values will go to PCH4 & same like other table.

Thanks,

Srujal Patel

vinayak_chavan
Participant
0 Kudos

ok so according to you , by using saved query on UDF I get the tax break up...

vinayak_chavan
Participant
0 Kudos

DEAR,

Srujal Patel

i have create UDF and use those query and refresh regulerly on docnum but its not working.

could you plese tell me how to use that query on sale order

Former Member
0 Kudos

Ok Try This...

SELECT SUM(pch4.TaxSum) AS Expr1
FROM OPCH INNER JOIN
pch4 ON OPCH.DocEntry = PCH4.DocEntry where PCH4.Statype=-90 AND OPCH.DocNum=$[OPCH.DocNum]

Thanks,

Srujal Patel

vinayak_chavan
Participant
0 Kudos

DEAR,

Srujal Patel

i have try your query on sale order and add the document but still its showing '0 ' in udf.

kindly help.

Former Member
0 Kudos

Hi Vinayak,

Please try the following;

Tax Break Up In PLD for Sales Order

Run the query Select * from OSTT to get the numerator of the tax types.

For ex. BED -90, VAT 1 etc etc.

In th pld, add a repetitive area. In repetitive area1 do the following;

A. Create Database field> RDR4>TaxSum

B. Create Database Field>RDR4>Statype

C. Create Database Field RDR4 Tax Rate

D. Create formula Field--> B = = -90 (This is for BED)

E. Create Formula field -> D*A

F. Create formula Field--> D*C

In Repetitive Footer1, do the following;

G. Create a formula field-->Colsum(E)

H. Create formula fields--> Colsum (F)

Repeat steps C,D, E and F for the tax types required. Make these repetitive areas invisible.

On End of report,

Make a formula field> in the field editor>E To get Tax Amount

Make a formula field> in the field editor>F To get Tax Rate

Thanks,

Joseph

Former Member
0 Kudos

Dear Vinayak,

SELECT SUM(RDR4.TaxSum) AS Expr1
FROM ORDR INNER JOIN
RDR4 ON ORDR.DocEntry = RDR4.DocEntry where RDR4.Statype=-90 AND ORDR.DocNum=$[ORDR.DocNum]

Just change the Statype as per your DB. For Statype Run Query

SELECT distinct T0.[staType], T0.[StcCode], T0.[StaCode] FROM RDR4 T0

Here Name call as Authority Type.

This Query show you result for BED

Thanks,

Srujal Patel

vinayak_chavan
Participant
0 Kudos

THANKS

MR.SRUJAL PATEL

ITS WORKING BUT I HAVE TO CREATE 9 UDF FOR EACH TAX VALUE.

AND SAME I WANT IN AR INVOICE

PLESE ADVICE FOR AR INVOICE ALSO.

Former Member
0 Kudos

Dear Vinayak,

For Purchase Order -- OPOR & POR4

For GRPO -- OPDN & PDN4

For A/P Invoice -- OPCH & PCH4

For Sales Order -- ORDR & RDR4

For Delivery -- ODLN & DLN4

For A/R Invoice -- OINV & INV4

Change Table Name in above query as per your requirement.

Thanks,

Srujal Patel

vinayak_chavan
Participant
0 Kudos

Dear srujal,

according to you this way is proper way to calculate???

Former Member
0 Kudos

Dear Vinayak Cha,

This way is proper if you want to create PLD other than if you want to create Crystal Report then no need to create 9 UDF.

Thanks,

Srujal Patel

Former Member
0 Kudos

Hi Vinayak,

I have shown you the example to create tax break up in pld without creating udf's and Srujal has given you the fms to capture the tax values and you can use these udf's in the pld.

Both are proper, its upto you to decide whether you want to create in pld or you want to use udf and fms to achieve tax amounts!

Hope this clears your doubts.

Thanks,

Joseph

Answers (3)

Answers (3)

vinayak_chavan
Participant
0 Kudos

Thankas tsrujal

thanks joseph

Regards,

vinayak

Former Member
0 Kudos

Hello Friend,

if You want to achieve then you should go for Tax breakup in PLD otherwise better option is made a UDF in header level and save in that UDF then you can easly select that udf in PLD.

At my end suggestion ,if you are working on Marketing document printout then you must go for Crystal report which have better option compare with PLD and QPLD.

Thanks

Manvendra Singh Niranjan

Former Member
0 Kudos

Hi,

PLD is a very simple tool. Why not calculate vat12.5 tax amount in a document first but in the report only?

Thanks,

Gordon