alright, so i found that i was invoicing on the wrong date for some of them and began this again.
i started out with Dec 1 receiving 500 units @$1.00 and then dec 2 i shipped 100 units. i printed the audit list and cleared it like you said and i see both transactions in history on their proper dates. the inventory valuation shows the 500 units for dec 1 like it should and it shows the 400 units for dec 2nd like it should.
there is only one problem, why is the average cost that prints on the valuation report at 1.25? and not 1? 1.25 is 400 units divided by $500.....the 500 units shows and the total cost shows $500 but the average cost per unit is now wrong.
Sorry for all the confusion, but the someone who showed me how to use this, left out a lot of steps. i finally have it all. i see that when you print a historical item valuation, it does not include recent or standard costs...and the average cost takes the units on hand today and divides by the total for the historical date. Why does it do this?
thanks for you help.