Problem with 2.60 fin compressed I/L

C2A_denis
Member Posts: 6
Hi,
i'm trying to migrate our customer from 2.60 fin to 3.70A Navision and having trouble with compressed I/L entries & codeunit 104049 in UpdateItemApplEntry(). This function takes place after the UpdateItemLedgEntry().
Some of his Item Ledger Entries have been compressed & it seems the migration processes the I/L but is blocked with apply entries associated with some compressed I/L. The problem appears with:
WITH ApplEntry DO
...
REPEAT
ItemLedgerEntry.GET("Item Ledger Entry No."); -> Crash saying "the entry No. xxxxxx does not exists".
Apparently, the first I/L from the original table 32 the UpdateItemApplEntry() function can't find is compr. I/L that has a quantity = 0 and an invoiced quantity <>0.
So, can someone explain to me why I/L entries disppeared from the original table and is it due to compression?
I think the way the UpdateItemLedgEntry() function processed the compressed I/L may be a part of the solution.
Please help...
i'm trying to migrate our customer from 2.60 fin to 3.70A Navision and having trouble with compressed I/L entries & codeunit 104049 in UpdateItemApplEntry(). This function takes place after the UpdateItemLedgEntry().
Some of his Item Ledger Entries have been compressed & it seems the migration processes the I/L but is blocked with apply entries associated with some compressed I/L. The problem appears with:
WITH ApplEntry DO
...
REPEAT
ItemLedgerEntry.GET("Item Ledger Entry No."); -> Crash saying "the entry No. xxxxxx does not exists".
Apparently, the first I/L from the original table 32 the UpdateItemApplEntry() function can't find is compr. I/L that has a quantity = 0 and an invoiced quantity <>0.
So, can someone explain to me why I/L entries disppeared from the original table and is it due to compression?
I think the way the UpdateItemLedgEntry() function processed the compressed I/L may be a part of the solution.
Please help...
0
Comments
-
Yep, thanks
the second time we processed we managed to store the apply entries for which there is no coresponding/source I/L entries in a table Temp and we found some matching criteria between the compressed I/L not present anymore:
It looks like there is two line created when compression is done, grouping some I/Ls together like you said but from this group filtered by "designation" on "compressed entry" and generated by the same operation i.e following each other, only one is present in table Temp.
I don't have screenshot now because i'm not at work till monday but I could easily do detailled screenshots of compressed entries that cause the problem but what I need is also a way to target the problem possibly in Navision standard migration codeunits 104048 & 104049 as soon as possible not to delay the delivery of Test database for too long(we're lread late).
Do you know anybody with some experience about Compression with fin 2.60 ?
cheers.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions