Mass Zero

Looks like quite a few were hit by Nimda - we still haven't recovered
completely.

I thought I would take the time to explain in more detail why the
mass update of our shipping department bins works for us.

No, we do not interface inventory with the GL, one reason is the
same 'personnel problem' and inaccurate data entry. That doesn't
mean we're not using standard costing in some form. We apply costs
with the help of special reports and programs that calculate standard
and actual for finished goods in the shipping warehouse. Our custom
inventory program and database allows us to track in-process material
and apply costs to it also. Manual GL entries are then made.

We also have a Vantage WIP program that takes a snapshot of part
quantities and locations, and applies cost, and then compares to cost
of physical inventory.

Back to Jason's question. If Vantage is not posting inventory to GL,
he could change bin values at will, couldn't he? Well, at least with
the correct tools..

Even if posting to GL, I don't see a problem creating PartTran
entries to balance bins to zero, as Mark brought to my attention.

Lonnie


--- In vantage@y..., Lydia Coffman <lcoffman@c...> wrote:
> I too have been off-line for a few days, but I would suggest that
in this case, using the inventory count is probably the best idea.
You have a definite trail-when you zeroed it, when you put in the
actual count, and your costs are accounted for-I'm sure that there
are some G/L issues that will bite you in the butt, maybe Lonnie's
accountant has made allowances for that, but some accountants (ours
in particular) would have a fit.

Try just doing a few items first, the data entry is very fast-and as I
recall, you don't actually have to print the tags. Way back -- we
had to count our full inventory every couple of months due to some
internal personnel problems, (which are now resolved), so we got
really good at it. Even the quantity adjustment feature seems like a
better idea, and it has its own set of problems.

I would think that especially a new user should think long and hard
before you start poking around in your database. The ripple effect
will almost certainly rear its ugly head.

Just my three cents worth - haven't said much lately.

Lydia
lcoffman@c...
>
>
> -----Original Message-----
> From: Wayne Cox [mailto:wmc@u...]
> Sent: Monday, September 24, 2001 7:39 AM
> To: vantage@y...
> Subject: RE: [Vantage] Re: Mass Zero
>
> At 08:21 AM 9/24/2001 , you wrote:
> >Now let me see if I got this right. There is progress code that
can do
> >this. But there are some issues. 1) I have never done anything
like that
> >and 2) you could perminently mess up you Vantage code.
>
> You would need to procure the ProVision development package and
your own
> programming resources; Or make arrangements with an outsider who
does to
> compile a program to do it. Yes, it is possible to bung up your
data, or
> at least make things inconsistent with how the Vantage programs
expect it.
>
> If Epicor gets wind of it.... well, in the past they've made some
nasty
> threats, like cutting off tech support and such, if you start
bypassing
> Vantage and poking your own data in directly. Though some places
seem to
> have gotten their blessing to make updates.
>
> >The other option is to use count entry and generate tags and go
line
> >by line adjusting your counts.(time consuming but safer) Could
you explan
> >the Ground Control utility or can I find info on this somewhere.
>
> Ground Control is a share-ware windows scripting or macro utility.
You can
> write scripts to send key strokes, mouse actions, etc to another
windows
> program to automate repetitive tasks. An evaluation version 2.10
is in our
> files page at Yahoo. The company that writes it is currently up to
version
> 3.0, but found it wasn't compatible with Vantage 4 / Progress 9.0.
>
> -Wayne
> Good afternoon,
>
> I have been posed with a question from my Material Manager regarding
> Inventory Items.
>
> What he has asked me is it possible to reset all the inventory item to
> zero in one mass swoop. Why he wants this is because he is trying to get
> the inventory as close to accurate as possible because of our year
> end.(he's wants to manually reinput the data on item we use and zero any
> of the old garbage inventory)
>
> I've just started using Vantage and I haven't figured out all the
> "special" features of it yet. You would save me a large amount of time if
> it is possible. We are using Ver. 5.0.329
>
> Thanks in advance
>
> Jason
> Pride Signs
> Cambridge ON.
> www.pridesigns.com
> jford@...
> 519-220-0505
>
>
>
If you're referring to setting the partbin.onhandqty to zero, it's a
relatively simple Progress program. If you're specifically asking
for bids on the project, you should get quite a few responses.

Lonnie

--- In vantage@y..., yahoopridesigns <yahoo@p...> wrote:
>
> > Good afternoon,
> >
> > I have been posed with a question from my Material Manager
regarding
> > Inventory Items.
> >
> > What he has asked me is it possible to reset all the inventory
item to
> > zero in one mass swoop. Why he wants this is because he is
trying to get
> > the inventory as close to accurate as possible because of our year
> > end.(he's wants to manually reinput the data on item we use and
zero any
> > of the old garbage inventory)
> >
> > I've just started using Vantage and I haven't figured out all the
> > "special" features of it yet. You would save me a large amount
of time if
> > it is possible. We are using Ver. 5.0.329
> >
> > Thanks in advance
> >
> > Jason
> > Pride Signs
> > Cambridge ON.
> > www.pridesigns.com
> > jford@p...
> > 519-220-0505
> >
> >
> >
yes I am referring to resetting the partbin.onhandqty to zero.

I have never created a Progress program so personally it would be that
simple. Could you give me some advice on how to start.

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, September 21, 2001 2:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass Zero


If you're referring to setting the partbin.onhandqty to zero, it's a
relatively simple Progress program. If you're specifically asking
for bids on the project, you should get quite a few responses.

Lonnie

--- In vantage@y..., yahoopridesigns <yahoo@p...> wrote:
>
> > Good afternoon,
> >
> > I have been posed with a question from my Material Manager
regarding
> > Inventory Items.
> >
> > What he has asked me is it possible to reset all the inventory
item to
> > zero in one mass swoop. Why he wants this is because he is
trying to get
> > the inventory as close to accurate as possible because of our year
> > end.(he's wants to manually reinput the data on item we use and
zero any
> > of the old garbage inventory)
> >
> > I've just started using Vantage and I haven't figured out all the
> > "special" features of it yet. You would save me a large amount
of time if
> > it is possible. We are using Ver. 5.0.329
> >
> > Thanks in advance
> >
> > Jason
> > Pride Signs
> > Cambridge ON.
> > www.pridesigns.com
> > jford@p...
> > 519-220-0505
> >
> >
> >



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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Lonnie,
It's not quite that simple. You would need to create part
transactions to do a quantity adjustment for each part. This way all of the
appropriate GL information would be present as well.
Just deleting the partbin records would probably come back to bite
you at a later date.

Mark Charamut

President
Caesar Development Services, LLC
Epicor Authorized Independent Solution Provider
mcharamut@...
www.caesardev.com
(860) 667-4774 x20


> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@...]
> Sent: Friday, September 21, 2001 2:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Mass Zero
>
>
> If you're referring to setting the partbin.onhandqty to zero, it's a
> relatively simple Progress program. If you're specifically asking
> for bids on the project, you should get quite a few responses.
>
> Lonnie
>
> --- In vantage@y..., yahoopridesigns <yahoo@p...> wrote:
> >
> > > Good afternoon,
> > >
> > > I have been posed with a question from my Material Manager
> regarding
> > > Inventory Items.
> > >
> > > What he has asked me is it possible to reset all the inventory
> item to
> > > zero in one mass swoop. Why he wants this is because he is
> trying to get
> > > the inventory as close to accurate as possible because of our year
> > > end.(he's wants to manually reinput the data on item we use and
> zero any
> > > of the old garbage inventory)
> > >
> > > I've just started using Vantage and I haven't figured out all the
> > > "special" features of it yet. You would save me a large amount
> of time if
> > > it is possible. We are using Ver. 5.0.329
> > >
> > > Thanks in advance
> > >
> > > Jason
> > > Pride Signs
> > > Cambridge ON.
> > > www.pridesigns.com
> > > jford@p...
> > > 519-220-0505
> > >
> > >
> > >
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Pinpoint the right security solution for your company- Learn
> how to add 128- bit encryption and to authenticate your web
> site with VeriSign's FREE guide!
> http://us.click.yahoo.com/JNm9_D/33_CAA/yigFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> 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/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Mark,

Deleting is not what I said. Setting the onhandqty to zero, while
letting any Vantage triggers run, should take care of it. We use
this procedure after each physical inventory.

Lonnie

--- In vantage@y..., Mark Charamut <mrprogress@C...> wrote:
> Lonnie,
> It's not quite that simple. You would need to create part
> transactions to do a quantity adjustment for each part. This way
all of the
> appropriate GL information would be present as well.
> Just deleting the partbin records would probably come back to
bite
> you at a later date.
>
> Mark Charamut
>
> President
> Caesar Development Services, LLC
> Epicor Authorized Independent Solution Provider
> mcharamut@c...
> www.caesardev.com
> (860) 667-4774 x20
>
>
> > -----Original Message-----
> > From: Lonnie Drew [mailto:lonniedrew@c...]
> > Sent: Friday, September 21, 2001 2:50 PM
> > To: vantage@y...
> > Subject: [Vantage] Re: Mass Zero
> >
> >
> > If you're referring to setting the partbin.onhandqty to zero,
it's a
> > relatively simple Progress program. If you're specifically
asking
> > for bids on the project, you should get quite a few responses.
> >
> > Lonnie
> >
> > --- In vantage@y..., yahoopridesigns <yahoo@p...> wrote:
> > >
> > > > Good afternoon,
> > > >
> > > > I have been posed with a question from my Material Manager
> > regarding
> > > > Inventory Items.
> > > >
> > > > What he has asked me is it possible to reset all the
inventory
> > item to
> > > > zero in one mass swoop. Why he wants this is because he is
> > trying to get
> > > > the inventory as close to accurate as possible because of our
year
> > > > end.(he's wants to manually reinput the data on item we use
and
> > zero any
> > > > of the old garbage inventory)
> > > >
> > > > I've just started using Vantage and I haven't figured out all
the
> > > > "special" features of it yet. You would save me a large
amount
> > of time if
> > > > it is possible. We are using Ver. 5.0.329
> > > >
> > > > Thanks in advance
> > > >
> > > > Jason
> > > > Pride Signs
> > > > Cambridge ON.
> > > > www.pridesigns.com
> > > > jford@p...
> > > > 519-220-0505
> > > >
> > > >
> > > >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > ---------------------~-->
> > Pinpoint the right security solution for your company- Learn
> > how to add 128- bit encryption and to authenticate your web
> > site with VeriSign's FREE guide!
> > http://us.click.yahoo.com/JNm9_D/33_CAA/yigFAA/PhFolB/TM
> > --------------------------------------------------------------
> > -------~->
> >
> > 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/.
> > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Lonnie,
As far as I know when the part quantity in a bin reaches zero the
record is deleted in Vantage. This usually occurs in the procedures that are
modifying the quantity. I am sure that setting the quanity to zero will
work. However, there will be no history and there will be no parttran
records for any costing procedures to look at. If your inventory is
interfaced with your GL, I expect there would be a problem at some point.
Any inventory correction procedures we create always use the
parttran table and make the necessary entries in addition changing
quantities in the bins. I'm not saying this approach is the only way to do
it, but we have found it to be the safest.

Mark Charamut



> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@...]
> Sent: Friday, September 21, 2001 3:07 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Mass Zero
>
>
> Mark,
>
> Deleting is not what I said. Setting the onhandqty to zero, while
> letting any Vantage triggers run, should take care of it. We use
> this procedure after each physical inventory.
>
> Lonnie
>
> --- In vantage@y..., Mark Charamut <mrprogress@C...> wrote:
> > Lonnie,
> > It's not quite that simple. You would need to create part
> > transactions to do a quantity adjustment for each part. This way
> all of the
> > appropriate GL information would be present as well.
> > Just deleting the partbin records would probably come back to
> bite
> > you at a later date.
> >
> > Mark Charamut
> >
> > President
> > Caesar Development Services, LLC
> > Epicor Authorized Independent Solution Provider
> > mcharamut@c...
> > www.caesardev.com
> > (860) 667-4774 x20
> >
> >
> > > -----Original Message-----
> > > From: Lonnie Drew [mailto:lonniedrew@c...]
> > > Sent: Friday, September 21, 2001 2:50 PM
> > > To: vantage@y...
> > > Subject: [Vantage] Re: Mass Zero
> > >
> > >
> > > If you're referring to setting the partbin.onhandqty to zero,
> it's a
> > > relatively simple Progress program. If you're specifically
> asking
> > > for bids on the project, you should get quite a few responses.
> > >
> > > Lonnie
> > >
> > > --- In vantage@y..., yahoopridesigns <yahoo@p...> wrote:
> > > >
> > > > > Good afternoon,
> > > > >
> > > > > I have been posed with a question from my Material Manager
> > > regarding
> > > > > Inventory Items.
> > > > >
> > > > > What he has asked me is it possible to reset all the
> inventory
> > > item to
> > > > > zero in one mass swoop. Why he wants this is because he is
> > > trying to get
> > > > > the inventory as close to accurate as possible because of our
> year
> > > > > end.(he's wants to manually reinput the data on item we use
> and
> > > zero any
> > > > > of the old garbage inventory)
> > > > >
> > > > > I've just started using Vantage and I haven't figured out all
> the
> > > > > "special" features of it yet. You would save me a large
> amount
> > > of time if
> > > > > it is possible. We are using Ver. 5.0.329
> > > > >
> > > > > Thanks in advance
> > > > >
> > > > > Jason
> > > > > Pride Signs
> > > > > Cambridge ON.
> > > > > www.pridesigns.com
> > > > > jford@p...
> > > > > 519-220-0505
> > > > >
> > > > >
> > > > >
> > >
> > >
> > > ------------------------ Yahoo! Groups Sponsor
> > > ---------------------~-->
> > > Pinpoint the right security solution for your company- Learn
> > > how to add 128- bit encryption and to authenticate your web
> > > site with VeriSign's FREE guide!
> > > http://us.click.yahoo.com/JNm9_D/33_CAA/yigFAA/PhFolB/TM
> > > --------------------------------------------------------------
> > > -------~->
> > >
> > > 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/.
> > > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get your FREE VeriSign guide to security solutions for your
> web site: encrypting transactions, securing intranets, and more!
> http://us.click.yahoo.com/XrFcOC/m5_CAA/yigFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> 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/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Mark,

I just ran a report on PartBin where onhandqty = 0, many records
found, so evidently the record exists for 0 qty, and I would assume
for any part with warehouse and bin created regardless of
transactions against it.

You're absolutely correct about the history, but I've never been
asked to balance the current onhandqty with past transactions. We
adjust and use the onhandqty for reporting reasons.

Any costing on parttran transactions for a period of time would
ignore any inventory adjustments wouldn't it?

Can't argue with your approach though, it does seem safest for any
Vantage environment.

Here is some code from one of the partbin programs...

message "About to Zero all ST Part Quantities" skip(0)
"in Shipping Warehouses and Bins, Continue?" view-as alert-box
buttons yes-no
update zerochoice as logical.
if zerochoice = yes then do:
output to f:\partqtys.txt.
for each part where part.company = "soutool"
and part.typecode = "M"
break by part.partnum:
put part.partnum at 1 format "x(12)".
CurPart:screen-value in frame dialog-frame = part.partnum.

for each partbin where partbin.company = "soutool"
and partbin.partnum = part.partnum
and (partbin.warehousecode = "fg1" or partbin.warehousecode =
"fg2")
break by partbin.warehousecode by partbin.binnum:
TheLocations = TheLocations + "- " +
partbin.warehousecode + " " + string(partbin.binnum).
partqty = partqty + partbin.onhandqty.
/* set qty to zero */
partbin.onhandqty = 0.
end. /* for each partbin */

if thelocations <> "" then put TheLocations at 14 partqty at
41.
TheLocations = "".
partqty = 0.

end. /* for each part */

message "List of parts, warehouses and bins that were" skip(0)
"set to zero printed to f:\partqtys.txt" view-as alert-
box.

message "Would you like to check for parts marked" skip(0)
"TOOL RETURNED and mark these as inactive?"
view-as alert-box buttons yes-no update ReturnChoice as
logical.

end. /* if zerochoice = yes */

--- In vantage@y..., Mark Charamut <mrprogress@C...> wrote:
> Lonnie,
> As far as I know when the part quantity in a bin reaches zero
the
> record is deleted in Vantage. This usually occurs in the procedures
that are
> modifying the quantity. I am sure that setting the quanity to zero
will
> work. However, there will be no history and there will be no
parttran
> records for any costing procedures to look at. If your inventory is
> interfaced with your GL, I expect there would be a problem at some
point.
> Any inventory correction procedures we create always use the
> parttran table and make the necessary entries in addition changing
> quantities in the bins. I'm not saying this approach is the only
way to do
> it, but we have found it to be the safest.
>
> Mark Charamut
>
>
>
> > -----Original Message-----
> > From: Lonnie Drew [mailto:lonniedrew@c...]
> > Sent: Friday, September 21, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Re: Mass Zero
> >
> >
> > Mark,
> >
> > Deleting is not what I said. Setting the onhandqty to zero,
while
> > letting any Vantage triggers run, should take care of it. We use
> > this procedure after each physical inventory.
> >
> > Lonnie
> >
> > --- In vantage@y..., Mark Charamut <mrprogress@C...> wrote:
> > > Lonnie,
> > > It's not quite that simple. You would need to create part
> > > transactions to do a quantity adjustment for each part. This
way
> > all of the
> > > appropriate GL information would be present as well.
> > > Just deleting the partbin records would probably come back to
> > bite
> > > you at a later date.
> > >
> > > Mark Charamut
> > >
> > > President
> > > Caesar Development Services, LLC
> > > Epicor Authorized Independent Solution Provider
> > > mcharamut@c...
> > > www.caesardev.com
> > > (860) 667-4774 x20
> > >
> > >
> > > > -----Original Message-----
> > > > From: Lonnie Drew [mailto:lonniedrew@c...]
> > > > Sent: Friday, September 21, 2001 2:50 PM
> > > > To: vantage@y...
> > > > Subject: [Vantage] Re: Mass Zero
> > > >
> > > >
> > > > If you're referring to setting the partbin.onhandqty to zero,
> > it's a
> > > > relatively simple Progress program. If you're specifically
> > asking
> > > > for bids on the project, you should get quite a few responses.
> > > >
> > > > Lonnie
> > > >
> > > > --- In vantage@y..., yahoopridesigns <yahoo@p...> wrote:
> > > > >
> > > > > > Good afternoon,
> > > > > >
> > > > > > I have been posed with a question from my Material
Manager
> > > > regarding
> > > > > > Inventory Items.
> > > > > >
> > > > > > What he has asked me is it possible to reset all the
> > inventory
> > > > item to
> > > > > > zero in one mass swoop. Why he wants this is because he
is
> > > > trying to get
> > > > > > the inventory as close to accurate as possible because of
our
> > year
> > > > > > end.(he's wants to manually reinput the data on item we
use
> > and
> > > > zero any
> > > > > > of the old garbage inventory)
> > > > > >
> > > > > > I've just started using Vantage and I haven't figured out
all
> > the
> > > > > > "special" features of it yet. You would save me a large
> > amount
> > > > of time if
> > > > > > it is possible. We are using Ver. 5.0.329
> > > > > >
> > > > > > Thanks in advance
> > > > > >
> > > > > > Jason
> > > > > > Pride Signs
> > > > > > Cambridge ON.
> > > > > > www.pridesigns.com
> > > > > > jford@p...
> > > > > > 519-220-0505
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > > ------------------------ Yahoo! Groups Sponsor
> > > > ---------------------~-->
> > > > Pinpoint the right security solution for your company- Learn
> > > > how to add 128- bit encryption and to authenticate your web
> > > > site with VeriSign's FREE guide!
> > > > http://us.click.yahoo.com/JNm9_D/33_CAA/yigFAA/PhFolB/TM
> > > > --------------------------------------------------------------
> > > > -------~->
> > > >
> > > > 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/.
> > > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> > > http://groups.yahoo.com/group/vantage/links
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > ---------------------~-->
> > Get your FREE VeriSign guide to security solutions for your
> > web site: encrypting transactions, securing intranets, and more!
> > http://us.click.yahoo.com/XrFcOC/m5_CAA/yigFAA/PhFolB/TM
> > --------------------------------------------------------------
> > -------~->
> >
> > 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/.
> > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
At 03:06 PM 9/21/2001 , you wrote:
>Deleting is not what I said. Setting the onhandqty to zero, while
>letting any Vantage triggers run, should take care of it. We use
>this procedure after each physical inventory.

Are you serious?!

Sorry, Dude, but that sounds like the kind of heavy-handed DB update that
probably sparked Epicor's policy of "No Writing What So Ever." Unless you
have source code to fully determine what's going on behind the scenes, that
just sounds really dangerous to me.

Unless you really don't care about any transaction trail, you would at
least need to generate Adj-Qty transactions with all the right GL#s based
on part class, reason codes, control accounts, etc. Even doing all that,
I'd be afraid I'd missed something that might come back to bite my behind.

Can I ask what kind of testing you do before letting something like that
rip on your live data? Sorry if I sound too critical - I'd really LIKE to
have the confidence and knowledge to do updates like that.

-Wayne
Wayne,

Yes I'm serious. As requested by our Cost Accountant, I set 'em to
zero! As for transaction trail, we don't care about adjustments, as
long as the current onhand is correct for reporting reasons. I must
say that the particular code I included is for the shipping
warehouse, from which we pull to create packing slips. We also have
another program that updates the correct counts in the shipping
warehouse from physical inventory. We have a custom pick list that
depends on the correct onhand qty (or at least as close as possible)
for customer service decisions.

In regards to 'heavy handed' DB editing, testing is carried out, with
collaboration with accounting, production control, etc.

And I would like to say, Epicor's policy is 'you break it, you fix
it, or pay us'. I know how to fix it I have to... and out of MANY,
MANY such projects and programs, maybe only a couple had to be
fixed. Testing and more testing before pushing a button is the
standard.

Lonnie



--- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 03:06 PM 9/21/2001 , you wrote:
> >Deleting is not what I said. Setting the onhandqty to zero, while
> >letting any Vantage triggers run, should take care of it. We use
> >this procedure after each physical inventory.
>
> Are you serious?!
>
> Sorry, Dude, but that sounds like the kind of heavy-handed DB
update that
> probably sparked Epicor's policy of "No Writing What So Ever."
Unless you
> have source code to fully determine what's going on behind the
scenes, that
> just sounds really dangerous to me.
>
> Unless you really don't care about any transaction trail, you would
at
> least need to generate Adj-Qty transactions with all the right GL#s
based
> on part class, reason codes, control accounts, etc. Even doing all
that,
> I'd be afraid I'd missed something that might come back to bite my
behind.
>
> Can I ask what kind of testing you do before letting something like
that
> rip on your live data? Sorry if I sound too critical - I'd really
LIKE to
> have the confidence and knowledge to do updates like that.
>
> -Wayne
One could at least store the values int a delimited or dbf file before
zeroing them, and create fix code with exact reverse logic to restore all
the records to the way they were, and testing the functionality of the
reverse code as well, before performing the change on the live side.

Of course a real man like Lonnie would probably bite the bullet and forego
the above, as the reverse code could be written and tested after the fact if
necessary....

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, September 21, 2001 3:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass Zero


Wayne,

Yes I'm serious. As requested by our Cost Accountant, I set 'em to
zero! As for transaction trail, we don't care about adjustments, as
long as the current onhand is correct for reporting reasons. I must
say that the particular code I included is for the shipping
warehouse, from which we pull to create packing slips. We also have
another program that updates the correct counts in the shipping
warehouse from physical inventory. We have a custom pick list that
depends on the correct onhand qty (or at least as close as possible)
for customer service decisions.

In regards to 'heavy handed' DB editing, testing is carried out, with
collaboration with accounting, production control, etc.

And I would like to say, Epicor's policy is 'you break it, you fix
it, or pay us'. I know how to fix it I have to... and out of MANY,
MANY such projects and programs, maybe only a couple had to be
fixed. Testing and more testing before pushing a button is the
standard.

Lonnie



--- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 03:06 PM 9/21/2001 , you wrote:
> >Deleting is not what I said. Setting the onhandqty to zero, while
> >letting any Vantage triggers run, should take care of it. We use
> >this procedure after each physical inventory.
>
> Are you serious?!
>
> Sorry, Dude, but that sounds like the kind of heavy-handed DB
update that
> probably sparked Epicor's policy of "No Writing What So Ever."
Unless you
> have source code to fully determine what's going on behind the
scenes, that
> just sounds really dangerous to me.
>
> Unless you really don't care about any transaction trail, you would
at
> least need to generate Adj-Qty transactions with all the right GL#s
based
> on part class, reason codes, control accounts, etc. Even doing all
that,
> I'd be afraid I'd missed something that might come back to bite my
behind.
>
> Can I ask what kind of testing you do before letting something like
that
> rip on your live data? Sorry if I sound too critical - I'd really
LIKE to
> have the confidence and knowledge to do updates like that.
>
> -Wayne



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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
VERY FUNNY..

Take the time to study the code I attached in the earlier message..
See the part, location and qty output?

I don't 'John Wayne' everything, just most...

Lonnie


--- In vantage@y..., Thad Jacobs <tjacobs@k...> wrote:
> One could at least store the values int a delimited or dbf file
before
> zeroing them, and create fix code with exact reverse logic to
restore all
> the records to the way they were, and testing the functionality of
the
> reverse code as well, before performing the change on the live side.
>
> Of course a real man like Lonnie would probably bite the bullet and
forego
> the above, as the reverse code could be written and tested after
the fact if
> necessary....
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Friday, September 21, 2001 3:14 PM
> To: vantage@y...
> Subject: [Vantage] Re: Mass Zero
>
>
> Wayne,
>
> Yes I'm serious. As requested by our Cost Accountant, I set 'em to
> zero! As for transaction trail, we don't care about adjustments,
as
> long as the current onhand is correct for reporting reasons. I
must
> say that the particular code I included is for the shipping
> warehouse, from which we pull to create packing slips. We also
have
> another program that updates the correct counts in the shipping
> warehouse from physical inventory. We have a custom pick list that
> depends on the correct onhand qty (or at least as close as
possible)
> for customer service decisions.
>
> In regards to 'heavy handed' DB editing, testing is carried out,
with
> collaboration with accounting, production control, etc.
>
> And I would like to say, Epicor's policy is 'you break it, you fix
> it, or pay us'. I know how to fix it I have to... and out of
MANY,
> MANY such projects and programs, maybe only a couple had to be
> fixed. Testing and more testing before pushing a button is the
> standard.
>
> Lonnie
>
>
>
> --- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> > At 03:06 PM 9/21/2001 , you wrote:
> > >Deleting is not what I said. Setting the onhandqty to zero,
while
> > >letting any Vantage triggers run, should take care of it. We use
> > >this procedure after each physical inventory.
> >
> > Are you serious?!
> >
> > Sorry, Dude, but that sounds like the kind of heavy-handed DB
> update that
> > probably sparked Epicor's policy of "No Writing What So Ever."
> Unless you
> > have source code to fully determine what's going on behind the
> scenes, that
> > just sounds really dangerous to me.
> >
> > Unless you really don't care about any transaction trail, you
would
> at
> > least need to generate Adj-Qty transactions with all the right
GL#s
> based
> > on part class, reason codes, control accounts, etc. Even doing
all
> that,
> > I'd be afraid I'd missed something that might come back to bite
my
> behind.
> >
> > Can I ask what kind of testing you do before letting something
like
> that
> > rip on your live data? Sorry if I sound too critical - I'd
really
> LIKE to
> > have the confidence and knowledge to do updates like that.
> >
> > -Wayne
>
>
>
> 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/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
At 11:34 PM 9/21/2001 +0000, you wrote:
>VERY FUNNY..
>I don't 'John Wayne' everything, just most...

Aawwlll Right, Cowboy. If you say so.

-WC
YippieKaiYoKaiYeah, Pilgrim

--- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 11:34 PM 9/21/2001 +0000, you wrote:
> >VERY FUNNY..
> >I don't 'John Wayne' everything, just most...
>
> Aawwlll Right, Cowboy. If you say so.
>
> -WC
Okay, am I missing something here?? If the intent is to zero out inventory
counts where inventory doesn't exist, wouldn't the Count Entry program
accomplish that while updating the actual counts of any existing inventory?
?????
======================
Steve Sanders
Delta Centrifugal Corp
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, September 21, 2001 6:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Mass Zero


One could at least store the values int a delimited or dbf file before
zeroing them, and create fix code with exact reverse logic to restore all
the records to the way they were, and testing the functionality of the
reverse code as well, before performing the change on the live side.

Of course a real man like Lonnie would probably bite the bullet and forego
the above, as the reverse code could be written and tested after the fact
if
necessary....

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, September 21, 2001 3:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass Zero


Wayne,

Yes I'm serious. As requested by our Cost Accountant, I set 'em to
zero! As for transaction trail, we don't care about adjustments, as
long as the current onhand is correct for reporting reasons. I must
say that the particular code I included is for the shipping
warehouse, from which we pull to create packing slips. We also have
another program that updates the correct counts in the shipping
warehouse from physical inventory. We have a custom pick list that
depends on the correct onhand qty (or at least as close as possible)
for customer service decisions.

In regards to 'heavy handed' DB editing, testing is carried out, with
collaboration with accounting, production control, etc.

And I would like to say, Epicor's policy is 'you break it, you fix
it, or pay us'. I know how to fix it I have to... and out of MANY,
MANY such projects and programs, maybe only a couple had to be
fixed. Testing and more testing before pushing a button is the
standard.

Lonnie



--- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 03:06 PM 9/21/2001 , you wrote:
> >Deleting is not what I said. Setting the onhandqty to zero, while
> >letting any Vantage triggers run, should take care of it. We use
> >this procedure after each physical inventory.
>
> Are you serious?!
>
> Sorry, Dude, but that sounds like the kind of heavy-handed DB
update that
> probably sparked Epicor's policy of "No Writing What So Ever."
Unless you
> have source code to fully determine what's going on behind the
scenes, that
> just sounds really dangerous to me.
>
> Unless you really don't care about any transaction trail, you would
at
> least need to generate Adj-Qty transactions with all the right GL#s
based
> on part class, reason codes, control accounts, etc. Even doing all
that,
> I'd be afraid I'd missed something that might come back to bite my
behind.
>
> Can I ask what kind of testing you do before letting something like
that
> rip on your live data? Sorry if I sound too critical - I'd really
LIKE to
> have the confidence and knowledge to do updates like that.
>
> -Wayne



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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor



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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
At 02:29 PM 9/22/2001 -0500, you wrote:
>Okay, am I missing something here?? If the intent is to zero out inventory
>counts where inventory doesn't exist, wouldn't the Count Entry program
>accomplish that while updating the actual counts of any existing inventory?

You have to generate tags for every part you want zeroed or adjusted. Then
you have to enter either a count or a void for every tag before you can
post the group and apply adjustments. Might be able to use the Ground
Control utility to zero all the tags if you wanted a quick way to zero all
your inventory.

-Wayne Cox
Wayne and Lonnie,

That was a great string you two have put together. Now let me see if I got
this right. There is progress code that can do this. But there are some
issues. 1) I have never done anything like that and 2) you could
perminently mess up you Vantage code. They don't sound very good at this
time. The other option is to use count entry and generate tags and go line
by line adjusting your counts.(time consuming but safer) Could you explan
the Ground Control utility or can I find info on this somewhere.

Thank for you time

Jason
Pride Signs
Cambridge ON.
www.pridesigns.com
jford@...
519-220-0505

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Sunday, September 23, 2001 12:16 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Mass Zero


At 02:29 PM 9/22/2001 -0500, you wrote:
>Okay, am I missing something here?? If the intent is to zero out inventory
>counts where inventory doesn't exist, wouldn't the Count Entry program
>accomplish that while updating the actual counts of any existing inventory?

You have to generate tags for every part you want zeroed or adjusted. Then
you have to enter either a count or a void for every tag before you can
post the group and apply adjustments. Might be able to use the Ground
Control utility to zero all the tags if you wanted a quick way to zero all
your inventory.

-Wayne Cox




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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Have your Material Manager make an adjustment to the correct onhand balance
instead you zapping balances and him/her adding all balances, may be less
work for him/her to just do adjustments since some maybe correct, don't let
anyone talk you in to a program to zero out balance, everyone is looking for
that button on the keyboard that automatically does their job for them.

Patrick

-----Original Message-----
From: yahoopridesigns [mailto:yahoo@...]
Sent: Friday, September 21, 2001 1:22 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Mass Zero



> Good afternoon,
>
> I have been posed with a question from my Material Manager regarding
> Inventory Items.
>
> What he has asked me is it possible to reset all the inventory item to
> zero in one mass swoop. Why he wants this is because he is trying to get
> the inventory as close to accurate as possible because of our year
> end.(he's wants to manually reinput the data on item we use and zero any
> of the old garbage inventory)
>
> I've just started using Vantage and I haven't figured out all the
> "special" features of it yet. You would save me a large amount of time if
> it is possible. We are using Ver. 5.0.329
>
> Thanks in advance
>
> Jason
> Pride Signs
> Cambridge ON.
> www.pridesigns.com
> jford@...
> 519-220-0505
>
>
>


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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
I agree with Steve, but our e-mail server has been down since Thursday, so I
haven't been able to respond until just now. The safest way to accomplish
this is use count entry and enter zeros for the parts you want to be zero.
Vantage will automatically generate the adjustment transactions, and it all
works very cleanly.

It's easy to do, doesn't require any custom programming, and doesn't force
you to write to your database.

Jon Hellebuyck
Stremel Manufacturing

-----Original Message-----
From:
sentto-20369-24082-1001186971-jhellebuyck=stremel.com@...
[mailto:sentto-20369-24082-1001186971-jhellebuyck=stremel.com@...
t.com]On Behalf Of Steve Sanders
Sent: Saturday, September 22, 2001 2:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass Zero


Okay, am I missing something here?? If the intent is to zero out
inventory
counts where inventory doesn't exist, wouldn't the Count Entry program
accomplish that while updating the actual counts of any existing
inventory?
?????
======================
Steve Sanders
Delta Centrifugal Corp
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, September 21, 2001 6:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Mass Zero


One could at least store the values int a delimited or dbf file before
zeroing them, and create fix code with exact reverse logic to restore
all
the records to the way they were, and testing the functionality of the
reverse code as well, before performing the change on the live side.

Of course a real man like Lonnie would probably bite the bullet and
forego
the above, as the reverse code could be written and tested after the
fact
if
necessary....

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, September 21, 2001 3:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass Zero


Wayne,

Yes I'm serious. As requested by our Cost Accountant, I set 'em to
zero! As for transaction trail, we don't care about adjustments, as
long as the current onhand is correct for reporting reasons. I must
say that the particular code I included is for the shipping
warehouse, from which we pull to create packing slips. We also have
another program that updates the correct counts in the shipping
warehouse from physical inventory. We have a custom pick list that
depends on the correct onhand qty (or at least as close as possible)
for customer service decisions.

In regards to 'heavy handed' DB editing, testing is carried out, with
collaboration with accounting, production control, etc.

And I would like to say, Epicor's policy is 'you break it, you fix
it, or pay us'. I know how to fix it I have to... and out of MANY,
MANY such projects and programs, maybe only a couple had to be
fixed. Testing and more testing before pushing a button is the
standard.

Lonnie



--- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 03:06 PM 9/21/2001 , you wrote:
> >Deleting is not what I said. Setting the onhandqty to zero, while
> >letting any Vantage triggers run, should take care of it. We use
> >this procedure after each physical inventory.
>
> Are you serious?!
>
> Sorry, Dude, but that sounds like the kind of heavy-handed DB
update that
> probably sparked Epicor's policy of "No Writing What So Ever."
Unless you
> have source code to fully determine what's going on behind the
scenes, that
> just sounds really dangerous to me.
>
> Unless you really don't care about any transaction trail, you would
at
> least need to generate Adj-Qty transactions with all the right GL#s
based
> on part class, reason codes, control accounts, etc. Even doing all
that,
> I'd be afraid I'd missed something that might come back to bite my
behind.
>
> Can I ask what kind of testing you do before letting something like
that
> rip on your live data? Sorry if I sound too critical - I'd really
LIKE to
> have the confidence and knowledge to do updates like that.
>
> -Wayne



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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor



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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
At 08:21 AM 9/24/2001 , you wrote:
>Now let me see if I got this right. There is progress code that can do
>this. But there are some issues. 1) I have never done anything like that
>and 2) you could perminently mess up you Vantage code.

You would need to procure the ProVision development package and your own
programming resources; Or make arrangements with an outsider who does to
compile a program to do it. Yes, it is possible to bung up your data, or
at least make things inconsistent with how the Vantage programs expect it.

If Epicor gets wind of it.... well, in the past they've made some nasty
threats, like cutting off tech support and such, if you start bypassing
Vantage and poking your own data in directly. Though some places seem to
have gotten their blessing to make updates.

>The other option is to use count entry and generate tags and go line
>by line adjusting your counts.(time consuming but safer) Could you explan
>the Ground Control utility or can I find info on this somewhere.

Ground Control is a share-ware windows scripting or macro utility. You can
write scripts to send key strokes, mouse actions, etc to another windows
program to automate repetitive tasks. An evaluation version 2.10 is in our
files page at Yahoo. The company that writes it is currently up to version
3.0, but found it wasn't compatible with Vantage 4 / Progress 9.0.

-Wayne