RE: Average Cost Help

[Paul Lanier <planier@xxxxxxxxxxxxxxxx>]

Why wouldn't you enter negative purchase order receipts to stock to return
the goods to the vendor and put them back on the purchase order?  Then
correct the purchase order for the correct cost and after correcting the
cost, enter new purchase order receipts to stock to receive them at the
correct cost.



-----Original Message-----
From: Nandagopal Padmanabhan [mailto:npadmanabhan@xxxxxxxxxxxxxx] 
Sent: Tuesday, November 11, 2003 2:26 PM
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!!

-----Original Message-----
From: mandis-inc@xxxxxxx [mailto:mandis-inc@xxxxxxx]
Sent: Tuesday, November 11, 2003 11:08 AM
To: MAPICS ERP System Discussion
Subject: Re: Average Cost Help


Refer to the IM manual, chapter 5 (Transaction Processing) and Appendix E 
same manual.

Review the CR transaction (Average Cost Replace) to adjust the average cost

--
Best regards,

Mike Dreimiller
Mandis Inc.
410-526-5996
Mandis-Inc@xxxxxxx
> Hello Group,
> I have a situation here where the buyer had typed in an incorrect purchase
price 
> on the PO. The actual average cost of the item is $20, but the purchase
price on 
> the PO was incorrectly keyed in as $4300. Our warehouse did an RP
transaction 
> after receiving the item and the average cost is all messed up in the
system as 
> we had around qty 200 of that item (valued at $20) prior to the RP
transaction. 
> 
> Question: what do I do to fix the problem and correct the avg cost! Also,
what 
> is the exact avg cost formula that MAPICS uses if a 15% overhead is added.
Let 
> me know if more info is needed. 
> 
> Thanks,
> Nandu
> 
> _______________________________________________
> 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.
> 
_______________________________________________
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.


_______________________________________________
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.