Payment Accounting Issue – Exchange Rate Not Defined

Issue:

Payment is not getting accounted or payment is not posting to GL.

Analysis:

  • Query the Payment, then navigate to Tools à View Accounting Events à Check the status of Event_Status on accounting event page, its shows as “Error”
  • xla_events table column event_status_code = ‘U’ and process_status_code = ‘I’
  • xla_ae_lines entered_cr is populated but accounted_cr is null, upon observation it looks like exchange rate is missing for xla lines.
  • xla_accounting_errors table shows following error message for concern payment event_id

Error 1:
“There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that:

The source assigned to the accounting attribute Accounted Amount has no value for extract line number 2168033. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute.”

Error 2:
“A conversion rate does not exist to convert GBP to USD for the conversion type Spot and conversion date 16-JAN-17 for line 1. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type.”
Resolution:

Perform Following Steps to resolve the issue

  • Define missing conversion rate for the payment transaction date.
  • Run “AutoRate” concurrent program for concern payment operating unit.
  • Run the Create Accounting process.

 

 

Thanks & Regards,

Yogesh

One thought on “Payment Accounting Issue – Exchange Rate Not Defined

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s