Dear Community,
Recently, we began managing our company's Sales Orders within our Netsuite account. However, we have encountered a specific challenge regarding the exchange rate between our accounting books: the primary book (Local currency) and the Secondary book (US Dollar).
Our primary objectives are twofold:
- Align the Exchange rate of the Sales Order with that of the invoice. Currently, we only create one invoice per Sales Order, but there are instances where the exchange rates differ. The reasons for this disparity include:
- Sales Orders are dated in the future, and when the invoice is sent on a later date, the Sales Order's date remains unchanged, causing it to be stuck with the date of its creation.
- In cases where invoices are created before 6 AM EST, the currency exchange rates in our system are updated after this time. So, when we synchronize the Sales Order date with the related Invoice, the Sales Order's exchange rate reflects the current date while the invoice retains the previous day's exchange rate.
- We create most orders in advance, and the Sales orders' dates are set with their future delivery dates. In that case, the exchange rate will remain the same as it was at the creation date. What we would like to achieve is that future orders will hold the most updated exchange rate between the books and keep updating it every day. We tried to create all Sales Orders with the current date and roll the date over every day, but it was too many orders, and the process took more than 12 hours.
Our primary motivation for achieving these objectives is to ensure the Revenue Recognition forecast report accurately reflects the correct exchange rate, as ARM considers the exchange rate used in the source transaction, which is the Sales Order.
If any of you have faced similar challenges or encountered comparable scenarios, we would greatly appreciate your advice and ideas on addressing these issues.
Thank you for your support.
Nir