Upgrade Step 2 error: Item Applicaion Enry No. Missing.

admoretutsieadmoretutsie Member Posts: 79
I am at the second stage of of upgrading to 4.0.1, and l have imported upgrade object number2, and when l click trasfer data, l am getting the error
Item Application Entry No. xxxx Missing

When l break on error, l am facing codeunit 104048, with something like this:
IF "Inbound Item Entry No." <> 0 THEN BEGIN
TempItemApplEntry.GET("Inbound Item Entry No.");
CASE TRUE OF
(TempItemApplEntry."Output Completely Invd. Date" = 0D) AND
NOT TempItemApplEntry."Cost Application":
IF "Output Completely Invd. Date" <> 0D THEN BEGIN
"Output Completely Invd. Date" := 0D;
MODIFY;
END;
Quantity > 0:
IF "Output Completely Invd. Date" <> "Posting Date" THEN BEGIN
"Output Completely Invd. Date" := "Posting Date";
MODIFY;
END;
Quantity < 0:
BEGIN
ItemLedgEntry.GET("Outbound Item Entry No.");
IF ItemLedgEntry."Completely Invoiced" AND
("Output Completely Invd. Date" <> ItemLedgEntry."Last Invoice Date")
THEN BEGIN
"Output Completely Invd. Date" := ItemLedgEntry."Last Invoice Date";
MODIFY;
END ELSE
IF NOT ItemLedgEntry."Completely Invoiced" AND
("Output Completely Invd. Date" <> 0D)
THEN BEGIN
"Output Completely Invd. Date" := 0D;
MODIFY;
END;
END;
END;
END;.......... etc
I just dont get it. l would appreciate any help from you guys. How can l proceed?
$cside -MBS
>install Navision::4.0 SP1
>q
$
oOo

Comments

  • ara3nara3n Member Posts: 9,256
    Do you actually get the error Item application entry No. xxxx missing? or is the error Item application entry No. xxxx does not exist.

    The code that you are showing does not have any error message. so it must be erroring on
    TempItemApplEntry.GET("Inbound Item Entry No.");

    find out where it is being populated. and put the code in here.


    I would also run a test table on item application table old version of db. See if you get any error.

    The purpose of item application table is to link how items have been applied to each other.

    I hope this helps.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • aheresqaheresq Member Posts: 3
    Hi, i had the same problem, and i find why, in my case it occurs because in other development had to share the item ledger entry table, and don't share the item application entry between two companies in the same database, then each one started to create their own record, but i don't know why, some movements from a company be applied with movements from the other. :-k , (i hope be explicit). then now when i try to run the upgrade process step 2 is missing the record which applied in the other company. Now i have to fix these error but the table has movements since 2 years, then i have a problem.

    If you have the same problem, and you think how can resolve, please tell me, i need help.
  • ara3nara3n Member Posts: 9,256
    The problem you are running to is really hard to fix. You'll have to spend days on analyzing the data. This is all because of bad modification. This modification should not be upgraded to 4.0.

    Going back to how to fix this problem. I have no idea on how the accounting side of this mod looks like.
    There is a couple of options.

    1) Delete all the item ledgers. and all the related tables. Upgrade all the data. Then bring in the inventory just like when you bring open balance on Go-live.

    second option.
    2)Export all the item ledger. Copy the database, delete all the item ledger and related tables from this temp db. create a dataport that will create item journal based on File that you exported from Item Ledger. Post the Item journal. This will create the Item ledger and the item application.
    Create a dataport to export the item application table into original db.


    Good luck.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • aheresqaheresq Member Posts: 3
    Thank you for your help, i think to do some like you tell me, i see that the best way to resolve it its analysing the information and rebuild some of the information, i will try to reset the inventories, and charge it again to fill the Item Application Entry table.

    When i have some advance i will to know you.

    Regards.
  • trintrin Member Posts: 110
    Hi,

    Were you able to get your problem fixed?

    I am in the process of upgrade from 3.10 to SP3. In the step 2 transfer data, I got the error
    "The Temp Inbound Tracking Entry does not exist.
    Identification fields and values,
    Inbound Item Entry No =XXX , Serial No ='', Lot No='XXXXX'"

    This customer uses Lot tracking.
    I was able to locate that entry with applied entry from Item Ledger entry form but I was not able to find this entry in Item Application table.

    How can I fix this error? I manually added a line for that ILE in the Item application. Will this work? How can I tell whether there are any more missing item applications further down the road?

    By the way, this is a huge database and it took me 2 days to get the error on transfer.

    Thanks
Sign In or Register to comment.