Calc Avg Cost on Make to Order Jobs

Yahoo Archive
1
If you've studied the original book Utopia by Sir Thomas Moore, you know that "Utopia" translated in Greek is "no place" meaning it's a place that doesn't exist. So back to reality...

There is the other option I mentioned about putting the parts in inventory before shipping. It's an extra transaction and there may be other side effects but it will get you an average cost update. HOWEVER, as you my know, average cost is only the average cost of all parts currently in inventory. Also, if there is never any existing inventory when you do the receipt, it effectively becomes last cost. So with low qty in stock at any given time, I'm still not sure you're going to get what you're looking for in terms of cost history.

If it were me, I would report my way out of this hole.

Chris

--- In vantage@yahoogroups.com, "Brian Schroeder" <brian.schroeder@...> wrote:
>
> There are times that we sell these glass pieces individually, so then how do I get a true average cost if these subassemblies are not factored in? Also, when we are using Vista to do quotes, if there are not accurate avg costs for each piece, then there is no point in using quotes in Vista.
>
> Maybe I am trying to live in Utopia, but I don't want to have to have my users run a report when I could just have them look at the part tracker to get avg costs for each piece.
>
> Am I just going to have to create this report or is there another way?
>
> Any help is great! I am still getting my feet wet with this stuff, so thanks for your patience & explanations in helping me better understand.
>
> Thanks to all!
> Brian
>
> --- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@> wrote:
> >
> > Im with chris, that's a simple crystal report to look at job history to
> > get average costs..
> >
> >
> >
> > Rob Bucek
> >
> > Manufacturing Engineer
> >
> > PH: 715-284-5376 ext 311
> >
> > FAX: 715-284-4084
> >
> > <http://www.dsmfg.com/>
> >
> > (Click the logo to view our site)
2
Here is what I want to accomplish.

I would like to have Vista adjust/modify the finished parts average cost when we do a job that is Make to Order, Make to Job or a subassembly.

When a job is `Make to Stock' and when that part is received into inventory, that parts average cost is updated. When the job is `Make to Order', when that part is `shipped' from that job, that parts cost is send directly to the correct COGS account, and the average cost of that part is never touched. When the job is `Make to Job', when the part (job) is received to the higher level job, the cost is rolled up and resent into WIP Materials account because it is part of a higher level job, and again the average cost of that part is never touched. When a job has subassemblies, those subassemblies costs are just rolled up into the higher level costs, and the average cost of the subassembly part is never touched.

Can we add a `trigger' to any of the above job process types to also create and/or update that parts average cost?

Any help/suggestion would be greatly apprecaited.

Thanks much!
Brian
3
if the items will never be 'on hand' why should it effect inventory value?


BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell



________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Schroeder
Sent: Thursday, April 02, 2009 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calc Avg Cost on Make to Order Jobs


Here is what I want to accomplish.

I would like to have Vista adjust/modify the finished parts average cost when we do a job that is Make to Order, Make to Job or a subassembly.

When a job is `Make to Stock' and when that part is received into inventory, that parts average cost is updated. When the job is `Make to Order', when that part is `shipped' from that job, that parts cost is send directly to the correct COGS account, and the average cost of that part is never touched. When the job is `Make to Job', when the part (job) is received to the higher level job, the cost is rolled up and resent into WIP Materials account because it is part of a higher level job, and again the average cost of that part is never touched. When a job has subassemblies, those subassemblies costs are just rolled up into the higher level costs, and the average cost of the subassembly part is never touched.

Can we add a `trigger' to any of the above job process types to also create and/or update that parts average cost?

Any help/suggestion would be greatly apprecaited.

Thanks much!
Brian




________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.


[Non-text portions of this message have been removed]
4
We want to have the avg cost calculate for history/tracking sake. We make large distillation systems and we usually don't make the glass stock parts until we need them (because they are costly). Now we do have an average cost, but now it is about a year old because every time we build one (say one or two a month), these glass parts are subassemblies than never get to be part of the average costs...we all know how materials change price often...some more than others.

Any help is much appreciated.

Thanks,
Brian



--- In vantage@yahoogroups.com, Bill King <bking@...> wrote:
>
> if the items will never be 'on hand' why should it effect inventory value?
>
>
> BILL R. KING
> J&B Industrial Services
> (806).776.4409 Office
> (254).592.4397 Cell
>
>
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Schroeder
> Sent: Thursday, April 02, 2009 10:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Calc Avg Cost on Make to Order Jobs
>
>
> Here is what I want to accomplish.
>
> I would like to have Vista adjust/modify the finished parts average cost when we do a job that is Make to Order, Make to Job or a subassembly.
>
> When a job is `Make to Stock' and when that part is received into inventory, that parts average cost is updated. When the job is `Make to Order', when that part is `shipped' from that job, that parts cost is send directly to the correct COGS account, and the average cost of that part is never touched. When the job is `Make to Job', when the part (job) is received to the higher level job, the cost is rolled up and resent into WIP Materials account because it is part of a higher level job, and again the average cost of that part is never touched. When a job has subassemblies, those subassemblies costs are just rolled up into the higher level costs, and the average cost of the subassembly part is never touched.
>
> Can we add a `trigger' to any of the above job process types to also create and/or update that parts average cost?
>
> Any help/suggestion would be greatly apprecaited.
>
> Thanks much!
> Brian
>
>
>
>
> ________________________________
> The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
> We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.
>
> This message (including any attachments) is intended only for
> the use of the individual or entity to which it is addressed and
> may contain information that is non-public, proprietary,
> privileged, confidential, and exempt from disclosure under
> applicable law or may constitute as attorney work product.
> If you are not the intended recipient, you are hereby notified
> that any use, dissemination, distribution, or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, notify us immediately by telephone and
> (i) destroy this message if a facsimile or (ii) delete this message
> immediately if this is an electronic communication.
>
> Thank you.
>
>
> [Non-text portions of this message have been removed]
>
5
I may be stating the obvious but if you want to update average cost for make-to-order, put the parts in inventory before you ship. Although, I'm not sure why you can't use job costs if you want to look back at history. Average cost by job isn't calculated by Vantage but that would be easy enough for a custom report.

Chris



--- In vantage@yahoogroups.com, "Brian Schroeder" <brian.schroeder@...> wrote:
>
> We want to have the avg cost calculate for history/tracking sake. We make large distillation systems and we usually don't make the glass stock parts until we need them (because they are costly). Now we do have an average cost, but now it is about a year old because every time we build one (say one or two a month), these glass parts are subassemblies than never get to be part of the average costs...we all know how materials change price often...some more than others.
>
> Any help is much appreciated.
>
> Thanks,
> Brian
>
>
>
> --- In vantage@yahoogroups.com, Bill King <bking@> wrote:
> >
> > if the items will never be 'on hand' why should it effect inventory value?
> >
> >
> > BILL R. KING
> > J&B Industrial Services
> > (806).776.4409 Office
> > (254).592.4397 Cell
> >
> >
> >
> > ________________________________
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Schroeder
> > Sent: Thursday, April 02, 2009 10:59 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Calc Avg Cost on Make to Order Jobs
> >
> >
> > Here is what I want to accomplish.
> >
> > I would like to have Vista adjust/modify the finished parts average cost when we do a job that is Make to Order, Make to Job or a subassembly.
> >
> > When a job is `Make to Stock' and when that part is received into inventory, that parts average cost is updated. When the job is `Make to Order', when that part is `shipped' from that job, that parts cost is send directly to the correct COGS account, and the average cost of that part is never touched. When the job is `Make to Job', when the part (job) is received to the higher level job, the cost is rolled up and resent into WIP Materials account because it is part of a higher level job, and again the average cost of that part is never touched. When a job has subassemblies, those subassemblies costs are just rolled up into the higher level costs, and the average cost of the subassembly part is never touched.
> >
> > Can we add a `trigger' to any of the above job process types to also create and/or update that parts average cost?
> >
> > Any help/suggestion would be greatly apprecaited.
> >
> > Thanks much!
> > Brian
> >
> >
> >
> >
> > ________________________________
> > The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
> > We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.
> >
> > This message (including any attachments) is intended only for
> > the use of the individual or entity to which it is addressed and
> > may contain information that is non-public, proprietary,
> > privileged, confidential, and exempt from disclosure under
> > applicable law or may constitute as attorney work product.
> > If you are not the intended recipient, you are hereby notified
> > that any use, dissemination, distribution, or copying of this
> > communication is strictly prohibited. If you have received this
> > communication in error, notify us immediately by telephone and
> > (i) destroy this message if a facsimile or (ii) delete this message
> > immediately if this is an electronic communication.
> >
> > Thank you.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
6
Im with chris, that's a simple crystal report to look at job history to
get average costs..



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of saab_barracuda
Sent: Thursday, April 02, 2009 12:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Calc Avg Cost on Make to Order Jobs



I may be stating the obvious but if you want to update average cost for
make-to-order, put the parts in inventory before you ship. Although, I'm
not sure why you can't use job costs if you want to look back at
history. Average cost by job isn't calculated by Vantage but that would
be easy enough for a custom report.

Chris

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian Schroeder" <brian.schroeder@...> wrote:
>
> We want to have the avg cost calculate for history/tracking sake. We
make large distillation systems and we usually don't make the glass
stock parts until we need them (because they are costly). Now we do have
an average cost, but now it is about a year old because every time we
build one (say one or two a month), these glass parts are subassemblies
than never get to be part of the average costs...we all know how
materials change price often...some more than others.
>
> Any help is much appreciated.
>
> Thanks,
> Brian
>
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Bill King <bking@> wrote:
> >
> > if the items will never be 'on hand' why should it effect inventory
value?
> >
> >
> > BILL R. KING
> > J&B Industrial Services
> > (806).776.4409 Office
> > (254).592.4397 Cell
> >
> >
> >
> > ________________________________
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Brian Schroeder
> > Sent: Thursday, April 02, 2009 10:59 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Calc Avg Cost on Make to Order Jobs
> >
> >
> > Here is what I want to accomplish.
> >
> > I would like to have Vista adjust/modify the finished parts average
cost when we do a job that is Make to Order, Make to Job or a
subassembly.
> >
> > When a job is `Make to Stock' and when that part is received into
inventory, that parts average cost is updated. When the job is `Make to
Order', when that part is `shipped' from that job, that parts cost is
send directly to the correct COGS account, and the average cost of that
part is never touched. When the job is `Make to Job', when the part
(job) is received to the higher level job, the cost is rolled up and
resent into WIP Materials account because it is part of a higher level
job, and again the average cost of that part is never touched. When a
job has subassemblies, those subassemblies costs are just rolled up into
the higher level costs, and the average cost of the subassembly part is
never touched.
> >
> > Can we add a `trigger' to any of the above job process types to also
create and/or update that parts average cost?
> >
> > Any help/suggestion would be greatly apprecaited.
> >
> > Thanks much!
> > Brian
> >
> >
> >
> >
> > ________________________________
> > The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
> > We have taken precautions to minimize the risk of transmitting
software viruses, but we advise you to carry out your own virus checks
on any attachment to this message. We cannot accept liability for any
loss or damage caused by software viruses.
> >
> > This message (including any attachments) is intended only for
> > the use of the individual or entity to which it is addressed and
> > may contain information that is non-public, proprietary,
> > privileged, confidential, and exempt from disclosure under
> > applicable law or may constitute as attorney work product.
> > If you are not the intended recipient, you are hereby notified
> > that any use, dissemination, distribution, or copying of this
> > communication is strictly prohibited. If you have received this
> > communication in error, notify us immediately by telephone and
> > (i) destroy this message if a facsimile or (ii) delete this message
> > immediately if this is an electronic communication.
> >
> > Thank you.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>





[Non-text portions of this message have been removed]
7
There are times that we sell these glass pieces individually, so then how do I get a true average cost if these subassemblies are not factored in? Also, when we are using Vista to do quotes, if there are not accurate avg costs for each piece, then there is no point in using quotes in Vista.

Maybe I am trying to live in Utopia, but I don't want to have to have my users run a report when I could just have them look at the part tracker to get avg costs for each piece.

Am I just going to have to create this report or is there another way?

Any help is great! I am still getting my feet wet with this stuff, so thanks for your patience & explanations in helping me better understand.

Thanks to all!
Brian

--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> Im with chris, that's a simple crystal report to look at job history to
> get average costs..
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of saab_barracuda
> Sent: Thursday, April 02, 2009 12:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Calc Avg Cost on Make to Order Jobs
>
>
>
> I may be stating the obvious but if you want to update average cost for
> make-to-order, put the parts in inventory before you ship. Although, I'm
> not sure why you can't use job costs if you want to look back at
> history. Average cost by job isn't calculated by Vantage but that would
> be easy enough for a custom report.
>
> Chris
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Brian Schroeder" <brian.schroeder@> wrote:
> >
> > We want to have the avg cost calculate for history/tracking sake. We
> make large distillation systems and we usually don't make the glass
> stock parts until we need them (because they are costly). Now we do have
> an average cost, but now it is about a year old because every time we
> build one (say one or two a month), these glass parts are subassemblies
> than never get to be part of the average costs...we all know how
> materials change price often...some more than others.
> >
> > Any help is much appreciated.
> >
> > Thanks,
> > Brian
> >
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> Bill King <bking@> wrote:
> > >
> > > if the items will never be 'on hand' why should it effect inventory
> value?
> > >
> > >
> > > BILL R. KING
> > > J&B Industrial Services
> > > (806).776.4409 Office
> > > (254).592.4397 Cell
> > >
> > >
> > >
> > > ________________________________
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of Brian Schroeder
> > > Sent: Thursday, April 02, 2009 10:59 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Calc Avg Cost on Make to Order Jobs
> > >
> > >
> > > Here is what I want to accomplish.
> > >
> > > I would like to have Vista adjust/modify the finished parts average
> cost when we do a job that is Make to Order, Make to Job or a
> subassembly.
> > >
> > > When a job is `Make to Stock' and when that part is received into
> inventory, that parts average cost is updated. When the job is `Make to
> Order', when that part is `shipped' from that job, that parts cost is
> send directly to the correct COGS account, and the average cost of that
> part is never touched. When the job is `Make to Job', when the part
> (job) is received to the higher level job, the cost is rolled up and
> resent into WIP Materials account because it is part of a higher level
> job, and again the average cost of that part is never touched. When a
> job has subassemblies, those subassemblies costs are just rolled up into
> the higher level costs, and the average cost of the subassembly part is
> never touched.
> > >
> > > Can we add a `trigger' to any of the above job process types to also
> create and/or update that parts average cost?
> > >
> > > Any help/suggestion would be greatly apprecaited.
> > >
> > > Thanks much!
> > > Brian
> > >
> > >
> > >
> > >
> > > ________________________________
> > > The information contained in this message is intended solely for the
> individual to whom it is specifically and originally addressed. This
> message and its contents may contain confidential or privileged
> information. If you are not the intended recipient, you are hereby
> notified that any disclosure or distribution, or taking any action in
> reliance on the contents of this information, is strictly prohibited.
> > > We have taken precautions to minimize the risk of transmitting
> software viruses, but we advise you to carry out your own virus checks
> on any attachment to this message. We cannot accept liability for any
> loss or damage caused by software viruses.
> > >
> > > This message (including any attachments) is intended only for
> > > the use of the individual or entity to which it is addressed and
> > > may contain information that is non-public, proprietary,
> > > privileged, confidential, and exempt from disclosure under
> > > applicable law or may constitute as attorney work product.
> > > If you are not the intended recipient, you are hereby notified
> > > that any use, dissemination, distribution, or copying of this
> > > communication is strictly prohibited. If you have received this
> > > communication in error, notify us immediately by telephone and
> > > (i) destroy this message if a facsimile or (ii) delete this message
> > > immediately if this is an electronic communication.
> > >
> > > Thank you.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
8
Embed a dashboard with a summarized average job cost in the part
advisor? That or embed the crystal report in that dashboard which you
can embed in the tracker...



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Schroeder
Sent: Thursday, April 02, 2009 1:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Calc Avg Cost on Make to Order Jobs



There are times that we sell these glass pieces individually, so then
how do I get a true average cost if these subassemblies are not factored
in? Also, when we are using Vista to do quotes, if there are not
accurate avg costs for each piece, then there is no point in using
quotes in Vista.

Maybe I am trying to live in Utopia, but I don't want to have to have my
users run a report when I could just have them look at the part tracker
to get avg costs for each piece.

Am I just going to have to create this report or is there another way?

Any help is great! I am still getting my feet wet with this stuff, so
thanks for your patience & explanations in helping me better understand.

Thanks to all!
Brian

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Rob
Bucek" <rbucek@...> wrote:
>
> Im with chris, that's a simple crystal report to look at job history
to
> get average costs..
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg.com/ <http://www.dsmfg.com/> >
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of saab_barracuda
> Sent: Thursday, April 02, 2009 12:05 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Calc Avg Cost on Make to Order Jobs
>
>
>
> I may be stating the obvious but if you want to update average cost
for
> make-to-order, put the parts in inventory before you ship. Although,
I'm
> not sure why you can't use job costs if you want to look back at
> history. Average cost by job isn't calculated by Vantage but that
would
> be easy enough for a custom report.
>
> Chris
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Brian Schroeder" <brian.schroeder@> wrote:
> >
> > We want to have the avg cost calculate for history/tracking sake. We
> make large distillation systems and we usually don't make the glass
> stock parts until we need them (because they are costly). Now we do
have
> an average cost, but now it is about a year old because every time we
> build one (say one or two a month), these glass parts are
subassemblies
> than never get to be part of the average costs...we all know how
> materials change price often...some more than others.
> >
> > Any help is much appreciated.
> >
> > Thanks,
> > Brian
> >
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> Bill King <bking@> wrote:
> > >
> > > if the items will never be 'on hand' why should it effect
inventory
> value?
> > >
> > >
> > > BILL R. KING
> > > J&B Industrial Services
> > > (806).776.4409 Office
> > > (254).592.4397 Cell
> > >
> > >
> > >
> > > ________________________________
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of Brian Schroeder
> > > Sent: Thursday, April 02, 2009 10:59 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Calc Avg Cost on Make to Order Jobs
> > >
> > >
> > > Here is what I want to accomplish.
> > >
> > > I would like to have Vista adjust/modify the finished parts
average
> cost when we do a job that is Make to Order, Make to Job or a
> subassembly.
> > >
> > > When a job is `Make to Stock' and when that part is received into
> inventory, that parts average cost is updated. When the job is `Make
to
> Order', when that part is `shipped' from that job, that parts cost is
> send directly to the correct COGS account, and the average cost of
that
> part is never touched. When the job is `Make to Job', when the part
> (job) is received to the higher level job, the cost is rolled up and
> resent into WIP Materials account because it is part of a higher level
> job, and again the average cost of that part is never touched. When a
> job has subassemblies, those subassemblies costs are just rolled up
into
> the higher level costs, and the average cost of the subassembly part
is
> never touched.
> > >
> > > Can we add a `trigger' to any of the above job process types to
also
> create and/or update that parts average cost?
> > >
> > > Any help/suggestion would be greatly apprecaited.
> > >
> > > Thanks much!
> > > Brian
> > >
> > >
> > >
> > >
> > > ________________________________
> > > The information contained in this message is intended solely for
the
> individual to whom it is specifically and originally addressed. This
> message and its contents may contain confidential or privileged
> information. If you are not the intended recipient, you are hereby
> notified that any disclosure or distribution, or taking any action in
> reliance on the contents of this information, is strictly prohibited.
> > > We have taken precautions to minimize the risk of transmitting
> software viruses, but we advise you to carry out your own virus checks
> on any attachment to this message. We cannot accept liability for any
> loss or damage caused by software viruses.
> > >
> > > This message (including any attachments) is intended only for
> > > the use of the individual or entity to which it is addressed and
> > > may contain information that is non-public, proprietary,
> > > privileged, confidential, and exempt from disclosure under
> > > applicable law or may constitute as attorney work product.
> > > If you are not the intended recipient, you are hereby notified
> > > that any use, dissemination, distribution, or copying of this
> > > communication is strictly prohibited. If you have received this
> > > communication in error, notify us immediately by telephone and
> > > (i) destroy this message if a facsimile or (ii) delete this
message
> > > immediately if this is an electronic communication.
> > >
> > > Thank you.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
9
Since I am still learning the hard way, how do I do that the quickest and/or easiest way? (Loaded question...I know)
Brian

--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> Embed a dashboard with a summarized average job cost in the part
> advisor? That or embed the crystal report in that dashboard which you
> can embed in the tracker...
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Brian Schroeder
> Sent: Thursday, April 02, 2009 1:18 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Calc Avg Cost on Make to Order Jobs
>
>
>
> There are times that we sell these glass pieces individually, so then
> how do I get a true average cost if these subassemblies are not factored
> in? Also, when we are using Vista to do quotes, if there are not
> accurate avg costs for each piece, then there is no point in using
> quotes in Vista.
>
> Maybe I am trying to live in Utopia, but I don't want to have to have my
> users run a report when I could just have them look at the part tracker
> to get avg costs for each piece.
>
> Am I just going to have to create this report or is there another way?
>
> Any help is great! I am still getting my feet wet with this stuff, so
> thanks for your patience & explanations in helping me better understand.
>
> Thanks to all!
> Brian
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Rob
> Bucek" <rbucek@> wrote:
> >
> > Im with chris, that's a simple crystal report to look at job history
> to
> > get average costs..
> >
> >
> >
> > Rob Bucek
> >
> > Manufacturing Engineer
> >
> > PH: 715-284-5376 ext 311
> >
> > FAX: 715-284-4084
> >
> > <http://www.dsmfg.com/ <http://www.dsmfg.com/> >
> >
> > (Click the logo to view our site)
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of saab_barracuda
> > Sent: Thursday, April 02, 2009 12:05 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Calc Avg Cost on Make to Order Jobs
> >
> >
> >
> > I may be stating the obvious but if you want to update average cost
> for
> > make-to-order, put the parts in inventory before you ship. Although,
> I'm
> > not sure why you can't use job costs if you want to look back at
> > history. Average cost by job isn't calculated by Vantage but that
> would
> > be easy enough for a custom report.
> >
> > Chris
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "Brian Schroeder" <brian.schroeder@> wrote:
> > >
> > > We want to have the avg cost calculate for history/tracking sake. We
> > make large distillation systems and we usually don't make the glass
> > stock parts until we need them (because they are costly). Now we do
> have
> > an average cost, but now it is about a year old because every time we
> > build one (say one or two a month), these glass parts are
> subassemblies
> > than never get to be part of the average costs...we all know how
> > materials change price often...some more than others.
> > >
> > > Any help is much appreciated.
> > >
> > > Thanks,
> > > Brian
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > Bill King <bking@> wrote:
> > > >
> > > > if the items will never be 'on hand' why should it effect
> inventory
> > value?
> > > >
> > > >
> > > > BILL R. KING
> > > > J&B Industrial Services
> > > > (806).776.4409 Office
> > > > (254).592.4397 Cell
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of Brian Schroeder
> > > > Sent: Thursday, April 02, 2009 10:59 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Calc Avg Cost on Make to Order Jobs
> > > >
> > > >
> > > > Here is what I want to accomplish.
> > > >
> > > > I would like to have Vista adjust/modify the finished parts
> average
> > cost when we do a job that is Make to Order, Make to Job or a
> > subassembly.
> > > >
> > > > When a job is `Make to Stock' and when that part is received into
> > inventory, that parts average cost is updated. When the job is `Make
> to
> > Order', when that part is `shipped' from that job, that parts cost is
> > send directly to the correct COGS account, and the average cost of
> that
> > part is never touched. When the job is `Make to Job', when the part
> > (job) is received to the higher level job, the cost is rolled up and
> > resent into WIP Materials account because it is part of a higher level
> > job, and again the average cost of that part is never touched. When a
> > job has subassemblies, those subassemblies costs are just rolled up
> into
> > the higher level costs, and the average cost of the subassembly part
> is
> > never touched.
> > > >
> > > > Can we add a `trigger' to any of the above job process types to
> also
> > create and/or update that parts average cost?
> > > >
> > > > Any help/suggestion would be greatly apprecaited.
> > > >
> > > > Thanks much!
> > > > Brian
> > > >
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > The information contained in this message is intended solely for
> the
> > individual to whom it is specifically and originally addressed. This
> > message and its contents may contain confidential or privileged
> > information. If you are not the intended recipient, you are hereby
> > notified that any disclosure or distribution, or taking any action in
> > reliance on the contents of this information, is strictly prohibited.
> > > > We have taken precautions to minimize the risk of transmitting
> > software viruses, but we advise you to carry out your own virus checks
> > on any attachment to this message. We cannot accept liability for any
> > loss or damage caused by software viruses.
> > > >
> > > > This message (including any attachments) is intended only for
> > > > the use of the individual or entity to which it is addressed and
> > > > may contain information that is non-public, proprietary,
> > > > privileged, confidential, and exempt from disclosure under
> > > > applicable law or may constitute as attorney work product.
> > > > If you are not the intended recipient, you are hereby notified
> > > > that any use, dissemination, distribution, or copying of this
> > > > communication is strictly prohibited. If you have received this
> > > > communication in error, notify us immediately by telephone and
> > > > (i) destroy this message if a facsimile or (ii) delete this
> message
> > > > immediately if this is an electronic communication.
> > > >
> > > > Thank you.
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>