RE: Average Cost Help

["Peter Vidal" <Peter_Vidal@xxxxxxxx>]

"I did think about a CR trasnaction, but performing a CR would post the
difference in costs (old - new) to a "change in avg cost" variance acct. Our
finance dept. doesn't like that!!! I'm trying to figure out other ways!!"

UPDDTA or DBU are very good tools for this kind of situations....

In regards to the formula, the MAPICS IM Manual says:
"The average cost method automatically recalculates the average cost field when
a transaction amount is entered on a receipt transaction. The calculations used
are:

OTOHV = old AVCST x old MOHTQ
New AVCST = OTOHV + TRAMT (1 + POH)
(old MOHTQ + TRQTY).

where:
OTOHV Old total on hand value.
AVCST Average Unit Cost.
MOHTQ Quantity On hand.
TRAMT Transaction amount.
TRQTY Transaction quantity.
POH Purchase Overhead from ITEMASB, if defined.

If the cost is not entered at the time an inventory receipt transaction is
processed, the average unit cost and last unit cost are not recalculated or
updated.  Transactions are available to allow adjustments to the average and
last costs at a later date."

Hope this helps...
Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com

"A good player makes himself look good; a great player makes the team look
good."
Author unknown