Share
Report*This post is locked for comments
You’re offline. This is a read only version of the page.
*This post is locked for comments
was there any solution for this / rootcause found? I have the same problem in a NAV2016 installation...
As I didn't have time to wait, I assembled a new codeunit from C22 Item Jnl.-Post Line, which checks and creates Value Entries, that are missing from Item Ledger Entries.
The functions, that need to be copies and customized for the Value Entry creation based on Item Ledger Entry, Sales Invoice Header and Sales Invoice Line tables, filtered for the specific invoice number are as follows:
- InitValueEntryNo
- InitValueEntry
- InsertValueEntry
These functions require the following local functions as well:
- MoveValEntryDimToValEntryDim
- RoundAmtValueEntry
- IsFirstValueEntry
- CalcCostPerUnit
- UpdateItemLedgerEntry
- CalcExpectedCost
- - CalcExpCostToBalance
- InsertItemReg
Please be advised to copy Text constants and global variables also. With the help of these I was able to generate Value Entries and write their entry no.-s into Item Register and Cost Adjustment is now runing as a charm.
Hope this helps to you, be carefull and test your codeunit on a test database with live data, before running your customized codeunit against the live database and system.
Are there any updates on this topic? I also ran into such a problem during Cost Adjustment, that Value Entries were missing from Item Ledger Entries on a LIVE Dynamics NAV 2017 system, but didn't find any official hotfixes yet to address the problem. Any suggestions?
I assume you mean "free for us"... well, I'm not Microsoft, so no warranty. All the bug tickets I have opened were with no charge in the end. The experienced person is generally not free. The main problem here is risk. It will cost money either way, but more so if a solution is delayed. Not a good idea if you have to explain your numbers to the auditors and you know the inventory is not consistent.
will it be free for them to sort it.?
Time to open a ticket with Microsoft support, I'd say. This should be escalated. Also, try to locate the originating transaction (have a look at the register) to get a clue what the missing item ledger should look like. The problem is: With the missing entry your inventory is inconsistent, which is bad. It has to be "restored" which means created by hand/script. If this is not corrected, your inventory will stay inconsistent, which can lead to wrong valuations in the G/L and pricing (cost, profit calculation), at the very least. I would also look for further occurrences of this or similar errors. You should have some experienced person on your side, even with Microsoft trying to solve this problem.
Hello,
Seems the Item Application Entry table has that entry, if am not wrong.
Have a look in table 339, filter the columns Item Ledger Entry No. (should suffice) or Inbound/Outbound Item Entry No.
Item Application Entry has entries. Just to be sure, how can I confirm if entry 3751 was recorded in the Item Application Entry.
[quote user="muleso"]Technically and functionally no one seems to understand what exactly happened.[/quote]
;-) I don't know how the copy function is implemented, but it's not likely. Does the ILE exist in the source company? Or is there a gap in the ILE numbers, too? What about the application entry?
On the other hand, a quick check of the changes in Codeunit 22 from RTM to the current CU 07 shows quite a few changes, some are the usual refactoring, but some are error corrections. Maybe worth a look?
#1
Community Member
2
#2
EH-09052238-0
1
#2
Sohail Ahmed
1
All responses (
Answers (
