Paym. Disc. together with Dutch Telebank in NAV4SP2/NAV4SP

Iwan_Ubachs

If you use the Dutch telebank module together with payment discount and credit memos, it seems that vendor entries are not applied in the right way.

Step 1: post an invoice and credit memo for the same vendor no.
Invoice : amount 100,- payment discount 3%
Credit memo: amount 50,-

Step2: Create a telebank payment proposal by using ‘Get Proposal entries’.
Use the following setting in the transaction mode :
Combine entries and Pmt. Disc. Possible are both Yes

Navision will propose the amount of 47,-
(This is correct: 100 - 3% -50)

Step3: process the telebank proposal

Step4: Go to Bank/Giro Journal and Insert payment history
Navision will insert a CBG statement line with the correct amount of 47,-

Step5: Post the bank/Giro Journal

Step6: Go the vendor ledger entries.
The Invoice is still open and has a remaining amount of -3,
The Credit memo is still open and has a remaining amount of 3.
The Payment has is closed.
This not correct, the amount of the invoice and credit memo should be zero.

In Navision Financials 2.60 with Dutch telebank this problem does not occur.

Does someone know if there is a hot fix for NAV4 available to solve the
problem?
(I could not find anything at partner source).

tsteeman

Hello Iwan,
Same problem still exists in 5.0
Did you ever get an answer? Did you contact Microsoft?

mvooijs

This problem still exists in NAV2009 R2. I got a bugfix for CU12 from MS which seems to work:

Old code:
========
IF OldCVLedgEntryBuf2.GETFILTER(Positive) <> '' THEN BEGIN
IF OldCVLedgEntryBuf2."Amount to Apply" <> 0 THEN
AppliedAmount := -OldCVLedgEntryBuf2."Amount to Apply"
ELSE
AppliedAmount := -OldCVLedgEntryBuf2."Remaining Amount";
…

New code:
=========
IF OldCVLedgEntryBuf2.GETFILTER(Positive) <> '' THEN BEGIN
IF OldCVLedgEntryBuf2."Amount to Apply" <> 0 THEN
BEGIN
IF (CheckCalcPmtDisc(NewCVLedgEntryBuf,OldCVLedgEntryBuf2,ApplnRoundingPrecision,FALSE,FALSE) AND
(ABS(OldCVLedgEntryBuf2."Amount to Apply") >=
ABS(OldCVLedgEntryBuf2."Remaining Amount" - OldCVLedgEntryBuf2."Remaining Pmt. Disc. Possible")))
THEN
AppliedAmount := -OldCVLedgEntryBuf2."Remaining Amount"
ELSE
AppliedAmount := -OldCVLedgEntryBuf2."Amount to Apply"
END
ELSE
AppliedAmount := -OldCVLedgEntryBuf2."Remaining Amount";
…

weltenss

I have a similar issue, but in the scenario where also the credit memo has a payment discount.

If you use the Dutch telebank module together with payment discount and credit memos, it seems that vendor entries are not applied in the right way.

Step 1: post an invoice and credit memo for the same vendor no.
Invoice : amount 1000,- payment discount 2%
Credit memo: amount 10,- payment discount 2%

Step2: Create a telebank payment proposal by using ‘Get Proposal entries’.
Use the following setting in the transaction mode :
Combine entries and Pmt. Disc. Possible are both Yes

Navision will propose the amount of 970,2
(This is correct: 1000 (invoice) -10 (credit memo) - 20 (discount on invoice) + 0,2 (discount on credit memo)

Step3: process the telebank proposal

Step4: Go to Bank/Giro Journal and Insert payment history
Navision will insert a CBG statement line with the correct amount of 970,2

Step5: Post the bank/Giro Journal

Step6: Go the vendor ledger entries.
The Invoice is closed
The Credit memo is still open and has a remaining amount of -0,2
The Payment is still open and has a remaining amount of 0.2
This not correct, the amount of the payment and credit memo should be zero.

In Navision Financials 2009R2 Dutch telebank this problem occurs.

Does someone know if there is a hot fix available to solve the
problem?
(I could not find anything at partner source).