Skip to Content
author's profile photo Former Member
Former Member

Grouping of tax according to item level.

Hi,

Can any body help me how to group the items in row level and get the summary of Tax in PLD's

Regards,

Ruheena Tasneem

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 09:21 AM

    Check these SAP Notes

    SAP Note: 633285 Printing the total Vat amounts in each Vat group

    [https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E¬e_numm=633285]

    SAP Note:917674 Tax Summary per Tax Groups on Marketing Documents

    [https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E¬e_numm=917674]

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 09:16 AM

    Hi Ruheena,

    Suppose you want the total Amount for the document in A/R Invoice

    attach this query as a formatted search

    "

    SELECT sum(taxsum), t0.docnum as "Doc Num" FROM OINV T0, INV4 T1 
    
    WHERE T0.Docentry = T1.Docentry 
    
    and T1.stacode = 'vat4'
    
    and t0.docnum =$[OINV.DocNum] 
    
    group by t0.docnum

    Like wise you can have different UDF for each tax code and you can

    create respective query by changing T1.stacode in WHERE condition.

    Using this you can have separate value for VAT 4,VAT 1,VAT 12.5,VAT 2.5

    and like wise BED 16,ECess 2,HECess 1

    You need to create UDF for each Tax code

    and you are required to write Query for each tax code.

    Hope above is op help to you.

    BR

    Samir Gandhi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.