unapply vendor ledger entries problem (multi-currency)

davmac1

NAV 2009SP1 RTC (same behavior in Classic as well).
Error:
Before you can unapply this entry, you must first unapply all application entries in Vendor Ledger Entry that were posted after this entry.

This has come up before, but I have not seen it in conjuction with multicurrency and exchange rates.
It passes the first check in codeunit 227 fine, but fails the last because there are gain/loss entries win the detailed vendor ledger with higher transaction no.s.
The user wants to unapply a partial application because it was made in the wrong month, then reverse the original transaction (a credit memo), then post an offsetting invoice and apply it to the bad credit memo, then re-appy the invoice to a correctly dated credit memo.

The best solution I have come up after going through the code, is you made a mistake, journalize it with correcting entries.
Does anyone know a better way (without a significant code change)?

jglathe

Hi David,

davmac1 wrote:

NAV 2009SP1 RTC (same behavior in Classic as well).
Error:
Before you can unapply this entry, you must first unapply all application entries in Vendor Ledger Entry that were posted after this entry.

This has come up before, but I have not seen it in conjuction with multicurrency and exchange rates.
It passes the first check in codeunit 227 fine, but fails the last because there are gain/loss entries win the detailed vendor ledger with higher transaction no.s.

the reason for this strong check is that if you unapply an earlier partial application, and it is in currency, you would not undo any later adjustments resulting from later partial applications, or just an "Adjust Exchange Rates" batch. Because the remaining amount of the entries would be different after the unapply, the adjustments would be wrong. But that's all IMO. Re-running the "Adjust Exchange Rates" batch after the unapply should resolve this.
So, my suggestion would be to comment out the strong checks (Text012, Text015) in CU 227. Maybe these should only be messages... The UnapplyVendLedgEntry() function in CU 12 already does the right thing on unapplying. After the unapply transaction, run the "Adjust Exchange Rates" batch again. I would do it after the re-apply, though.

with best regards

Jens

davmac1

Thanks,
I tried it out in a copy of their live database, and will let them see if they like the results before moving it into live.

Dave