Partial payment in AP/AR-unusual amount for realize gain/los

nasheer

Hi Friends

Navision Version. 3.70

Partial payment in AP and AR caused Aged Account Receivable/Payable report not tally with Customer/Vendor Trial Balance report.

During application, system generates unusual amount for realize currency gain/loss or correction entry.

Example Scenario.

Posted one Invoice with Posting Date 23/08/2006, USD=1952.40, Rate=3.70
Posted one Payment with Posting Date 09/10/2006, USD=1000.00, Rate=3.6785

Goto Vendor Ledger Entries to apply payment
After applying, Realized Gain/Lost account 2 entries in Detailed Ledger Entries
Realized Loss Amount = -7378.50
Correction on Remaining Amount = 14447.76
Document Type = Payment

Vendor Ledger Entries
Invoice line, Remaining Amount (LCY) = 3523.88 [Postive]
Payment line, Amount (LCY) = -3700[Negative]

Appreciate anyone could help us to know the workaround.

Thanks & Regards
Nasheer.