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
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