Air Pollution (VOC and HAPS) Tracking in Vantage 8.03

Yahoo Archive
1
In Epicor 9, you could use the Rohs functionality.

Bruce

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
carey_ryerson
Sent: Monday, December 28, 2009 2:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Air Pollution (VOC and HAPS) Tracking in Vantage 8.03

I have to provide VOC (volatile organic compounds) HAPS (hazardous air
pollutants) data in the form of a 12-month rolling average to the EPA and
the state. Does anyone know of a way to do this in Vantage? Where would I
put the VOC and HAPS data for each product?

Thanks much.

Carey



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
I have to provide VOC (volatile organic compounds) HAPS (hazardous air pollutants) data in the form of a 12-month rolling average to the EPA and the state. Does anyone know of a way to do this in Vantage? Where would I put the VOC and HAPS data for each product?

Thanks much.

Carey
3
Good Day Carey:

Sun is on:
M2K, 7.0 SP7, Informix ( not Unix) (Currently using).
Epicor 9, 9.05, SQL (live 7/1/2010)

Some ideas:

Is there a specific amount for each part#?
If yes, then:

1. Simply export usage to Excell, add a column for "amount per Each"
then total.
If there are different compounds, you would need another field for
that, so you could sort on it.
If there are a lot of part#'s involved you could us LOOKUP in Excell
so that you do not have to enter the [Amount per Each] for each line - I
have only used it a few times, but it works ( might be Vlookup).

OR, you could put the [Amount per each] at the end of the
description, Then use Excell command Left([cell],3) where 3 is the
last 3 digits of the field so 010, 150, 005, etc. You will have to
format the column to 'Number".

2. In M2K there are used_Defined_fields. Make a field for "Amount per
Each".
Created a calculated field of [Usage] times [Amount per Each].
If need a "Compound field" sort by it when totaling.

Do you have a field for the usage for the last 12 months? Or if have
for each month, you could add up the first 12. M2K stored by months

You may also have to consider Dependent ( Work order\internal usage)
versus Independent (sold to customer) usage. Hopefully you have no
Dependent usage.


len.hartka@...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of carey_ryerson
Sent: Monday, December 28, 2009 3:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Air Pollution (VOC and HAPS) Tracking in Vantage 8.03




I have to provide VOC (volatile organic compounds) HAPS (hazardous air
pollutants) data in the form of a 12-month rolling average to the EPA
and the state. Does anyone know of a way to do this in Vantage? Where
would I put the VOC and HAPS data for each product?

Thanks much.

Carey






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
4
Good Day Carey:

To get usage, you could do it through Sales reports, if all usage is
through sales and NOT on WO's. Simply limit to dates T-364 to T.

This might be more of kind of detail they might want.

Do they want Gross totals, or how much in each shipment?


len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Monday, December 28, 2009 5:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Air Pollution (VOC and HAPS) Tracking in Vantage
8.03




Good Day Carey:

Sun is on:
M2K, 7.0 SP7, Informix ( not Unix) (Currently using).
Epicor 9, 9.05, SQL (live 7/1/2010)

Some ideas:

Is there a specific amount for each part#?
If yes, then:

1. Simply export usage to Excell, add a column for "amount per Each"
then total.
If there are different compounds, you would need another field for
that, so you could sort on it.
If there are a lot of part#'s involved you could us LOOKUP in Excell
so that you do not have to enter the [Amount per Each] for each line - I
have only used it a few times, but it works ( might be Vlookup).

OR, you could put the [Amount per each] at the end of the
description, Then use Excell command Left([cell],3) where 3 is the
last 3 digits of the field so 010, 150, 005, etc. You will have to
format the column to 'Number".

2. In M2K there are used_Defined_fields. Make a field for "Amount per
Each".
Created a calculated field of [Usage] times [Amount per Each].
If need a "Compound field" sort by it when totaling.

Do you have a field for the usage for the last 12 months? Or if have
for each month, you could add up the first 12. M2K stored by months

You may also have to consider Dependent ( Work order\internal usage)
versus Independent (sold to customer) usage. Hopefully you have no
Dependent usage.


len.hartka@... <mailto:len.hartka%40sunautomation.com>



________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of carey_ryerson
Sent: Monday, December 28, 2009 3:58 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Air Pollution (VOC and HAPS) Tracking in Vantage 8.03

I have to provide VOC (volatile organic compounds) HAPS (hazardous air
pollutants) data in the form of a 12-month rolling average to the EPA
and the state. Does anyone know of a way to do this in Vantage? Where
would I put the VOC and HAPS data for each product?

Thanks much.

Carey

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
5
We are a manufaturer or urethane products, so I end up with the compounds used to manufacture the products, the paint, and various maintenance chemials. Currently, I run an Inventory Usage Report, manually input this data into and Excel spreadsheet that has all of my chemical information, and derive my total VOC and HAPS output.

My initial thought was to add two custom fields (VOC in lbs. and HAPS as a percentage)to the Manifest Info tab in Part Maintenance and then write a custom Crystal report to pull the data.