I'm hoping you can help us understand/confirm Netsuite Advanced Revenue Management behavior, and also help us find a solution to our issue.
- We created an invoice 123 with a base currency of 3187.50 CAD.
- The Revenue Arrangement created for that invoice was for 3187.50 CAD
- When the invoice was linked to a project, we did not realize the primary currency was USD for the project. So it updated the invoice currency to USD as well.
- The original RAR did not update the currency and the user did not delete the RAR for that invoice so that resulted in an invoice for 3187.50 USD and a related RAR for 3187.50 CAD.
- Later on, the user decided to Credit back the invoice since it was in the wrong currency. They created a Credit Memo for INV 123, which resulted in a RAR -3187.50 USD.
- The problem is that we needed that to be in CAD to cancel out the RAR for INV 123. So now we are stuck in how to correct this since these transactions are all in closed periods.
Question #1: Is Netsuite supposed to update the current Revenue Arrangement currency if it has been changed on the invoice?
Question #2: The invoice RAR is debiting 3187.50 CAD, whilst the Credit Memo RAR is crediting 4008.04 CAD. How would we resolve this for a closed period? Do we need to create a journal to account for the difference?
?