I uploaded it to the file section...
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 W. Spolarich
Sent: Friday, June 12, 2009 8:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RMA receipts posting material cost only
I would be interested in this as well.
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Rob Bucek
Sent: Thursday, June 11, 2009 10:56 PM
To: mjfw2003@... <mailto:mjfw2003%40yahoo.com>
Cc: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] RMA receipts posting material cost only
Mark,
Well I got the last few bugs worked out and it seems to be working to my
satisfaction. Reading more into your business case it appears that
while ours is very different from yours it does share the notion that we
are interested in the costs that Vantage is passing through the process.
Our business case is where our customer returns a product and say
'dude, you messed it up, we don't want to waste time with debit notes,
just fix the damn thing and send it back on a shipper'.
Our account managers then typically make another release on the original
sales order at 0 dollars price. What happens is we accept the RMA to a
job to rework it, it passes the costs from the sales order they tied to
on the RMA and it hoses our gross margin. With a customization on the
RMA processing screen I gave them a checkbox at the header level to
indicate when the RMA is to be processed without a debit note. I then
have a BPM which runs off the RMAProc.GetNewRcpt method to transfer the
checkbox from the header to the receipt. I also suppress costs based on
the state of the checkbox in the receipt record during the
RMAProc.Update method.
Vantage however is extremely persistent with passing this cost around
and at RMA disposition it somehow goes out and gets those costs
(again!), and not from the receipt record either (because those are
still zero at this point). I can only surmise they have business logic
that goes back to the sales order (or a sales order if they don't pick
one, from what ive seen, the most recent) and then subsequently the COS
recorded on the invoice detail.
Using the RMADisp.GetNewRMADisp method I once again suppress costs based
on the state of the checkbox (this time on the receipt) as they will
roll right into the unit costs and from there pass to the job once the
record is saved. At first we tried having the folks at inspection
manually suppress these costs, but based on timing, and a host of other
reasons, you can imagine how effective that was on a reoccurring basis.
You may be able to use some of the basics of what I have to spin off in
the direction you need. If not, perhaps I can help in some other manner
once you get started. The tough thing about the RMA disposition, and I
think that's where you really want to look, is, if you follow the Part
Transaction History Tracker; costs don't appear (at least in our
environment) until disposition, in our case usually a DMR-MTL or DMR-STK
transaction. At the very least this series of BPM's demonstrates you
can change the costs as Vantage goes through its various transactions,
and that being said you can probably invoke other actions based on costs
present at any transaction. Hope this email wasn't a waste of your
time.
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 Mark Wagner
Sent: Monday, June 08, 2009 4:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] RMA receipts posting material cost only
That would be great Rob, appreciate the help
--- On Mon, 6/8/09, Rob Bucek <rbucek@...
<mailto:rbucek%40dsmfg.com>
<mailto:rbucek%40dsmfg.com> > wrote:
From: Rob Bucek <rbucek@... <mailto:rbucek%40dsmfg.com>
<mailto:rbucek%40dsmfg.com> >
Subject: RE: [Vantage] RMA receipts posting material cost only
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Date: Monday, June 8, 2009, 5:17 PM
Im doing some tweaking to that yet this week, Ill be happy to share with
you. Ill give you a heads up when Im done.
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 Mark Wagner
Sent: Saturday, June 06, 2009 2:39 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] RMA receipts posting material cost only
We've run into the same problem, especially coming off a legacy system
where there is no SO history to track what the COGS sold was for that
shipment. If you do an RMA against a SO it will look at the COGS sold,
if it is not against a SO the system will attempt to find any shipments
for that particular part for that particular customer and use that COGS.
If it cannot find any shipments it will default to zero and not to the
current (avg, standard, etc) inventory cost
Rob, I would be interested in that BPM if you could share what you are
doing. We either need to flag our inspectors if a part has a $0 cost
and not allow them to process until somone with override authority can
issue a cost or, use the default value from inventory
through a BPM (havent decided which way we want to go yet)
--- On Fri, 6/5/09, Rob Bucek <rbucek@dsmfg. com
<mailto:rbucek% 40dsmfg.com> > wrote:
From: Rob Bucek <rbucek@dsmfg. com <mailto:rbucek% 40dsmfg.com> >
Subject: RE: [Vantage] RMA receipts posting material cost only
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Date: Friday, June 5, 2009, 5:04 PM
I cant say that Ive seen the variation you are describing, but I do have
several BPM's managing how costs are passing through the DMR process
from RMA's and from what Ive learned is that the costs are derived from
the Sales Order, line, Release, which is ultimately tied to the costs
that rolled to the Invoice detail line(s). Now if the user failed to
select a specific sales order to the rma vantage will automatically go
and link it to the last SO that was invoiced for that part (you wont see
this on the RMA screen though). Im not sure this helps you specifically
but that maybe the information might be useful.
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 mlezivk
Sent: Friday, June 05, 2009 3:26 PM
To: vantage@yahoogroups .com
Subject: [Vantage] RMA receipts posting material cost only
Has anybody else encountered a problem with RMA receipt costs in Vantage
8.03.405A? For some reason, it is applying only the standard material
portion of the unit cost, and ignoring the standard labor, burden and
subcontract costs. We use jobs but ship mostly from stock.
Any help is appreciated. Thanks!
Kevin Mleziva
Ace Precision Machining
[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]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
[Non-text portions of this message have been removed]
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 W. Spolarich
Sent: Friday, June 12, 2009 8:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RMA receipts posting material cost only
I would be interested in this as well.
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Rob Bucek
Sent: Thursday, June 11, 2009 10:56 PM
To: mjfw2003@... <mailto:mjfw2003%40yahoo.com>
Cc: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] RMA receipts posting material cost only
Mark,
Well I got the last few bugs worked out and it seems to be working to my
satisfaction. Reading more into your business case it appears that
while ours is very different from yours it does share the notion that we
are interested in the costs that Vantage is passing through the process.
Our business case is where our customer returns a product and say
'dude, you messed it up, we don't want to waste time with debit notes,
just fix the damn thing and send it back on a shipper'.
Our account managers then typically make another release on the original
sales order at 0 dollars price. What happens is we accept the RMA to a
job to rework it, it passes the costs from the sales order they tied to
on the RMA and it hoses our gross margin. With a customization on the
RMA processing screen I gave them a checkbox at the header level to
indicate when the RMA is to be processed without a debit note. I then
have a BPM which runs off the RMAProc.GetNewRcpt method to transfer the
checkbox from the header to the receipt. I also suppress costs based on
the state of the checkbox in the receipt record during the
RMAProc.Update method.
Vantage however is extremely persistent with passing this cost around
and at RMA disposition it somehow goes out and gets those costs
(again!), and not from the receipt record either (because those are
still zero at this point). I can only surmise they have business logic
that goes back to the sales order (or a sales order if they don't pick
one, from what ive seen, the most recent) and then subsequently the COS
recorded on the invoice detail.
Using the RMADisp.GetNewRMADisp method I once again suppress costs based
on the state of the checkbox (this time on the receipt) as they will
roll right into the unit costs and from there pass to the job once the
record is saved. At first we tried having the folks at inspection
manually suppress these costs, but based on timing, and a host of other
reasons, you can imagine how effective that was on a reoccurring basis.
You may be able to use some of the basics of what I have to spin off in
the direction you need. If not, perhaps I can help in some other manner
once you get started. The tough thing about the RMA disposition, and I
think that's where you really want to look, is, if you follow the Part
Transaction History Tracker; costs don't appear (at least in our
environment) until disposition, in our case usually a DMR-MTL or DMR-STK
transaction. At the very least this series of BPM's demonstrates you
can change the costs as Vantage goes through its various transactions,
and that being said you can probably invoke other actions based on costs
present at any transaction. Hope this email wasn't a waste of your
time.
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 Mark Wagner
Sent: Monday, June 08, 2009 4:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] RMA receipts posting material cost only
That would be great Rob, appreciate the help
--- On Mon, 6/8/09, Rob Bucek <rbucek@...
<mailto:rbucek%40dsmfg.com>
<mailto:rbucek%40dsmfg.com> > wrote:
From: Rob Bucek <rbucek@... <mailto:rbucek%40dsmfg.com>
<mailto:rbucek%40dsmfg.com> >
Subject: RE: [Vantage] RMA receipts posting material cost only
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Date: Monday, June 8, 2009, 5:17 PM
Im doing some tweaking to that yet this week, Ill be happy to share with
you. Ill give you a heads up when Im done.
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 Mark Wagner
Sent: Saturday, June 06, 2009 2:39 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] RMA receipts posting material cost only
We've run into the same problem, especially coming off a legacy system
where there is no SO history to track what the COGS sold was for that
shipment. If you do an RMA against a SO it will look at the COGS sold,
if it is not against a SO the system will attempt to find any shipments
for that particular part for that particular customer and use that COGS.
If it cannot find any shipments it will default to zero and not to the
current (avg, standard, etc) inventory cost
Rob, I would be interested in that BPM if you could share what you are
doing. We either need to flag our inspectors if a part has a $0 cost
and not allow them to process until somone with override authority can
issue a cost or, use the default value from inventory
through a BPM (havent decided which way we want to go yet)
--- On Fri, 6/5/09, Rob Bucek <rbucek@dsmfg. com
<mailto:rbucek% 40dsmfg.com> > wrote:
From: Rob Bucek <rbucek@dsmfg. com <mailto:rbucek% 40dsmfg.com> >
Subject: RE: [Vantage] RMA receipts posting material cost only
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Date: Friday, June 5, 2009, 5:04 PM
I cant say that Ive seen the variation you are describing, but I do have
several BPM's managing how costs are passing through the DMR process
from RMA's and from what Ive learned is that the costs are derived from
the Sales Order, line, Release, which is ultimately tied to the costs
that rolled to the Invoice detail line(s). Now if the user failed to
select a specific sales order to the rma vantage will automatically go
and link it to the last SO that was invoiced for that part (you wont see
this on the RMA screen though). Im not sure this helps you specifically
but that maybe the information might be useful.
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 mlezivk
Sent: Friday, June 05, 2009 3:26 PM
To: vantage@yahoogroups .com
Subject: [Vantage] RMA receipts posting material cost only
Has anybody else encountered a problem with RMA receipt costs in Vantage
8.03.405A? For some reason, it is applying only the standard material
portion of the unit cost, and ignoring the standard labor, burden and
subcontract costs. We use jobs but ship mostly from stock.
Any help is appreciated. Thanks!
Kevin Mleziva
Ace Precision Machining
[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]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
[Non-text portions of this message have been removed]