Remaining Amt already 0,but remaining (LCY) still has amount

amphysvena

Hi,
We're using NAV 2009. In the vendor ledger entry, we have some entries that the remaining amount is already 0, but the remaining amount (LCY) still has some amounts.
Example:
Document Type = Invoice
Document No. = A001
Currency Code = USD
Amount = -600
Amount(LCY) = -5.385.000,00
Remaining Amount = 0
Remaining Amt (LCY) = 7.800
Open = NO

Note : we do adjust exchange rate every end of month. Our LCY is in IDR

The question is, how come the remaining LCY still has amount, while the remaining amt already zero? And why the "open" field is already FALSE, while there still amount in remaining amount.

Thanks

markborges

Hello amphysvena,

Did you analize the "Detailed Customer Ledger Entries" for this situation?

Maybe they will tell you something.

regards,

amphysvena

Hi,
I believe what you mean is Detailed Vendor Ledger Entries. I've check it, but I'm not sure what is wrong with the entries.
If I sort the entries by entry no., it will look like this :
- Initial Entry
- Few entries from adjust exchange rate (Unrealized gain)
- An entry with realized loss
- An application entry (this the entry that close the initial entry)
- an entry with Unrealized Gain
- An entry Unrealized loss from adjust exchange rate.

Thanks

amphysvena

Its been almost 3 weeks, and we still cannot figure the solutions. ](*,)
Anybody can help?

Thanks

jglathe

Hi amphysvena,

just guessing... usually the applying functions in CU12 ensure that when remaining amount is 0, remaining amount (LCY) must be 0 as well, by posting a realized gain/loss/rounding/correction of remaining amount. However, unlike the G/L entries, there is no consistency check at the end of the posting, so this *can* go wrong. Does the W1 version have a bug resulting in this? Unlikely. Is your CU12 modified? Does it have changes in the applying functions?

with best regards

Jens

David_Singleton

Since there is a 10,000:1 currency rate, I would say the issue relates to rounding. Probably bug in the currency adjustment routine. What rounding do you have set on both those currencies, your use of ,00 is inconstant in your example, so I assume you typed that manually.