From what I've seen so far, Vantage addresses subcontract processing in a very limited fashion. Our business scenario includes a Top level assy with several outside processing sequential operations.
We typically ship out the the top-level assy to get parts welded on or other treatments along with a drawing/instruction number that get shipped out on then come back to us. The problem is that in Vantage, Subcontract Shipment entry- pack slip prints out the finished good part and not the actual list of materials that you ship out to the supplier to perform the welding/treatment operation. I've listed this as a call with Epicor and they've acknowledged the product limitations including the incorrect pack slip printing. I've tried customizing the Crystal rpt (SubCPack.rpt) to add the JobMtl table and I cannot get any data at all from this table.(I've played around with the links, joins etc. my query on an inner join works correctly)
If anyone else out there has addressed this process or this report, I would appreciate hearing about it.
Thanks
RSN
ami_miker <mrandolph@...> wrote:
I addressed this challenge with one of our clients about a year
ago. We set up the subcontact operations (anodizing, in our case)
on the jobs as normal. When it was time to send the parts out, a
single PO line be created and linked to all of the appropriate
jobs. (We would list pieces, but pounds should work.) You now have
a PO line with 4 releases totaling 500 pieces. The conversion
factor on the releases would be changed to the inverse of the total
(i.e. 1/500 or 0.002). The PO line would be described as a Lot
Charge, with a quantity of 1 and releases representing the number of
each piece being sent. Occassionally, there were some adjustments
to account for limited decimal places (don't get me started on that)
or for pieces that were significantly different in size. It did
allow us to reasonably tie the subcontracting costs to the
appropriate job without driving us nuts. The other nice thing is
that when the parts were returned, the receiver could count the
parts and confirm that everything came back. "Our Quantity" was
still 100 of part A, 200 of Part B, 50 of Part C and 150 of Part D.
I can go into more detail if you need, but that's basically how we
got it to work.
Michael Randolph
Infinity Business Consulting
mrandolph@...
865-329-3000
We typically ship out the the top-level assy to get parts welded on or other treatments along with a drawing/instruction number that get shipped out on then come back to us. The problem is that in Vantage, Subcontract Shipment entry- pack slip prints out the finished good part and not the actual list of materials that you ship out to the supplier to perform the welding/treatment operation. I've listed this as a call with Epicor and they've acknowledged the product limitations including the incorrect pack slip printing. I've tried customizing the Crystal rpt (SubCPack.rpt) to add the JobMtl table and I cannot get any data at all from this table.(I've played around with the links, joins etc. my query on an inner join works correctly)
If anyone else out there has addressed this process or this report, I would appreciate hearing about it.
Thanks
RSN
ami_miker <mrandolph@...> wrote:
I addressed this challenge with one of our clients about a year
ago. We set up the subcontact operations (anodizing, in our case)
on the jobs as normal. When it was time to send the parts out, a
single PO line be created and linked to all of the appropriate
jobs. (We would list pieces, but pounds should work.) You now have
a PO line with 4 releases totaling 500 pieces. The conversion
factor on the releases would be changed to the inverse of the total
(i.e. 1/500 or 0.002). The PO line would be described as a Lot
Charge, with a quantity of 1 and releases representing the number of
each piece being sent. Occassionally, there were some adjustments
to account for limited decimal places (don't get me started on that)
or for pieces that were significantly different in size. It did
allow us to reasonably tie the subcontracting costs to the
appropriate job without driving us nuts. The other nice thing is
that when the parts were returned, the receiver could count the
parts and confirm that everything came back. "Our Quantity" was
still 100 of part A, 200 of Part B, 50 of Part C and 150 of Part D.
I can go into more detail if you need, but that's basically how we
got it to work.
Michael Randolph
Infinity Business Consulting
mrandolph@...
865-329-3000
--- In vantage@yahoogroups.com, "Mitchell Kirby" <m.kirby@...> wrote:
>
> All of our parts are heat treated which is billed by material by
weight.
> Each routing has a subcontract operation to aid in scheduling but
we expense
> the heat treat costs. We issue a manual PO for tracking purposes
but we
> don't allocate the costs directly to the job. Heat treat costs
are in the
> overhead.
>
>
>
> Not the most accurate costing method but it works for us. We
decided long
> ago that keeping track of actual heat treat costs was more trouble
than it
> was worth. We have considered coming up with an average cost by
pound
> regardless of material to make standard costs more accurate. I
still don't
> intend to try to compare actual to standard.
>
>
>
> Just a thought.
>
>
>
> Sincerely,
>
>
>
> Mitchell Kirby
>
> Riten Industries, Inc.
>
> <http://www.riten.com/> www.riten.com
>
>
>
> 740-333-8719 Direct
>
> 800-338-0027 Sales
>
> 800-338-0717 FAX
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Lou Laird
> Sent: Tuesday, October 03, 2006 10:07 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Subcontract operations
>
>
>
> We have a process of Galvanizing our parts and assemblies, this is
paid for
> by weight.
> Every part/assembly has a different weight. We have over 40,000
different
> parts/assemblies. From what we can see each one would require it's
own
> purchase order or line on a purchase order.
>
> Does anyone know of a way to have one PO/Line to receive
subcontract
> operation in pounds for eaches on parts/assemblies.
>
>
> ---------------------------------
> Get your email and more, right on the new Yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]