I have done as you suggested. This works GREAT! It should be easy enough
for even a VP of Sales to handle (notoriously impatient).
I tried using a VB Form for some other fields and had completely forgotten
that VB form fields do not show up in Crystal until the database is
verified. Now I have those fields plus the Cust ID all on one form.
Also, we briefly had EBI before we found we could not use it the way we
expected to so we returned it without ever using it.
I am still going to look into Ground Control (or similar keystroke
emulation) to try to automate a few processes.
Thanks for everyones help on the Order Acknowledgement and Export issues.
-Todd Caughey
Harvey Vogel Mfg. Co.
-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, June 19, 2001 3:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Order Ackn. - Crystal Fields - Cust ID
Todd,
What we have done is added a field to the VB form for the order
header, and called it cusnum. Then on the "On Entry" event of the VB
form, we added the following command:
set orderhed.char-field_1.scrvalue = {bill-id.scrvalue}
This copies the screen value for the bill to id into the new field on
the VB form. The only caveat to this is that the order entry people
have to click on the VB form button, then click OK on the VB form
while filling in the order header information.
To get this onto the Crystal form, you need to:
1. Create the field on the VB form, and add the code to the On Entry
event of the form.
2. Enter a sales order, being sure to click on the VB form button
while the order header screen is up.
3. Print (or do a Print Preview of) the sales order. This will write
the .dbf fields, including the new one you created.
4. Go to Crystal, open the sales order form, then go to: Database,
then Verify database. You should see a window that says, "database
file orderhed has changed. Proceed to fix up the report?" Click yes.
5. Add the new field to the report.
6. Save the report, then go back to Vantage, and try reprinting the
report. You should find the new field.
Keep in mind that this will only print for the orders that order
entry personnel have clicked the VB form button.
Hope this helps!
Andrew
acretors@...
for even a VP of Sales to handle (notoriously impatient).
I tried using a VB Form for some other fields and had completely forgotten
that VB form fields do not show up in Crystal until the database is
verified. Now I have those fields plus the Cust ID all on one form.
Also, we briefly had EBI before we found we could not use it the way we
expected to so we returned it without ever using it.
I am still going to look into Ground Control (or similar keystroke
emulation) to try to automate a few processes.
Thanks for everyones help on the Order Acknowledgement and Export issues.
-Todd Caughey
Harvey Vogel Mfg. Co.
-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, June 19, 2001 3:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Order Ackn. - Crystal Fields - Cust ID
Todd,
What we have done is added a field to the VB form for the order
header, and called it cusnum. Then on the "On Entry" event of the VB
form, we added the following command:
set orderhed.char-field_1.scrvalue = {bill-id.scrvalue}
This copies the screen value for the bill to id into the new field on
the VB form. The only caveat to this is that the order entry people
have to click on the VB form button, then click OK on the VB form
while filling in the order header information.
To get this onto the Crystal form, you need to:
1. Create the field on the VB form, and add the code to the On Entry
event of the form.
2. Enter a sales order, being sure to click on the VB form button
while the order header screen is up.
3. Print (or do a Print Preview of) the sales order. This will write
the .dbf fields, including the new one you created.
4. Go to Crystal, open the sales order form, then go to: Database,
then Verify database. You should see a window that says, "database
file orderhed has changed. Proceed to fix up the report?" Click yes.
5. Add the new field to the report.
6. Save the report, then go back to Vantage, and try reprinting the
report. You should find the new field.
Keep in mind that this will only print for the orders that order
entry personnel have clicked the VB form button.
Hope this helps!
Andrew
acretors@...
--- In vantage@y..., Todd Caughey <caugheyt@h...> wrote:
> Thanks. I did not know and had not thought of creating such an
export. I
> don't want to use ODBC so this might be just the trick for a couple
other
> .dbf dificiencies in canned reports.
> Thanks again,
> -Todd C.
>
> -----Original Message-----
> From: Thad Jacobs [mailto:tjacobs@k...]
> Sent: Monday, June 18, 2001 4:51 PM
> To: 'vantage@y...'
> Subject: RE: [Vantage] Order Ackn. - Crystal Fields - Cust ID
>
>
> Todd,
>
> What you may need to do is do an export of the customer name and
customer ID
> fields to a DBF, using the export utility in vantage, and link to
the export
> using the customer name. Because this would create a mandatory
inner join,
> you'd have to update the dbf export every time you add a new
customer, or
> sales orders with new customers may appear blank.
>
> Of course, linking to an ODBC connection would do the exact same
thing.
>
> Good luck,
>
> Thaddeus
>
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Monday, June 18, 2001 4:15 PM
> To: 'vantage@y...'
> Subject: [Vantage] Order Ackn. - Crystal Fields - Cust ID
>
>
> I need to put the Customer ID on our sales Order Acknowledgements.
Maybe
> I'm just blind today and not seeing it or perhaps it is named
something
> cryptic but I suspect Epicor did not include it (like to many other
fields)
> in the .dbf files. If anyone knows if it is available and where to
find it
> I would be very appreciative.
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>
> To access the Files Section of our Yahoo!Group for Report Builder
and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
> < http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> > Note: You must
have
> already
> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>
> < http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
>
>
>
> Yahoo! Groups Sponsor
>
>
< http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1
<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1>
700007
> 183:N/A=675622/* http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?
<http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?>
mpt=9929
> 00947> []
>
> < http://us.adserver.yahoo.com/l? <http://us.adserver.yahoo.com/l?>
M=202225.1433492.3029752.1269402/D=egroupmai
> l/S=1700007183:N/A=675622/rand=763468045>
>
> To access the Files Section of our Yahoo!Group for Report Builder
and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
> < http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> > Note: You must
have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> < http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
Service.
>
>
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
183:N/A=675622/*http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9929
83283> []
<http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
l/S=1700007183:N/A=675622/rand=686836782>
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> Note: You must have
already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]