Cost Adjustments

Yahoo Archive
1
We have Vantage 8.03.409C. What you can do is uncheck the the use inventory reason codes in the company setup. Upload the cost for your parts and then when finish, check the use inventory reason codes in company setup under inventory module.

Jose

--- In vantage@yahoogroups.com, "Vic Drecchio" wrote:
>
> Are you SQL? If so, yes.
>
>
>
> (hush, Jose) :-)
>
>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Ken Dumesnil
> Sent: Monday, January 14, 2013 3:53 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Cost Adjustments
>
>
>
>
>
> Hi,
>
> We are running 9.05.700B and I'm trying to mass update the cost of parts.
> Does anyone know of a way to do this other than doing them individually? I
> have tried DMT (no updates only new allowed), Paste Update from List View
> (getting invalid Reason Code) and an Updateable BAQ. All which have
> failed.
>
> Any help with this would be appreciated.
>
> Thanks,
>
> Ken
>
> [Non-text portions of this message have been removed]
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2638/5532 - Release Date: 01/14/13
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2638/5532 - Release Date: 01/14/13
>
> [Non-text portions of this message have been removed]
>
2
When are the Average/Lot and Last fields updated in the Cost
Adjustment screen for Manufactured Parts.

Is there a program thats needs to be run or does it happen when the
job is marked complete or closed out by accounting or ??????

thanks
3
--- In vantage@yahoogroups.com, "homestyleindustries"
<homestyleindustries@...> wrote:
>
>
I agree with the Standard side that it comes from your cost roll ups
but I am talking about Average and Last Costs columns on the Cost
Adjustment Screen.

I would think Last would be what it cost you the last time you made
the part and average would be the average cost to make it.

Reason I am asking is because I found a part that we have made but
nothing shows up in the last or average fields. While other parts we
make there is information in those 2 fields.

Just trying to get an idea of how it works

Thanks for your reply



> These fields do not update themselves. Whatever you enter becomes
the
> new cost for those parts. The defaults come from the part master
> file.
>
>
>
> --- In vantage@yahoogroups.com, "Marty" <marty1325@> wrote:
> >
> > When are the Average/Lot and Last fields updated in the Cost
> > Adjustment screen for Manufactured Parts.
> >
> > Is there a program thats needs to be run or does it happen when
the
> > job is marked complete or closed out by accounting or ??????
> >
> > thanks
> >
>
4
--- In vantage@yahoogroups.com, "homestyleindustries"
<homestyleindustries@...> wrote:
>
>
I agree with the Standard side that it comes from your cost roll ups
but I am talking about Average and Last Costs columns on the Cost
Adjustment Screen.

I would think Last would be what it cost you the last time you made
the part and average would be the average cost to make it.

Reason I am asking is because I found a part that we have made but
nothing shows up in the last or average fields. While other parts we
make there is information in those 2 fields.

Just trying to get an idea of how it works

Thanks for your reply



> These fields do not update themselves. Whatever you enter becomes
the
> new cost for those parts. The defaults come from the part master
> file.
>
>
>
> --- In vantage@yahoogroups.com, "Marty" <marty1325@> wrote:
> >
> > When are the Average/Lot and Last fields updated in the Cost
> > Adjustment screen for Manufactured Parts.
> >
> > Is there a program thats needs to be run or does it happen when
the
> > job is marked complete or closed out by accounting or ??????
> >
> > thanks
> >
>
5
Did the part every go into inventory? If it's made on a subassembly or
shipped from the job, Vantage won't update the costs. The same is true
if a part is bought directly to a job.

-Liz


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Marty
Sent: Thursday, September 04, 2008 01:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Cost Adjustments



--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"homestyleindustries"
<homestyleindustries@...> wrote:
>
>
I agree with the Standard side that it comes from your cost roll ups
but I am talking about Average and Last Costs columns on the Cost
Adjustment Screen.

I would think Last would be what it cost you the last time you made
the part and average would be the average cost to make it.

Reason I am asking is because I found a part that we have made but
nothing shows up in the last or average fields. While other parts we
make there is information in those 2 fields.

Just trying to get an idea of how it works

Thanks for your reply

> These fields do not update themselves. Whatever you enter becomes
the
> new cost for those parts. The defaults come from the part master
> file.
>
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Marty" <marty1325@> wrote:
> >
> > When are the Average/Lot and Last fields updated in the Cost
> > Adjustment screen for Manufactured Parts.
> >
> > Is there a program thats needs to be run or does it happen when
the
> > job is marked complete or closed out by accounting or ??????
> >
> > thanks
> >
>






[Non-text portions of this message have been removed]
6
This is a topic that I'm very interested in at the moment as I'm
having to work out all sorts of costs.

A manufactured part will not update its avg/last costs, unless (I
think) it goes into inventory, shipping the final manufactured part
out to a customer does not update the avg/last cost.

The avg/last costs are only updated when a part has been received, so
that's something you bought via a purchase order and then received to
stock/your warehouse.

Personaly I don't like the avg cost, with the costs of materials such
as steel increasing al the time I prefere the last cost which is from
when the material was last purchased (when something doubles in price
in a year I think the avg costs is just bs).

I'l looking forward to Epicor 9 as it is supposed to have fifo :)

--- In vantage@yahoogroups.com, "Elizabeth Hahn" <ehahn@...> wrote:
>
> Did the part every go into inventory? If it's made on a
subassembly or
> shipped from the job, Vantage won't update the costs. The same is
true
> if a part is bought directly to a job.
>
> -Liz
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Marty
> Sent: Thursday, September 04, 2008 01:46 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Cost Adjustments
>
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "homestyleindustries"
> <homestyleindustries@> wrote:
> >
> >
> I agree with the Standard side that it comes from your cost roll
ups
> but I am talking about Average and Last Costs columns on the Cost
> Adjustment Screen.
>
> I would think Last would be what it cost you the last time you made
> the part and average would be the average cost to make it.
>
> Reason I am asking is because I found a part that we have made but
> nothing shows up in the last or average fields. While other parts
we
> make there is information in those 2 fields.
>
> Just trying to get an idea of how it works
>
> Thanks for your reply
>
> > These fields do not update themselves. Whatever you enter becomes
> the
> > new cost for those parts. The defaults come from the part master
> > file.
> >
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> "Marty" <marty1325@> wrote:
> > >
> > > When are the Average/Lot and Last fields updated in the Cost
> > > Adjustment screen for Manufactured Parts.
> > >
> > > Is there a program thats needs to be run or does it happen when
> the
> > > job is marked complete or closed out by accounting or ??????
> > >
> > > thanks
> > >
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
Don't get too excited about fifo from Epicor. My wife works with a company that uses another Epicor product, iScala. They use fifo and it either does not work, or they had to do a lot of workarounds to make it work. My understanding is that Epicor is trying to unify all their product lines. To the extent they are integrating the fifo part of iScala into Vantage/Vista, it may have problems.

Thom Rose
Controller
Electric Mirror, LLC
T 425 776-4946 ext. 1024
A 11831 Beverly Park Road, Building D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com/>
Note: The information contained in this e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use. www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of clive.1972
Sent: Friday, September 05, 2008 12:24 AM
To: vantage@yahoogroups.com
Subject: {Disarmed} [Vantage] Re: Cost Adjustments


This is a topic that I'm very interested in at the moment as I'm
having to work out all sorts of costs.

A manufactured part will not update its avg/last costs, unless (I
think) it goes into inventory, shipping the final manufactured part
out to a customer does not update the avg/last cost.

The avg/last costs are only updated when a part has been received, so
that's something you bought via a purchase order and then received to
stock/your warehouse.

Personaly I don't like the avg cost, with the costs of materials such
as steel increasing al the time I prefere the last cost which is from
when the material was last purchased (when something doubles in price
in a year I think the avg costs is just bs).

I'l looking forward to Epicor 9 as it is supposed to have fifo :)

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Elizabeth Hahn" <ehahn@...> wrote:
>
> Did the part every go into inventory? If it's made on a
subassembly or
> shipped from the job, Vantage won't update the costs. The same is
true
> if a part is bought directly to a job.
>
> -Liz
>
>
> ________________________________
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
Behalf
> Of Marty
> Sent: Thursday, September 04, 2008 01:46 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Cost Adjustments
>
>
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
> "homestyleindustries"
> <homestyleindustries@> wrote:
> >
> >
> I agree with the Standard side that it comes from your cost roll
ups
> but I am talking about Average and Last Costs columns on the Cost
> Adjustment Screen.
>
> I would think Last would be what it cost you the last time you made
> the part and average would be the average cost to make it.
>
> Reason I am asking is because I found a part that we have made but
> nothing shows up in the last or average fields. While other parts
we
> make there is information in those 2 fields.
>
> Just trying to get an idea of how it works
>
> Thanks for your reply
>
> > These fields do not update themselves. Whatever you enter becomes
> the
> > new cost for those parts. The defaults come from the part master
> > file.
> >
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%
40yahoogroups.com> ,
> "Marty" <marty1325@> wrote:
> > >
> > > When are the Average/Lot and Last fields updated in the Cost
> > > Adjustment screen for Manufactured Parts.
> > >
> > > Is there a program thats needs to be run or does it happen when
> the
> > > job is marked complete or closed out by accounting or ??????
> > >
> > > thanks
> > >
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
8
Not good news :(

Not to worry though as I'm going nowhere near 'Epicor 9' until it's
been out for a good year or so, they may have sorted out fifo by
then ;)

--- In vantage@yahoogroups.com, Thomas Rose <t.rose@...> wrote:
>
> Don't get too excited about fifo from Epicor. My wife works with a
company that uses another Epicor product, iScala. They use fifo and
it either does not work, or they had to do a lot of workarounds to
make it work. My understanding is that Epicor is trying to unify all
their product lines. To the extent they are integrating the fifo
part of iScala into Vantage/Vista, it may have problems.
>
> Thom Rose
> Controller
> Electric Mirror, LLC
> T 425 776-4946 ext. 1024
> A 11831 Beverly Park Road, Building D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electricmirror.com/>
> Note: The information contained in this e-mail, including any
attachments, is legally privileged and confidential. If you are not
the intended recipient you are hereby notified that any reading, use
or dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system.
Even though this e-mail and any attachments are believed to be free
of any virus or other defect that might affect any computer system
into which it is received and opened, it is the responsibility of the
recipient to ensure that it is virus free, and no responsibility is
accepted by Electric Mirror LLC for any loss or damage arising in any
way from its use.
www.electricmirror.com<http://www.electricmirror.com>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of clive.1972
> Sent: Friday, September 05, 2008 12:24 AM
> To: vantage@yahoogroups.com
> Subject: {Disarmed} [Vantage] Re: Cost Adjustments
>
>
> This is a topic that I'm very interested in at the moment as I'm
> having to work out all sorts of costs.
>
> A manufactured part will not update its avg/last costs, unless (I
> think) it goes into inventory, shipping the final manufactured part
> out to a customer does not update the avg/last cost.
>
> The avg/last costs are only updated when a part has been received,
so
> that's something you bought via a purchase order and then received
to
> stock/your warehouse.
>
> Personaly I don't like the avg cost, with the costs of materials
such
> as steel increasing al the time I prefere the last cost which is
from
> when the material was last purchased (when something doubles in
price
> in a year I think the avg costs is just bs).
>
> I'l looking forward to Epicor 9 as it is supposed to have fifo :)
>
> --- In vantage@yahoogroups.com<mailto:vantage%
40yahoogroups.com>, "Elizabeth Hahn" <ehahn@> wrote:
> >
> > Did the part every go into inventory? If it's made on a
> subassembly or
> > shipped from the job, Vantage won't update the costs. The same is
> true
> > if a part is bought directly to a job.
> >
> > -Liz
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
> Behalf
> > Of Marty
> > Sent: Thursday, September 04, 2008 01:46 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Cost Adjustments
> >
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> > "homestyleindustries"
> > <homestyleindustries@> wrote:
> > >
> > >
> > I agree with the Standard side that it comes from your cost roll
> ups
> > but I am talking about Average and Last Costs columns on the Cost
> > Adjustment Screen.
> >
> > I would think Last would be what it cost you the last time you
made
> > the part and average would be the average cost to make it.
> >
> > Reason I am asking is because I found a part that we have made but
> > nothing shows up in the last or average fields. While other parts
> we
> > make there is information in those 2 fields.
> >
> > Just trying to get an idea of how it works
> >
> > Thanks for your reply
> >
> > > These fields do not update themselves. Whatever you enter
becomes
> > the
> > > new cost for those parts. The defaults come from the part master
> > > file.
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%
40yahoogroups.com> <mailto:vantage%
> 40yahoogroups.com> ,
> > "Marty" <marty1325@> wrote:
> > > >
> > > > When are the Average/Lot and Last fields updated in the Cost
> > > > Adjustment screen for Manufactured Parts.
> > > >
> > > > Is there a program thats needs to be run or does it happen
when
> > the
> > > > job is marked complete or closed out by accounting or ??????
> > > >
> > > > thanks
> > > >
> > >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>
9
Hi,
Â
We are running 9.05.700B and I'm trying to mass update the cost of parts.  Does anyone know of a way to do this other than doing them individually?  I have tried DMT (no updates only new allowed), Paste Update from List View (getting invalid Reason Code) and an Updateable BAQ.   All which have failed.
Â
Any help with this would be appreciated.
Â
Thanks,
Â
Ken

[Non-text portions of this message have been removed]
10
We use Service Connect for our updates. Use an Excel sheet with just 4 columns for input:


PartNum UnitMatCost UnitBurden Reason
PART1 1.23 1.23 StdC
PART2 1.23 1.23 StdC


--Matt

--- In vantage@yahoogroups.com, Ken Dumesnil wrote:
>
> Hi,
> Â
> We are running 9.05.700B and I'm trying to mass update the cost of parts.  Does anyone know of a way to do this other than doing them individually?  I have tried DMT (no updates only new allowed), Paste Update from List View (getting invalid Reason Code) and an Updateable BAQ.   All which have failed.
> Â
> Any help with this would be appreciated.
> Â
> Thanks,
> Â
> Ken
>
> [Non-text portions of this message have been removed]
>
11
All Cost adjustments are new records, that is why DMT only shows it. We do them thru DMT. If the part is lot tracked, you will need the lot info in the dmt.

Greg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mattcald_73
Sent: Monday, January 14, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Cost Adjustments



We use Service Connect for our updates. Use an Excel sheet with just 4 columns for input:

PartNum UnitMatCost UnitBurden Reason
PART1 1.23 1.23 StdC
PART2 1.23 1.23 StdC

--Matt

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ken Dumesnil wrote:
>
> Hi,
>
> We are running 9.05.700B and I'm trying to mass update the cost of parts. Does anyone know of a way to do this other than doing them individually? I have tried DMT (no updates only new allowed), Paste Update from List View (getting invalid Reason Code) and an Updateable BAQ. All which have failed.
>
> Any help with this would be appreciated.
>
> Thanks,
>
> Ken
>
> [Non-text portions of this message have been removed]
>


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
12
Good Day Ken:



Paste update would work if you add a reason. If the
column is not there, you might be able to add it with customization or
maybe just personalization. Do not do all at once or it will be very
slow. Start with maybe 100 lines then increase until it slows too much.



If you have an Excel sheet, you could have Epi-Center,
or another consultant, do a quick program for you. Test for speed on
Test account first.



Or, call helpline, the DMT should work. I think. Do you
own the full DMT program?



Remember to update all non-zero cost buckets: burden,
labor, matl, etc.



Make sure you get right set: Averge vs. Standard, vs.
Last








Len



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Dumesnil
Sent: Monday, January 14, 2013 3:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Cost Adjustments





Hi,

We are running 9.05.700B and I'm trying to mass update the cost of
parts. Does anyone know of a way to do this other than doing them
individually? I have tried DMT (no updates only new allowed), Paste
Update from List View (getting invalid Reason Code) and an Updateable
BAQ. All which have failed.

Any help with this would be appreciated.

Thanks,

Ken

[Non-text portions of this message have been removed]





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
13
Good Day Greg:



While all cost Adjustment records may be new since they
are PartTrans records, I think changing PartCost records would be a
change.



Unless you are pasting into QtyAdjust program and not
directly into the records.




Len



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Greg Payne
Sent: Monday, January 14, 2013 4:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Cost Adjustments





All Cost adjustments are new records, that is why DMT only shows it. We
do them thru DMT. If the part is lot tracked, you will need the lot info
in the dmt.

Greg

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of mattcald_73
Sent: Monday, January 14, 2013 4:03 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Cost Adjustments

We use Service Connect for our updates. Use an Excel sheet with just 4
columns for input:

PartNum UnitMatCost UnitBurden Reason
PART1 1.23 1.23 StdC
PART2 1.23 1.23 StdC

--Matt

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Ken
Dumesnil wrote:
>
> Hi,
>
> We are running 9.05.700B and I'm trying to mass update the cost of
parts. Does anyone know of a way to do this other than doing them
individually? I have tried DMT (no updates only new allowed), Paste
Update from List View (getting invalid Reason Code) and an Updateable
BAQ. All which have failed.
>
> Any help with this would be appreciated.
>
> Thanks,
>
> Ken
>
> [Non-text portions of this message have been removed]
>

________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments,
is privileged and confidential. It is intended only for the exclusive
use of the addressee. If the reader of this message is not the intended
recipient, or the employee or agent responsible for delivering it to the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify us at
727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in
the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
Export of this material is restricted by the Arms Export Control Act (22
U.S.C. 2751 et seq.) and may not be exported to foreign persons without
prior approval form the U.S. Department of State."

[Non-text portions of this message have been removed]





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
14
The company I work for is on 700C. I used the DMT to load my costs. If the part cost remains the same as before, it will give an error saying there is no part cost update. If the part cost is changing, it will update the part cost. I updated 4,000+ purchased part costs using the DMT and then used the cost workbench to create the new standard cost for the manufactured parts. You do need a reason code for the cost adjustment. Our parts are lot tracked, but I didn't have to do anything for that.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Monday, January 14, 2013 4:19 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Cost Adjustments



Good Day Greg:

While all cost Adjustment records may be new since they
are PartTrans records, I think changing PartCost records would be a
change.

Unless you are pasting into QtyAdjust program and not
directly into the records.

Len

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Greg Payne
Sent: Monday, January 14, 2013 4:10 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Cost Adjustments

All Cost adjustments are new records, that is why DMT only shows it. We
do them thru DMT. If the part is lot tracked, you will need the lot info
in the dmt.

Greg

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> ] On
Behalf Of mattcald_73
Sent: Monday, January 14, 2013 4:03 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Cost Adjustments

We use Service Connect for our updates. Use an Excel sheet with just 4
columns for input:

PartNum UnitMatCost UnitBurden Reason
PART1 1.23 1.23 StdC
PART2 1.23 1.23 StdC

--Matt

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> , Ken
Dumesnil wrote:
>
> Hi,
>
> We are running 9.05.700B and I'm trying to mass update the cost of
parts. Does anyone know of a way to do this other than doing them
individually? I have tried DMT (no updates only new allowed), Paste
Update from List View (getting invalid Reason Code) and an Updateable
BAQ. All which have failed.
>
> Any help with this would be appreciated.
>
> Thanks,
>
> Ken
>
> [Non-text portions of this message have been removed]
>

________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments,
is privileged and confidential. It is intended only for the exclusive
use of the addressee. If the reader of this message is not the intended
recipient, or the employee or agent responsible for delivering it to the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify us at
727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in
the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
Export of this material is restricted by the Arms Export Control Act (22
U.S.C. 2751 et seq.) and may not be exported to foreign persons without
prior approval form the U.S. Department of State."

[Non-text portions of this message have been removed]

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
15
Thanks,
Â
I tested with a few parts using DMT and it appears to work.  Thanks for your help.
Â
Ken

--- On Mon, 1/14/13, Connie Houston <cfader@...> wrote:


From: Connie Houston <cfader@...>
Subject: RE: [Vantage] Re: Cost Adjustments
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Monday, January 14, 2013, 9:28 PM



Â




The company I work for is on 700C. I used the DMT to load my costs. If the part cost remains the same as before, it will give an error saying there is no part cost update. If the part cost is changing, it will update the part cost. I updated 4,000+ purchased part costs using the DMT and then used the cost workbench to create the new standard cost for the manufactured parts. You do need a reason code for the cost adjustment. Our parts are lot tracked, but I didn't have to do anything for that.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Monday, January 14, 2013 4:19 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Cost Adjustments

Good Day Greg:

While all cost Adjustment records may be new since they
are PartTrans records, I think changing PartCost records would be a
change.

Unless you are pasting into QtyAdjust program and not
directly into the records.

Len

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Greg Payne
Sent: Monday, January 14, 2013 4:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Cost Adjustments

All Cost adjustments are new records, that is why DMT only shows it. We
do them thru DMT. If the part is lot tracked, you will need the lot info
in the dmt.

Greg

From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com ] On
Behalf Of mattcald_73
Sent: Monday, January 14, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Cost Adjustments

We use Service Connect for our updates. Use an Excel sheet with just 4
columns for input:

PartNum UnitMatCost UnitBurden Reason
PART1 1.23 1.23 StdC
PART2 1.23 1.23 StdC

--Matt

--- In vantage@yahoogroups.com , Ken
Dumesnil wrote:
>
> Hi,
>
> We are running 9.05.700B and I'm trying to mass update the cost of
parts. Does anyone know of a way to do this other than doing them
individually? I have tried DMT (no updates only new allowed), Paste
Update from List View (getting invalid Reason Code) and an Updateable
BAQ. All which have failed.
>
> Any help with this would be appreciated.
>
> Thanks,
>
> Ken
>
> [Non-text portions of this message have been removed]
>

________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments,
is privileged and confidential. It is intended only for the exclusive
use of the addressee. If the reader of this message is not the intended
recipient, or the employee or agent responsible for delivering it to the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify us at
727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in
the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
Export of this material is restricted by the Arms Export Control Act (22
U.S.C. 2751 et seq.) and may not be exported to foreign persons without
prior approval form the U.S. Department of State."

[Non-text portions of this message have been removed]

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

[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]
16
Hi,
Â
Thanks, I'm going to try DMT first.
Â
Ken

--- On Mon, 1/14/13, Len Hartka <len.hartka@...> wrote:


From: Len Hartka <len.hartka@...>
Subject: RE: [Vantage] Cost Adjustments
To: vantage@yahoogroups.com
Date: Monday, January 14, 2013, 9:14 PM



Â



Good Day Ken:

Paste update would work if you add a reason. If the
column is not there, you might be able to add it with customization or
maybe just personalization. Do not do all at once or it will be very
slow. Start with maybe 100 lines then increase until it slows too much.

If you have an Excel sheet, you could have Epi-Center,
or another consultant, do a quick program for you. Test for speed on
Test account first.

Or, call helpline, the DMT should work. I think. Do you
own the full DMT program?

Remember to update all non-zero cost buckets: burden,
labor, matl, etc.

Make sure you get right set: Averge vs. Standard, vs.
Last

Len

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Dumesnil
Sent: Monday, January 14, 2013 3:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Cost Adjustments

Hi,

We are running 9.05.700B and I'm trying to mass update the cost of
parts. Does anyone know of a way to do this other than doing them
individually? I have tried DMT (no updates only new allowed), Paste
Update from List View (getting invalid Reason Code) and an Updateable
BAQ. All which have failed.

Any help with this would be appreciated.

Thanks,

Ken

[Non-text portions of this message have been removed]

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

[Non-text portions of this message have been removed]








[Non-text portions of this message have been removed]
17
ok, Thanks.

--- On Mon, 1/14/13, mattcald_73 <matt@...> wrote:


From: mattcald_73 <matt@...>
Subject: [Vantage] Re: Cost Adjustments
To: vantage@yahoogroups.com
Date: Monday, January 14, 2013, 9:02 PM



Â



We use Service Connect for our updates. Use an Excel sheet with just 4 columns for input:

PartNum UnitMatCost UnitBurden Reason
PART1 1.23 1.23 StdC
PART2 1.23 1.23 StdC

--Matt

--- In vantage@yahoogroups.com, Ken Dumesnil wrote:
>
> Hi,
> Â
> We are running 9.05.700B and I'm trying to mass update the cost of parts.  Does anyone know of a way to do this other than doing them individually?  I have tried DMT (no updates only new allowed), Paste Update from List View (getting invalid Reason Code) and an Updateable BAQ.   All which have failed.
> Â
> Any help with this would be appreciated.
> Â
> Thanks,
> Â
> Ken
>
> [Non-text portions of this message have been removed]
>








[Non-text portions of this message have been removed]
18
Are you SQL? If so, yes.



(hush, Jose) :-)







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ken Dumesnil
Sent: Monday, January 14, 2013 3:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Cost Adjustments





Hi,

We are running 9.05.700B and I'm trying to mass update the cost of parts.
Does anyone know of a way to do this other than doing them individually? I
have tried DMT (no updates only new allowed), Paste Update from List View
(getting invalid Reason Code) and an Updateable BAQ. All which have
failed.

Any help with this would be appreciated.

Thanks,

Ken

[Non-text portions of this message have been removed]



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2638/5532 - Release Date: 01/14/13




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2638/5532 - Release Date: 01/14/13

[Non-text portions of this message have been removed]