Tuesday, April 30, 2019

Currency Used in the Revenue Recognition Schedule

There are instances when an account is using Multi-Currency for Customers and it is not evident on what currency is used on the Revenue Recognition Schedule. The ability to expose the Currency field on the Revenue Recognition Schedule is currently not possible.

The transaction (e.g. Sales Order) will use the Customer Record: Primary Currency. However, the GL Impact will use the Subsidiary: Currency. On this note, the Revenue Recognition Schedule will also use the Subsidiary: Currency and not the Customer Record: Primary Currency to ensure that the financial impact offsets each other when the transaction is invoiced.

To illustrate:

  1. Assume that Multi-Currency for Customer is turned on for the account.
  2. Customer: Test_Customer is assigned to Subsidiary: USA where Currency = USD. However, on the Customer Record the Primary Currency = GBP.
  3. Currency Exchange Rate is 1 GBP = 1.25 USD. On the Sales Order, a user selects an Item and assigns Amount = 1000. Note that this is in fact GBP 1000.

NOTE: GL Impact will show 800 which is in USD (since Subsidiary = USA and Currency = USD). When a Revenue Recognition is selected for this Item, then the corresponding Revenue Recognition Schedule will show an amount of 800 which is in USD.

No comments:

Post a Comment