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.
Hi Bryan,
Thank you for kind answer!
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156