RE: [Axapta-Knowledge-Village] Problem Printing Detail Charges from MarkupTable on SalesInvoiceUS

[Don Price]

You need to use table id and recid     Look at the relationship on MarkupTrans –CustInvoiceTrans    MarkupTrans.transTableId == custInvoiceTrans.TableId   MarkupTrans.TransRecid == CustInvoiceTrans.RecId     Don -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 09, 2004 9:39 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Problem Printing Detail Charges from MarkupTable on SalesInvoiceUS   Hi All, I am having a problem printing the detail Misc Charges (from the MarkupTrans table) on the SalesInvoiceUS report. No descriptions or charges print on my report. I get no description and .00 for the charge. I have assumed that it is sufficient to go after the MarkupTrans table using just RecId and queried both tables to be sure I have the correct record Id?s.  Any help, suggestions, etc will be greatly appreciated. I am using the method shown below but the detail misc charges do not appear when I print an invoice. Can any one tell me what I am doing wrong? display MarkupTransTxt60 mMarkupTransTxt()     {     MarkupTrans     markupTrans;     ;     select txt from markupTrans where markupTrans.TransRecId == this.RecId;        return markupTrans.Txt; } I also tried, without success, to obtain the Misc Charges by adding the MarkupTrans as a data source and setting the relationship using OuterJoin and 1:n and as follows. CustInvoiceJour.RecId = = MarkupTrans.TransRecId Thanks, Bob Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.