Invoice Amount precision in RA_INTERFACE_LINES_ALL table
One of the Credit Memos in RA_INTERFACE_LINES_ALL table is failing with the error:
The entered amount does not have the correct currency precision.
Below are the values in our interface table for this invoice
RA_INTERFACE_LINES_ALL.Currency_Code = 'USD'
RA_INTERFACE_LINES_ALL.Amount = -72.072
RA_INTERFACE_LINES_ALL.Quantity = -6
RA_INTERFACE_LINES_ALL.Unit_Selling_Price = 12.012
From the note ID 1111566.1 AutoInvoice Error: The Supplied Amount Must Match Unit Selling Price Times The Quantity When You Do Not Use An AutoInvoice Clearing Account.,
i see that when clearing account is not used, the value provided for Amount column shoul match Unit Selling Price Times the Quantity and the precision for Amount value should be same as the precision setup for the currency code.