Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / how to apply Item Ledg...
Small and medium business | Business Central, N...
Answered

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

(0) ShareShare
ReportReport
Posted on by elguaje 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
    Bryan Tschosik Profile Picture
    Bryan Tschosik on at
    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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans