Hello,
When we update Revenue Arrangements and Plan, we are getting this error on our Bulk Processing Page for Processed Revenue Arrangements.
The arrangement currency must match the currency of the lines.
Great! But it doesn't tell us which transaction this is related to, so we don't know where to fix the error! I found this SuiteAnswer below, but it looks like we need to create a report that shows currency discrepancies between the Sales Order and Revenue Arrangement. Does this report already exist, or can you help me understand how to build the search to find this error? Thank you!
NetSuite SuiteAnswer
Scenario
User has a source transaction (i.e. Sales Order) wherein the Currency was changed from JPY to USD via UI. User deleted the prior Revenue Arrangement, however, when the new Revenue Arrangement was generated it is still using JPY instead of USD (Sales Order's updated currency
Solution
The Currency of the Revenue Arrangement is dependent on the Currency of the Revenue Element. Revenue Element is not deleted when the Revenue Arrangement was deleted.
Per SuiteAnswers Article 50310 | Deleting Revenue Elements, Revenue Elements that are still linked to a source document cannot be deleted. Thus, the newly generated Revenue Arrangement is still referring and pulling the old currency of the line items on Sales Order.
To also update the currency on Revenue Arrangement, follow the steps below:
1. Edit the Sales Order or any applicable source transaction
2. Click Make Copy on the affected line item on the Sales Order
3. Click Remove on the original line item
4. Click Save
5. Navigate to Transactions > Financial > Update Revenue Arrangements and Plans
6. Click Update Revenue Arrangement
Note: A new Revenue Arrangement should be generated on the source transaction with the updated Currency.