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

Iwan_Ubachs
Iwan_Ubachs Member Posts: 19
edited 2014-11-03 in NAV/Navision Classic Client
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).

Comments

  • tsteeman
    tsteeman Member Posts: 2
    Hello Iwan,
    Same problem still exists in 5.0
    Did you ever get an answer? Did you contact Microsoft?
  • mvooijs
    mvooijs Member Posts: 4
    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";
    …
    Martin Vooijs

    Indigo Solutions B.V.
    http://www.indigosolutions.nl
  • weltenss
    weltenss Member Posts: 1
    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).

Categories