How To Fix VAL351 - Transaction exchange rate is being used instead of book exchange rate

SAP Error Message - Details

• Message type: E = Error

• Message class: VAL - Treasury: Messages for General Valuation

• Message number: 351

• Message text: Transaction exchange rate is being used instead of book exchange rate

What causes this issue?

The valuation step requires the foreign exchange book rate on the
valuation key date for calculating the margin accrual in the valuation
currency. The system calculates the foreign exchange book rate from the
book values in position currency and valuation currency.
However, for this position the system could not determine the foreign
exchange book rate because at least one of the book values is 0 or the
book values have different plus/minus signs.

System Response

Instead of the foreign exchange book value, the system uses the
exchange rate that results from the spot amounts of the transaction.

How to fix this error?

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message VAL351 - Transaction exchange rate is being used instead of book exchange rate ?

  The SAP error message VAL351 indicates that the system is using the transaction exchange rate instead of the book exchange rate for a particular valuation. This typically occurs in the context of asset accounting or when dealing with foreign currency transactions.
  Cause:
  The error can arise due to several reasons:
  
  Currency Settings: The system is configured to use the transaction exchange rate for certain transactions instead of the book exchange rate.
  Valuation Method: The valuation method set for the asset or transaction may be configured to use the transaction exchange rate.
  Missing Configuration: There may be missing or incorrect configuration in the currency settings for the company code or the asset class.
  Transaction Type: The transaction type being used may not be set up to allow the use of the book exchange rate.
  
  Solution:
  To resolve the VAL351 error, you can take the following steps:
  
  
  Check Configuration:
  
  Go to the configuration settings for your company code and asset class in the SAP system.
  Ensure that the settings for currency types are correctly configured to allow the use of the book exchange rate.
  
  
  
  Review Valuation Method:
  
  Check the valuation method assigned to the asset. Ensure that it is set to use the book exchange rate if that is the desired behavior.
  
  
  
  Transaction Type Settings:
  
  Review the transaction type settings in the Asset Accounting (FI-AA) module. Ensure that the transaction type allows for the use of the book exchange rate.
  
  
  
  Currency Translation:
  
  If you are dealing with foreign currency transactions, ensure that the currency translation settings are correctly configured. This includes checking the exchange rate types and ensuring that the book exchange rate is maintained in the system.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for specific guidance on configuring exchange rates and valuation methods.
  
  
  
  Testing:
  
  After making changes, perform a test transaction to ensure that the error is resolved and that the system is now using the book exchange rate as intended.
  
  
  
  Related Information:
  
  Transaction Codes: You may need to use transaction codes such as OAYZ (for asset accounting configuration) or OX15 (for company code settings) to access the relevant configuration areas.
  Exchange Rate Types: Familiarize yourself with the different exchange rate types in SAP (e.g., M for average rate, B for bank buying rate) and how they are used in transactions.
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to this error message.
  
  If the issue persists after following these steps, it may be beneficial to consult with your SAP support team or a functional consultant who specializes in Asset Accounting.