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

amphysvena
amphysvena Member Posts: 113
edited 2011-12-02 in NAV/Navision Classic Client
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

Comments

  • markborges
    markborges Member Posts: 170
    Hello amphysvena,

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

    Maybe they will tell you something.

    regards,
    Marcelo Borges
    D365 Business Central Solutions Architect
    BC AL/NAV C/AL Developer
    BC Repositories.com
  • amphysvena
    amphysvena Member Posts: 113
    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
    amphysvena Member Posts: 113
    Its been almost 3 weeks, and we still cannot figure the solutions. ](*,)
    Anybody can help?

    Thanks
  • jglathe
    jglathe Member Posts: 639
    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
    David_Singleton Member Posts: 5,479
    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.
    David Singleton

Categories