How to get Unrounded tax amount in Order Management

Dear All

We are getting our sales invoice report from AR but due to some reasons we want to take this report from OM side. One issue we are facing is that we have to show and include calculations of taxes in our report. But there is some difference in amount due to rounded figure of taxes.

For example: In our previous report which is taking data from AR side, we are getting data of taxes from ZX_LINES_V using CUSTOMER_TRX_LINE_ID of invoice matching with TRX_LINE_ID in ZX_LINES_V. In ZX_LINES_V we are taking value of column UNROUNDED_TAX_AMT which is in one case 32.170722. For another order with same attributes. prices, and items we are getting value of tax 32.17 from column ADJUSTED_AMOUNT in OE_PRICE_ADJUSTMENTS table. Since there is no record of taxes in ZX_LINES_V therefore we cannot take tax amounts against sales order from ZX_LINES_V.