24c82f35-cc27-4e0a-acd4-171fbf8b8607 Set custom float fields to 4 decimal places. Sets the decimal precision of Custom fields to a nominated number of decimal places true false 0 Atronics Consulting 7.2.1 using Microsoft.VisualBasic; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using JiwaFinancials.Jiwa; using System.Windows.Forms; using System.Data.SqlClient; using System.Drawing; using ServiceStack; using ServiceStack.DataAnnotations; using ServiceStack.Model; #region "FormPlugin" public class FormPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaFormPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void SetupBeforeHandlers(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "BusinessLogicPlugin" public class BusinessLogicPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogicPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic JiwaBusinessLogic, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "ApplicationManagerPlugin" public class ApplicationManagerPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaApplicationManagerPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "CustomFieldPlugin" public class CustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { if(CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "test_so" || CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "test_q") { if(GridObject.ActiveSheet.Cells[Row, Col].CellType == null){ GridObject.ActiveSheet.Cells[Row, Col].CellType = new FarPoint.Win.Spread.CellType.NumberCellType(); } FarPoint.Win.Spread.CellType.NumberCellType n = new FarPoint.Win.Spread.CellType.NumberCellType(); n.DecimalPlaces = 6; GridObject.ActiveSheet.Cells[Row, Col].CellType = n; } else if(CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "wo_litres" || CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "wo_weightpercent" || CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "litres" || CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "weightpercent") { if(GridObject.ActiveSheet.Cells[Row, Col].CellType == null){ GridObject.ActiveSheet.Cells[Row, Col].CellType = new FarPoint.Win.Spread.CellType.NumberCellType(); } FarPoint.Win.Spread.CellType.NumberCellType n = new FarPoint.Win.Spread.CellType.NumberCellType(); n.DecimalPlaces = 6; GridObject.ActiveSheet.Cells[Row, Col].CellType = n; } } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } } #endregion #region "LineCustomFieldPlugin" public class LineCustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { if(BusinessLogicHost.Client is JiwaFinancials.Jiwa.JiwaBillOfMaterialsUI.BillMaintenance.BillMaintenance){ JiwaFinancials.Jiwa.JiwaBillOfMaterialsUI.BillMaintenance.BillMaintenance billMaintenanceForm = (JiwaFinancials.Jiwa.JiwaBillOfMaterialsUI.BillMaintenance.BillMaintenance)BusinessLogicHost.Client; if(CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "test_so" || CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "test_q") { if(GridObject.ActiveSheet.Cells[Row, Col].CellType == null){ GridObject.ActiveSheet.Cells[Row, Col].CellType = new FarPoint.Win.Spread.CellType.NumberCellType(); } FarPoint.Win.Spread.CellType.NumberCellType n = new FarPoint.Win.Spread.CellType.NumberCellType(); n.DecimalPlaces = 6; GridObject.ActiveSheet.Cells[Row, Col].CellType = n; } else if(CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "wo_litres" || CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "wo_weightpercent" || CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "litres" || CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "weightpercent") { if(GridObject.ActiveSheet.Cells[Row, Col].CellType == null){ GridObject.ActiveSheet.Cells[Row, Col].CellType = new FarPoint.Win.Spread.CellType.NumberCellType(); } FarPoint.Win.Spread.CellType.NumberCellType n = new FarPoint.Win.Spread.CellType.NumberCellType(); n.DecimalPlaces = 6; GridObject.ActiveSheet.Cells[Row, Col].CellType = n; } else if(CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "quantity") { if(GridObject.ActiveSheet.Cells[Row, Col].CellType == null){ GridObject.ActiveSheet.Cells[Row, Col].CellType = new FarPoint.Win.Spread.CellType.NumberCellType(); } FarPoint.Win.Spread.CellType.NumberCellType n = new FarPoint.Win.Spread.CellType.NumberCellType(); n.DecimalPlaces = 4; GridObject.ActiveSheet.Cells[Row, Col].CellType = n; } if(CustomFieldValue.CustomField.PluginCustomField.Name.Trim().ToLower() == "weightpercent") { GridObject.Change += (sender, e) => Change(sender, e, billMaintenanceForm.OutputsJiwaGrid, billMaintenanceForm.CustomFieldsGrid); FarPoint.Win.Spread.Cell acell = GridObject.ActiveSheet.ColumnFooter.Cells[0, Col]; FarPoint.Win.Spread.CellType.NumberCellType pcent = new FarPoint.Win.Spread.CellType.NumberCellType(); pcent.DecimalPlaces = 4; pcent.Separator = ","; acell.CellType = pcent; acell.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; GridObject.ActiveSheet.ColumnFooter.SetAggregationType(0, Col, FarPoint.Win.Spread.Model.AggregationType.Sum); } } } private void Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid OutputsJiwaGrid, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid CustomFieldsGrid) { try { JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid grd = (JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid)sender; JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid grdout = (JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid)OutputsJiwaGrid; JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid grdcustom = (JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid)CustomFieldsGrid; grd.Change -= (sender1, e1) => Change(grd, e, grdout, grdcustom); if(grd.ActiveSheet.GetValue(e.Row,e.Column) != null && grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["PartNo"].Index].Value.ToString() != "" && grdout.ActiveSheet.Cells[0, grdout.ActiveSheet.Columns["Quantity"].Index].Value != null && grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["Set custom float fields to 4 decimal places..WeightPerCent"].Index].Value.ToString() != null){ decimal outputquantity = Convert.ToDecimal(grdout.ActiveSheet.Cells[0, grdout.ActiveSheet.Columns["Quantity"].Index].Value.ToString()); // decimal weightpercent = Convert.ToDecimal(grd.ActiveSheet.GetValue(e.Row,e.Column).ToString()); //MessageBox.Show(grd.ActiveSheet.GetValue(e.Row,e.Column).ToString()); decimal weightpercent = Convert.ToDecimal(grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["Set custom float fields to 4 decimal places..WeightPerCent"].Index].Value.ToString()); decimal kg = ((outputquantity * weightpercent) / 100); //MessageBox.Show(grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["LastCost"].Index].Value.ToString()); decimal lastCost = Convert.ToDecimal(grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["LastCost"].Index].Value.ToString()); decimal totLineCost = kg * lastCost; //MessageBox.Show(totLineCost.ToString()); grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["Quantity"].Index].Value = kg; // MessageBox .Show(grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["Quantity"].Index].Value.ToString()); decimal Cubic = getCubic(grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["PartNo"].Index].Value.ToString()); decimal litres = kg/Cubic; foreach(FarPoint.Win.Spread.Column col in grd.ActiveSheet.Columns) { if (col.Label == "Litres") { grd.ActiveSheet.Cells[e.Row, col.Index].Value = litres; } } grd.ActiveSheet.Cells[e.Row, grd.ActiveSheet.Columns["TotalLineCost"].Index].Value = totLineCost; } } catch(Exception ex) { //MessageBox.Show(ex.Message+" StackTrace : "+ex.StackTrace); } } private decimal getCubic(string PartNo) { decimal Cubic = 1; var db = JiwaFinancials.Jiwa.JiwaApplication.Manager.Instance.Database; System.Data.SqlClient.SqlParameter SQLParam = null; System.Data.SqlClient.SqlDataReader SQLReader = null; try { string SQL = @"Select Cubic From IN_Main Where PartNo = @PartNo "; using (SqlCommand SQLCmd = new SqlCommand(SQL, db.SQLConnection, db.SQLTransaction)) { SQLParam = new SqlParameter("@PartNo", System.Data.SqlDbType.Char, 50); SQLParam.Value = PartNo; SQLCmd.Parameters.Add(SQLParam); SQLReader = db.ExecuteReader(SQLCmd); while (SQLReader.Read()) { Cubic = Convert.ToDecimal(db.Sanitise(SQLReader, "Cubic").ToString()); } } SQLReader.Close(); } catch(Exception ex) { MessageBox.Show("SalesOrderSaveEnding : "+ex.Message+ex.StackTrace); } finally { } return (Cubic == 0 ? 1 : Cubic); } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } } #endregion #region "SystemSettingPlugin" public class SystemSettingPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaSystemSettingPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } } #endregion #region "ScheduledExecutionPlugin" public class ScheduledExecutionPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin { public void Execute(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin, JiwaFinancials.Jiwa.JiwaApplication.Schedule.Schedule Schedule) { } public void OnServiceStart(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void OnServiceStopping(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion Report CSharp c38a89ef-18d7-4076-affb-f3cdc2ea1cf6 Sales Orders JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm 01987a02-5b6b-402a-ba12-f449ab652204 Quoting JiwaFinancials.Jiwa.JiwaSalesUI.SalesQuote.SalesQuoteEntryForm a201c5db-9599-4185-a697-5ffd0ef3432e Work Order JiwaFinancials.Jiwa.JiwaBillOfMaterialsUI.WorkOrder.WorkOrder 6adae60c-9a3b-4ab1-8195-a3bdf83a353f BoM Maintenance JiwaFinancials.Jiwa.JiwaBillOfMaterialsUI.BillMaintenance.BillMaintenance 327ea190-91a5-4059-bcef-8a3638bc83bf Bill Maintenance JiwaFinancials.Jiwa.JiwaBillOfMaterials.BillMaintenance.BillMaintenance JiwaBillOfMaterials, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c 5ebd952e-a92a-4d47-ade0-460f087cb433 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaApplication.dll 84d62ad7-e0f0-469a-8870-29fb1094d416 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 53fb3a91-81e3-4994-9c59-a920ab241bec System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll ccaf31d2-a8fd-4917-8c29-dd5b045a9d6f Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.VisualBasic.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll 774c1c15-9086-4d42-a177-03f2ae19e267 System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Drawing.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll 1e6c5dfd-1375-47a2-a2db-1a1f767672a2 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaODBC.dll 7bb32be8-f341-43b9-b219-133690053a87 System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.dll C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll f70954a2-bb01-47d9-bb17-6ff6d5baffff System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Xml.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll b29504e7-85de-49d5-8ba0-128d5fae7357 System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Runtime.Serialization.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll 88ca9b28-6cb8-45e8-aec7-809f30d9e016 System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Windows.Forms.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll 509a960e-e9e0-404e-ab25-3583b65a6358 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaServiceModel.dll 570b64b2-f2fe-4227-8a7f-a1df37d3e2ae Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.Misc.v13.1.dll 07e35f66-354d-4d3f-928a-76cf3bfa2651 Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinEditors.v13.1.dll 8e6a6a48-e02f-4c8d-8986-ac46ac68f0ce Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.v13.1.dll 506f1e22-81bf-44af-90dd-a5910f949c9d Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Smo.dll d09e4f91-b7b3-4d83-a3ab-af0d10e2070c Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll 42c9220d-8ee7-4f21-b8d9-3f6857c6b631 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 56438f1d-41bd-4a5d-934d-1553e587a1c3 Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinTree.v13.1.dll c0248b8f-4e9d-4072-865e-6eca75e89622 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\FarPoint.Win.Spread.dll 929a5dec-afd5-4963-9130-73f74b203c91 Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinTabControl.v13.1.dll 5633ec64-7b99-45cf-b2e7-79a2b55ab0bd Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Shared.v13.1.dll 4ee58eca-f6ce-4847-9777-8f2b35d9b69d Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinToolbars.v13.1.dll a9587880-ce15-475a-833c-3b26358a0afd Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinStatusBar.v13.1.dll 1f6dd237-30f3-405e-980e-7930686ecfa6 Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinSchedule.v13.1.dll d7012aa3-e333-4115-8a87-c71b94cea8eb Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinListView.v13.1.dll 2f470e02-169e-4335-b327-bca8e56dcab8 ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.dll e4a952e0-e0ad-4d61-b6c2-ddc361d9349e EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\EntityFramework.dll 37092ea6-22a7-4aaa-b30f-f4f099acaad5 System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Core.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll 204ca863-1660-4f03-8372-40a150502e38 ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll e2ffc6ea-7661-4579-8d9a-d07c9b65082a ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ZetaHtmlEditControl.dll ad21fa1a-eb89-4838-a352-707ab1f1fbcd ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll 28b2cdfa-9787-419c-b59f-3f2ef525727f JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaEncryption.dll 374fb1dc-d375-4330-8777-336e272b757f Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinGrid.v13.1.dll 11beafb1-3fb8-4bcd-a9f3-c4340f312426 Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Dac.dll 1707e8ef-bf12-4de4-a726-bd988672dab4 CrystalDecisions.CrystalReports.Engine, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.CrystalReports.Engine.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.3500.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll 61ca7da4-50e9-4230-aeb9-982d2d90775e CrystalDecisions.Shared, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Shared.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.Shared\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Shared.dll 964346ed-2ece-4b4b-8019-e56df5c3e0ef CrystalDecisions.ReportAppServer.Controllers, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.Controllers.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.Controllers\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.Controllers.dll b2ef5107-8bcd-43e0-b4be-2b1dfa538897 Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.AppStylistSupport.v13.1.dll 24f827e0-7502-45fd-bece-7732acf4237b JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaLib.dll bcdec6bd-59eb-475f-9d1f-a80647da5949 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.ApplicationInsights.dll 6d60cbfc-1f38-40b1-9875-3fdd93443404 CrystalDecisions.Windows.Forms, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Windows.Forms.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll 349748cd-fbc8-4e20-be58-1d20900bb8fe EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\EntityFramework.SqlServer.dll 57f5f97a-6e94-448e-8422-51a369d108b7 ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Text.dll 03dd0c55-1f4a-4df0-ac96-0431f18a490c ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.Shared.WinForms.dll e2a09417-b1c0-4e18-94ae-39a338a9c471 System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Security.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll 4200341d-1a9b-4d03-9b0a-e05cdba2a487 FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\FarPoint.Win.dll 0cbdc293-16c4-4bbf-91a4-05edceb6fc3e CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ClientDoc.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ClientDoc\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ClientDoc.dll fb4ebba2-8f41-4822-818e-57658457527b CrystalDecisions.ReportAppServer.ReportDefModel, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ReportDefModel.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ReportDefModel\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ReportDefModel.dll f4293c31-f52b-4147-8d34-d5a4e7555244 ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Interfaces.dll 29355d71-0a75-46a0-b7a5-d5766ed8527c ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Server.dll b574a2e7-2f06-4a24-a5d7-6b4375f71f02 ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.OrmLite.dll 0628b74a-63b1-499b-b315-0a96888a233a JiwaSalesUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSalesUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaSalesUI.dll f95a9a7a-27eb-410a-8bbb-55df31dcd22f JiwaSales, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSales.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaSales.dll f9413bd6-6782-4944-a384-08fb6cf319a9 JiwaPriceSchemes, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaPriceSchemes.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaPriceSchemes.dll 52c8cc02-ea1f-4223-8c0f-f8cfbe9b5dae JiwaJobCosting, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaJobCosting.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaJobCosting.dll a89fa53b-5a8d-49f4-9986-ccb86c80f32b JiwaSerialNumbersUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSerialNumbersUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaSerialNumbersUI.dll a69dfc35-e8d7-4d5e-826c-40022a9e5641 JiwaBillOfMaterialsUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaBillOfMaterialsUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaBillOfMaterialsUI.dll a596218a-4698-4b3b-b9e1-053883e1c44c JiwaBillOfMaterials, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaBillOfMaterials.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaBillOfMaterials.dll 290917d5-2bbb-4e66-9311-770a9a4b9e77 Infragistics4.Win.UltraWinGanttView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGanttView.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinGanttView.v13.1.dll cc91e1f3-1a57-4a1c-af20-6990a09a6aee JiwaWarehouses, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaWarehouses.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaWarehouses.dll b46536cb-9443-40d4-9162-927c21e822b6 JiwaJournalSets, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaJournalSets.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaJournalSets.dll 44cedea0-b5f1-45fd-9746-527731f8c874 Microsoft.Office.Interop.Outlook, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c Microsoft.Office.Interop.Outlook.dll C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Outlook\15.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Outlook.dll 764fb5ee818b4ad4b9a0 TEST_Q Test float Quotes 1 Float Sales Quote 57701423d408493787ea TEST_SO Test float sales orders 1 Float Sales Order 38c7596e-23bd-4879-accb-8a8096b915bf Litres Litres 1 Float Bill Inputs b670e6b7-f072-44df-85aa-64ef3da7f076 WeightPerCent Weight PerCent 1 Float Bill Inputs 7a4bccf2-3d63-46e3-a9c9-2e7d8453af93 WO_Litres WO Litres 1 Float Work Order Inputs cecb17c9-0733-41da-b4ce-32efbed9a441 WO_WeightPerCent WO WeightPerCent 1 Float Work Order Inputs