Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

Posted on by 230

Hi,

We hit below message when try to apply and invoice that has a posting date later then the cash receipt journal posting date.

"You are not allowed to apply and post an entry to an entry with an earlier posting date."

 

In previous version, this is not an issues. Current version we are using is NAV2013R2.

 

Any idea to by pass this checking?

 

Thanks in advance

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

    Thank you Amol.

    Hi Jens,

    Thank you for these detailed information.

    I suggest our customer to keep the check and follow NAV STD.

    If he wants to apply in the financial journal, I will remove the message in F00232 Apply Customer Entries.

    Best regards,

    Louis

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

    Hi Louis,

    AFAIR, there was some cleanup in CU12 during the NAV2015 year. Basically, the possibility to specify an explicit application date was removed, and the handling of it in CU12 was also removed, which stremlines the code somewhat.  But this is all only applicable to "late" applications of already applied entries. For your use case, this should have no effect. Removing the check should be sort of safe.

    Possible side effects are on VAT correction on payment forum.mibuso.com/.../265138 and on currency gains/losses (see above).

    with best regards

    Jens

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

    I don't think so we can have that kind of validation as you can receive the payment from customer prior date as an advance also and then you can apply that payment against the invoices.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

    Dear All,

    Since 2014, has someone experienced to remove this check in recent NAV Version ?

    What is the possible issue ?

    Our customer receive payments with a posting date prior of invoice validation date.

    Kind regards,

    Louis

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

    Hi Alex,

    I had a few scenarios where the payment is posted before the invoice - interfaces to other booking systems, for instance. Also, application against prepayment or down payment (as negotiated in the contract) and a few others. As I said above, the check makes only limited sense the way NAV is actually posting. And it wasn't there in older versions of NAV.

    with best regards

    Jens

  • Darren_Chew Profile Picture
    Darren_Chew 230 on at
    RE: NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

    Thanks for the respond.

    We have not encounter this issues it oldest version using the application functions.

    The business flow required to process the payment first and invoice later to knock off the payment made.

    Noted the prepayment function and it is not applicable due to many steps for process the cash receive.

  • Alex Chow Profile Picture
    Alex Chow 4,481 on at
    RE: NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

    Before talking about developing or modifying this, the more fundamental question is why do you have instances where the posted invoice date is later than the cash receipt date?

    Are you addressing prepayments? If so, why not consider enabling the standard prepayment functionality in NAV?

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: NAV2013R2 - You are not allowed to apply and post an entry to an entry with an earlier posting date

    Hi Darren,

    except brute force and a developer license - no. The work around is to first post the invoice, then do an application of invoice and cash receipt in the posted entries.

    The check is there for a reason, although it "only" makes sort of sense in currency scenarios. To be frank, it is a strange thing. You cannot choose an application date which is before the newest date of all entries selected for application. This makes sense in a way, as you should not be able to apply an entry before it has been posted. The realized gain/loss calculation however doesn't care for the date *at all*, it is just the difference between the original currency factor of the applying entry and the applied entry. And, when you analyze the code in CU12, you will find out that the ApplyCust(), ApplyVend() functions always calculate the newest date of the selected entries to apply and take this as their posting date, unless the application date given is newer. So, what you get would (almost) always be the same regardless of the date checking. Apply this to your original problem, then you're right. It should be safe to remove this check. One "strange" thing will happen, though: the realized gains/losses will be on the payment when you post an invoice with application to a previous payment. This is because the applying entry takes the gains/losses in this case. But you would get the same effect with the workaround, so go figure.

    with best regards

    Jens

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans