Tuesday, 16 December 2014

Flow values from table SalesQuotationLine into SalesLine while Sales Quotation confirmed

We have 2- customized fields in table SalesQuotationLine and needs to flow into SalesLine while Sales Quotation gets confirmed. Then add these fields in table SalesLine as well and assign values in this table method
 and class method as well
\Classes\SalesQuotationEditLinesForm_Sales_Confir\createSalesLines
// Changed on 18 Jan 2011 at 13:54:36 by vip - GAP rebate
// Use salesQuotationLineUpdate to search for the rebate Line instead of using salesQuotationLine
void createSalesLines(SalesQuotationTable   _salesQuotationTable    = salesQuotationTable,
                      SalesTable            _salesTable             = salesTableCreated)
{
    SalesQuotationLine          salesQuotationLineUpdate;
    SalesParameters             salesParameters;
    InventDim                   inventDim           = null;
    SalesLine                   salesLine;
    SalesQuotationParmLine      salesQuotationParmLineUpdate;
    ;
    salesParameters   = SalesParameters::find();

    while select forupdate salesQuotationLineUpdate
        index hint QuotationLineIdx
        where   salesQuotationLineUpdate.QuotationId == salesQuotationTable.QuotationId
        &&      salesQuotationLineUpdate.SalesQty    != 0
        exists join salesQuotationParmLineUpdate
            where salesQuotationParmLineUpdate.SalesQuotationLineRecId == salesQuotationLineUpdate.RecId          &&
                  salesQuotationParmLineUpdate.ParmId                  == salesQuotationParmTable.ParmId    &&
                  salesQuotationParmLineUpdate.TableRefId              ==  salesQuotationParmTable.TableRefId    &&
                  salesQuotationParmLineUpdate.Transfer                == NoYes::Yes
    {
        salesLine.clear();
        salesLine.initValue();

        salesLine.initFromSalesTable(_salesTable);

        salesLine.setInventDimId(salesQuotationLineUpdate.InventDimId);

        salesLine.ItemId            = salesQuotationLineUpdate.ItemId;
        …………………
        // <start> added by Vimal on Dec 09, 2014 for updating values while confirming Sales Quotation
        salesLine.MTI_ShowPrice     = salesQuotationLineUpdate.MTI_ShowPrice;
        salesLine.MTI_RollTo        = salesQuotationLineUpdate.MTI_RollTo;

        // <end> by Vimal

No comments:

Post a Comment