Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Item journal posting error

Posted on by Microsoft Employee

Hi,

When I was posting Item journal I got the error

"There is no Value Entry within the filter. Filters: Item Ledger Entry No.: 28766". I checked that the posted  item ledger entry did not have any value entry record. Can anybody tell me why few times value entry is not created?

Is this related to the inventory setup field Automatic Cost Posting?

If Automatic Cost Posting is set FALSE, then value entry is not created? Is my understanding right?

Thanks,

Vidya Moger

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item journal posting error

    Check if in value entries there are gaps in entry No.

    If yes  -> DELETE.

    If no and there are no customizations, try to replicate the problem with same item same sales doc ecc

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item journal posting error

    Hi Amol,

    Thank you for the reply.

    There is no customization done to stop or delete value entry.

    There were only few missing value entry records in between which caused the error. I managed to add the entry number in the table from backend to continue my development. Now to understand the root cause so that it does not create problem in future in production, I posted many entries in different ways. In all cases value entry is created. I have no clue why 3 to 4 value entries were not created in between.

    One more question does it depend on amount? The item ledger entries which did not have value entries were having zero unit amount and zero cost amount but quantity=1 and entry type = sale.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Item journal posting error

    Check whether any customization is done for stopping this  as in standard system it should create entries in value entry.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item journal posting error

    Value entry is always created...

    I think there is a customization or a DELETE via SQL

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