Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

how to apply Item Ledger Entry by Application Workshet (Entry never applied before)

Posted on by 55

Hello experts,

I am new user of NAV 2018 from NAV 2009.

I see that I am not able to apply Item Ledger Entry by Application worksheet - if the entries wasn't applied before.

So, If I have to entries (ex: remaining + 5 Item, and one more is remaning -5 Item, and haven't been applied), then I can not apply to close them.

I am thinking about posting other positive & negative adjustment to close them, but if I can use application worksheet, it is more convenience.

Could you please tell me any tip in this case?

Thank you.

  • elguaje Profile Picture
    elguaje 55 on at
    RE: how to apply Item Ledger Entry by Application Workshet (Entry never applied before)

    Hi Bryan,

    Thank you for kind answer!

  • Verified answer
    RE: how to apply Item Ledger Entry by Application Workshet (Entry never applied before)

    Hi Elguaje,

    Thank you for posting your question.

    The Application Worksheet is limited in what you can and cannot apply.   Sometimes it will abide by posting rules...such as you can apply a Sale to a Credit Memo where the Credit Memo was using Exact Cost Reversing, as this will cause a circular application...and get you into a loop.  There are other scenarios also....for example you will not be able to apply an outbound from one location to an inbound from another....here we have another Posting Rule example.  

    If the entries are not applied at this point in time, then either you have something similar to the above, or there is some other unknown, such as data corruption from previous, what I would call back-end (through sql or Object Designer) data manipulation where other tables that work hand in hand was not accounted for when applying....or some code modification that caused the issue.... In years past, I've mostly seen the first.

    With that all said, you probably just then need to post a positive and negative adjustment...but do not use the 'Applies-from Entry' field on the positive...just let NAV's posting routine apply as it should.

    Also, I would highly recommend you have a copy of the live company data in a Test database/company and try it there first...to verify your expected/desired results.

    Thank you.

    Bryan

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans