Need help in finding data to create BAQ

[system]

If I recall correctly, the core data comes from PartDtl & other data (MRP/PO suggestions), are linked in.
Â
PartDtl may be static though (say after an MRP run snapshot).

From: Bethany Rye <brye@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 1, 2011 12:18 PM
Subject: RE: [Vantage] Re: Need help in finding data to create BAQ


Â
We will be looking at the Job Prod table to try to get the information we
need. It is just sad that we can't get the formula they use to create the
data for Time Phase.

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...> brye@...

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Wednesday, August 31, 2011 6:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Need help in finding data to create BAQ

Have any of you looked at the Job Prod table?

That table usually has demand in it and may help a bit.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of cooner_55421
Sent: Wednesday, August 31, 2011 5:36 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Need help in finding data to create BAQ

Hi Bethanny,

I have the same problem.
I'd sure like to hear if you find something you like.

Dashboards & reports I have come up with so far have been a compromise.
The time phase report is correct but it is really hard to use here, due
to the many levels in our methods & number of components parts involved.

Mfg was sad when we changed to Stock.
They liked Non-Stock because it had those direct links but...
This introduced inefficiencies in so many other areas.
Also cost issues with Average Cost, probably much worse here than in
most environments.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Bethany Rye" <brye@...> wrote:

>
> We have a request to customize the Priority Dispatch report so that we

can

> link the sales orders to each job for stock items. For the

make-to-order

> jobs, we can see the order number but if it is a stock job, it just

says

> "Stock".
>
>
>
> We are changing all of our parts over to stock parts which will make

the

> report useless for us unless we can see what orders will be fulfilled

by the

> stock jobs. We have some very complicated methods that are currently
> non-stock and go levels deep. We will be breaking these apart to

accomplish

> the task of making all parts stock. When we do that, we will lose
> visibility to what parts go to what top level assembly and then

ultimately

> what sales order.
>
>
>
> So our predicament is that we found a variable that we might be able

to use

> but it is in the time phase table, which we have been told is just a
> temporary table that we cannot use. When I asked support how that temp
> table is derived, I got an explanation that it depend on the data in

it, but

> the support person could not tell me how the specific field was

created.

>
>
>
> Any ideas, anyone???
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
>
>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data

within

> the definition of the International Traffic in Arms regulations, and

are

> subject to the export control laws of the US Government. Transfer of

this

> data by any means to a foreign person, whether in the US or abroad,

without

> an export license or other approval from the US Department of State,

is

> prohibited. No portion of this e-mail or its attachment(s) may be

reproduced

> without written consent of CIGNYS. If you are not the intended

recipient or

> believe that you may have received this document in error, please

notify the

> sender and delete this e-mail and any attachments immediately.
>
>
>
>
>
> [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]

[system]

We have a request to customize the Priority Dispatch report so that we can
link the sales orders to each job for stock items. For the make-to-order
jobs, we can see the order number but if it is a stock job, it just says
"Stock".



We are changing all of our parts over to stock parts which will make the
report useless for us unless we can see what orders will be fulfilled by the
stock jobs. We have some very complicated methods that are currently
non-stock and go levels deep. We will be breaking these apart to accomplish
the task of making all parts stock. When we do that, we will lose
visibility to what parts go to what top level assembly and then ultimately
what sales order.



So our predicament is that we found a variable that we might be able to use
but it is in the time phase table, which we have been told is just a
temporary table that we cannot use. When I asked support how that temp
table is derived, I got an explanation that it depend on the data in it, but
the support person could not tell me how the specific field was created.



Any ideas, anyone???



Beth Rye

IT Director

CIGNYS



***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.





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

[system]

If the time phase report is using the same basic business object that the time phase inquiry is you are limited in your flexibility. The time phase inquiry BO creates a truly temp table/dataset that doesn't connect directly to a real table. When the inquiry exits the table/dataset goes away so you can't do much. I have done some slight of hand with a post processing BPM on the time phase inquiry dashboard to pump some extra data into it. During the post processing phase the temp table exists and is fully populated. You can use data in the table to look-up other data, you can also change the data in existing fields. For example a client wanted the customer's name in the dashboard. I used a field the customer didn't care about and put the information in that field. On the dashboard I changed the column heading. I haven't played around with the time phase report so can't say off the top of my head if it uses a similar BO but if it does you might be able to do the same thing with a post BPM on its BO.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "Bethany Rye" <brye@...> wrote:
>
> We have a request to customize the Priority Dispatch report so that we can
> link the sales orders to each job for stock items. For the make-to-order
> jobs, we can see the order number but if it is a stock job, it just says
> "Stock".
>
>
>
> We are changing all of our parts over to stock parts which will make the
> report useless for us unless we can see what orders will be fulfilled by the
> stock jobs. We have some very complicated methods that are currently
> non-stock and go levels deep. We will be breaking these apart to accomplish
> the task of making all parts stock. When we do that, we will lose
> visibility to what parts go to what top level assembly and then ultimately
> what sales order.
>
>
>
> So our predicament is that we found a variable that we might be able to use
> but it is in the time phase table, which we have been told is just a
> temporary table that we cannot use. When I asked support how that temp
> table is derived, I got an explanation that it depend on the data in it, but
> the support person could not tell me how the specific field was created.
>
>
>
> Any ideas, anyone???
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
>
>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data within
> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad, without
> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be reproduced
> without written consent of CIGNYS. If you are not the intended recipient or
> believe that you may have received this document in error, please notify the
> sender and delete this e-mail and any attachments immediately.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[system]

Hi Bethanny,

I have the same problem.
I'd sure like to hear if you find something you like.

Dashboards & reports I have come up with so far have been a compromise. The time phase report is correct but it is really hard to use here, due to the many levels in our methods & number of components parts involved.

Mfg was sad when we changed to Stock.
They liked Non-Stock because it had those direct links but...
This introduced inefficiencies in so many other areas.
Also cost issues with Average Cost, probably much worse here than in most environments.

--- In vantage@yahoogroups.com, "Bethany Rye" <brye@...> wrote:
>
> We have a request to customize the Priority Dispatch report so that we can
> link the sales orders to each job for stock items. For the make-to-order
> jobs, we can see the order number but if it is a stock job, it just says
> "Stock".
>
>
>
> We are changing all of our parts over to stock parts which will make the
> report useless for us unless we can see what orders will be fulfilled by the
> stock jobs. We have some very complicated methods that are currently
> non-stock and go levels deep. We will be breaking these apart to accomplish
> the task of making all parts stock. When we do that, we will lose
> visibility to what parts go to what top level assembly and then ultimately
> what sales order.
>
>
>
> So our predicament is that we found a variable that we might be able to use
> but it is in the time phase table, which we have been told is just a
> temporary table that we cannot use. When I asked support how that temp
> table is derived, I got an explanation that it depend on the data in it, but
> the support person could not tell me how the specific field was created.
>
>
>
> Any ideas, anyone???
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
>
>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data within
> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad, without
> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be reproduced
> without written consent of CIGNYS. If you are not the intended recipient or
> believe that you may have received this document in error, please notify the
> sender and delete this e-mail and any attachments immediately.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[system]

Have any of you looked at the Job Prod table?



That table usually has demand in it and may help a bit.







M. Manasa Reddy

manasa@...

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Wednesday, August 31, 2011 5:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need help in finding data to create BAQ





Hi Bethanny,

I have the same problem.
I'd sure like to hear if you find something you like.

Dashboards & reports I have come up with so far have been a compromise.
The time phase report is correct but it is really hard to use here, due
to the many levels in our methods & number of components parts involved.

Mfg was sad when we changed to Stock.
They liked Non-Stock because it had those direct links but...
This introduced inefficiencies in so many other areas.
Also cost issues with Average Cost, probably much worse here than in
most environments.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Bethany Rye" <brye@...> wrote:

>
> We have a request to customize the Priority Dispatch report so that we

can

> link the sales orders to each job for stock items. For the

make-to-order

> jobs, we can see the order number but if it is a stock job, it just

says

> "Stock".
>
>
>
> We are changing all of our parts over to stock parts which will make

the

> report useless for us unless we can see what orders will be fulfilled

by the

> stock jobs. We have some very complicated methods that are currently
> non-stock and go levels deep. We will be breaking these apart to

accomplish

> the task of making all parts stock. When we do that, we will lose
> visibility to what parts go to what top level assembly and then

ultimately

> what sales order.
>
>
>
> So our predicament is that we found a variable that we might be able

to use

> but it is in the time phase table, which we have been told is just a
> temporary table that we cannot use. When I asked support how that temp
> table is derived, I got an explanation that it depend on the data in

it, but

> the support person could not tell me how the specific field was

created.

>
>
>
> Any ideas, anyone???
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
>
>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data

within

> the definition of the International Traffic in Arms regulations, and

are

> subject to the export control laws of the US Government. Transfer of

this

> data by any means to a foreign person, whether in the US or abroad,

without

> an export license or other approval from the US Department of State,

is

> prohibited. No portion of this e-mail or its attachment(s) may be

reproduced

> without written consent of CIGNYS. If you are not the intended

recipient or

> believe that you may have received this document in error, please

notify the

> sender and delete this e-mail and any attachments immediately.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

[system]

I use the JobProd table in a few reports.
You are right, it has a lot of good info.

Nice supply and demand fields too but...
Those stopped being populated when we changed to stock parts.

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Have any of you looked at the Job Prod table?
>
>
>
> That table usually has demand in it and may help a bit.
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> 630.806.2000 x1515
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of cooner_55421
> Sent: Wednesday, August 31, 2011 5:36 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Need help in finding data to create BAQ
>
>
>
>
>
> Hi Bethanny,
>
> I have the same problem.
> I'd sure like to hear if you find something you like.
>
> Dashboards & reports I have come up with so far have been a compromise.
> The time phase report is correct but it is really hard to use here, due
> to the many levels in our methods & number of components parts involved.
>
> Mfg was sad when we changed to Stock.
> They liked Non-Stock because it had those direct links but...
> This introduced inefficiencies in so many other areas.
> Also cost issues with Average Cost, probably much worse here than in
> most environments.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Bethany Rye" <brye@> wrote:
> >
> > We have a request to customize the Priority Dispatch report so that we
> can
> > link the sales orders to each job for stock items. For the
> make-to-order
> > jobs, we can see the order number but if it is a stock job, it just
> says
> > "Stock".
> >
> >
> >
> > We are changing all of our parts over to stock parts which will make
> the
> > report useless for us unless we can see what orders will be fulfilled
> by the
> > stock jobs. We have some very complicated methods that are currently
> > non-stock and go levels deep. We will be breaking these apart to
> accomplish
> > the task of making all parts stock. When we do that, we will lose
> > visibility to what parts go to what top level assembly and then
> ultimately
> > what sales order.
> >
> >
> >
> > So our predicament is that we found a variable that we might be able
> to use
> > but it is in the time phase table, which we have been told is just a
> > temporary table that we cannot use. When I asked support how that temp
> > table is derived, I got an explanation that it depend on the data in
> it, but
> > the support person could not tell me how the specific field was
> created.
> >
> >
> >
> > Any ideas, anyone???
> >
> >
> >
> > Beth Rye
> >
> > IT Director
> >
> > CIGNYS
> >
> >
> >
> > ***ITAR NOTICE***
> >
> > This e-mail and/or the attached documents may contain technical data
> within
> > the definition of the International Traffic in Arms regulations, and
> are
> > subject to the export control laws of the US Government. Transfer of
> this
> > data by any means to a foreign person, whether in the US or abroad,
> without
> > an export license or other approval from the US Department of State,
> is
> > prohibited. No portion of this e-mail or its attachment(s) may be
> reproduced
> > without written consent of CIGNYS. If you are not the intended
> recipient or
> > believe that you may have received this document in error, please
> notify the
> > sender and delete this e-mail and any attachments immediately.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[system]

>Those stopped being populated when we changed to stock parts.

I take that back.
I see OrderNums are populated for some jobs with Stock Parts.
I guess I'll have to check a little deeper on this one.
Why some are populated & others not...

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> I use the JobProd table in a few reports.
> You are right, it has a lot of good info.
>
> Nice supply and demand fields too but...
> Those stopped being populated when we changed to stock parts.
>
> --- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@> wrote:
> >
> > Have any of you looked at the Job Prod table?
> >
> >
> >
> > That table usually has demand in it and may help a bit.
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > manasa@
> >
> > 630.806.2000 x1515
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of cooner_55421
> > Sent: Wednesday, August 31, 2011 5:36 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Need help in finding data to create BAQ
> >
> >
> >
> >
> >
> > Hi Bethanny,
> >
> > I have the same problem.
> > I'd sure like to hear if you find something you like.
> >
> > Dashboards & reports I have come up with so far have been a compromise.
> > The time phase report is correct but it is really hard to use here, due
> > to the many levels in our methods & number of components parts involved.
> >
> > Mfg was sad when we changed to Stock.
> > They liked Non-Stock because it had those direct links but...
> > This introduced inefficiencies in so many other areas.
> > Also cost issues with Average Cost, probably much worse here than in
> > most environments.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Bethany Rye" <brye@> wrote:
> > >
> > > We have a request to customize the Priority Dispatch report so that we
> > can
> > > link the sales orders to each job for stock items. For the
> > make-to-order
> > > jobs, we can see the order number but if it is a stock job, it just
> > says
> > > "Stock".
> > >
> > >
> > >
> > > We are changing all of our parts over to stock parts which will make
> > the
> > > report useless for us unless we can see what orders will be fulfilled
> > by the
> > > stock jobs. We have some very complicated methods that are currently
> > > non-stock and go levels deep. We will be breaking these apart to
> > accomplish
> > > the task of making all parts stock. When we do that, we will lose
> > > visibility to what parts go to what top level assembly and then
> > ultimately
> > > what sales order.
> > >
> > >
> > >
> > > So our predicament is that we found a variable that we might be able
> > to use
> > > but it is in the time phase table, which we have been told is just a
> > > temporary table that we cannot use. When I asked support how that temp
> > > table is derived, I got an explanation that it depend on the data in
> > it, but
> > > the support person could not tell me how the specific field was
> > created.
> > >
> > >
> > >
> > > Any ideas, anyone???
> > >
> > >
> > >
> > > Beth Rye
> > >
> > > IT Director
> > >
> > > CIGNYS
> > >
> > >
> > >
> > > ***ITAR NOTICE***
> > >
> > > This e-mail and/or the attached documents may contain technical data
> > within
> > > the definition of the International Traffic in Arms regulations, and
> > are
> > > subject to the export control laws of the US Government. Transfer of
> > this
> > > data by any means to a foreign person, whether in the US or abroad,
> > without
> > > an export license or other approval from the US Department of State,
> > is
> > > prohibited. No portion of this e-mail or its attachment(s) may be
> > reproduced
> > > without written consent of CIGNYS. If you are not the intended
> > recipient or
> > > believe that you may have received this document in error, please
> > notify the
> > > sender and delete this e-mail and any attachments immediately.
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

[system]

> I guess I'll have to check a little deeper on this one.

JobProd - OrderNum was filled in for some NonStock parts

I forgot we do this sometimes still...
It is from the "Make Direct" (Override) checkbox in the Sale Order release.
So, without manual intervention, NonStock parts don't normally fill the OrderNum field in JobProd.

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> >Those stopped being populated when we changed to stock parts.
>
> I take that back.
> I see OrderNums are populated for some jobs with Stock Parts.
> I guess I'll have to check a little deeper on this one.
> Why some are populated & others not...
>
>
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > I use the JobProd table in a few reports.
> > You are right, it has a lot of good info.
> >
> > Nice supply and demand fields too but...
> > Those stopped being populated when we changed to stock parts.
> >
> > --- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@> wrote:
> > >
> > > Have any of you looked at the Job Prod table?
> > >
> > >
> > >
> > > That table usually has demand in it and may help a bit.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > M. Manasa Reddy
> > >
> > > manasa@
> > >
> > > 630.806.2000 x1515
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of cooner_55421
> > > Sent: Wednesday, August 31, 2011 5:36 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Need help in finding data to create BAQ
> > >
> > >
> > >
> > >
> > >
> > > Hi Bethanny,
> > >
> > > I have the same problem.
> > > I'd sure like to hear if you find something you like.
> > >
> > > Dashboards & reports I have come up with so far have been a compromise.
> > > The time phase report is correct but it is really hard to use here, due
> > > to the many levels in our methods & number of components parts involved.
> > >
> > > Mfg was sad when we changed to Stock.
> > > They liked Non-Stock because it had those direct links but...
> > > This introduced inefficiencies in so many other areas.
> > > Also cost issues with Average Cost, probably much worse here than in
> > > most environments.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > "Bethany Rye" <brye@> wrote:
> > > >
> > > > We have a request to customize the Priority Dispatch report so that we
> > > can
> > > > link the sales orders to each job for stock items. For the
> > > make-to-order
> > > > jobs, we can see the order number but if it is a stock job, it just
> > > says
> > > > "Stock".
> > > >
> > > >
> > > >
> > > > We are changing all of our parts over to stock parts which will make
> > > the
> > > > report useless for us unless we can see what orders will be fulfilled
> > > by the
> > > > stock jobs. We have some very complicated methods that are currently
> > > > non-stock and go levels deep. We will be breaking these apart to
> > > accomplish
> > > > the task of making all parts stock. When we do that, we will lose
> > > > visibility to what parts go to what top level assembly and then
> > > ultimately
> > > > what sales order.
> > > >
> > > >
> > > >
> > > > So our predicament is that we found a variable that we might be able
> > > to use
> > > > but it is in the time phase table, which we have been told is just a
> > > > temporary table that we cannot use. When I asked support how that temp
> > > > table is derived, I got an explanation that it depend on the data in
> > > it, but
> > > > the support person could not tell me how the specific field was
> > > created.
> > > >
> > > >
> > > >
> > > > Any ideas, anyone???
> > > >
> > > >
> > > >
> > > > Beth Rye
> > > >
> > > > IT Director
> > > >
> > > > CIGNYS
> > > >
> > > >
> > > >
> > > > ***ITAR NOTICE***
> > > >
> > > > This e-mail and/or the attached documents may contain technical data
> > > within
> > > > the definition of the International Traffic in Arms regulations, and
> > > are
> > > > subject to the export control laws of the US Government. Transfer of
> > > this
> > > > data by any means to a foreign person, whether in the US or abroad,
> > > without
> > > > an export license or other approval from the US Department of State,
> > > is
> > > > prohibited. No portion of this e-mail or its attachment(s) may be
> > > reproduced
> > > > without written consent of CIGNYS. If you are not the intended
> > > recipient or
> > > > believe that you may have received this document in error, please
> > > notify the
> > > > sender and delete this e-mail and any attachments immediately.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>

[system]

The costing issues in FIFO are much greater when you don't ship from stock.
We are not happy that we chose FIFO now. L



Beth



Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...> brye@...



***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cooner_55421
Sent: Wednesday, August 31, 2011 6:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need help in finding data to create BAQ





Hi Bethanny,

I have the same problem.
I'd sure like to hear if you find something you like.

Dashboards & reports I have come up with so far have been a compromise. The
time phase report is correct but it is really hard to use here, due to the
many levels in our methods & number of components parts involved.

Mfg was sad when we changed to Stock.
They liked Non-Stock because it had those direct links but...
This introduced inefficiencies in so many other areas.
Also cost issues with Average Cost, probably much worse here than in most
environments.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Bethany
Rye" <brye@...> wrote:

>
> We have a request to customize the Priority Dispatch report so that we can
> link the sales orders to each job for stock items. For the make-to-order
> jobs, we can see the order number but if it is a stock job, it just says
> "Stock".
>
>
>
> We are changing all of our parts over to stock parts which will make the
> report useless for us unless we can see what orders will be fulfilled by

the

> stock jobs. We have some very complicated methods that are currently
> non-stock and go levels deep. We will be breaking these apart to

accomplish

> the task of making all parts stock. When we do that, we will lose
> visibility to what parts go to what top level assembly and then ultimately
> what sales order.
>
>
>
> So our predicament is that we found a variable that we might be able to

use

> but it is in the time phase table, which we have been told is just a
> temporary table that we cannot use. When I asked support how that temp
> table is derived, I got an explanation that it depend on the data in it,

but

> the support person could not tell me how the specific field was created.
>
>
>
> Any ideas, anyone???
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
>
>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data

within

> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad,

without

> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be

reproduced

> without written consent of CIGNYS. If you are not the intended recipient

or

> believe that you may have received this document in error, please notify

the

> sender and delete this e-mail and any attachments immediately.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

[system]

We will be looking at the Job Prod table to try to get the information we
need. It is just sad that we can't get the formula they use to create the
data for Time Phase.



Beth



Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...> brye@...



***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Wednesday, August 31, 2011 6:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Need help in finding data to create BAQ





Have any of you looked at the Job Prod table?

That table usually has demand in it and may help a bit.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of cooner_55421
Sent: Wednesday, August 31, 2011 5:36 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Need help in finding data to create BAQ

Hi Bethanny,

I have the same problem.
I'd sure like to hear if you find something you like.

Dashboards & reports I have come up with so far have been a compromise.
The time phase report is correct but it is really hard to use here, due
to the many levels in our methods & number of components parts involved.

Mfg was sad when we changed to Stock.
They liked Non-Stock because it had those direct links but...
This introduced inefficiencies in so many other areas.
Also cost issues with Average Cost, probably much worse here than in
most environments.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Bethany Rye" <brye@...> wrote:

>
> We have a request to customize the Priority Dispatch report so that we

can

> link the sales orders to each job for stock items. For the

make-to-order

> jobs, we can see the order number but if it is a stock job, it just

says

> "Stock".
>
>
>
> We are changing all of our parts over to stock parts which will make

the

> report useless for us unless we can see what orders will be fulfilled

by the

> stock jobs. We have some very complicated methods that are currently
> non-stock and go levels deep. We will be breaking these apart to

accomplish

> the task of making all parts stock. When we do that, we will lose
> visibility to what parts go to what top level assembly and then

ultimately

> what sales order.
>
>
>
> So our predicament is that we found a variable that we might be able

to use

> but it is in the time phase table, which we have been told is just a
> temporary table that we cannot use. When I asked support how that temp
> table is derived, I got an explanation that it depend on the data in

it, but

> the support person could not tell me how the specific field was

created.

>
>
>
> Any ideas, anyone???
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
>
>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data

within

> the definition of the International Traffic in Arms regulations, and

are

> subject to the export control laws of the US Government. Transfer of

this

> data by any means to a foreign person, whether in the US or abroad,

without

> an export license or other approval from the US Department of State,

is

> prohibited. No portion of this e-mail or its attachment(s) may be

reproduced

> without written consent of CIGNYS. If you are not the intended

recipient or

> believe that you may have received this document in error, please

notify the

> sender and delete this e-mail and any attachments immediately.
>
>
>
>
>
> [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]