Dynamics Community Forum Thread Details

How to add SalesQuotationLine.Name field to Project Quotation Report.

Hi Experts,

I am trying to add SalesQuotationLine.Name field to Project Quotation Report. But not appearing.

0020.ProjQuotation.jpg

I have updated the method in DP.

[SysEntryPointAttribute(false)]
public void processReport()
{
    QuotationIdBase         m_eQuotation;
    QueryRun                tradeLoopTrans;

    m_tPSAQuotationsTmp.setConnection(this.parmUserConnection());

    contract    = this.parmDataContract() as PSAQuotationsContract;
    m_eQuotation = contract.parmQuotations();
    m_bPrintNonCharge = contract.parmM_bPrintNonCharge();
    salesQuotationTable  =  SalesQuotationTable::find(m_eQuotation);
   
    salesQuotationTotals =  SalesQuotationTotals::construct(salesQuotationTable);
    salesQuotationTotals.calc();
    tax = salesQuotationTotals.tax();
    tmpTaxWorkTrans.setTmpData(tax.tmpTaxWorkTrans());
    
     //SFA added 28-OCT-21
    
    salesQuotationLineTmp = SalesQuotationLine::find(m_eQuotation);
    //Ended

public void insertPSAQuotationsTmp()
{
    TaxJournalTrans     taxJournalTrans;

    m_tPSAQuotationsTmp.QuotationId             = salesQuotationTable.QuotationId;
    m_tPSAQuotationsTmp.QuotationName           = salesQuotationTable.QuotationName;
    m_tPSAQuotationsTmp.DeliveryPostalAddress   = salesQuotationTable.DeliveryPostalAddress;
    m_tPSAQuotationsTmp.CurrencyCode            = salesQuotationTable.CurrencyCode;
    m_tPSAQuotationsTmp.ProjTransType           = custQuotationTransTmp.ProjTransType;
    m_tPSAQuotationsTmp.SalesQty                = custQuotationTransTmp.Qty;
    m_tPSAQuotationsTmp.ProjCategoryId          = custQuotationTransTmp.ProjCategoryId;
    m_tPSAQuotationsTmp.CustomerName            = salesQuotationTable.customerName();
    m_tPSAQuotationsTmp.ProjDescription         = custQuotationTransTmp.ProjDescription;

    //SFA added 28-OCT-21
    m_tPSAQuotationsTmp.Description = salesQuotationLineTmp.Name;
    //Ended

SalesQuotationLine Table

8715.SalesQuotationLine.jpg