Help with an idea

Yahoo Archive
1
Im actually on with something similar but Im working from the top-level part
down over to the raw material.

Mine is going like this ...

For an order with part x.

For Part x is the demand greater than the on hand?

If it is, which jobs are out for that part and what stage are they are?

Thats the point Im up to now.

Ive got it working nicely on a web page which refreshes the with BAQ data every
30 seconds so the aim is to put it on displays throughout the building so area
managers are always up to date.

The next step I want to do is to display all sub-assembly / raw material
shortages.


Â



________________________________
From: "Trzaska, Mark" <mtrzaska@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thu, 24 February, 2011 21:34:11
Subject: [Vantage] help with an idea

Â
Hi all,

I am looking to create a dashboard that contains the following.

1) Part #

2) Qty on Hand

3) Raw Material part # used to make above Part #

4) Qty on hand for raw material

5) Any raw material on order

6) Active jobs running part #

I know there are many ways to right click to get all this. But I need an
executive style dashboard.
Simple and to the point.

Im having issues figuring out in the BAQ which tables to select and their
corresponding relationships.

If anyone can give me a hint on what would be the tables to use in order as wee
as links that would be helpful.

Thank You

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







[Non-text portions of this message have been removed]
2
Hi all,

I am looking to create a dashboard that contains the following.


1) Part #

2) Qty on Hand

3) Raw Material part # used to make above Part #

4) Qty on hand for raw material

5) Any raw material on order

6) Active jobs running part #


I know there are many ways to right click to get all this. But I need an executive style dashboard.
Simple and to the point.

Im having issues figuring out in the BAQ which tables to select and their corresponding relationships.

If anyone can give me a hint on what would be the tables to use in order as wee as links that would be helpful.

Thank You



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