RE: Average Cost Help

Peter,
What is UPDDTA or DBU?

-----Original Message-----
From: Peter Vidal [mailto:Peter_Vidal@xxxxxxxx]
Sent: Tuesday, November 11, 2003 11:38 AM
To: MAPICS ERP System Discussion
Subject: RE: Average Cost Help



"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


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.