Adding OrderNum to ARInvoice for RMA credit memo

Dick,

Can you link from the invoice to the RMA Detail line. It has the order
number the RMA was for.


Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Todd Caughey
Sent: Wednesday, June 29, 2005 9:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding OrderNum to ARInvoice for RMA credit memo

I don't know these specific tables but I do know that the DBF file fields
are often changed to a different type (usually numeric to character) and you
must convert them with a formula field back to "like types" for linking.
Perhaps a type issue but I don't see why CompanyID would be that case. Are
you also linking within a subreport?
-Todd C.


-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, June 29, 2005 8:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding OrderNum to ARInvoice for RMA credit memo


Most knowledgeable ones;
I am trying to add the sales order number to the ARInvoice form (crystal
report 8.5) when generating an invoice for an RMA credit memo.
I find it odd that the sales order number does not come along with
everything else, but that is the hard truth.
Anyway, I attempted to link the sales order header table using ODBC and was
like a chicken is trying to talk to a duck!
You would think that these tables have nothing in common. Even the
companyID did not link.
Does anyone have any words of wisdom for me?

kind regards,





[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/links

<?---- LSpots keywords ?><?---- HM ADS ?>

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage>
" on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




[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/links
Yahoo! Groups Links
Most knowledgeable ones;
I am trying to add the sales order number to the ARInvoice form (crystal
report 8.5) when generating an invoice for an RMA credit memo.
I find it odd that the sales order number does not come along with
everything else, but that is the hard truth.
Anyway, I attempted to link the sales order header table using ODBC and
was like a chicken is trying to talk to a duck!
You would think that these tables have nothing in common. Even the
companyID did not link.
Does anyone have any words of wisdom for me?

kind regards,





[Non-text portions of this message have been removed]
I don't know these specific tables but I do know that the DBF file fields are often changed to a different type (usually numeric to character) and you must convert them with a formula field back to "like types" for linking. Perhaps a type issue but I don't see why CompanyID would be that case. Are you also linking within a subreport?
-Todd C.


-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, June 29, 2005 8:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding OrderNum to ARInvoice for RMA credit memo


Most knowledgeable ones;
I am trying to add the sales order number to the ARInvoice form (crystal
report 8.5) when generating an invoice for an RMA credit memo.
I find it odd that the sales order number does not come along with
everything else, but that is the hard truth.
Anyway, I attempted to link the sales order header table using ODBC and
was like a chicken is trying to talk to a duck!
You would think that these tables have nothing in common. Even the
companyID did not link.
Does anyone have any words of wisdom for me?

kind regards,





[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/links

<?---- LSpots keywords ?><?---- HM ADS ?>

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




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