Mass Parts movement Whse/Bin to Whse/Bin in 9.05.605B

Yahoo Archive
1
All cycle counts were closed before we started and no new ones were created until we were done and Finance was happy. We actually used the opportunity to do a physical on those two warehouses while we were at it so the reset to the count date was ok for us.

--- In vantage@yahoogroups.com, "erp07052" <erp07052@...> wrote:
>
> Good morning.
> What affect did this have on any of your already scheduled cycles?
> Or did you NOT have any cycle counts already scheduled and selected?
> thanks
>
> --- In vantage@yahoogroups.com, "amvarghai" <amin@> wrote:
> >
> > Thanks for suggestion. I will try this for sure.
> >
> > --- In vantage@yahoogroups.com, "Kirstin Brandt" <kirstin.brandt@> wrote:
> > >
> > > We did this by doing a physical inventory for both warehouses, copying the resulting cycle count data to Excel, adding or appending the counts from WH B into WH A, changing the counts in WH A to zero, then carefully paste-updating the results back into cycle counting. Requires someone decent at Excel and very careful with data, but completely free and not bypassing Epicor's logic.
> > >
> > > --- In vantage@yahoogroups.com, "amvarghai" <amin@> wrote:
> > > >
> > > > Hi,
> > > > I apologize if this question has been asked and answered before. In that case please point me to the right thread.
> > > >
> > > > we had two warehouse (A & B). We have consolidated and got rid of warehouse B. We are trying to reassign about 20K different parts that were in WH B into WH A. It is pretty time consuming to do them one by one. Epicor does not a have batch method for this at the moment. They told to look into DMT or create a updatable BAQ with BPM. They don't have a document for it. It was just a guidance.
> > > >
> > > > We also asked our consultants for a solution and it seems the cost is $5,000+. That seems a bit excessive for a tool we would use just once.
> > > >
> > > > I am wondering if anyone has come across this problem before and what method you used to solve the problem?
> > > >
> > > > thanks,
> > > > Amin
> > > >
> > >
> >
>
2
Hi,
I apologize if this question has been asked and answered before. In that case please point me to the right thread.

we had two warehouse (A & B). We have consolidated and got rid of warehouse B. We are trying to reassign about 20K different parts that were in WH B into WH A. It is pretty time consuming to do them one by one. Epicor does not a have batch method for this at the moment. They told to look into DMT or create a updatable BAQ with BPM. They don't have a document for it. It was just a guidance.

We also asked our consultants for a solution and it seems the cost is $5,000+. That seems a bit excessive for a tool we would use just once.

I am wondering if anyone has come across this problem before and what method you used to solve the problem?

thanks,
Amin
3
Use DMT. Don't remember the exact cost off-hand, but less than that
$5,000+.



We're starting the move of a plant & some outlying warehouses into one
larger building, with physical moves staggered over the next couple of
months. DMT is great for this: write a query to pull all the on-hand
qty for a warehouse/bin, export in the CSV format required by DMT (with
hardcoded destination whse/bin), and process it all automatically as an
inventory transfer. Poof!



Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of amvarghai
Sent: Tuesday, October 16, 2012 12:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Mass Parts movement Whse/Bin to Whse/Bin in 9.05.605B





Hi,
I apologize if this question has been asked and answered before. In that
case please point me to the right thread.

we had two warehouse (A & B). We have consolidated and got rid of
warehouse B. We are trying to reassign about 20K different parts that
were in WH B into WH A. It is pretty time consuming to do them one by
one. Epicor does not a have batch method for this at the moment. They
told to look into DMT or create a updatable BAQ with BPM. They don't
have a document for it. It was just a guidance.

We also asked our consultants for a solution and it seems the cost is
$5,000+. That seems a bit excessive for a tool we would use just once.

I am wondering if anyone has come across this problem before and what
method you used to solve the problem?

thanks,
Amin





[Non-text portions of this message have been removed]
4
If you're SQL, you're set -- Carefully do an update. Otherwise, updatable
BAQs are easy. DMT is ridiculously expensive.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
amvarghai
Sent: Tuesday, October 16, 2012 12:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Mass Parts movement Whse/Bin to Whse/Bin in 9.05.605B





Hi,
I apologize if this question has been asked and answered before. In that
case please point me to the right thread.

we had two warehouse (A & B). We have consolidated and got rid of warehouse
B. We are trying to reassign about 20K different parts that were in WH B
into WH A. It is pretty time consuming to do them one by one. Epicor does
not a have batch method for this at the moment. They told to look into DMT
or create a updatable BAQ with BPM. They don't have a document for it. It
was just a guidance.

We also asked our consultants for a solution and it seems the cost is
$5,000+. That seems a bit excessive for a tool we would use just once.

I am wondering if anyone has come across this problem before and what method
you used to solve the problem?

thanks,
Amin



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5334 - Release Date: 10/15/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5334 - Release Date: 10/15/12

[Non-text portions of this message have been removed]
5
Your consultant should be able to write a simple BPM to do this its not too
bad.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Oct 16, 2012 at 2:35 PM, Vic Drecchio
<vic.drecchio@...>wrote:

> **
>
>
> If you're SQL, you're set -- Carefully do an update. Otherwise, updatable
> BAQs are easy. DMT is ridiculously expensive.
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> amvarghai
> Sent: Tuesday, October 16, 2012 12:30 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Mass Parts movement Whse/Bin to Whse/Bin in 9.05.605B
>
> Hi,
> I apologize if this question has been asked and answered before. In that
> case please point me to the right thread.
>
> we had two warehouse (A & B). We have consolidated and got rid of warehouse
> B. We are trying to reassign about 20K different parts that were in WH B
> into WH A. It is pretty time consuming to do them one by one. Epicor does
> not a have batch method for this at the moment. They told to look into DMT
> or create a updatable BAQ with BPM. They don't have a document for it. It
> was just a guidance.
>
> We also asked our consultants for a solution and it seems the cost is
> $5,000+. That seems a bit excessive for a tool we would use just once.
>
> I am wondering if anyone has come across this problem before and what
> method
> you used to solve the problem?
>
> thanks,
> Amin
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5334 - Release Date: 10/15/12
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5334 - Release Date: 10/15/12
>
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
6
We did this by doing a physical inventory for both warehouses, copying the resulting cycle count data to Excel, adding or appending the counts from WH B into WH A, changing the counts in WH A to zero, then carefully paste-updating the results back into cycle counting. Requires someone decent at Excel and very careful with data, but completely free and not bypassing Epicor's logic.

--- In vantage@yahoogroups.com, "amvarghai" <amin@...> wrote:
>
> Hi,
> I apologize if this question has been asked and answered before. In that case please point me to the right thread.
>
> we had two warehouse (A & B). We have consolidated and got rid of warehouse B. We are trying to reassign about 20K different parts that were in WH B into WH A. It is pretty time consuming to do them one by one. Epicor does not a have batch method for this at the moment. They told to look into DMT or create a updatable BAQ with BPM. They don't have a document for it. It was just a guidance.
>
> We also asked our consultants for a solution and it seems the cost is $5,000+. That seems a bit excessive for a tool we would use just once.
>
> I am wondering if anyone has come across this problem before and what method you used to solve the problem?
>
> thanks,
> Amin
>
7
Thanks for suggestion. I will try this for sure.

--- In vantage@yahoogroups.com, "Kirstin Brandt" <kirstin.brandt@...> wrote:
>
> We did this by doing a physical inventory for both warehouses, copying the resulting cycle count data to Excel, adding or appending the counts from WH B into WH A, changing the counts in WH A to zero, then carefully paste-updating the results back into cycle counting. Requires someone decent at Excel and very careful with data, but completely free and not bypassing Epicor's logic.
>
> --- In vantage@yahoogroups.com, "amvarghai" <amin@> wrote:
> >
> > Hi,
> > I apologize if this question has been asked and answered before. In that case please point me to the right thread.
> >
> > we had two warehouse (A & B). We have consolidated and got rid of warehouse B. We are trying to reassign about 20K different parts that were in WH B into WH A. It is pretty time consuming to do them one by one. Epicor does not a have batch method for this at the moment. They told to look into DMT or create a updatable BAQ with BPM. They don't have a document for it. It was just a guidance.
> >
> > We also asked our consultants for a solution and it seems the cost is $5,000+. That seems a bit excessive for a tool we would use just once.
> >
> > I am wondering if anyone has come across this problem before and what method you used to solve the problem?
> >
> > thanks,
> > Amin
> >
>
8
I thought it would be a simple BPM as well, but apparently I have to learn BPMs or switch consultants.

thanks for the suggestion.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Your consultant should be able to write a simple BPM to do this its not too
> bad.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Tue, Oct 16, 2012 at 2:35 PM, Vic Drecchio
> <vic.drecchio@...>wrote:
>
> > **
> >
> >
> > If you're SQL, you're set -- Carefully do an update. Otherwise, updatable
> > BAQs are easy. DMT is ridiculously expensive.
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of
> > amvarghai
> > Sent: Tuesday, October 16, 2012 12:30 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Mass Parts movement Whse/Bin to Whse/Bin in 9.05.605B
> >
> > Hi,
> > I apologize if this question has been asked and answered before. In that
> > case please point me to the right thread.
> >
> > we had two warehouse (A & B). We have consolidated and got rid of warehouse
> > B. We are trying to reassign about 20K different parts that were in WH B
> > into WH A. It is pretty time consuming to do them one by one. Epicor does
> > not a have batch method for this at the moment. They told to look into DMT
> > or create a updatable BAQ with BPM. They don't have a document for it. It
> > was just a guidance.
> >
> > We also asked our consultants for a solution and it seems the cost is
> > $5,000+. That seems a bit excessive for a tool we would use just once.
> >
> > I am wondering if anyone has come across this problem before and what
> > method
> > you used to solve the problem?
> >
> > thanks,
> > Amin
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.2221 / Virus Database: 2441/5334 - Release Date: 10/15/12
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.2221 / Virus Database: 2441/5334 - Release Date: 10/15/12
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
9
Good morning.
What affect did this have on any of your already scheduled cycles?
Or did you NOT have any cycle counts already scheduled and selected?
thanks

--- In vantage@yahoogroups.com, "amvarghai" <amin@...> wrote:
>
> Thanks for suggestion. I will try this for sure.
>
> --- In vantage@yahoogroups.com, "Kirstin Brandt" <kirstin.brandt@> wrote:
> >
> > We did this by doing a physical inventory for both warehouses, copying the resulting cycle count data to Excel, adding or appending the counts from WH B into WH A, changing the counts in WH A to zero, then carefully paste-updating the results back into cycle counting. Requires someone decent at Excel and very careful with data, but completely free and not bypassing Epicor's logic.
> >
> > --- In vantage@yahoogroups.com, "amvarghai" <amin@> wrote:
> > >
> > > Hi,
> > > I apologize if this question has been asked and answered before. In that case please point me to the right thread.
> > >
> > > we had two warehouse (A & B). We have consolidated and got rid of warehouse B. We are trying to reassign about 20K different parts that were in WH B into WH A. It is pretty time consuming to do them one by one. Epicor does not a have batch method for this at the moment. They told to look into DMT or create a updatable BAQ with BPM. They don't have a document for it. It was just a guidance.
> > >
> > > We also asked our consultants for a solution and it seems the cost is $5,000+. That seems a bit excessive for a tool we would use just once.
> > >
> > > I am wondering if anyone has come across this problem before and what method you used to solve the problem?
> > >
> > > thanks,
> > > Amin
> > >
> >
>