Parts On Hand + Total Sales Dashboard/Tracker

Create the main dashboard from the Part Plant (or Warehouse I can't
remember off the top of my head)

Publish the company and part num

Add at tracker view using the shipment details filtered on Company and
Partnum

Add a filter to get only those shipments from the last 12 months

Set it to group and summarize the shipments by Year/Month (The shippers
do not contain fiscal information)



Or create a query that summarizes the shipments and display that in the
sub tracker.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of thedemondamian
Sent: Friday, October 23, 2009 11:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Parts On Hand + Total Sales Dashboard/Tracker





I need a dashboard that will show me the OnHandQTY, Total Demand, and
the last 12 months Total Shipped Qty per Fiscal Period (by part).

For example; one line of the grid would look like this:
Part | OnHandQTY | Demand | Fiscal 1 | Fical 2 | Fiscal 3...

I do not believe that this can be done through a standard BAQ.

The only way I can see to do it is to create a dashboard, add a tracker
view, throw a grid on it, gather the data and manipulate it in the
script editor. Then throw it in the grid.

Any Ideas!?!





[Non-text portions of this message have been removed]
I need a dashboard that will show me the OnHandQTY, Total Demand, and the last 12 months Total Shipped Qty per Fiscal Period (by part).

For example; one line of the grid would look like this:
Part | OnHandQTY | Demand | Fiscal 1 | Fical 2 | Fiscal 3...

I do not believe that this can be done through a standard BAQ.

The only way I can see to do it is to create a dashboard, add a tracker view, throw a grid on it, gather the data and manipulate it in the script editor. Then throw it in the grid.

Any Ideas!?!