Small and medium business | Business Central, N...

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

(0) Share

Report

Posted on by Jim Neble

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,

All responses (7)

Answers (0)

Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (0)

Report

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 10 on at

Like (0)

Report

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 4,192 Super User 2025 Season 1 on at

Like (0)

Report

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 10 on at

Like (0)

Report

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 10 on at

Like (0)

Report

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 81,798 Super User 2025 Season 1 on at

Like (0)

Report

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.

Hope this helps.

Thanks.

ZHU
DAnny3211 9,276 Moderator on at

Like (0)

Report

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