Invoice form question

Yahoo Archive
1
Not sure about speed. I can't imagine that it slows it down, though.



One option around this is to insert an OLE object instead and have the
picture get pulled at the time of printing from your Epicor server. This is
the same functionality that Epicor uses for their employee photos when they
get pulled into reports.

When you put in the ole object pick a "picture" type. Then in the Ole Object
formatting go to Picture and at the bottom is a formula button for the
"Graphic Location". You can specify something like
"\\epicorserver\mfgsys803\...\" + <filename>

What's neat is that this becomes extremely flexible. You can update a single
graphic and any report using that graphic pulls in the new one.

The only catch is that the graphic has to be the size you need it as you
don't have any control over this piece.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Thursday, July 30, 2009 4:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Invoice form question





Thank you for all of your help. This has given me some ideas on how to move
forward.

One question, when you have multiple logos in a crystal form does it slow
down the print time?

Thanks again for the help.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA112F.A3949800
<mailto:image001.jpg%4001CA112F.A3949800> ]

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mark Wonsil
Sent: Thursday, July 30, 2009 3:01 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Invoice form question

Hi Michelle,

> I have a plant that has a separate logo and format for their
> invoices. I have created a new form for this location,
> however, I wasn't sure if there was a way to default which
> form printed by plant? I know I can choose the default by
> company, I just didn't know if there was a way to do it by plant.

We do what Sean does. We put all logos in one Crystal and show/hide the
appropriate graphic/address block conditionally. No need to pick a
particular report style.

Mark

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





[Non-text portions of this message have been removed]
2
I have a plant that has a separate logo and format for their invoices. I have created a new form for this location, however, I wasn't sure if there was a way to default which form printed by plant? I know I can choose the default by company, I just didn't know if there was a way to do it by plant.

Thanks in advance for your help.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA111E.1FBB4C60]



[Non-text portions of this message have been removed]
3
If the plant is provided in the dataset then just create a suppression
formula or if you're using an ole object use a formula to determine the
graphics file location. That way you have a single form that needs updated.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Thursday, July 30, 2009 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Invoice form question





I have a plant that has a separate logo and format for their invoices. I
have created a new form for this location, however, I wasn't sure if there
was a way to default which form printed by plant? I know I can choose the
default by company, I just didn't know if there was a way to do it by plant.

Thanks in advance for your help.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA111E.1FBB4C60
<mailto:image001.jpg%4001CA111E.1FBB4C60> ]

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





[Non-text portions of this message have been removed]
4
My users have the same sort of issues with Purchase Orders. We'd like ship-to addresses to default to the current plant. Not a report style issue per se, but I'm curious if there are ways to deal with this kind of thing.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Michelle de la Vega
Sent: Thursday, July 30, 2009 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Invoice form question

I have a plant that has a separate logo and format for their invoices. I have created a new form for this location, however, I wasn't sure if there was a way to default which form printed by plant? I know I can choose the default by company, I just didn't know if there was a way to do it by plant.

Thanks in advance for your help.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA111E.1FBB4C60]



[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/linksYahoo! Groups Links
5
We're on 8.03 and have coded forms specific to "plant". The invoice head table has a field "plant" that you could add to the report data definition (its excluded by default).

If you try to do this with orders be careful, we ran into problems with orders that can be shipped from both plants -- whatever the plant was on the first line become the logo on the form.

--- In vantage@yahoogroups.com, Michelle de la Vega <mdelavega@...> wrote:
>
> I have a plant that has a separate logo and format for their invoices. I have created a new form for this location, however, I wasn't sure if there was a way to default which form printed by plant? I know I can choose the default by company, I just didn't know if there was a way to do it by plant.
>
> Thanks in advance for your help.
>
> Michelle de la Vega
6
Hi Michelle,

> I have a plant that has a separate logo and format for their
> invoices. I have created a new form for this location,
> however, I wasn't sure if there was a way to default which
> form printed by plant? I know I can choose the default by
> company, I just didn't know if there was a way to do it by plant.

We do what Sean does. We put all logos in one Crystal and show/hide the
appropriate graphic/address block conditionally. No need to pick a
particular report style.

Mark
7
Thank you for all of your help. This has given me some ideas on how to move forward.

One question, when you have multiple logos in a crystal form does it slow down the print time?

Thanks again for the help.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA112F.A3949800]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Thursday, July 30, 2009 3:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Invoice form question



Hi Michelle,

> I have a plant that has a separate logo and format for their
> invoices. I have created a new form for this location,
> however, I wasn't sure if there was a way to default which
> form printed by plant? I know I can choose the default by
> company, I just didn't know if there was a way to do it by plant.

We do what Sean does. We put all logos in one Crystal and show/hide the
appropriate graphic/address block conditionally. No need to pick a
particular report style.

Mark



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