BI Publisher (MOSC)

MOSC Banner

Calculating total line tax amount on AR invoice

edited Jun 5, 2020 4:08PM in BI Publisher (MOSC) 5 commentsAnswered

Hi,

I am trying to calculate the total tax amount per invoice line. But only the amount on line #1 is calculating. Any help is appreciated.

I am grouping per G_LINES with a condition on line_type (line), if there is a <LIST_G_TAX_RATE> <G_TAX_RATE>LINE_TAX_RATE1 exists, calculate the tax amount as below.

But, only first <LIST_G_TAX_RATE> <G_TAX_RATE>LINE_TAX_RATE1 is calculated.... not the sum of all 3 tax_rate lines

<?if:not(.//G_TAX_RATE/LINE_TAX_RATE1)?><?format-number(sum(LIST_G_TAX_RATE/G_TAX_RATE/LINE_TAX_RATE1 div 100 * LINE_EXTENDED_AMOUNT),'0.00')?><?end if?>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center