Quote from kevind   on 01/30/07 at 14:02:48:

Well, it has to or you will have overstated your costs.
 
If you don't want it to, you can manually enter a cost on the last receipt and then you will get an entry posted to your WIP Variance.
 
When we do partial receipts we manually calculate the costs (usually we can take the current total actual costs divided by units made so it's pretty easy), and then the last one comes out right.

I don't have any explanation for that "logic". What do you see if you look at Transactions in IN-A, or print IN-E?

What type of Inventory Method do you employ - FIFO, LIFO or AVERAGE?  
 
In the past, we employed FIFO, and used Standard costing for partial work order receipts. This resulted in numerous negative dollar work order receipts and or large postive dollar values because standard costs were not being reviewed for accuracy ( current routings, material costs, etc)
 
Also, when the last transfer to finished goods results in negative dollars, DBA does not have the ability to pass on the negative cost to cost of goods sold when using FIFO, creating an accountant's nightmare.
 
We switched to AVERAGE costing 2 years ago (using average cost for partial work order receipts) and rarely see negative dollar or huge positive dollar swings in the last transfer work order receipt to inventory.
 
Also, the LIFO/FIFO buckets do not always properly reflect all transactions incurred, resulting in unexpected inventory costing. Many times we had to manually edit the buckets so our costs came out properly.
 
 
 

Quote from kevind   on 01/31/07 at 09:29:21:

 
Your actual cost is $76.98 for 20 units.
The 2 partial transfers put $48.294 ( 10 x $3.2196 and 5 x $3.2196) w/o cost into inventory,
Your last entry to FG for 5 units should have been at $5.7372 for a total of $28.686.
I suggest backing out the last transfer to finished goods, and re-enter it by overriding DBA/EVO's calculation with $5.7372. Assuming no other activity in this inventory account, the average cost should now be the actual average cost of $3.849 . (IF not, you can manually change it in IN-K to set the system straight).
Sorry, I am not sure why the system went astray.

Has anyone been able to duplicate the negative cost result I had above in the 3rd post??
 
Is this by design, or did I do something wrong?   ???
 
P.S.  Data used is the origonal Demo Data from DBA, Company #99.

I have some more detailed info for this problem that may help someone find out what is happening.
 
I have a work order for 30 items.
10 were turned in on 1/24/07.  The Item Transaction shows a cost of 65.2000 (this is good)
10 were turned in on 2/26/07.  The Item Transaction shows a cost of 62.7370 (this also looks good)
 
Now we want to turn in the final 10.  We answered Yes to this is the final receipt.
 
This is what the WO-I screen looks like:

 
Why is it calculating an actual Unit Cost of -4.7903 ?  
 
I calculate:
              (10 * $65.2000) + (10 * $62.7370) = $1279.37  - - Turned in before
                                   $1884.50 - $1279.37 = $605.13  - - Dollars yet to turn in
                                              $605.13 / 10 = $60.5130 - - Actual cost per item
 
Someone please correct me so that I can understand were this Unit Cost comes from.  

Thank You.
 
HERE is how to duplicate it.
 
BTW: Here are the previous 2 receipts