I have this scenario with multi book accounting:
Issue:
NetSuite is using a wrong currency exchange rate in the item fulfillment, creating a wrong impact in a secondary accounting book that uses a different currency.
Description:
Subsidiary base currency (Primary book) = CRC
Secondary book currency = USD
- I created a Sales Order with Currency = USD and Currency exchange rate = 532
The Sales Order contains 2 line items but only 1 will be fulfilled. Quantity will be 144 units with an unit cost of CRC 77,589.9325 each:
2. It is correctly calculating GL impact for primary accounting book (although this is a non posting transaction):
a) Total amount in transaction currency (USD) = 144 units x USD 208.01 = USD 29,953.44
b) Exchange rate = 532
c) Amount in CRC = USD 29,953.44 x CRC 532 = CRC 15,935,230.08
That last amount is recorded in the Income account, this is correct:
3. Then I created an Item Fulfillment from this Sales Order:
4. This Item Fulfillment is in Status = Picked, so it is non-posting yet, however this is not relevant. The issue is that, for some reason, when creating the GL Impact, it is totally wrong in secondary book (USD):
Apparently NetSuite is doing the following calculation:
a) Unit cost in base currency is CRC 77,589.9325 each
b) 144 units fulfilled x CRC 77,589.9325 = 11,172,950.28 > This is the effect in the COGS and Inventory Assets account in primary book (CRC), and this is correct.
c) NetSuite apparently is using an exchange rate of CRC 1 per USD to convert amounts for secondary book (USD) so the amounts are the same. This is wrong.
d) It is important to consider also that there is a currency exchange rate already saved for the item fulfillment date:
Request:
I would appreciate any suggestion about what might be causing this behavior.
Thanks in advance to everyone in the Community.