20
When trying to post a revaluation entry, I get the following message in NAV:
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
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
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.
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
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
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
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....
In regards to the batch, you have the REVALPROD batch showing. You can drill into that dropdown and see if there are other batches...
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:
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
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
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?
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)
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,645
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (