On our credits (A/R invoices) the field "REFINVNUM" is the crystal field we
use which displays the original invoice we are crediting (it is called
InvoiceRef in the vantage database but REFINVNUM in our crystal dbf table
(and it is a part of the std crystal dbf). Is this the field you are
looking for or is it a different one?
-----Original Message-----
From: halm180 [mailto:
Mis@...]
Sent: March 11, 2005 3:54 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Subreport Question
We are trying to add InvcHead.InvoiceRef to the Crystal Invoice
Document. Because InvoiceRef is not in the INVOICEHEAD.dbf file we
created a subreport to retrieve the field. We created a formula field
using the ToNumber function to convert the Invoicehead.Invnum
character field to numeric and used that field to link to InvcHead in
the Vantage database. No luck. We are using a Credit Memo that does
have info in the InvoiceRef field, so we know that we have good data.
Any ideas, suggestions? Thank you in advance for your help!
Sincerely,
Peter Dunbar
Halm Industries Co., Inc.
Mis@...
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