Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Application worksheet ...
Small and medium business | Business Central, N...
Suggested answer

Application worksheet - open entries not showing up in "unapplied entries"

(0) ShareShare
ReportReport
Posted on by Jim Neble 10

Hi all,

I have an issue where a customer has made several sales shipments and purchase receipts incorrectly and then undone them afterwards.

Now the entries are applied to each other pretty randomly and when I go to the application worksheet and remove the applications and try to reapply them I hit an issue. The entries that I have reopened are not showing under "Unapplied entries" for the other entries. Thus I cannot apply the right entries to each other.

I have noticed that the customer has had a negative inventory early in this process and their inventory setup allows this. I have a suspecion that this is causing the issue. I have adviced them to not allow this, but I still need to fix the current issue.

Does anyone have a solution, or will I have to fix the costing in the Revaluation Journal?

/Thanks,

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Application worksheet - open entries not showing up in "unapplied entries"

    You can not manually apply item ledger entries. That can only be done for vendor ledger entries and customer ledger entries.

    It is the posting routines in BC that apply item ledger entries according to the costing method for the items and the transaction sequenze.

  • Jim Neble Profile Picture
    Jim Neble 10 on at
    RE: Application worksheet - open entries not showing up in "unapplied entries"

    Hi KasparsSemjonovs - No that is not the case here. Setup is very simple.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    RE: Application worksheet - open entries not showing up in "unapplied entries"

    Could it be that those items have Lot No. or Serial No. assigned, and values used are different for entries?

  • Jim Neble Profile Picture
    Jim Neble 10 on at
    RE: Application worksheet - open entries not showing up in "unapplied entries"

    ZHU - Thanks for responding. I see the setting and why you would recommend it. I do believe that applies from item entry no. is filled automatically if using the "Undo reciept"-function from a posten purchase reciept (Which the customer does if applicable).

    However, the issue I am currently facing is that if any item has a negative inventory and any amount is then received in error. Then the error cannot be correctly because the item entries are already applied to the entries that caused negative inventory. And I don't see a way to fix this in the application worksheet as you cannot choose the entries to apply with freely when there has been a negative inventory.

    Do you have any way to solve this?

    /Jim

  • Jim Neble Profile Picture
    Jim Neble 10 on at
    RE: Application worksheet - open entries not showing up in "unapplied entries"

    Hi Daniele,

    Thanks for the response. However, I don't see any explanation as to why reopenen entries should not show up in unapplied entries to apply with.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: Application worksheet - open entries not showing up in "unapplied entries"

    Hi, For existing entries, you can refer to Daniele's link.

    For the future, I recommend that you try the following settings.

    pastedimage1671582339323v1.png

    Hope this helps.

    Thanks.

    ZHU

  • DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Application worksheet - open entries not showing up in "unapplied entries"

    hi

    look this

    learn.microsoft.com/.../finance-how-to-remove-and-reapply-item-entries

    DAniele

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans