Usage Report 8.03.409c

Yahoo Archive
1
I uploaded our inventory usage report under Reports - Crystal Reports. It's a BAQ report that lets you choose a date range and filter by part or class. It then gives you total usage over the date range and calculates a monthly average.

HTH, Kirstin

--- In vantage@yahoogroups.com, Keith Walter <keithfwalter@...> wrote:
>
> Does anyone have a good part usage report? We use thw Inventory Usage
> Report, but it is a progress report. We really need something to show average
> and/or total usage summed by part number. The Inventory Usage report would be
> fine if it were Crystal. We currently query PartTran and export to Excel,
> however we are hitting the 65k row limit. I am hoping to not re-invent the
> wheel, but may have to write a crystal report myself. Just hoping somone can
> show some pitty on me!!!Â
>
>
> THanks!
> Â
> Keith Walter
> Vantage Coordinator
> Norgren Automation Solutions, Saline Division
> keith.walter@...
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Does anyone have a good part usage report? We use thw Inventory Usage
Report, but it is a progress report. We really need something to show average
and/or total usage summed by part number. The Inventory Usage report would be
fine if it were Crystal. We currently query PartTran and export to Excel,
however we are hitting the 65k row limit. I am hoping to not re-invent the
wheel, but may have to write a crystal report myself. Just hoping somone can
show some pitty on me!!!Â


THanks!
Â
Keith Walter
Vantage Coordinator
Norgren Automation Solutions, Saline Division
keith.walter@...




[Non-text portions of this message have been removed]
3
We are using Office 2007 and it as a million rows or so....

We are Extracting straight to Excel Via ODBC and have configured users with Analysis tab whereby they can change few parameters to review and quickly analyse parts without having to re-run Crystal.

They have the ability to review usage while changing date intervals in Excel Cells. We also linked in this file a list of extract from part master and or PartPlant to provide users with planning data such as min, max,.......

It is much faster than getting data in Vantage and copy paste to Excel.



Benoit Desjardins
Marquez Transtech Ltée



________________________________
AVIS IMPORTANT: Cette transmission électronique est strictement réservée à l'usage de la (des) personne(s) à qui elle est adressée et contient des informations privilégiées et confidentielles. Toute divulgation, distribution, copie, ou autre utilisation de cette transmission par une autre personne est strictement prohibée. Si vous avez reçu ce courriel par erreur, veuillez s'il vous plaît en aviser immédiatement l'expéditeur par courriel et détruire tout exemplaire ou copie de la transmission originale.

WARNING: This electronic transmission contains confidential information, intended only for the person(s) named above, and is privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or any other use of this email is strictly prohibited. If you have received this transmission by error, please notify us immediately by return email and destroy the original transmission immediately and all copies thereof.


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