Re: Costing of purchased items.

We update our standard costs once a year, so towards the end of the year
I give the Purchasing department an Excel list of all purchased parts,
existing standard cost, contract price, last PO price etc. They review
the prices and give me the updated list with the new standard costs. I
then load this list using offline load into ITEMASB, and update UCDEF in
ITEMASA with the month end IM close.
I use an application called XL400 from Symtrax to load the data to the
offline files from Excel. (The tool is usually for direct querying from
AS/400 to Excel, but can also send data back to the 400).


David Unwin

Systems Manager
CML Innovative Technologies

DDL +44 (0)1284 714710
FAX +44 (0)1284 754406
Email dunwin@xxxxxxxxxx



-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Weston Wheat
Sent: 08 May 2008 21:07
To: mapics-l@xxxxxxxxxxxx
Cc: Jeff Pile
Subject: [MAPICS-L] Costing of purchased items.

List

In investigating costing of purchased items I have found the following
from the Infor XA support website:



Here is the solution: Material cost for Raw Material and Purchased
Items

Standard and Current Material Costs for Raw Material (Item Type = 3) and
Purchased Items (Item Type = 4) are maintained only through file
maintenance. These fields are not updated through any receipt
transactions or any MAPICS program.



Here is the problem or goal:

Material cost for Raw Material and Purchased Items


How does the material costs for raw material and purchased items get
updated?






I have three questions then.

1. How does the costs get entered into Current and Standard costs
the first time that item is created?

2. What is the best way to keep these costs accurate, since it
appears you must do file maintenance to update the costs?

i.e. Is there a off-line load option from , say, a excel spreadsheet?

3. Is there a bolt on module that will track the purchasing cost
and update the purchase item costs in IM?



Thanks



Weston Wheat

Information Systems Manager

Quality Thermistor Inc

Phone: 208-377-3373

E-mail: wwheat@xxxxxxxxxxxxxx <mailto:wwheat@xxxxxxxxxxxxxx>

Web: http://www.thermistor.com <http://www.thermistor.com>