Glad we could help. This was an area that we struggled with for a while
also. We had to upgrade to 700 a few weeks before our go live because this
didn't work in 606.
We are also a contract manufacturer and have specific customer and ISO
requirements. We were also faced with lot traceability issues.
Job level lot traceability is about as far as you can go in the base
system. This means we'd have to create 30 jobs a day for each product line
and have users log in and out of each job. Not going to happen.
Instead we created a customization that allows us to match issued lot
tracked material to finished lot tracked parts. We are using a UD table to
store all the relationships. We now have one job spanning a month with full
lot traceability. If your situation is similar to ours, it might be worth
your time to customize.
Scott
also. We had to upgrade to 700 a few weeks before our go live because this
didn't work in 606.
We are also a contract manufacturer and have specific customer and ISO
requirements. We were also faced with lot traceability issues.
Job level lot traceability is about as far as you can go in the base
system. This means we'd have to create 30 jobs a day for each product line
and have users log in and out of each job. Not going to happen.
Instead we created a customization that allows us to match issued lot
tracked material to finished lot tracked parts. We are using a UD table to
store all the relationships. We now have one job spanning a month with full
lot traceability. If your situation is similar to ours, it might be worth
your time to customize.
Scott
On Mon, Mar 18, 2013 at 12:06 PM, ssoeder@... <ssoeder@...>wrote:
> **
>
>
> Just an update, I have successfully been able to create the desired
> behavior thanks to your suggestions!
> I created a generic part and turned the "whole units" checkbox ON (under
> part maintenance/part entry).
> Now, for quoting and planning purposes, I can create a sub-assembly and
> issue the generic part as a material.
> I put in the price for the whole bar, put the qty/parent at whatever the
> percent of the whole bar is (i.e. 10" part from a 144" bar is
> 0.069444444)and I can set my scrap to account for any remnant and setup
> pieces.
> This works well for me to calculate how many bars I need.
> Since I can calculate my needs, I can also calculate my supplier price
> breaks properly, and this has really made a HUGE difference for me.
>
> Thanks everyone for your help!
>
> --- In vantage@yahoogroups.com, "ssoeder@..." <ssoeder@...> wrote:
> >
> > I will try this, this sounds like the most promising solution and is
> similar to the post by Josh Serwe regarding changing UOM, but allows a
> little more flexibility.
> >
> >
> >
> >
> > Also, to answer the question about returning to inventory:
> > We are a contract manufacturer, and we must maintain traceability to
> material heat lot per our customer and ISO requirements.
> > Some of our customers also require that each lot is run out of one
> material heat.
> > For these reasons, I cannot simply return a partial bar to inventory and
> plan to use it later - we may never get that job again, and if we do, we
> may not have enough of that specific heat available for the whole job, so
> we may never be able to use the remnant.
> > This is especially important with exotic materials or special shape bar
> stocks.
> >
> > The same goes for tooling, which we normally add as a material. If I
> need $300 for broaches that I know last say 200 parts, I need to be able to
> account for that when a customer wants an RFQ for 15, 200, 2000, and 20,000
> parts.
> >
> > --- In vantage@yahoogroups.com, "Scotty K." <scottyk537@> wrote:
> > >
> > > Not sure about vantage, but in E9 we have a similar issue that was
> fixed by
> > > using sub assemblies. Create a sub assembly in your MOM and enter your
> > > qty/parent as it relates to your part. Then add your material to the
> > > subassembly. As long as your each UOM does not allow decimals, you will
> > > never be able to quote/estimate a fractional subassembly.
> > >
> > > On Mar 1, 2013, at 3:30 PM, "ssoeder@" <ssoeder@>
> > > wrote:
> > >
> > >
> > >
> > > When I am quoting or engineering a part in Vantage, often times we have
> > > material costs we need to account for based on a set amount of parts.
> This
> > > would need to be entered as a cost per number of units, however I seem
> to
> > > be able to choose only cost/ea or a fixed cost, and this can be
> dangerously
> > > inaccurate for planning accordingly!
> > >
> > > Example, I have a part now, we are quoting 45 parts for a prototype,
> and
> > > production is estimated at 1500/month.
> > > I want to quote quantities ranging from 45 to 4500 parts, to cover
> > > prototype, monthly releases and quarterly releases.
> > > My material cost is $450/1000 parts
> > > This material cannot be used for any other job and is only available in
> > > quantities for 1000 parts.
> > > I need $450 worth of material to make 1 part, 45 parts, 450 parts, or
> 1000
> > > parts.
> > >
> > > If I enter my cost as .45/ea, my pricing is way off for the 45 part
> run � I
> > > would only be accounting for $20.20 out of $450 in my costs!
> > > On the same token, I cannot put in $450 as a fixed cost because then I
> am
> > > off for anything over 1000 parts.
> > > I need $900 worth of tooling for 1001, 1500 or 2000 parts, etc.
> > >
> > > Has anyone experienced this same problem?
> > > How do you work around this limitation?
> > > Vantage version 8.0.3.409C
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
[Non-text portions of this message have been removed]