How to prorate Freight across taxable/non-taxable Items, prorate Tax on taxable items and Freight
Oracle EBS version 12.1.3 -> Payables
We are trying to process an invoice through Payables Open Invoice Import Interface (APXIIMPT) with this scenario: prorate Freight across taxable and non-taxable Item lines and prorate Tax on taxable Item lines and Freight line only.
Example:
We tried importing the invoice with the above line_group_number and prorate_across_flag values but it did not allocate Freight across all items.
Does anyone encountered this scenario? If so, please share what was the solution for this scenario.