Skip to main content

Notifications

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

Item revaluation error message

(0) ShareShare
ReportReport
Posted on by 20

When trying to post a revaluation entry, I get the following message in NAV:

pastedimage1602527203467v2.png

I am not sure why I get this message since line 3 is empty and I have manually deleted line 3 as well after getting the error message. Line 1&2 contain an "applies to" entry, so I am not sure why I get the message.

Does anyone have an idea why I might be getting this error message?

Thank you

Marco

  • Marco V Profile Picture
    Marco V 20 on at
    RE: Item revaluation error message

    I appreciate your help and am glad we were able to figure it out.

    Have a wonderful weekend.

    Marco 

  • Verified answer
    RE: Item revaluation error message

    Hello Marco,

    Ahhh yes...   Ok, now I totally understand what was going on.  As in my last reply...

    "Typically you should be able to revalue a Purchase, unless that is it is like for a FIFO or Average Cost item and the Purchase was Received only.  In that case, we can only revalue Invoiced costs...not received only."

    If we review the costs of a Received item only, within the Item Ledger Entries Table32, or Value Entries Table 5802, this is in 'Cost Amount (Expected)'.   We cannot revalue this (unless Standard Cost).

    Once you Transferred it, it created new Item Ledger Entries and Transfers are always 'Invoiced' = TRUE.  So you were able to revalue the new Inbound Transfer ILE - Item Ledger Entry.

    I didn't realize the Purchase you were trying to revalue was Received only, and not Invoiced.  Sorry, I should have stepped back, as I made an assumption there....but I guess didn't think about it..   So it makes perfect sense and explains it.  Thank you for the follow-up and confirmation.  Have a super rest of the week and stay safe and healthy! :)

    Bryan

  • Marco V Profile Picture
    Marco V 20 on at
    RE: Item revaluation error message

    Hi Brian,

    We have finally been able to do the revaluation. The item was booked as a purchase (PRCT) and since we are using FIFO, we are not able to revalue a PRCT document. 

    pastedimage1603235985946v1.png

    After we transferred the items (entry type changed to "transfer"), we were able to revalue the items. 

    I appreciate your help in this.

    Have a wonderful day.

    Thanks

    Marco

  • RE: Item revaluation error message

    Hi Marco,

    I honestly am not so sure about that.   If the line he is trying to revalue is line 30000 and NAV sees it as line 30000, i don't think that is a problem....I'm not really sure how to interpret what the means I guess.  

    In regards to applying to a related Purchase, you can indeed revalue a purchase.  I don't understand this really either.   Typically you should be able to revalue a Purchase, unless that is it is like for a FIFO or Average Cost item and the Purchase was Received only.  In that case, we can only revalue Invoiced costs...not received only.  

    So I guess neither of the 2 statements you were given make too much sense to me.

    On another troubleshooting/research note, I investigated our bug database, both the old and new ones and don't see this issue reported.

    I'm not sure if you are a partner or customer, if customer, you may want to check with your partner....or either way, check if the Revaluation Page is modified and that is causing you the error.

    OR/and what if you go to a different batch, maybe try the Default Batch if you have one and see if you can revalue it.   I'm really not sure why you'd be getting this error.  Sorry I don't have a more definite answer for you here. :(

    Bryan

  • Marco V Profile Picture
    Marco V 20 on at
    RE: Item revaluation error message

    Hi Bryan, I received some feedback from a someone else as well. He mentioned the following:

    - I ran a reval calculation and deleted some lines from there that didn't need to be revalued. The line that I am trying to revalue is the original line 30000 and NAV still sees it as line 30000.

    - The applies to entry is related to a purchase and you can't revalue a purchased item (we are using FIFO). I will need to change the status of the receipt (e.g. put in on hold) to be able to revalue.

    Does that in any way sound like that could be the case to you?

    Cheers

    Marco

  • RE: Item revaluation error message

    Hi Marco,

    Ahh, the Line 83 you refer to is actually the Table Object number that the Reval. Journal Line is stored in.  It is not the Line no. field of the record.

    You would want to click on the Table fields tab as shown below....

    pastedimage1602697274353v2.png

    In regards to the batch, you have the REVALPROD batch showing.  You can drill into that dropdown and see if there are other batches...

    pastedimage1602697096464v1.png

  • Marco V Profile Picture
    Marco V 20 on at
    RE: Item revaluation error message

    Lol, no worries. 

    1 of my items got fully consumed, so I have only 1 line left to revalue. 

    When doing ctrl-alt-F1, I get the following pop-up:

    pastedimage1602695705515v1.png

    It looks like the 1 line I have is actually line 83 in the system. 

    I am not aware of any other batches. How can I check for this and delete them? I normally delete all lines that I do not revalue.

    Thanks

    Marco

  • RE: Item revaluation error message

    Oh gosh Marco,  I'm so sorry...I beg your pardon, Old habit, and too much going on.  

    I meant  Ctrl-Alt-F1.  This will show the Table fields.   Sorry again for my typo.

    Wondering if maybe you have another batch for Revaluations and like you said, it is looking for something else.  Can you check that and if so, delete the other batch(es) if you have more than 1 for Revaluation Journals?

    Keep me posted. Thank you Marco.

    Bryan

  • Marco V Profile Picture
    Marco V 20 on at
    RE: Item revaluation error message

    Hello Bryan,

    Thank you for your your help.

    The revaluation is only for 2 lines (see screenshot below). The third line is empty and like you suggested, I had already "deleted" it but still got the same message. I tried it again after reading your email and still got the same error when trying to post the revaluation entry.

    I am not sure how to do the ctrl-alt-del without the blue Microsoft page popping up asking if I want to lock my screen, use task manager, etc. Would you be able to explain into more detail how to do that?

    pastedimage1602636281270v1.png

    I have even tried to post the revaluation 1 item at a time to see if that would make a difference, but that gives me the same error message as well (referring to line 3000, while only posting 1 line instead of 2)

    pastedimage1602636571296v2.png

    Not sure if this is relevant, but to me it seems like the error is related to something else than the 2 lines I would like to post.

    Usually I am able to post revaluation entries without a problem or figure out why there is a problem. In this case I don't know.

    Again, I appreciate your help.

    Thanks

    Marco

  • RE: Item revaluation error message

    Hi Marco,

    Thank you for posting your question in Community Forum.  This is Bryan and I'll see if I can assist with this.

    Looks to me the error is complaining about nothing, as you do indeed have the Applies-to Entry field populated...well, on the 2 lines anyways.  (BTW - It is good to use the Applies-to Entry....vs the Calc. Inventory function.   I always recommend using the 'Applies-to Entry' so that so you don't revalue partial quantities on ILE's (Item Ledger Entries), which can get tricky sometimes...anyways....)  However, it says it is for Line=30000, which would be the 3rd line of the Revaluation Journal.

    The screenshot shows 2 lines.  Is that all there is? Just 2 lines?   If you do a Ctrl+Alt+Del  F1 on the first line, is that Line No. = 10000?  If you do the same on the 2nd line, is that Line No. = 20000?   Is there a 3rd line that is a blank record perhaps?  Can you try deleting the 3rd line?

    Let me know how it goes.  Hopefully that helps.  Thanks Marco.

    Bryan

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans