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

[Former Member]

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.

[Former Member]

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.