Scenario:
The user is investigating an issue involving two journals—Journal 001 and Journal 002—in which Journal 002 appears to void Journal 001. However, the application behavior and resulting balances are inconsistent and not fully understood by the user.
Upon reviewing Journal 001, the user observed that it reflects a total amount of $22,850.00 US Dollars. When checking the Related Records tab, it is shown that Journal 002 is applied to Journal 001. However, Journal 002 is denominated in 89,120.00 Pesos, which, based on the exchange rate at the time (18.55), converts to approximately $4,804.32 US Dollars.
This situation leads to a discrepancy: Journal 001 still shows an open balance of $18,045.68 US Dollars, while Journal 002 appears to be fully applied. As a result, the user is unable to apply additional transactions to clear the remaining balance on Journal 001. This raises the question of why Journal 002 was only partially applied, even though it was intended to fully void the original journal.
Solution / Explanation:
The user identified that Journal 002 had already been applied to a separate transaction—Invoice 001. This invoice had a balance of $18,045.68 US Dollars, which was fully paid using Journal 002.
After the invoice was settled, only the remaining balance of $89,120.00 Pesos—converted to approximately $4,804.32 US Dollars—was available for application. This leftover amount was then applied to Journal 001.
Since the majority of Journal 002’s funds were allocated to Invoice 001, only the remaining converted amount was available to apply toward Journal 001. Therefore, Journal 001 ended up partially applied, with a remaining open balance of $18,045.68 US Dollars, and Journal 002 was fully used.
It is important to note that no system error occurred. This behavior is in line with how NetSuite handles multi-currency applications, prioritizing the application of funds based on availability. The partial application resulted from the prior allocation of Journal 002’s funds to another transaction.
To resolve the remaining balance on Journal 001, the user will need to identify or create a transaction or journal in US Dollars with sufficient available funds to cover the outstanding amount.
When working with multi-currency journal entries, especially in scenarios involving voids or adjustments, the user should follow these best practices:
- Confirm all prior applications of journals to understand how amounts have been allocated.
- Monitor available balances in the base and foreign currencies before applying journals across multiple records.
- Use the audit trail and Related Records tabs to trace allocation history and detect potential mismatches.
- If necessary, create adjustment journals or review and correct exchange rate configurations to ensure accurate conversions.
Hope this helped!