Item Application Entry No. xxxx Missing
I just dont get it. l would appreciate any help from you guys. How can l proceed?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
Comments
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.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
If you have the same problem, and you think how can resolve, please tell me, i need help.
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.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
When i have some advance i will to know you.
Regards.
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