Adjust Cost routine 1 ILE with with item No Value entries
 
            
                
                    jannestig                
                
                    Member Posts: 1,000                
            
                        
            
                    I encountered a scenario which i believe is a huge flaw in the adjust cost.
1 item in the past had a large incorrect value (FIFO) and during the correction process one of the large value entries got linked to a ILE for item 2 also FIFO.
3 months later adjust cost has picked up this entry and applied the unit cost of item 1 to item 2.
How can the system allow that to happen although i acknowledge that the incorrect linking was probably manually made.
Is the fact that the system allowed 2 item value entries to influence one another with costs a large bug in the adjust cost routine?
Any thoughts ? the entries are shown below.
Posting Date Adjustment Item Ledger Entry Type Entry Type Document No. Cost per Unit Cost Amount (Actual) Cost Posted to G/L Item Ledger Entry Quantity Valued Quantity Invoiced Quantity Item No. Item Ledger Entry No. Entry No.
18/05/2007 No Positive Adjmt. Direct Cost ITE001863 9.99857 69.99 69.99 7 7 7 FT100/02 233914 701921
18/05/2007 Yes Positive Adjmt. Direct Cost ITE001863 357.11143 2,499.78 2,499.78 0 7 0 FT100/02 233914 703566
08/08/2007 Yes Positive Adjmt. Direct Cost ITE001863 14,053.62 98,375.34 98,375.34 0 7 0 FT100/02 233914 816968
18/05/2007 No Sale Direct Cost PSI048858 32.5 -32.5 -32.5 0 -1 -1 BRS/08 233914 702717
18/05/2007 Yes Sale Direct Cost PSI048858 492.12 -492.12 -492.12 0 -1 0 BRS/08 233914 703567
08/08/2007 Yes Sale Direct Cost PSI048858 14,053.62 -14,053.62 -14,053.62 0 -1 0 BRS/08 233914 816969
18/05/2007 No Sale Direct Cost SHP055267 32.5 0 0 0 -1 0 BRS/08 233914 701926
                1 item in the past had a large incorrect value (FIFO) and during the correction process one of the large value entries got linked to a ILE for item 2 also FIFO.
3 months later adjust cost has picked up this entry and applied the unit cost of item 1 to item 2.
How can the system allow that to happen although i acknowledge that the incorrect linking was probably manually made.
Is the fact that the system allowed 2 item value entries to influence one another with costs a large bug in the adjust cost routine?
Any thoughts ? the entries are shown below.
Posting Date Adjustment Item Ledger Entry Type Entry Type Document No. Cost per Unit Cost Amount (Actual) Cost Posted to G/L Item Ledger Entry Quantity Valued Quantity Invoiced Quantity Item No. Item Ledger Entry No. Entry No.
18/05/2007 No Positive Adjmt. Direct Cost ITE001863 9.99857 69.99 69.99 7 7 7 FT100/02 233914 701921
18/05/2007 Yes Positive Adjmt. Direct Cost ITE001863 357.11143 2,499.78 2,499.78 0 7 0 FT100/02 233914 703566
08/08/2007 Yes Positive Adjmt. Direct Cost ITE001863 14,053.62 98,375.34 98,375.34 0 7 0 FT100/02 233914 816968
18/05/2007 No Sale Direct Cost PSI048858 32.5 -32.5 -32.5 0 -1 -1 BRS/08 233914 702717
18/05/2007 Yes Sale Direct Cost PSI048858 492.12 -492.12 -492.12 0 -1 0 BRS/08 233914 703567
08/08/2007 Yes Sale Direct Cost PSI048858 14,053.62 -14,053.62 -14,053.62 0 -1 0 BRS/08 233914 816969
18/05/2007 No Sale Direct Cost SHP055267 32.5 0 0 0 -1 0 BRS/08 233914 701926
0                
            Comments
- 
            Application is not responsible for errors made by users. If somebody linked two item entries for different items, application is not preapred for that. Find the person who did that mistake and cut him the hands.
 If somebody will fill the car tank by high explosive liquid instead gas and the car will explode, do not try to accuse the car designer that it is a bug... 0 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
- 323 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
