Mystery of the Missing WH-1260s (revised)

Yahoo Archive
1
Have you looked at the part transaction history to see what the system recorded for movement of the part?
Is it possible that whoever issued the part to the job (assuming that it was on the job as a material) did not issue the correct qty?




________________________________
From: Ree Pruehs <rpruehs@...>
To: vantage@yahoogroups.com
Sent: Wednesday, August 21, 2013 2:09 PM
Subject: [Vantage] Mystery of the Missing WH-1260s (revised)



Â
I seem to be trying to cause even more confusion. Sorry about that.
Let's try this again.

____

We are currently running Epicor 9.05-700C and are encountering a
difficulty with reconciling inventory. Here is the situation:

We had an order for ten pieces of a given product, each of which
requires one piece of a specific part (WH-1260). The order was built and
shipped, and the supervisor is certain she entered her targets into the
system accurately. The traveler shows up as closed in the system.

Our problem is that inventory was relieved of only one of the WH-1260,
not ten.

Now we need to build more product using the WH-1260, and Epicor is
showing that we have nine pieces of WH-1260 in stock where actually we
used them all up building the previous order.

How can we begin to track out what really happened? Any ideas? Are we
looking at a problem with how the traveler was closed, the target
entered, a setting somewhere in E9? (The BOM for the end product is
correct and shows the correct quantity requirement for the WH-1260.)

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




[Non-text portions of this message have been removed]
2
We are getting started reviewing the upgrade to 9.05.701 from 9.05.605. We
are considering going to SQL Server 2012 at the same time. Is anyone else
making the jump to the latest release?



*Tanya Denison* | IT Manager | NRS, Inc.

*2009 S. Main Street, Moscow, ID 83843*



*tdenison@... *|* www.nrsweb.com*

*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*


[Non-text portions of this message have been removed]
3
I tried to make the jump but the data conversion ran horribly. When I called support they said SQL2012 was not supported, even though it showed it in the diagrams in the install guides.

Once I rolled back to SQL 2008 R2 the data conversions ran fine. I suppose you could convert on SQL 2008 R2 then restore it to a SQL 2012 server, but unless support signs off on SQL2012 I can just bet what any answer will be on a support call for issues...

--- In vantage@yahoogroups.com, Tanya Denison wrote:
>
> We are getting started reviewing the upgrade to 9.05.701 from 9.05.605. We
> are considering going to SQL Server 2012 at the same time. Is anyone else
> making the jump to the latest release?
>
>
>
> *Tanya Denison* | IT Manager | NRS, Inc.
>
> *2009 S. Main Street, Moscow, ID 83843*
>
>
>
> *tdenison@... *|* www.nrsweb.com*
>
> *c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
>
>
> [Non-text portions of this message have been removed]
>
4
I called Epicor support to see what their stance is, and they did validate
that SQL Server 2012 is supported. One of my team suggested that it might
have been that you needed to roll back the Native Client to version 10,
since 2012 installs version 11.



*Tanya Denison* | IT Manager | NRS, Inc.

*2009 S. Main Street, Moscow, ID 83843*



*tdenison@... *|* www.nrsweb.com*

*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*



*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
Of *Jennifer
*Sent:* Monday, February 04, 2013 1:55 PM
*To:* vantage@yahoogroups.com
*Subject:* [Vantage] Re: SQL Server 2012





I tried to make the jump but the data conversion ran horribly. When I
called support they said SQL2012 was not supported, even though it showed
it in the diagrams in the install guides.

Once I rolled back to SQL 2008 R2 the data conversions ran fine. I suppose
you could convert on SQL 2008 R2 then restore it to a SQL 2012 server, but
unless support signs off on SQL2012 I can just bet what any answer will be
on a support call for issues...

--- In vantage@yahoogroups.com, Tanya Denison wrote:
>
> We are getting started reviewing the upgrade to 9.05.701 from 9.05.605. We
> are considering going to SQL Server 2012 at the same time. Is anyone else
> making the jump to the latest release?
>
>
>
> *Tanya Denison* | IT Manager | NRS, Inc.
>
> *2009 S. Main Street, Moscow, ID 83843*
>
>
>
> *tdenison@... *|* www.nrsweb.com*
>
> *c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
5
Usually the problem with conversions is that you have the DB set to the
wrong compatibility mode, it needs to be running as a SQL 100 DB, by default
I believe it is setup to run as a 110 DB unless you manually change it.

You need to be at 701 for support to help with SQL 2012, .700 and they will
say it's unsupported.

And you can just install the 10.0 native client on the servers or
workstations so the ones who need it have it, it will co-exist with 11.0.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jennifer
Sent: Monday, February 04, 2013 4:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: SQL Server 2012

I tried to make the jump but the data conversion ran horribly. When I
called support they said SQL2012 was not supported, even though it showed it
in the diagrams in the install guides.

Once I rolled back to SQL 2008 R2 the data conversions ran fine. I suppose
you could convert on SQL 2008 R2 then restore it to a SQL 2012 server, but
unless support signs off on SQL2012 I can just bet what any answer will be
on a support call for issues...

--- In vantage@yahoogroups.com, Tanya Denison wrote:
>
> We are getting started reviewing the upgrade to 9.05.701 from
> 9.05.605. We are considering going to SQL Server 2012 at the same
> time. Is anyone else making the jump to the latest release?
>
>
>
> *Tanya Denison* | IT Manager | NRS, Inc.
>
> *2009 S. Main Street, Moscow, ID 83843*
>
>
>
> *tdenison@... *|* www.nrsweb.com*
>
> *c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
>
>
> [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/.
(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/linksYahoo! Groups Links
6
We're on 9.05.700C and are migrating to 9.05.700 as well as switching from Progress to SQL 2012.

So far we've had no problems and our first pass of the database from Ben Nixon's group hasn't had a problem. In fact, we took the converted DB at the 9.05.700C level and I ran all the conversions on our new SQL based server and had no issues whatsoever.

--- In vantage@yahoogroups.com, Tanya Denison wrote:
>
> We are getting started reviewing the upgrade to 9.05.701 from 9.05.605. We
> are considering going to SQL Server 2012 at the same time. Is anyone else
> making the jump to the latest release?
>
>
>
> *Tanya Denison* | IT Manager | NRS, Inc.
>
> *2009 S. Main Street, Moscow, ID 83843*
>
>
>
> *tdenison@... *|* www.nrsweb.com*
>
> *c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
>
>
> [Non-text portions of this message have been removed]
>
7
Yeesh, make that we're going to 9.05.701.. typo there.

--- In vantage@yahoogroups.com, "pbparker" wrote:
>
> We're on 9.05.700C and are migrating to 9.05.700 as well as switching from Progress to SQL 2012.
>
> So far we've had no problems and our first pass of the database from Ben Nixon's group hasn't had a problem. In fact, we took the converted DB at the 9.05.700C level and I ran all the conversions on our new SQL based server and had no issues whatsoever.
>
> --- In vantage@yahoogroups.com, Tanya Denison wrote:
> >
> > We are getting started reviewing the upgrade to 9.05.701 from 9.05.605. We
> > are considering going to SQL Server 2012 at the same time. Is anyone else
> > making the jump to the latest release?
> >
> >
> >
> > *Tanya Denison* | IT Manager | NRS, Inc.
> >
> > *2009 S. Main Street, Moscow, ID 83843*
> >
> >
> >
> > *tdenison@ *|* www.nrsweb.com*
> >
> > *c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
8
Help! I'm pretty sure I saw a script on the group (some time back) to
facilitate closing multiple jobs simultaneously. I've hunted through
both Outlook and Yahoo! and am coming up zilch. Can anyone give me a
hand on this?
9
Hi Ree,



We don't use a script, but we do use DMT to close a list of jobs.



Thanks,



Darryn



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ree Pruehs
Sent: 21 August 2013 16:21
To: vantage@yahoogroups.com
Subject: [Vantage] Closing multiple jobs at once





Help! I'm pretty sure I saw a script on the group (some time back) to
facilitate closing multiple jobs simultaneously. I've hunted through
both Outlook and Yahoo! and am coming up zilch. Can anyone give me a
hand on this?





[Non-text portions of this message have been removed]
10
Is there any efficient way to deal with this situation if we don't have
DMT? (I'm not sure at this point if we do or don't, but the person I
would normally ask is on vacation this week.)



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darryn Ralph
Sent: Wednesday, August 21, 2013 11:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Closing multiple jobs at once





Hi Ree,

We don't use a script, but we do use DMT to close a list of jobs.

Thanks,

Darryn

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ree Pruehs
Sent: 21 August 2013 16:21
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Closing multiple jobs at once

Help! I'm pretty sure I saw a script on the group (some time back) to
facilitate closing multiple jobs simultaneously. I've hunted through
both Outlook and Yahoo! and am coming up zilch. Can anyone give me a
hand on this?

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





[Non-text portions of this message have been removed]
11
If you are on Epicor 905 I have written an updatable dashboard that allows tou to close all jobs attached to a sales order at the same time.

Kent

To: vantage@yahoogroups.com
From: rpruehs@...
Date: Wed, 21 Aug 2013 14:02:53 -0400
Subject: RE: [Vantage] Closing multiple jobs at once


























Is there any efficient way to deal with this situation if we don't have

DMT? (I'm not sure at this point if we do or don't, but the person I

would normally ask is on vacation this week.)



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf

Of Darryn Ralph

Sent: Wednesday, August 21, 2013 11:41 AM

To: vantage@yahoogroups.com

Subject: RE: [Vantage] Closing multiple jobs at once



Hi Ree,



We don't use a script, but we do use DMT to close a list of jobs.



Thanks,



Darryn



From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On

Behalf Of

Ree Pruehs

Sent: 21 August 2013 16:21

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

Subject: [Vantage] Closing multiple jobs at once



Help! I'm pretty sure I saw a script on the group (some time back) to

facilitate closing multiple jobs simultaneously. I've hunted through

both Outlook and Yahoo! and am coming up zilch. Can anyone give me a

hand on this?



[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]
12
...or you could just set your thresholds and run the Auto Job Closing Process if you want to take care of this without customizations - especially if you're not going to review the jobs and just close them automatically.
13
I seem to be trying to cause even more confusion. Sorry about that.
Let's try this again.

____



We are currently running Epicor 9.05-700C and are encountering a
difficulty with reconciling inventory. Here is the situation:



We had an order for ten pieces of a given product, each of which
requires one piece of a specific part (WH-1260). The order was built and
shipped, and the supervisor is certain she entered her targets into the
system accurately. The traveler shows up as closed in the system.



Our problem is that inventory was relieved of only one of the WH-1260,
not ten.



Now we need to build more product using the WH-1260, and Epicor is
showing that we have nine pieces of WH-1260 in stock where actually we
used them all up building the previous order.



How can we begin to track out what really happened? Any ideas? Are we
looking at a problem with how the traveler was closed, the target
entered, a setting somewhere in E9? (The BOM for the end product is
correct and shows the correct quantity requirement for the WH-1260.)







[Non-text portions of this message have been removed]
14
Transaction History, how many were issued?



Patrick Winter



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ree Pruehs
Sent: Wednesday, August 21, 2013 14:09
To: vantage@yahoogroups.com
Subject: [Vantage] Mystery of the Missing WH-1260s (revised)





I seem to be trying to cause even more confusion. Sorry about that.
Let's try this again.

____

We are currently running Epicor 9.05-700C and are encountering a
difficulty with reconciling inventory. Here is the situation:

We had an order for ten pieces of a given product, each of which
requires one piece of a specific part (WH-1260). The order was built and
shipped, and the supervisor is certain she entered her targets into the
system accurately. The traveler shows up as closed in the system.

Our problem is that inventory was relieved of only one of the WH-1260,
not ten.

Now we need to build more product using the WH-1260, and Epicor is
showing that we have nine pieces of WH-1260 in stock where actually we
used them all up building the previous order.

How can we begin to track out what really happened? Any ideas? Are we
looking at a problem with how the traveler was closed, the target
entered, a setting somewhere in E9? (The BOM for the end product is
correct and shows the correct quantity requirement for the WH-1260.)

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





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

Sent from my iPhone

On Aug 21, 2013, at 6:48 PM, "Ree Pruehs" <rpruehs@...<mailto:rpruehs@...>> wrote:



Help! I'm pretty sure I saw a script on the group (some time back) to
facilitate closing multiple jobs simultaneously. I've hunted through
both Outlook and Yahoo! and am coming up zilch. Can anyone give me a
hand on this?




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