Digest Number 3380

The view command for a pdf file is: acroRD32.exe "&1"

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2005 3:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Digest Number 3380


There are 25 messages in this issue.

Topics in this digest:

1. RE: Multi-Site Management
From: "Michelle de la Vega" <mdelavega@...>
2. vantage 6.1 crystal connected thru odbc to access
From: "mansfield1024" <johnm@...>
3. [ver 6.1] Quality Supplier Rating
From: "Manasa Reddy" <mreddy@...>
4. RE: [ver 6.1] Quality Supplier Rating
From: "Mike McGee" <mmcgee@...>
5. Count Tags
From: "Paul H. Smith" <psmith@...>
6. Quote's Expiration
From: "bbelzer42" <bbelzer@...>
7. Re: Quote's Expiration
From: "wfcovanman" <jim.frice@...>
8. RE: Inventory/WIP Reconciliation
From: "Ludwig, Rick" <RickL@...>
9. RMAs Needing Credits Report V6.1
From: "dupagejoe" <joe@...>
10. link progress tables in access
From: "sharma_nalini" <sharma_nalini@...>
11. Re: link progress tables in access
From: jeremyrleonard@...
12. [6.1] Document Association for PDF
From: "Todd Caughey" <caugheyt@...>
13. RE: [6.1] Document Association for PDF
From: "Manasa Reddy" <mreddy@...>
14. Re: RMAs Needing Credits Report V6.1
From: "bbelzer42" <bbelzer@...>
15. RE: [6.1] Document Association for PDF
From: "Todd Caughey" <caugheyt@...>
16. RE: Re: RMAs Needing Credits Report V6.1
From: "Todd Caughey" <caugheyt@...>
17. RE: Re: RMAs Needing Credits Report V6.1
From: "Shirley Graver" <shirleyg@...>
18. Re: link progress tables in access
From: "sharma_nalini" <sharma_nalini@...>
19. [6.1] Report Builder - Who never clocked in Yesterday
From: "Juliet Martin" <jmartin@...>
20. Lost HELP option again and no word from Epicor
From: "Susan Iverson" <siverson@...>
21. RE: [6.1] Report Builder - Who never clocked in Yesterday
From: "Todd Caughey" <caugheyt@...>
22. RE: [6.1] Report Builder - Who never clocked in Yesterday
From: "Juliet Martin" <jmartin@...>
23. Tooling cost to jobs
From: "Bruce Butler" <bbutler@...>
24. RE: Tooling cost to jobs
From: "Sherer, Rhonda" <rhonda@...>
25. Data Collection / Labor Reporting
From: "jeffchrist123" <jeff.christ@...>


________________________________________________________________________
________________________________________________________________________

Message: 1
Date: Thu, 23 Jun 2005 09:05:26 -0400
From: "Michelle de la Vega" <mdelavega@...>
Subject: RE: Multi-Site Management

We use both multi-plants and multi-company and multi-plant is the best
way to go. It is much easier to use and it works...Multi-company still
have a few problems that need to be worked out by epicor.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Susan Iverson
Sent: Wednesday, June 22, 2005 4:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Multi-Site Management


You would still need to switch "plants" to see some information. I
haven't worked with multiple companies yet but multi-plant does require
a lot of changing back and forth between plants to access a lot of PO,
Inventory and Job information.



Sue

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, June 22, 2005 8:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Multi-Site Management



We have a separate company (same ownership) that supplies raw material
to us. Our demand generates a sales order to them and a PO for the
parent company.
The order must be shipped on the supplying company, and received on the
parent company. The demands of the parent company are not visible
to the supplying company, even tho each company is using vantage (set up
as separate companies). Users must switch to the other company
to view and maintain the other company records.
Question: does multi-site management lessen the need for all of the
care and feeding of the above scenario?
regards




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



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/.
<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/links




_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



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



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/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




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



________________________________________________________________________
________________________________________________________________________

Message: 2
Date: Thu, 23 Jun 2005 14:12:46 -0000
From: "mansfield1024" <johnm@...>
Subject: vantage 6.1 crystal connected thru odbc to access

Hi to all,

I have been trying to create a crystal report connecting to access thru
odbc. The report I am writing uses a subreport. The problem I am having
is very strange. I will format the header and detail bands of the
subreport and save which results in a completely different layout.

Am I dealing with a known gotcha?

This is taking far too much time.

Thanks,

John Mansfield
General Sheet Metal





________________________________________________________________________
________________________________________________________________________

Message: 3
Date: Thu, 23 Jun 2005 09:28:06 -0500
From: "Manasa Reddy" <mreddy@...>
Subject: [ver 6.1] Quality Supplier Rating

We have a need to rate our vendors based on On-time delivery and quality of
product per AS9100 and customer requirements.

Wondering if anyone out there is doing this and HOW are you attempting to
gather the statistics?

I don't want to use the Vendor Shipping performance because it averages
everything out and doesn't give me a true picture of what is going on.

As always, any help is appreciated.

Thanks,



M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272




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



________________________________________________________________________
________________________________________________________________________

Message: 4
Date: Thu, 23 Jun 2005 09:40:06 -0500
From: "Mike McGee" <mmcgee@...>
Subject: RE: [ver 6.1] Quality Supplier Rating

We are doing this using the following criteria and tracking with an excel
spreadsheet.





Vendor Metric



Assign point value for quality or delivery non-conformance.





Quality - Monthly % rejects 0-1% - .25 points


Monthly %
rejects 1-2% - .50 points

Monthly %
rejects > 2% - 1 point



Delivery - 1 day late - .25 points


2 days late - .5 poins


3 + days late - 1 point





Corrective Action 2-3 Weeks - .5 points


Requests - 3+ Weeks - .5 points per day










Point total of 4 during a 12 month period will initiate a warning letter to
the vendor. Point total of 6 during a 12 month period could terminate
purchases from vendor.




Hope this helps.



Mike

Flexial Corporation

Vantage 6.1

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Thursday, June 23, 2005 9:28 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] [ver 6.1] Quality Supplier Rating



We have a need to rate our vendors based on On-time delivery and quality of
product per AS9100 and customer requirements.

Wondering if anyone out there is doing this and HOW are you attempting to
gather the statistics?

I don't want to use the Vendor Shipping performance because it averages
everything out and doesn't give me a true picture of what is going on.

As always, any help is appreciated.

Thanks,



M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272




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



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/.
<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/links




_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



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



________________________________________________________________________
________________________________________________________________________

Message: 5
Date: Thu, 23 Jun 2005 11:06:22 -0400
From: "Paul H. Smith" <psmith@...>
Subject: Count Tags


I just became aware that Vantage is not including inactive parts when you
start the count and create tag numbers. Just to verify, does this sound
correct? Thanks in advance.



Paul H Smith


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



________________________________________________________________________
________________________________________________________________________

Message: 6
Date: Thu, 23 Jun 2005 15:49:28 -0000
From: "bbelzer42" <bbelzer@...>
Subject: Quote's Expiration

How can I make sure quotes never expire?

Thanks,
Ben




________________________________________________________________________
________________________________________________________________________

Message: 7
Date: Thu, 23 Jun 2005 16:27:04 -0000
From: "wfcovanman" <jim.frice@...>
Subject: Re: Quote's Expiration

Try Company Configuration/Quote management/Expire days zero.


--- In vantage@yahoogroups.com, "bbelzer42" <bbelzer@t...> wrote:
> How can I make sure quotes never expire?
>
> Thanks,
> Ben





________________________________________________________________________
________________________________________________________________________

Message: 8
Date: Thu, 23 Jun 2005 11:51:54 -0500
From: "Ludwig, Rick" <RickL@...>
Subject: RE: Inventory/WIP Reconciliation

Michelle-

Although we don't use Product Groups, Vantage works in the following
manner with respect to product costs:

1. Pack Slip creation: DEBIT A/R Clearing Account CREDIT
Inventory
2. Invoice creation: DEBIT COGS CREDIT
A/R Clearing Account

The A/R clearing account only serves the purpose to ensure all pack
slipped goods have been invoiced/posted (when I review the Inventory/WIP
Reconcilation report at month-end, I make sure that the debits = credits
in the A/R Clearing account). I have a feeling that you are using your
"A/R Trade" account number as your "A/R Clearing" account number in your
configuration setup.

I hope this helps. Let me know if you have any questions.



Thanks!



Rick Ludwig



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michelle de la Vega
Sent: Tuesday, June 14, 2005 10:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Inventory/WIP Reconciliation


Sometimes (Not Always) when we create a sales order with the proper
product groups then ship the inventory the cost hits AR Trade instead of
the correct G/L account which is set up in the product group. But then
when we invoice this shipment, the cost moves from AR Trade to the
correct G/L account. Does anyone know what causes this?

I am truly stumped.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com




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



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/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




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



________________________________________________________________________
________________________________________________________________________

Message: 9
Date: Thu, 23 Jun 2005 17:27:09 -0000
From: "dupagejoe" <joe@...>
Subject: RMAs Needing Credits Report V6.1

I am trying to create a 'to do' report for our QA Manager listing the
RMAs that have been received but credit has not been appoved / 'added'.
My problem is that I can't find a way to filter and list only RMAs
without a credit added. Suggestions?





________________________________________________________________________
________________________________________________________________________

Message: 10
Date: Thu, 23 Jun 2005 17:30:03 -0000
From: "sharma_nalini" <sharma_nalini@...>
Subject: link progress tables in access

Is it possible to link tables from vantage to access?

I tries my self , i was able to see the tables via odbc but it gives me
authorization error when i would like to view entries.







________________________________________________________________________
________________________________________________________________________

Message: 11
Date: Thu, 23 Jun 2005 13:42:17 EDT
From: jeremyrleonard@...
Subject: Re: link progress tables in access

When linking the table, you need to select the little checkbox in the right
hand corner that says "Save Password".

You will also need to run Epicors ODBC kit to setup ODBC before you try to
link the tables.


HTH
Jeremy


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



________________________________________________________________________
________________________________________________________________________

Message: 12
Date: Thu, 23 Jun 2005 13:02:09 -0500
From: "Todd Caughey" <caugheyt@...>
Subject: [6.1] Document Association for PDF

Gotta be an easy one but I've wasted too much time already trying things
when I should have asked the experts.

What is the document association line for opening an Adobe Acrobat PDF file?

Thanks,
-Todd C.


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



________________________________________________________________________
________________________________________________________________________

Message: 13
Date: Thu, 23 Jun 2005 13:09:32 -0500
From: "Manasa Reddy" <mreddy@...>
Subject: RE: [6.1] Document Association for PDF

Try this:

AcroRd32.exe "&1"

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Todd Caughey
Sent: Thursday, June 23, 2005 1:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Document Association for PDF


Gotta be an easy one but I've wasted too much time already
trying things when I should have asked the experts.

What is the document association line for opening an Adobe
Acrobat PDF file?

Thanks,
-Todd C.


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



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/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



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



________________________________________________________________________
________________________________________________________________________

Message: 14
Date: Thu, 23 Jun 2005 18:14:05 -0000
From: "bbelzer42" <bbelzer@...>
Subject: Re: RMAs Needing Credits Report V6.1

I am also very interested in this. Let me know if you find anything.

Thanks!
Ben

--- In vantage@yahoogroups.com, "dupagejoe" <joe@d...> wrote:
> I am trying to create a 'to do' report for our QA Manager listing the
> RMAs that have been received but credit has not been appoved / 'added'.
> My problem is that I can't find a way to filter and list only RMAs
> without a credit added. Suggestions?





________________________________________________________________________
________________________________________________________________________

Message: 15
Date: Thu, 23 Jun 2005 13:17:02 -0500
From: "Todd Caughey" <caugheyt@...>
Subject: RE: [6.1] Document Association for PDF

Thanks. I could swear thats what we started out with but it would not work.
Must have been some small difference because now it does. We are doing all
our CAD prints in PDF on the part revisions so this will be very useful.
Thanks again.
-Todd C.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 23, 2005 1:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1] Document Association for PDF


Try this:

AcroRd32.exe "&1"

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Todd Caughey
Sent: Thursday, June 23, 2005 1:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Document Association for PDF


Gotta be an easy one but I've wasted too much time already
trying things when I should have asked the experts.

What is the document association line for opening an Adobe
Acrobat PDF file?

Thanks,
-Todd C.


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



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/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



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



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/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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



________________________________________________________________________
________________________________________________________________________

Message: 16
Date: Thu, 23 Jun 2005 13:22:06 -0500
From: "Todd Caughey" <caugheyt@...>
Subject: RE: Re: RMAs Needing Credits Report V6.1

Left outer join link the RMA to InvcHead table using the RMA number (and
company). Test for ? in the filter on InvcHead.RMAnum (no record found for
that RMA) and these will be your uncredited RMA's. I think.
-Todd C.

-----Original Message-----
From: bbelzer42 [mailto:bbelzer@...]
Sent: Thursday, June 23, 2005 1:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: RMAs Needing Credits Report V6.1


I am also very interested in this. Let me know if you find anything.

Thanks!
Ben

--- In vantage@yahoogroups.com, "dupagejoe" <joe@d...> wrote:
> I am trying to create a 'to do' report for our QA Manager listing the
> RMAs that have been received but credit has not been appoved / 'added'.
> My problem is that I can't find a way to filter and list only RMAs
> without a credit added. Suggestions?





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/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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



________________________________________________________________________
________________________________________________________________________

Message: 17
Date: Thu, 23 Jun 2005 14:24:47 -0400
From: "Shirley Graver" <shirleyg@...>
Subject: RE: Re: RMAs Needing Credits Report V6.1

Try a left outer join to the credits file and filter on "?".

Shirley Graver
Rubber Associates

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bbelzer42
Sent: Thursday, June 23, 2005 2:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: RMAs Needing Credits Report V6.1

I am also very interested in this. Let me know if you find anything.

Thanks!
Ben

--- In vantage@yahoogroups.com, "dupagejoe" <joe@d...> wrote:
> I am trying to create a 'to do' report for our QA Manager listing the
> RMAs that have been received but credit has not been appoved / 'added'.
> My problem is that I can't find a way to filter and list only RMAs
> without a credit added. Suggestions?





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/.
<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/links



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

Tracking #: 3B7E79059BAE0F44A64F114EEA365A24F6EA6286


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



________________________________________________________________________
________________________________________________________________________

Message: 18
Date: Thu, 23 Jun 2005 18:40:50 -0000
From: "sharma_nalini" <sharma_nalini@...>
Subject: Re: link progress tables in access

Thank you



h--- In vantage@yahoogroups.com, jeremyrleonard@a... wrote:
> When linking the table, you need to select the little checkbox in the
right
> hand corner that says "Save Password".
>
> You will also need to run Epicors ODBC kit to setup ODBC before you
try to
> link the tables.
>
>
> HTH
> Jeremy
>
>
> [Non-text portions of this message have been removed]




________________________________________________________________________
________________________________________________________________________

Message: 19
Date: Thu, 23 Jun 2005 13:47:18 -0500
From: "Juliet Martin" <jmartin@...>
Subject: [6.1] Report Builder - Who never clocked in Yesterday

I am trying to build a report showing who never clocked in at all yesterday.
I can't believe how hard I am making this. I am looking for any clues if
anyone has tried this. There is a report in the files section for
Absenteeism but it shows anyone who didn't work their full shift not who
never got here at all.

I have tried to do a left outer join between EmpBasic and LaborHed.
Sorted to only active employees and the payroll date.

My theory being if you are an active employee and you are not in laborhed
(for that date) it would fill you in with a ?. No record existed for you in
laborhed on that day because you never clocked in. Then I could filter for
the ?s. Nope.

Anybody have any ideas? I feel really stupid here but not too stupid to not
ask for help.

Thanks in advance,


JM


________________________________________________________________________
________________________________________________________________________

Message: 20
Date: Thu, 23 Jun 2005 12:00:28 -0700
From: "Susan Iverson" <siverson@...>
Subject: Lost HELP option again and no word from Epicor

NOW what patches do I have to remove???



Sue





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



________________________________________________________________________
________________________________________________________________________

Message: 21
Date: Thu, 23 Jun 2005 14:00:03 -0500
From: "Todd Caughey" <caugheyt@...>
Subject: RE: [6.1] Report Builder - Who never clocked in Yesterday

I took a stab at this once but don't recall if it worked right. Here is
what I did:

1. Link EmpBasic to LaborHed (LOJ) (filter only on company and active
employees)
2. Sort on EmpNum then LaborHead Sequence
2. Pre-pass aggregate for Max Labor Head Sequence number
3. Condition band line to print employees where:
IIF(LaborHedSeq = EmpMaxLaborSeq and ClockOutTime > 0 ,Yes,No)
***this means LAST head sequence was a clock OUT not an IN - if OUT they
are not here

This particular report shows who is not now here. I think maybe it would
still work if you addtionally filtered <= date and added a date test in the
line print condition for max labor head date not that date.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 23, 2005 1:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Report Builder - Who never clocked in Yesterday


I am trying to build a report showing who never clocked in at all yesterday.
I can't believe how hard I am making this. I am looking for any clues if
anyone has tried this. There is a report in the files section for
Absenteeism but it shows anyone who didn't work their full shift not who
never got here at all.

I have tried to do a left outer join between EmpBasic and LaborHed.
Sorted to only active employees and the payroll date.

My theory being if you are an active employee and you are not in laborhed
(for that date) it would fill you in with a ?. No record existed for you in
laborhed on that day because you never clocked in. Then I could filter for
the ?s. Nope.

Anybody have any ideas? I feel really stupid here but not too stupid to not
ask for help.

Thanks in advance,


JM


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/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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



________________________________________________________________________
________________________________________________________________________

Message: 22
Date: Thu, 23 Jun 2005 14:08:17 -0500
From: "Juliet Martin" <jmartin@...>
Subject: RE: [6.1] Report Builder - Who never clocked in Yesterday

I think yours is the report that I mentioned was in the files.

I will try this and get back to the list. If I get it - I will post it.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Thursday, June 23, 2005 2:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1] Report Builder - Who never clocked in
Yesterday


I took a stab at this once but don't recall if it worked right. Here is
what I did:

1. Link EmpBasic to LaborHed (LOJ) (filter only on company and active
employees)
2. Sort on EmpNum then LaborHead Sequence
2. Pre-pass aggregate for Max Labor Head Sequence number
3. Condition band line to print employees where:
IIF(LaborHedSeq = EmpMaxLaborSeq and ClockOutTime > 0 ,Yes,No)
***this means LAST head sequence was a clock OUT not an IN - if OUT they
are not here

This particular report shows who is not now here. I think maybe it would
still work if you addtionally filtered <= date and added a date test in the
line print condition for max labor head date not that date.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 23, 2005 1:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Report Builder - Who never clocked in Yesterday


I am trying to build a report showing who never clocked in at all yesterday.
I can't believe how hard I am making this. I am looking for any clues if
anyone has tried this. There is a report in the files section for
Absenteeism but it shows anyone who didn't work their full shift not who
never got here at all.

I have tried to do a left outer join between EmpBasic and LaborHed.
Sorted to only active employees and the payroll date.

My theory being if you are an active employee and you are not in laborhed
(for that date) it would fill you in with a ?. No record existed for you in
laborhed on that day because you never clocked in. Then I could filter for
the ?s. Nope.

Anybody have any ideas? I feel really stupid here but not too stupid to not
ask for help.

Thanks in advance,


JM


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/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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



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/links
Yahoo! Groups Links








________________________________________________________________________
________________________________________________________________________

Message: 23
Date: Thu, 23 Jun 2005 15:14:12 -0400
From: "Bruce Butler" <bbutler@...>
Subject: Tooling cost to jobs

We currently do not track tooling cost to a job within Vantage. Could
anybody doing this provide some feedback as to how it is working for
you?

The easiest way I can see to do this within Vantage's job structure
would be to setup a single material line (Tooling), manage the
inventory, and issue tooling against that line. The downside is it is
going to create more processing for our tool crib.

TIA for your help again,

I really don't know how people can say this group is not useful.

Bruce Butler, IT Manager
Knappe & Koester
18 Bradco St
Keene, NH 03431
bbutler@...



________________________________________________________________________
________________________________________________________________________

Message: 24
Date: Thu, 23 Jun 2005 14:22:49 -0500
From: "Sherer, Rhonda" <rhonda@...>
Subject: RE: Tooling cost to jobs

We do a line item on the sales order for tooling (either billable or non
billable) Cut a linked job, using subassemblies for the various tooling
components. any material purchased for these are bought to the job and
assembly, any shop labor is clocked accordingly.



-----Original Message-----
From: Bruce Butler [mailto:bbutler@...]
Sent: Thursday, June 23, 2005 2:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Tooling cost to jobs


We currently do not track tooling cost to a job within Vantage. Could
anybody doing this provide some feedback as to how it is working for
you?

The easiest way I can see to do this within Vantage's job structure
would be to setup a single material line (Tooling), manage the
inventory, and issue tooling against that line. The downside is it is
going to create more processing for our tool crib.

TIA for your help again,

I really don't know how people can say this group is not useful.

Bruce Butler, IT Manager
Knappe & Koester
18 Bradco St
Keene, NH 03431
bbutler@...



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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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



________________________________________________________________________
________________________________________________________________________

Message: 25
Date: Thu, 23 Jun 2005 19:23:32 -0000
From: "jeffchrist123" <jeff.christ@...>
Subject: Data Collection / Labor Reporting

Please Help!

We just started using shop floor data collection terminals. We have
been running into this when we do not have set-up or production times
entered into a operation. When a person is clocked into that
operation for 8 hours we look into the job and no labor time is put
against that operation. We have a lot of time and material jobs and I
was wondering what I can do to collect labor time into these jobs,
without having to put time estimates in for all operations for time
and material jobs? Am I missing something?

Thank You
Jeff Christ
Steel Craft Corp.
262-673-6770 x123




________________________________________________________________________
________________________________________________________________________


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/links
------------------------------------------------------------------------
Yahoo! Groups Links




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