RE: MAPICS "Inventory Valuation" Report

["aldg" <aldg@xxxxxxxxxxxx>]

Hi Philip Freimann and Michael J. Dreimiller:

Thank you for your messages (see below).

I have glanced thru the Reports shown in the PCC manuals and unless I'm just 
missing something, I don't see a Work-in-Process (WIP) report that shows the 
follows information, say at Month-End:

1. Listing of all Open Manufacturing Orders (OMO) with their respective  Item 
Numbers and Item Descriptions

2. For each OMO, show a summary of costs by:

     Direct Labor
     Materials, including Outside Processing)
     Overhead Applied

The above costs could be broken down between Current Level and Lower Level 
costs.

3. Totals for the three components of costs listed in No. 2 above.  These 
totals should tie into the WIP totals that are on the Mapics General Ledger at 
the Month-End.

In reviewing the Reports in PCC, I see various types of reports under the 
catigories "Order Status Reports" and "Exception Analysis," which don't appear 
to be any type of a WIP month end report.

The Reports under the catigories "Period Analysis Cost Summary" and "WIP Totals 
Sheet" are closer to what I'm looking for but they don't give summaries by each 
Open Maufacturing Order; only totals that appear to tie into the WIP General 
Ledger balances at Month-End.

So please see if you can give me some additional suggestions for this.

Regards.....

------Freimann's Original Message------

>From: Philip R Freimann <Philip.Freimann@Miltope.com>
>Date: Mon, 24 Apr 2000 13:18:36 -0500

>Hi Al,
>
>I do not have all the manuals in front of me - others more familiar with the
>applications will give you more detail.  I'll just give you the 'quick n
>dirty.'
>
>The AMISQ report (as you probably know comes from Inventory Management.  All
>MAPICS programs, menus, procedures, etc. are identified by the third
>character.  ie. "I" = IM, "C" = PCC, etc).  The IM reports only show the
>cost of the raw material or finished inventory, normally the cost that is in
>the ITEMBL file - no labor.  (If there is no cost in the ITEMBL, it
>retrieves the cost from ITEMAS).
>
>The PCC application values WIP, and there doubtless are reports in PCC that
>value the WIP - I know there are at month end.  That would include the cost
>of the material used to that point in the operation, and labor expended
>through that operation.  Scrap is similarly valued.
>
>Hope that points you in the right direction and that others will add
>details.
>
>Phil
>Montgomery, AL
>

------Dreimiller's Original Message------

>From: "Michael J. Dreimiller" <Mandis-Inc@worldnet.att.net>
>Reply-To: MAPICS-L@midrange.com
>Date: Mon, 24 Apr 2000 15:23:42 -0400

>Look at the Reports under Production Control and Costing for WIP Valuation.
>Inventory Management reports inventory in a warehouse.
>
>Mike Dreimiller
>
------End of Original Messages------


--
Above message before copy enclosure (if any) was sent by:

Al Gershen
Grants Pass, OR 97526 
aldg@mail.rvi.net & aldg@webtv.net;
and thru ICQ # 12342782

--
+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---