Part history usage

Yahoo Archive
1
Either. With a BAQ you would summarize your chosen period bucket totals in a BAQ report.
You can also do it via SQL out of excel or a web page. I'd be leary of that though as hitting a huge table like parttran w/ SQL may result in system load issues (slowing down user apps).

--- Original Message ---
From:"michael.hutcheson@..." <michael.hutcheson@...>
Sent:Fri 7/2/10 11:01 am
To:vantage@yahoogroups.com
Subj:[Vantage] Re: Part history usage

would this all be possible using a BAQ or will I have to use crystal?

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Parttran is what you want. Just filter on the types pertinent to you. You can also get fancy & seperate independent from dependent use based on type. How you choose to bucket summarize (quarterly, monthly, weekly) is up to you.
>
> --- Original Message ---
> From:"michael.hutcheson@..." <michael.hutcheson@...>
> Sent:Fri 7/2/10 6:51 am
> To:vantage@yahoogroups.com
> Subj:[Vantage] Part history usage
>
> Hey folks,
>
> I'm building a report to show the part history usage - qtys used in the past 6 months etc. Is it just a case of using the part tran table, filtering for tran types and dates or is there another way?
>
> Regards,
>
> Michael
>
2
Hey folks,

I'm building a report to show the part history usage - qtys used in the past 6 months etc. Is it just a case of using the part tran table, filtering for tran types and dates or is there another way?

Regards,

Michael
3
Is this for invoiced parts or for all parts?




________________________________
From: "michael.hutcheson@..." <michael.hutcheson@...>
To: vantage@yahoogroups.com
Sent: Fri, 2 July, 2010 11:50:46
Subject: [Vantage] Part history usage

Â
Hey folks,

I'm building a report to show the part history usage - qtys used in the past 6 months etc. Is it just a case of using the part tran table, filtering for tran types and dates or is there another way?

Regards,

Michael







[Non-text portions of this message have been removed]
4
All parts - manufactured or purchased.

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Is this for invoiced parts or for all parts?
>
>
>
>
> ________________________________
> From: "michael.hutcheson@..." <michael.hutcheson@...>
> To: vantage@yahoogroups.com
> Sent: Fri, 2 July, 2010 11:50:46
> Subject: [Vantage] Part history usage
>
> ÂÂ
> Hey folks,
>
> I'm building a report to show the part history usage - qtys used in the past 6 months etc. Is it just a case of using the part tran table, filtering for tran types and dates or is there another way?
>
> Regards,
>
> Michael
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Sorry I can't help you there.




________________________________
From: "michael.hutcheson@..." <michael.hutcheson@...>
To: vantage@yahoogroups.com
Sent: Fri, 2 July, 2010 13:07:04
Subject: [Vantage] Re: Part history usage

Â
All parts - manufactured or purchased.

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Is this for invoiced parts or for all parts?
>
>
>
>
> ________________________________
> From: "michael.hutcheson@..." <michael.hutcheson@...>
> To: vantage@yahoogroups.com
> Sent: Fri, 2 July, 2010 11:50:46
> Subject: [Vantage] Part history usage
>
> ÂÂ
> Hey folks,
>
> I'm building a report to show the part history usage - qtys used in the past 6 months etc. Is it just a case of using the part tran table, filtering for tran types and dates or is there another way?
>
> Regards,
>
> Michael
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>


an't




[Non-text portions of this message have been removed]
6
Parttran is what you want. Just filter on the types pertinent to you. You can also get fancy & seperate independent from dependent use based on type. How you choose to bucket summarize (quarterly, monthly, weekly) is up to you.

--- Original Message ---
From:"michael.hutcheson@..." <michael.hutcheson@...>
Sent:Fri 7/2/10 6:51 am
To:vantage@yahoogroups.com
Subj:[Vantage] Part history usage

Hey folks,

I'm building a report to show the part history usage - qtys used in the past 6 months etc. Is it just a case of using the part tran table, filtering for tran types and dates or is there another way?

Regards,

Michael
7
would this all be possible using a BAQ or will I have to use crystal?

--- In vantage@yahoogroups.com, robertb_versa@... wrote:
>
> Parttran is what you want. Just filter on the types pertinent to you. You can also get fancy & seperate independent from dependent use based on type. How you choose to bucket summarize (quarterly, monthly, weekly) is up to you.
>
> --- Original Message ---
> From:"michael.hutcheson@..." <michael.hutcheson@...>
> Sent:Fri 7/2/10 6:51 am
> To:vantage@yahoogroups.com
> Subj:[Vantage] Part history usage
>
> Hey folks,
>
> I'm building a report to show the part history usage - qtys used in the past 6 months etc. Is it just a case of using the part tran table, filtering for tran types and dates or is there another way?
>
> Regards,
>
> Michael
>