SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How can we achieve the tax calculation separately of each line item?

Former Member

‎2010 Feb 04 4:18 AM

0 Kudos
174

Hi,

As per my understanding the tax is calculated on Subtotal of the line items with similar tax code during invoicing.

For example:

Print Doc Line Co Line Item Posting Tax Tax Tax Total

Item Code Type Relevant Rate Base Amt Amt

602000000 2 5100 ZRAEL1 X 0,00 0,00 0,00

602000000 4 5100 ZRSSTG X 0,00 0,00 0,00

602000000 5 5100 MWS SUBT X 5,000 20,16 1,01 21,17

602000000 2 5100 ZRAEL1 X 0,00 0,00 0,00

602000000 4 5100 ZRSSTG X 0,00 0,00 0,00

602000000 5 5100 MWS SUBT X 15,000 100,00 15,00 115,00

Now I am struggling to figure out is there a way to calculate the tax for each line item separately as shown below.

Print Doc Line Co Line Item Posting Tax Tax Tax Total

Item Code Type Relevant Rate Base Amt Amt

602000000 2 5100 MWS ZRAEL1 X 5,000 10,00 0,50 5,50

602000000 4 5100 MWS ZRSSTG X 5,000 10,00 0,50 5,50

602000000 2 5100 MWS ZRAEL1 X 10,000 50,00 5,00 55,00

602000000 4 5100 MWS ZRSSTG X 10,000 50,00 5,00 55,00

Please let me provide your input / experience and opinion whether it is possible.

Thanks,

YL

PS: Copy and paste the query in word for clear table view.

1 REPLY 1

Former Member

‎2010 Feb 15 8:02 AM

0 Kudos
122

I looked at u2018Sorting for Bill Printoutu2019 settings and by changing the settings to sort by date instead of by contract, the SUBT lines are no longer grouped and we now get multiple lines.