Hi All,
I have an Invoice and Payment in same currency, other than local currency, with different exchange rate.
While applying exch. gain/loss has taken place and “adjust. exch. Rate” also adjusted the entry later.
After the above steps system is still having value in Remaining Amount (LCY) with entry as closed. which should not be the case.
Is it possible to un-apply the entry and re-apply the invoice against the payment.
Kindly advise.
Environment : NAV SP3. / SQL / Singapore database.
The below are the transaction.
| Vendor Ledger Entry | |
|---|---|
| Posting Date | 01-02-2010 |
| Document Date | 01-02-2010 |
| Document Type | Invoice |
| Document No. | PI10-1313 |
| Currency Code | SGD |
| Original Amount | -221.66 |
| Original Amt. (LCY) | -158.77 |
| Adjusted Currency Factor | 1.3968 |
| Original Currency Factor | 1.3961 |
| Amount | -221.66 |
| Amount (LCY) | -157.35 |
| Remaining Amount | 0 |
| Remaining Amt. (LCY) | 1.42 |
| Open | No |
| Entry No. | 535663 |
Detailed Vendor Ledger Entry
| Posting Date | 01-02-2010 | 25-02-2010 | 25-02-2010 | 25-02-2010 | 28-02-2010 |
|---|---|---|---|---|---|
| Entry Type | Initial Entry | Application | Unrealized Gain | Unrealized Gain | Unrealized Gain |
| Document Type | Invoice | Payment | Payment | ||
| Document No. | PI10-1313 | PV10-03-0213 | PV10-03-0213 | Y0910-SGD-R3 | Y1002-SGD |
| Vendor No. | OC0010 | OC0010 | OC0010 | OC0010 | OC0010 |
| Currency Code | SGD | SGD | SGD | SGD | SGD |
| Amount | -221.66 | 221.66 | 0 | 0 | 0 |
| Amount (LCY) | -158.77 | 158.77 | -1.42 | 1.42 | 1.42 |
| Initial Entry Due Date | 40210 | 40210 | 40210 | 40210 | 40210 |
| Source Code | PURCHASES | PAYMENTJNL | PAYMENTJNL | EXCHRATADJ | EXCHRATADJ |
| Unapplied | No | No | No | No | No |
| Vendor Ledger Entry No. | 535663 | 535663 | 535663 | 535663 | 535663 |
| Entry No. | 53765 | 54122 | 54121 | 59619 | 54020 |
| Entry No. | 53765 | 54121 | 59619 | 54020 |