Thursday, 19 January 2017

Oracle Payable - Period Close Exceptional Report Error :The entered amount and accounted amount for line 10 are not on the same side.

Period Close Exceptional Report Error :The entered amount and accounted amount for line 10 are not on the same side.



Payable  

Period Close Exceptional Report - Invoice  - Create Accounting Issues 
Line
Error Number
Error Message
xx
95314
The entered amount and accounted amount for line 10 are not on the same side.

Please inform your system administrator or support representative that: The source assigned to the accounting attribute entered amount is not consistent with the source assigned to the accounting attribute accounted amount or the supplied conversion rate is invalid.
xx
953Invoice  - Create Accounting Issues 14
The entered amount and accounted amount for line 11 are not on the same side.

Please inform your system administrator or support representative that: The source assigned to the accounting attribute entered amount is not consistent with the source assigned to the accounting attribute accounted amount or the supplied conversion rate is invalid.


Solution :

Update : Query

UPDATE ap_invoice_distributions_all
SET description = description||'_'||invoice_line_number||'_'||
distribution_line_number
WHERE invoice_distribution_id IN (
SELECT invoice_distribution_id
FROM ap_invoice_distributions_all
WHERE invoice_id = 939098)

Commit

And Run the Create accounting against the Invoice or Concurrent.