Purchase Order Comments

Yahoo Archive
1
We had to go to a totally live ODBC Traveller for all the extra info we needed to add to the Traveller.

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

----- Original Message -----
From: Vantage List
To: 'vantage@yahoogroups.com'
Sent: Thursday, April 05, 2001 6:04 AM
Subject: [Vantage] Purchase Order Comments


Vantage V. 4 - Crystal V. 7

Does anyone know how I can print a standard verbage on the bottom of the
purchase order for only certain material - such as when the material is
Raw Material ? I don't think the dbf files contain the information I
need to distinguish what type of material I am purchasing. Has anyone
done this and can lead me in the right direction ? Your help would be
appreciated.

Thank you,
Kristine Pollard
Director Information Systems
American Turned Products
vlist@...
- or -
kpollard@...





[Non-text portions of this message have been removed]
2
Vantage V. 4 - Crystal V. 7

Does anyone know how I can print a standard verbage on the bottom of the
purchase order for only certain material - such as when the material is
Raw Material ? I don't think the dbf files contain the information I
need to distinguish what type of material I am purchasing. Has anyone
done this and can lead me in the right direction ? Your help would be
appreciated.

Thank you,
Kristine Pollard
Director Information Systems
American Turned Products
vlist@...
- or -
kpollard@...
3
We have PO comments that print based on the vendor. But, I don't think that
is what you want. You would probably need the comments to print based on
the 'Part Class', but your right, that field isn't there. I think you would
have to just look through the available fields and determine if there is
anything that can give you what you need, maybe something related to how
your parts are numbered or to their descriptions?
4
I accomplished this by accessing the GL Acct# (PORel.ExpChart), which
let me know that the item was raw material or not.

I created a report footer with the text on it that I wanted then I
formatted that section and setup conditional formatting for
the "suppress print" option. In the formula editor, I type the
following in:
if {porel.EXPCHART} = '012000' then no else yes

If the GL# matched my condition then the formula returned 'no', which
told Crystal to NOT suppress the section. Otherwise it suppressed the
section and nothing printed.

If the GL# doesn't specify raw material or not for you, then maybe
there is another field that you can use.

Jonathan Tompkins
jonathan@...-ots.com


--- In vantage@y..., Vantage List <vlist@a...> wrote:
> Vantage V. 4 - Crystal V. 7
>
> Does anyone know how I can print a standard verbage on the bottom
of the
> purchase order for only certain material - such as when the
material is
> Raw Material ? I don't think the dbf files contain the information I
> need to distinguish what type of material I am purchasing. Has
anyone
> done this and can lead me in the right direction ? Your help would
be
> appreciated.
>
> Thank you,
> Kristine Pollard
> Director Information Systems
> American Turned Products
> vlist@a...
> - or -
> kpollard@a...