Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kris Ruyeras]

Hello All,

Hopefully someone can guide me. I’m no super expert when it comes to the inner workings of adjust cost. We’re running NAV 2009 SP1, when someone runs the “Adjust Cost – Item Entries”, they get stopped or get an error for “There is no Item Application Entry within the filter”, then referencing a specific Item Ledger Entry.

I’m not sure what steps to take to correct this issue. There was a transfer on their IN TRANSIT location for -432, someone did a Positive adjustment for 432 to ‘zero’ out the inventory to offset but both are still ‘Open’.

Any guidance on this would be greatly appreciated.

——————————
Kristoffer Ruyeras
Director of Business Technology
Seattle, WA
——————————

[Andrew Good]

It looks like you have found the source of at least one error. The issue is that there are one Item Ledger Entry (ILE) that is open and Negative. You will need to get this entry to Open = No.

You may be able to use the Application Worksheet to link the positive and negative entries together.

——————————
Andrew Good
President
Liberty Grove Software
Oakbrook Terrace IL
——————————
——————————————-

[Dave Cintron]

Kris,

Did applying the entries handle this error? If not, there are a few possibilities. Did you start on NAV 2009 or upgrade from an earlier version, and have you ever date compressed the Item Ledger?

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-

[Kris Ruyeras]

Hi Dave,

No date compressed was done to this nav instance and I believe it started with NAV 2009. I have not yet tried to run the Application Worksheet but will test this sometime this week.

——————————
Kristoffer Ruyeras
Director of Business Technology
Seattle, WA
——————————
——————————————-

[Alex Apodaca]

Hello,

According to Microsoft you are not supposed to be able to make positive adjustments against the IN-TRANSIT location. Perhaps it’s your version/build of NAV, but Apparently, there is no code to handle an adjustment for this location thus you are likely missing the corresponding record in the Item Application Entry table.

You will want to make sure you have the latest cumulative update for your version of NAV, for starters. Also you might check into any customization that made this possible as well. You might be able to band-aid fix this… however if this has been going on for some time you may never have accurate costs. Ultimately you may have to make a new Item and start over for your accounting purposes. Please share if you find another solution.

——————————
If my response has helped you please mark the answer.

Alex A
Sr. NAV Consultant
Irvine, CA United States
——————————
——————————————-

[Dave Cintron]

Alex makes a good point. If your In-Transit quantity was adjusted, standard NAV functionality was bypassed, and you have an error message as a consequence. The two entries need to be manually closed and this should be done only by someone who really knows how to correctly modify the tables.

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-