Could you leverage Quotes in Purchasing to store costs. Then link to
Vendor number in the ITEMBL to tell is the "current" cost; who are you
currently buying from. Then write a simple program that runs before cost
rollup that pulls the latest cost from the quote files and puts it into
current and/or standard material cost for standard costing. You could use
a standard quote ID to identify which quote represents the most current
cost you are using from Vendor that the program always looks for. When you
place a PO it could leverage that cost to default as well. You could also
replace current unit cost default when this program runs before cost
rollup by doing an automatic off-line change of UCDEF which would
generate a CU.
So in this scenero you only buy from one vendor at one time and
maintaining the default vendor tells the program which one to replace
prior to cost rollup.
As Dale points out not sure on all the objectives here. And this solution
above would assume you only buy from one vendor at a time. Sounds like
maybe you need to select variable costs at the same time and tag it to
orders for variance reporting.
Just some thoughts.
-------------------------------------------
Kevin Gerard, Senior Technical Consultant
TriMin Systems, Inc. - Infor Channel Partner
kevin.gerard@xxxxxxxxxxxxx
Direct 309-932-3103
Mobile 309-883-1689
www.triminmfg.com
"We are committed to helping manufacturing companies improve their
Visibility, Productivity, Growth and Profitability"
"Gindlesperger, Dale" <DGindle@xxxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
04/03/2009 10:04 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
To
"'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>
cc
Subject
Re: [MAPICS-L] One item different costs
Jeff,
Since you are using PDM, not EPDM, costs are in ITEMASA and ITEMASB, and
there's a cost available in ITEMBL. What are you attempting to do? We
also had a situation where we could use materials from various vendors
(similar situation - different costs from different vendors), but we
handled that with substitutions at IM Order Entry time or we changed the
order after it was released.
We ended up with cost variances from standard, but we handled that by
doing our own job costing for materials just comparing a calculated
end-item cost for the individual orders (running MODATA at current cost,
std qty vs. issued qty). We did a compare against the end item std, but
didn't use that for order variance, just for information.
Again, what are you attempting to accomplish?
Dale "Cork" Gindlesperger, CPIM
Senior Business Analyst
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of jeffw@xxxxxxxxxxxxxxxx
Sent: Friday, April 03, 2009 10:11 AM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] One item different costs
Hi list. I am pretty sure you cant do it, but I wanted to ask. We have the
green screen version of Product Data Management. We have some items that
are
raw materials that come from different vendors. Each vendor has a
different
cost. Currently we track that by having different item numbers for each
vendor. Is there a way to have one item number with different costs
associated
to it? Maybe do something in the Product Structure to tell it which cost
to
use? Thought I would check. Thanks
Jeff Williams
_______________________________________________
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.
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.238 / Virus Database: 270.11.40/2039 - Release Date: 04/03/09
06:19:00
_______________________________________________
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.
midrange.com
