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
0
Comments
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...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.