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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,846

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,157

#3
Sumit Singh Profile Picture

Sumit Singh 2,903

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans