web
You’re offline. This is a read only version of the page.
close
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.

I have the same question (0)
  • Verified answer
    Bryan Tschosik Profile Picture
    Bryan Tschosik on at

    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

  • elguaje Profile Picture
    elguaje 55 on at

    Hi Bryan,

    Thank you for kind answer!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans