Digest Number 838

Hi Karen,
I will be attending as well as Nicole Strong, our Finance Mgr.
Thanks,
Nelson

-----Original Message-----
From: vantage@egroups.com [mailto:vantage@egroups.com]
Sent: Thursday, July 13, 2000 1:03 PM
To: vantage@egroups.com
Subject: [Vantage] Digest Number 838


------------------------------------------------------------------------
10% off Windows 2000 or Linux Certification training!
First 5,000 can win free training!
http://click.egroups.com/1/6362/13/_/411782/_/963507753/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
------------------------------------------------------------------------

There are 25 messages in this issue.

Topics in this digest:

1. FW: DETROIT AREA VANTAGE USERS GROUP MEETING - WED JULY 19, 1 PM
From: kblaine@...
2. RE: Releasing Subsitute Part to a Job
From: Chris Brisbin <brisbinc@...>
3. Outlook forms & shortcuts
From: Dan Shallbetter <dans@...>
4. Issue with Crystal Reports
From: Greg Gillette <ggillette@...>
5. RE: Issue with Crystal Reports
From: sarah.vareschi@...
6. Re: Issue with Crystal Reports
From: rgors <rgors@...>
7. Plant floor data collection tracking
From: "Urban, Kenneth" <kurban@...>
8. Mass shipments
From: "Jim Frice" <Jim.Frice@...>
9. Printing Report Error
From: "Jim Frice" <Jim.Frice@...>
10. RE: Issue with Crystal Reports
From: Martin Nijdam <martinn@...>
11. RE: Printing Report Error
From: Bob Lindberg <sysadmin@...>
12. Citrix Dos Client
From: "Joanne Yargeau" <jyargeau@...>
13. Crystal Reports - Page Numbers
From: "Cole, Dave" <dave@...>
14. RE: Crystal Reports - Page Numbers
From: sarah.vareschi@...
15. Purchase Order
From: "Hendrik Stasik" <hstasik@...>
16. A/R credit memo application
From: Dan Shallbetter <dans@...>
17. Midwest User's Group Meeting
From: "Mike England" <mike@...>
18. RE: Midwest User's Group Meeting
From: Jeanne Weiler <JWEILER@...>
19. dcdv7.lg
From: gcollins <gcollins@...>
20. Outstanding check list at month end
From: Martin Nijdam <martinn@...>
21. FWD: receiced but not invoiced report-onelist
From: Judy Stauduhar <judys@...>
22. Vantage Upgrade / drive mappings
From: "Brian Valentine" <brianjvalentine@...>
23. Outstanding Check list at Month End
From: Martin Nijdam <martinn@...>
24. RE: dcdv7.lg
From: Todd Anderson <tanderson@...>
25. Re: Outstanding check list at month end
From: Wayne Cox <wmc@...>


________________________________________________________________________
________________________________________________________________________

Message: 1
Date: Wed, 12 Jul 2000 08:09:07 -0400
From: kblaine@...
Subject: FW: DETROIT AREA VANTAGE USERS GROUP MEETING - WED JULY 19, 1 PM

DETROIT AREA VANTAGE USERS GROUP MEETING

WHEN: WEDNESDAY, JULY 19,2000 at 1 p.m.
WHERE: PGF TECHNOLOGY (same location as last time - contact Karen Blaine for
directions)

Please RSVP to Karen Blaine (kblaine@... or 248.363.1555 ext. 220)
by Friday, July 14th.

We look forward to seeing you there! Thanks!

Steven Simser
Karen Blaine
Detroit Area Vantage Group




________________________________________________________________________
________________________________________________________________________

Message: 2
Date: Wed, 12 Jul 2000 08:07:41 -0400
From: Chris Brisbin <brisbinc@...>
Subject: RE: Releasing Subsitute Part to a Job

You should be able to issue the 5 IBM's to the Western Digital material
sequence with no problem. From experience (at least on 3.0) the part number
you are issuing does not need to match the part number in the material
sequence on the job you are issuing it to.

Chris



- My question is:
We have released a job to build 50 computers, we purchase a Western
Digitial Drive(on the BOM), with a IBM Hard Drive as a sub. part(Not on
the BOM). I have 45 WD Hard Drives in stock which I can release to
manufacturing, and I want to use 5 IBM Hard drive to complete this job.

How do I release them to the job??



________________________________________________________________________
________________________________________________________________________

Message: 3
Date: Wed, 12 Jul 2000 07:58:04 -0500
From: Dan Shallbetter <dans@...>
Subject: Outlook forms & shortcuts

I have created a sub contracting move tag custom form in Outlook 2000. I am
looking for an easy way to deploy this on the plant floor. Does anybody know
if I can create a desktop shortcut to the Outlook form?

TIA
Dan Shallbetter
States Electric Mfg.


________________________________________________________________________
________________________________________________________________________

Message: 4
Date: Wed, 12 Jul 2000 09:30:49 -0400
From: Greg Gillette <ggillette@...>
Subject: Issue with Crystal Reports

OK.. I was asked if I could include the planner on the Job Traveller.
Realizing that the Jobhead table was part of the report, I figured adding in
the PersonID would be no problem. This field does exist in the table. Yet
in Crystal, why can I not insert the field.. it is not on the list of fields
under the Jobhead table. Is my thinking off or does Crystal not work the
way I was told in that as long as the table is there in the report, you can
grab that field.. please advise.

Greg


________________________________________________________________________
________________________________________________________________________

Message: 5
Date: Wed, 12 Jul 2000 09:36:47 -0400
From: sarah.vareschi@...
Subject: RE: Issue with Crystal Reports

Crystal DOES work so that if you add a table through ODBC, than all fields
are available to you.

HOWEVER, since the report you are looking at was written by Epicor, and is
therefore not using ODBC, the only fields supplied with the report are the
fields that Epicor used in the report. I don't know the mechanics of it,
but they export the tables with the fields they need for the report to some
sort of temporary file so that the fields can be grabbed by crystal without
using ODBC. Therefore, you are correct in that you can not simply add any
field to the report that is in one of the tables that is used in the report.

There are ways to add the table and field through ODBC, but this gets messy
because the report now will require ODBC to run it.

Sarah


________________________________________________________________________
________________________________________________________________________

Message: 6
Date: Wed, 12 Jul 2000 10:56:23 -0400
From: rgors <rgors@...>
Subject: Re: Issue with Crystal Reports

By the way:

The rumor I heard was that Epicor will release ALL of their reports in
Crystal with a future (next?) release so that all users may modify to
their heart's content. I hope this is a true statement. I heard it
from an Epicor Support person of some stature...

Rick
MIS
Osco

sarah.vareschi@... wrote:
>
> Crystal DOES work so that if you add a table through ODBC, than all
> fields
> are available to you.
>
> HOWEVER, since the report you are looking at was written by Epicor,
> and is
> therefore not using ODBC, the only fields supplied with the report are
> the
> fields that Epicor used in the report. I don't know the mechanics of
> it,
> but they export the tables with the fields they need for the report to
> some
> sort of temporary file so that the fields can be grabbed by crystal
> without
> using ODBC. Therefore, you are correct in that you can not simply add
> any
> field to the report that is in one of the tables that is used in the
> report.
>
> There are ways to add the table and field through ODBC, but this gets
> messy
> because the report now will require ODBC to run it.
>
> Sarah
> ----------------------------------------------------------------------
>
> ----------------------------------------------------------------------
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:
> http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it,
> go to www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)


________________________________________________________________________
________________________________________________________________________

Message: 7
Date: Wed, 12 Jul 2000 10:57:22 -0500
From: "Urban, Kenneth" <kurban@...>
Subject: Plant floor data collection tracking

Every TT5 used for plant floor data collection has a unique unit ID.
Does anyone know if that ID is reported anywhere? Our plant manager wants to
know which units get used the most, and which get used the least (so we
could relocate them if prudent). I've searched the data dictionary to no
avail. Has anyone else done this?


________________________________________________________________________
________________________________________________________________________

Message: 8
Date: Wed, 12 Jul 2000 11:42:37 -0500
From: "Jim Frice" <Jim.Frice@...>
Subject: Mass shipments

We are on Vantage 3.00.632 Progress 8.3A. When entering mass shipments and
tell the system what quantities to ship from inventory not all lines are
being created on the packing slip. Usually it is the last line that doesn't
get created. Have to then add that line to the packing slip. Anyone else
running into the same problem?

Jim



________________________________________________________________________
________________________________________________________________________

Message: 9
Date: Wed, 12 Jul 2000 11:42:44 -0500
From: "Jim Frice" <Jim.Frice@...>
Subject: Printing Report Error

Trying to print a job traveler and getting "Error code 997". Job was just
entered today and have been entering and printing jobs without any problems.
The jobs before and after this job# printed fine. Even flagged this job as a
template and created a new job but still got the error message. Anyone have
any ideas what may have caused this? Solution was to start from scratch and
re-enter all the information. Thankfully it was only a single assembly with
a few operations and very much detail. We are on Vantage 3.00.632 Progress
8.3A.

Thanks,

Jim



________________________________________________________________________
________________________________________________________________________

Message: 10
Date: Wed, 12 Jul 2000 12:54:26 -0400
From: Martin Nijdam <martinn@...>
Subject: RE: Issue with Crystal Reports

I remember speaking to epicor on that subject a year ago and I was promised
it would happen with version 4 but nothing happened...

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: rgors [SMTP:rgors@...]
> Sent: Wednesday, July 12, 2000 10:56 AM
> To: vantage@egroups.com
> Subject: Re: [Vantage] Issue with Crystal Reports
>
> By the way:
>
> The rumor I heard was that Epicor will release ALL of their reports in
> Crystal with a future (next?) release so that all users may modify to
> their heart's content. I hope this is a true statement. I heard it
> from an Epicor Support person of some stature...
>
> Rick
> MIS
> Osco
>
> sarah.vareschi@... wrote:
>


________________________________________________________________________
________________________________________________________________________

Message: 11
Date: Wed, 12 Jul 2000 10:25:53 -0700
From: Bob Lindberg <sysadmin@...>
Subject: RE: Printing Report Error

Error code 997 refers to having more than 30 lines in comments.

-----Original Message-----
From: Jim Frice [mailto:Jim.Frice@...]
Sent: Wednesday, July 12, 2000 9:43 AM
To: Vantage@Egroups. Com
Subject: [Vantage] Printing Report Error


Trying to print a job traveler and getting "Error code 997". Job was just
entered today and have been entering and printing jobs without any problems.
The jobs before and after this job# printed fine. Even flagged this job as a
template and created a new job but still got the error message. Anyone have
any ideas what may have caused this? Solution was to start from scratch and
re-enter all the information. Thankfully it was only a single assembly with
a few operations and very much detail. We are on Vantage 3.00.632 Progress
8.3A.

Thanks,

Jim


_____

<http://click.egroups.com/1/6637/13/_/411782/_/963419365/>

<http://adimg.egroups.com/img/6637/13/_/411782/_/963419365/specialoffer468x6
0a3.gif>

_____

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)




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



________________________________________________________________________
________________________________________________________________________

Message: 12
Date: Wed, 12 Jul 2000 17:38:10 -0000
From: "Joanne Yargeau" <jyargeau@...>
Subject: Citrix Dos Client

I have been asked by my MIS manager to pose this question. We cannot
get a Citrix Client to reconize the Citrix Server because of
transport stack. Which stack should we be using to use for Dos
Client? As always any help is appreciated. Thank you.



________________________________________________________________________
________________________________________________________________________

Message: 13
Date: Wed, 12 Jul 2000 16:10:40 -0500
From: "Cole, Dave" <dave@...>
Subject: Crystal Reports - Page Numbers

Crystal Reports has the ability to put page x of y on
a report. The problem is, it counts all pages in a print
run. For example, if you print a range or travelers it
will count all the pages in the print run.

Does anyone know how to reset that counter so it starts
counting over when the next traveler start printing.
If would be triggered by the job number.


Thanks,

Dave Cole


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



________________________________________________________________________
________________________________________________________________________

Message: 14
Date: Wed, 12 Jul 2000 17:51:34 -0400
From: sarah.vareschi@...
Subject: RE: Crystal Reports - Page Numbers

Dave, there are several ways to do this, unfortunately I have to run out the
door right now. The easiest to describe would be to open the crystal
traveler form and move the fields into the Job group section (I think it's
Group Header 1 in the traveler). This should reset them for that group,
which would be each traveler since it's sorted by group. Also, if that
group is set to be hidden, you will have to change that to make it visible.

Sarah



________________________________________________________________________
________________________________________________________________________

Message: 15
Date: Wed, 12 Jul 2000 23:19:08 -0000
From: "Hendrik Stasik" <hstasik@...>
Subject: Purchase Order

Hi all,

when i write a PO the Contact Person(Attn) comes up as first line in
the Vendor address field...example:

Jim Johnson
XYZ Corporation
P.O. Box 12345
Chicago, IL 67890
U.S.A.

How can i change it to be at least in the second line ?
The "Address Format" option under Vendor Maintenance doesnt have
the "Contact' as an available field.

Thanks

Hendrik



________________________________________________________________________
________________________________________________________________________

Message: 16
Date: Thu, 13 Jul 2000 08:21:57 -0500
From: Dan Shallbetter <dans@...>
Subject: A/R credit memo application

My A/R person is asking about credit memo application procedures. The
Vantage 3.0 help screen for the ref invoice number field on a credit memo
says that credit memo can be applied directly in cash receipts. Her question
is if we have invoice 123 and credit memo 456cm, how do we apply 456cm
against 123 in the cash receipt screen? And will it then show on the group
edit list? We current use the apply credit memo function. I am told that she
can not reference the customer check number that the credit is being taken
on. And that the only place the transaction appears is on a G/L
distributions report. She also does not like the fact that she has to back
out of cash receipts and go into apply credit memo function. Does anybody
have a Crystal report for customer statements that shows adjusted balance
due per invoice? We would like the amount shown on the statement to actually
reflect what is still open and due. (partial payments)

Thanks
Dan Shallbetter
States Electric Mfg.


________________________________________________________________________
________________________________________________________________________

Message: 17
Date: Thu, 13 Jul 2000 08:44:16 -0500
From: "Mike England" <mike@...>
Subject: Midwest User's Group Meeting

This is a reminder that the Midwest User's Group meets a week from tomorrow,
7/21, in Chicago. Deadline for meeting registration is Tuesday, 7/18.

Please note that this meeting is in danger of being cancelled for lack of
participation...

Mike England
Program Chair
Vantage Midwest User's Group


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



________________________________________________________________________
________________________________________________________________________

Message: 18
Date: Thu, 13 Jul 2000 09:06:09 -0500
From: Jeanne Weiler <JWEILER@...>
Subject: RE: Midwest User's Group Meeting

This is the first time I have seen a notice about the meeting other than it
was to be held in July.

Please register me for the meeting.
Where will it be held, time etc.,and cost.

thanks

-----Original Message-----
From: Mike England [mailto:mike@...]
Sent: Thursday, July 13, 2000 8:44 AM
To: vantage@egroups.com
Subject: [Vantage] Midwest User's Group Meeting


This is a reminder that the Midwest User's Group meets a week from tomorrow,
7/21, in Chicago. Deadline for meeting registration is Tuesday, 7/18.

Please note that this meeting is in danger of being cancelled for lack of
participation...

Mike England
Program Chair
Vantage Midwest User's Group


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


------------------------------------------------------------------------
Still looking for the complete Application Server solution?
Find answers and a $75 gift certificate at the Intraware App Server
Webinar. Sign up at:
http://click.egroups.com/1/6756/13/_/411782/_/963496436/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)


________________________________________________________________________
________________________________________________________________________

Message: 19
Date: Thu, 13 Jul 2000 11:15:59 -0400
From: gcollins <gcollins@...>
Subject: dcdv7.lg

Wondering if anyone can tell me what triggers this message in the database
log andhow I can fix it. This has suddenly started to happen the last
couple of days. We are on 3.00.


1: Usernum 17 terminated abnormally. (794)
1: Begin transaction backout. (2252)
1: Transaction backout completed. (2253)

Gilda Collins
Pride Signs Ltd.
Tel: (519) 220 0505
Fax: (519) 220 0606



________________________________________________________________________
________________________________________________________________________

Message: 20
Date: Thu, 13 Jul 2000 11:19:13 -0400
From: Martin Nijdam <martinn@...>
Subject: Outstanding check list at month end

My controller is going ballistic. He needs an "Outstanding Check list at
month end". This would be a report of all the checks that were not cleared
in a specific month. None are posted on the Onelist site. Have any of you
created such a report that you would be willing to share with me?

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565



________________________________________________________________________
________________________________________________________________________

Message: 21
Date: Thu, 13 Jul 2000 10:29:23 -0500
From: Judy Stauduhar <judys@...>
Subject: FWD: receiced but not invoiced report-onelist

Hi,
Our staff accountant had the following question. Does anyone have any
input
for her?
Judy Zaworski
Taber Bushnell


-----Original Message-----
From: Brenda Schultz On Behalf Of Brenda Schultz
Sent: Thursday, July 13, 2000 9:47 AM
To: Judy Stauduhar
Subject: receiced but not invoiced report-onelist

Does anyone use the Received but not invoiced report? We want to begin using
this report, but there is a lot of old receivers on it that were either
invoiced without a PO, or for other reasons. I am wondering if anyone else
has this problem and how you cleaned it up?
Thanks for any help I can get on this.
Brenda Schultz
brendas@...






________________________________________________________________________
________________________________________________________________________

Message: 22
Date: Thu, 13 Jul 2000 15:34:16 -0000
From: "Brian Valentine" <brianjvalentine@...>
Subject: Vantage Upgrade / drive mappings

We will be upgrading our 3.0 to 4.0 this weekend. While going over
the
instructions on Upgrading from an existing application, it says you
must map drive letters to your current \dwc share and a new letter to
the new \epicor share. And these letters must match what is on the
clients. This basically means we must create a new drive letter (W:
for instance) on the clients in addition to the current letter (V:).
Is there any way around this? We had a hard enough time coming up
with
a letter that all of the clients had available, now we need another?
I
called Vantage support and they said we need to map a new drive
letter. Anybody run into this? Any help would be appreciated.


-Brian Valentine



________________________________________________________________________
________________________________________________________________________

Message: 23
Date: Thu, 13 Jul 2000 11:52:35 -0400
From: Martin Nijdam <martinn@...>
Subject: Outstanding Check list at Month End

My controller needs an "Outstanding Check list at month end". This would be
a report of all the checks that were not cleared in a specific month. None
are posted on the Onelist site. Have any of you created such a report that
you would be willing to share with me?

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565




________________________________________________________________________
________________________________________________________________________

Message: 24
Date: Thu, 13 Jul 2000 10:47:30 -0500
From: Todd Anderson <tanderson@...>
Subject: RE: dcdv7.lg

Have you paid your annual maintenance fees ?

-----Original Message-----
From: gcollins [mailto:gcollins@...]
Sent: Thursday, July 13, 2000 10:16 AM
To: 'Vantage (E-mail)
Subject: [Vantage] dcdv7.lg


Wondering if anyone can tell me what triggers this message in the database
log andhow I can fix it. This has suddenly started to happen the last
couple of days. We are on 3.00.


1: Usernum 17 terminated abnormally. (794)
1: Begin transaction backout. (2252)
1: Transaction backout completed. (2253)

Gilda Collins
Pride Signs Ltd.
Tel: (519) 220 0505
Fax: (519) 220 0606


_____

<http://click.egroups.com/1/6352/13/_/411782/_/963503450/>

<http://adimg.egroups.com/img/6352/13/_/411782/_/963503450/ColorMeRevised-46
8x60.gif>

_____

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)




________________________________________________________________________
________________________________________________________________________

Message: 25
Date: Thu, 13 Jul 2000 12:25:36 -0400
From: Wayne Cox <wmc@...>
Subject: Re: Outstanding check list at month end

At 11:19 AM 7/13/2000 , you wrote:
>My controller is going ballistic. He needs an "Outstanding Check list at
>month end". This would be a report of all the checks that were not cleared
>in a specific month. None are posted on the Onelist site. Have any of you
>created such a report that you would be willing to share with me?

Wow, I just looked at the stock Check Register report, and the stupid thing
doesn't show the check's status?! Silly omission.

Maybe someone has one handy, but seriously, if you haven't gotten your feet
wet in Report Builder, this would be a real easy one to learn on. No
joins, even. Look at CheckHed in the Data Dictionary Viewer.

-Wayne



________________________________________________________________________
________________________________________________________________________