Can you guys tell me why the last trans. is -322.1441
Thx
Juan
 
INVENTORY TRANSACTIONS REPORT               Page:     1
                    Wednesday October 13, 2004 11:39 AM                        
Txn Date     : 06/30/04    -   10/30/04     Class :      -        Loc : ADC                                    
Txn Types    : ASPJWIOQCM                Catagory :      -            : ADC      
                                   
Part Number  : DRASSY203491                                    
Description  : Assy,6 BrkrPDU/Booster Tray                                    
            : Rev A                                    
Date      T      Action      Quantity      Order No      Cost      Customer/Vendor
--------      --      ---------      -------------      ------------      --------------      ----------------------
6/30/04      W      WO RECPT      52      995-16      25.0012      Make-to-Stock
7/1/04      I      WO ISSUE      24      1614-4      20.8946      Make-to-Stock
7/6/04      S      SHIPMENT      4      10160      19.6456      Communication Components Inc.
7/6/04      I      WO ISSUE      2      1600-20      19.31      3000287
7/7/04      W      WO RECPT      5      995-15      10.4557      Make-to-Stock
7/12/04      I      WO ISSUE      2      1826-3      20.47      Cingular, Carolina
7/15/04      I      WO ISSUE      3      1789-3      20.47      Cingular, Carolina
7/15/04      I      WO ISSUE      2      1825-3      20.47      Cingular, Carolina
7/15/04      I      WO ISSUE      2      1827-3      20.47      Cingular, Carolina
7/15/04      I      WO ISSUE      1      1836-3      20.47      Cingular, Carolina
7/15/04      W      WO RECPT      40      995-16      18.4511      Make-to-Stock
7/19/04      W      WO RECPT      38      995-16      18.4511      Make-to-Stock
7/19/04      I      WO ISSUE      36      1614-4      19.6456      Make-to-Stock
7/19/04      W      WO RECPT      59      995-16      18.4511      Make-to-Stock
7/27/04      I      WO ISSUE      44      1614-4      19.31      Make-to-Stock
7/30/04      I      WO ISSUE      1      1874-2      19.31      Cingular Carolina
7/30/04      I      WO ISSUE      1      1787-2      19.31      Cingular, Carolina
8/2/04      I      WO ISSUE      1      1824-3      19.31      Cingular, Carolina
8/24/04      I      WO ISSUE      1      1600-5      19.31      40738
8/25/04      S      SHIPMENT      1      10342      19.31      Communication Components Inc.
9/24/04      I      WO ISSUE      -2      1614-4      19.31      Make-to-Stock
9/27/04      I      WO ISSUE      10      1600-5      19.31      445
10/1/04      I      WO ISSUE      2      1927-3      19.31      Concorde Telephone
10/5/04      W      WO RECPT      10      995-16      18.4511      Make-to-Stock
10/7/04      I      WO ISSUE      -1      1614-4      19.26      USING FOR N8
10/13/04      W      WO RECPT      1      995-16      -322.1441      Make-to-Stock
                                   
                                   
Net Unit Chg:        71.00 Avg Cost (Period) :      18.2561 StdC:      15.559140                                    
(for period)               Avg Cost (Current):      17.1355 LstC:      18.4511                                    

The downside to a negative dollar work order receipt, is that DBA logic will neither issue these pieces to another work order at the negative cost, but will use standard cost, nor will it assign the negative dollar value to a shipment cost of goods sold, but will use standard cost.
 
We have been living with this BUG for the past 4 years and have to manually edit the General Ledger financials to correct these conditions.

Even though I answer "Yes" to 'is this the final receipt to the work order?', I change the value to what I have been writing off.  Then I close the work order and the difference, either positive or negative, is allocated between the parts left in inventory and cogs for the parts that have already been taken out of inventory.  
 
At least this is what I think is happening.  Of course, this may not work if there are several work orders putting the same part into stock.  But that usually isn't an issue with us.

The first entry is from the same WO.  Previous WO will not affect the costing of any WO.

It does a pro-rated calculation based on percentage complete so if material and labor issues are not accurate, the calculation can be off.

Karen,
Yeah you're right people can go crazy pushing bottoms, but I think there is something else going on here. This particular part avg cost had being around the same since the beginning of time. It just the first w/o receipt from this w/o that get it out of whack. That is what I can’t figure out why and what made the cost 25.0012.
Thank you for the input.
JI

That's not the case here, there were parts o/h
JI

As we use FIFO inventory method, weighted average cost is the value DBA uses for determining book value of inventory.  
 
Also, Juan, if you see that the cost DBA has used for processing transactions to inventory is not realisitic (i.e. $25.001), or see that DBA will use a negative dollar value for a transaction, one has the option of reversing out transactions already booked to inventory through WO-I, select "LOOK UP" and start typing the work order number, then scroll to find the transaction.  Once you find the transaction, click on it and you will be prompted if you wish to back out this transaction.  Say "yes" and it will be backed out.  This allows the user to re-book the entry(entries) to finished goods at whatever value you deem proper by going back to WO-I and starting afresh.