Alter System Currency Value

[Former Member]

Dear all,

Is it possible to extract the exchange rate from a user-defined field in the row details of an invoice document to compute for the system currency value of the invoice journal entries, instead of using the rate maintained in the Exchange Rates and Indexes table? Please refer to the desired journal entries below.

To Illustrate:

Exchange Rate Maintained in SAP B1 Table = 44.20

Basic Initialization Settings:

Local Currency = PHP

System Currency = USD

Exchange Rate Maintained in User-defined Field (INV1) = 44.00

Invoice Details:

Transaction Currency = Local Currency (PHP)

BP Currency = Multicurrency

Doc Total = PHP 30,000

Journal Entries Posted from AR Invoice:

Debit Debit (System Currency)

BP Control Account PHP 30000 678.73 (PHP 30000/ 44.20)

_Desired Journal Entries to be Posted from AR Invoice:_

Debit Debit (System Currency)

BP Control Account PHP 30000 681.82 (PHP 30000 /44 )

Your feedback shall be very much appreciated.

Thank you,

Dona

[Former Member]

It may be possible to achieve this using a crystal report to recalculate the vaues. My question though is why is this necessary?