Announcements
No record found.
public static SalesQuotationTable findProjId(ProjId _projId, boolean _forupdate = false) { SalesQuotationTable salesQuotationTable; if (isConfigurationkeyEnabled(configurationKeyNum(Project)) && _projId) { salesQuotationTable.selectForUpdate(_forupdate); select firstonly salesQuotationTable where salesQuotationTable.ProjIdRef == _projId; } return salesQuotationTable; }
[ExtensionOf(tableStr(SalesQuotationTable))] final class DT_SalesQuotationTable_Extension { public void Insert() { next Insert(); SalesQuotationTable salesQuotationTable; ProjTable projTable; if(projTable.ProjId != "") { select sum(quotationValue) from salesQuotationTable join projTable where projTable.ProjId == this.ProjIdRef; projTable.quotationValue = salesQuotationTable.quotationValue; projTable.update(); } } }
public void insert() { ttsbegin; next insert(); SalesQuotationTable::updateProjQuotationValue(this.ProjIdRef); ttscommit; } private static void updateProjQuotationValue(ProjId _projId) { if (!_projId) { return; } SalesQuotationTable quotation; select sum(QuotationValue) from quotation where quotation.ProjIdRef == _projId; ProjTable projTable = ProjTable::find(_projId, true); projTable.QuotationValue = quotation.QuotationValue; projTable.update(); }
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 274 Super User 2026 Season 2
Aayush Tiwari 219
Subra 202 Super User 2026 Season 2