RE: Types of Mapics "Costs" Stored in Item Master Files

Al,

I was hoping someone else would answer, since I don't have a MAPICS system
or manuals to check my answers, but no one has come forward, so here goes
from memory:

ITEMASB - Current Unit Cost and Standard Unit Cost are set by rolling up the
purchase, labor, and overhead costs during a Current or Standard Cost Rollup
job.

ITEMASA - Unit Cost Default is updated from ITEMASB Standard Unit Cost when
the IM monthend/period end close is run, IF the option to update the Unit
Costs is selected on the prompt screen for the close job.  I believe that
Inventory revaluation transactions are written to IM Transaction History
(IMHIST) for the correct amounts to keep things in balance.  These can then
be fed to the General Ledger if you have the IM to GL interface turned on.

ITEMBL - Average Cost and Last Cost are updated for purchased items when
purchase receipts are made.  I vaguely recall that that's documented in one
of the reference manuals, either for IM or Purchasing.  I think there's a
way for the Standard Unit Cost in ITEMBL to be updated, but I don't recall
now what it was (we never used it where I was before, as we drove off Unit
Cost Default instead).

I hope this helps a little.

Dave Shaw
Spartan International, Inc.
Spartanburg, SC

> -----Original Message-----
> From: aldg [mailto:aldg@mail.rvi.net]
>
> Hi Mapics ML members:
> 
> General Mapics Info:  1. Our company uses Mapics DB or Y2K, Mod 4
> 2. Tailoring information: Under Information Management (IM), 
> the Inventory Costing Method selected is Standard Costs  3. 
> IM interfaces with Product Data Management (PDM) and 
> Production Control & Costing (PCC)
> 
> There are various "Cost" fields stored by Mapics in the Item 
> Master A & B files and the Item Balance file.  These include:
> 
> Item Master A File (ITEMASA) - Unit Cost Default (UCDEF)
> 
> Item Master B File (ITEMASB) - Current Unit Cost (CURCU) and 
> Standard Unit Cost (STDUC)
> 
> Item Balance File (ITEMBL) - Average Unit Cost (AVCST) , Last 
> Cost (LCOST) and Standard Cost (STDUC)
> 
> I'm trying to understand how Mapics updates these different 
> costs.  Which costs are automatically updated by Mapics and 
> which ones have to be "user" updated?  If the cost is 
> automatically updated, which Mapics module does the updating?
> 
> What Mapics options and tailorings affect the above answers; 
> that is, change the cost updating from automatic by Mapics to 
> manual or vice versa.
> 
> I look forward to hearing from you at your convenience.
> 
> Regards......
> 
> 
> --
> 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
> +---
> 
+---
| 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
+---