Adjust Cost routine 1 ILE with with item No Value entries

jannestigjannestig 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

Comments

  • kinekine Member Posts: 12,562
    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... :wink:
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.