/* ***** General Information ***** Creator: coresystems ag, muf@coresystems.ch Create Date: 2012-03-21   ***** StartConfDesc ***** This rule fills the project code with the value entered on the document header on the first row and the values entered in the previous row for all other rows ***** EndConfDesc *****   ***** Updates ***** 2012-03-21, muf: Initial Rule 2012-07-16, muf: Fill the first row with the value from the document header and use pVal.Row to get the current row */ // Here Project Code (ColumnUid = 31), adjust this if you need to copy a the value of a different column to the next row string columnUID = "31"; string ruleName = pVal.RuleInfo.RuleName.ToString(); string errorMessage = "Error in Optimizer Rule '" + ruleName + "'"; string project = ""; try { Matrix oMatrix = Matrix.GetFromUID(pVal.Form, "38"); int currentRow = pVal.Row - 1; if (currentRow == 0) { // Get the value from the BP Project under Accounting folder project = TextEdit.GetFromUID(pVal.Form, "157").Value; } else { // Get the value from the previous row project = oMatrix.GetValue(columnUID, currentRow - 1); } oMatrix.SetValue(columnUID, currentRow, project); } catch(System.Exception ex) { StatusBar.WriteError(errorMessage + ": " + ex.Message); Debug.WriteMessage(errorMessage + ": " + ex.Message, Debug.DebugLevel.Exception); } return true;