RE: Average Cost Help

["Nandagopal Padmanabhan" <npadmanabhan@xxxxxxxxxxxxxx>]

Paul,
I did a negative RP to put the item back on the PO and I did this for 2 reasons:
1. I thought that this would change the average cost in the warehouse to the 
original average cost
2. I wanted to change the purchase price on the PO to the correct value

But after I performed the negative RP, the above didn't take place. Instead the 
average cost changed to a higher cost, but the item was put back on the PO.

In a nut shell, the original avg cost was: $20
After RP: avg cost: $1320
After negative RP: avg cost: $4300!!!!!!!!

I did my negative RP on the RP screen and made sure I had a neagtive qty! 
What's happening? Let me know if you need more info, I can send you a 
spreadsheet with the transactions.

-----Original Message-----
From: Paul Lanier [mailto:planier@xxxxxxxxxxxxxxxx]
Sent: Tuesday, November 11, 2003 11:52 AM
To: 'MAPICS ERP System Discussion'
Subject: RE: Average Cost Help


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