ac888685-f0cb-4d8f-a839-2ef3408985a3 Cashbook Bank Import and Debtor Match Adds Button to Cash Book receipt to import a Westpac Format Bank CSV file to Cash Book Receipts and Match debtor,based on prior Cash Book Transactions Put your default Bank accountno on Line 88, Your default Cash Debtor accountno on line 94/104 Check your bank CSV format
and adjust as required. true false 0 Superb Software NZ 7.0.157.0 Imports JiwaFinancials.Jiwa Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports System.Data.SqlClient Imports System.Drawing Imports System.Data Public Class FormPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaFormPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub SetupBeforeHandlers(ByVal JiwaForm As JiwaApplication.IJiwaForm, ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaFormPlugin.SetupBeforeHandlers End Sub Public Sub Setup(ByVal JiwaForm As JiwaApplication.IJiwaForm, ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaFormPlugin.Setup If TypeOf JiwaForm Is JiwaCashBookUI.frmCashBook Then Dim cashBookForm As JiwaCashBookUI.frmCashBook = DirectCast(JiwaForm, JiwaCashBookUI.frmCashBook) Dim group As Infragistics.Win.UltraWinToolbars.RibbonGroup = cashBookForm.UltraToolbarsManager1.Ribbon.Tabs("Main").Groups("Actions") ' Dim newTool As New Infragistics.Win.UltraWinToolbars.ButtonTool("Load CSV") newTool.SharedProps.Caption = "Load CSV" cashBookForm.UltraToolbarsManager1.Tools.Add(newTool) group.Tools.AddTool("Load CSV") group.Tools("Load CSV").InstanceProps.MinimumSizeOnRibbon = Infragistics.Win.UltraWinToolbars.RibbonToolSize.Normal AddHandler cashBookForm.UltraToolbarsManager1.ToolClick, AddressOf cashBookForm_Toolbar_ToolClick End If End Sub Public Sub cashBookForm_Toolbar_ToolClick(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinToolbars.ToolClickEventArgs) Dim cashBookForm As JiwaCashBookUI.frmCashBook = DirectCast(sender, Infragistics.Win.UltraWinToolbars.UltraToolbarsManager).DockWithinContainer If e.Tool.Key = "Load CSV" Then cashBookForm.DialogOpen.FileName = "" If cashBookForm.DialogOpen.ShowDialog() = System.Windows.Forms.DialogResult.OK Then CSVCashBookImport(cashBookForm.DialogOpen.FileName) End If End If End Sub Private Sub CSVCashBookImport(ByVal FileName As String) 'SAMPLE CSV INPUT FILE - From WESTPAC '======================================================================= 'Date,Amount,Other Party Name, Description, Particulars, Analysis Code, Reference, Transaction Notes '20/03/2018,5.68,TIGER TURF GO,BILL PAYMENT,Tiggol,101629002 '======================================================================= ' JIWA 7.01 ' SyncLock JiwaFinancials.Jiwa.JiwaApplication.Manager.CriticalSectionFlag ' JIWA 7.01 ' Dim CashBookRct As JiwaFinancials.Jiwa.JiwaCashBook.CashBook = _plugin.Manager.BusinessLogicFactory.CreateBusinessLogic(Of JiwaCashBook.CashBook)(Nothing) Dim CashBookRct As JiwaFinancials.Jiwa.JiwaCashBook.CashBook = JiwaApplication.Manager.Instance.BusinessLogicFactory.CreateBusinessLogic(Of JiwaCashBook.CashBook)(Nothing) Using csvParser As New FileIO.TextFieldParser(FileName) csvParser.TextFieldType = FileIO.FieldType.Delimited csvParser.Delimiters = New String() {","} csvParser.HasFieldsEnclosedInQuotes = True Dim csvFields As String() Dim previousOrderNo As String = Nothing Dim newKey As String = "" Dim DefaultDebtor As String = "" ' JIWA 7.01 ' Dim debtor As JiwaApplication.Entities.Debtor.Debtor = _plugin.Manager.EntityFactory.CreateEntity(Of JiwaApplication.Entities.Debtor.Debtor) ' Dim BankLedger As JiwaApplication.Entities.GeneralLedger.Account = _plugin.Manager.EntityFactory.CreateEntity(Of JiwaApplication.Entities.GeneralLedger.Account) Dim debtor As JiwaApplication.Entities.Debtor.Debtor = New JiwaApplication.Entities.Debtor.Debtor Dim BankLedger As JiwaApplication.Entities.GeneralLedger.Account = New JiwaApplication.Entities.GeneralLedger.Account ' Do While Not csvParser.EndOfData csvFields = csvParser.ReadFields ' Ignore Blanks, and the first Line and only accept Positive Values If csvFields(0) <> "" And csvFields(0) <> "Date" Then If csvFields(1) > 0 Then If Not previousOrderNo Is Nothing AndAlso csvFields(0) <> previousOrderNo Then ' on Change of Date it will start a new Cash Book receipt CashBookRct.Save() msgbox ("Imported Cash Book Batch No." & CashBookRct.BatchNo & " From File:" & FileName) End If If previousOrderNo Is Nothing OrElse csvFields(0) <> previousOrderNo Then ' Create a new order ' Load your default bank account number here BankLedger.ReadRecordFromAccountNo("6420-000-00") CashBookRct.CreateNew() CashBookRct.CashBookType = JiwaCashBook.CashBook.CashBookTypes.Receipt CashBookRct.BankLedgerID = BankLedger.GLLedgerID End If ' Load your default CASH SALE Account here, for when Link to debtor not found. DefaultDebtor = "CASSAL" ' Check Prior Cash Book Entries for use of this Remit No, and get Linked Debtor. With JiwaApplication.Manager.Instance.Database Dim SQLParam As SqlClient.SqlParameter = Nothing Dim SQLReader As SqlDataReader = Nothing Try Dim SQL As String = "Select top 1 accountno from CB_BatchTranLines " _ & " inner join CB_BatchTrans On CB_BatchTrans.CBBatchID = CB_BatchTranLines.CBBatchID " _ & " inner join db_main On db_main.DebtorID = CB_BatchTranLines.DebtorCreditorID " _ & " where CB_BatchTrans.LastSavedDateTime > getdate()-90 And db_main.AccountNo <> 'CASSAL' " _ & " And remitno = '" & csvFields(2) & "' " _ & " order by CB_BatchTrans.LastSavedDateTime desc " ' msgbox ( SQL) Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) ' SQLParam = New SqlParameter("@DebtorID", System.Data.SqlDbType.Char) ' SQLParam.Value = debtor.DebtorID ' SQLCmd.Parameters.Add(SQLParam) SQLReader = SQLCmd.ExecuteReader() If SQLReader.Read = True Then DefaultDebtor = .Sanitise(SQLReader, "accountno") End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With Debtor.ReadRecordFromAccountNo(DefaultDebtor) Dim newTransactionKey As String CashBookRct.AddNewTransaction(JiwaCashBook.CashBookTransactionCollection.TransactionTypes.Debtor, Debtor.RecID, newTransactionKey) CashBookRct.CashBookTransactions(newTransactionKey).HomeAmount = csvFields(1) CashBookRct.CashBookTransactions(newTransactionKey).RemitNo = csvFields(2) CashBookRct.CashBookTransactions(newTransactionKey).Remark = csvFields(4) CashBookRct.CashBookTransactions(newTransactionKey).Reference = csvFields(5) & " " & csvFields(6) CashBookRct.CashBookTransactions(newTransactionKey).TranDate = csvFields(0) ' for intellisense ' Dim cashBookTransaction As JiwaCashBook.CashBookTransaction = CashBookRct.CashBookTransactions(newTransactionKey) ' cashBookTransaction.TranDate previousOrderNo = csvFields(0) End If ' If csvFields(1) > 0 Then End If ' If csvFields(0) <> "" Then Loop ' If CashBookRct.CashBookTransactions.Count > 0 Then CashBookRct.Save() msgbox ("Imported Cash Book Batch No." & CashBookRct.BatchNo & " From File:" & FileName) End If End Using ' JIWA 7.01 ' End SyncLock End Sub End Class Public Class BusinessLogicPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaBusinessLogicPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub Setup(ByVal JiwaBusinessLogic As JiwaApplication.IJiwaBusinessLogic, ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaBusinessLogicPlugin.Setup End Sub End Class Public Class ApplicationManagerPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaApplicationManagerPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub Setup(ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaApplicationManagerPlugin.Setup End Sub End Class Public Class CustomFieldPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaCustomFieldPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub FormatCell(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostObject As JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaCustomFieldPlugin.FormatCell End Sub Public Sub ReadData(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal HostObject As JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaCustomFieldPlugin.ReadData End Sub Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostObject As JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaCustomFieldPlugin.ButtonClicked End Sub End Class Public Class LineCustomFieldPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaLineCustomFieldPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub FormatCell(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostItem As JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaLineCustomFieldPlugin.FormatCell End Sub Public Sub ReadData(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal HostItem As JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaLineCustomFieldPlugin.ReadData End Sub Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostItem As JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaLineCustomFieldPlugin.ButtonClicked End Sub End Class Public Class SystemSettingPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaSystemSettingPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub FormatCell(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal SystemSetting As JiwaApplication.SystemSettings.Setting) Implements JiwaApplication.IJiwaSystemSettingPlugin.FormatCell End Sub Public Sub ReadData(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal SystemSetting As JiwaApplication.SystemSettings.Setting) Implements JiwaApplication.IJiwaSystemSettingPlugin.ReadData End Sub Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal SystemSetting As JiwaApplication.SystemSettings.Setting) Implements JiwaApplication.IJiwaSystemSettingPlugin.ButtonClicked End Sub End Class Public Class ScheduledExecutionPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaScheduledExecutionPlugin Public Sub Execute(ByVal Plugin As JiwaApplication.Plugin.Plugin, ByVal Schedule As JiwaApplication.Schedule.Schedule) Implements JiwaApplication.IJiwaScheduledExecutionPlugin.Execute End Sub Public Sub OnServiceStart(ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaScheduledExecutionPlugin.OnServiceStart End Sub Public Sub OnServiceStopping(ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaScheduledExecutionPlugin.OnServiceStopping End Sub End Class Report VisualBasic 813d48d2-dc11-4f1c-911b-5b92b4af9af1 Cash Book Payments JiwaFinancials.Jiwa.JiwaCashBookUI.frmCashBookPayments 28448891-ac6a-4136-8844-806c9025e500 Cash Book Receipts JiwaFinancials.Jiwa.JiwaCashBookUI.frmCashBookReceipts 14eece04-b502-495e-839e-c85704380a25 JiwaApplication, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaApplication.dll d36a4466-7f71-46d4-b5ac-30f2a7435148 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll d75e6f37-ca23-4836-909c-f75b80cde78e 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 cdfda9c9-c181-4a66-a18c-68693b325c6f 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 a325495a-b51a-4de0-9fd5-77bcde29638b 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 6ea4b1e3-3480-4723-9a6d-dec3265d0126 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 c1e16350-9141-4a87-bc0e-6b6204789fda JiwaODBC, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaODBC.dll cc57fc31-cb22-4d93-898d-4037afc5ed51 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 8cb56b1d-df2f-4c20-8b6f-19c8ed86edf7 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 54631ada-c2a3-4167-b9f9-a9a00a35bcf7 Microsoft.SqlServer.Smo, Version=13.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Smo.dll 0fce6eb2-d2e0-439b-b18b-779b265bfe0e Microsoft.SqlServer.ConnectionInfo, Version=13.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll f6af68be-bd54-4792-a597-ba62948de06d 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 6c8fab43-9065-4c73-8508-2d9c5d491c35 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 8749c301-7adc-4182-9e0b-da3d63aec403 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 944236b0-4236-46ae-beb1-0cb0ae229506 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 2540b77d-f638-4fb2-be89-43da4227995b 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 6e7b8cc7-5368-4181-9b6f-7424ff8a15c1 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 65c737d3-cc89-4ec3-b56d-e332af7235b9 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 a1239ec7-de52-49b9-8998-b880fbaae26f 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 85ee3196-5d46-47f5-a012-509ca81cee35 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 a9fa9b38-0af2-44f4-8a92-e3b299460209 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 f1309a1f-943d-4c07-9ff3-099b283e8133 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 43163fe4-83b0-4034-b353-2c7e079b01e5 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 88c4f29c-a5e5-4aea-befa-1c6ac7f40f09 ServiceStack, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43 ServiceStack.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.dll 39c7458f-d8db-48b0-a9b3-536d93f2da40 ActiproSoftware.SyntaxEditor.WinForms, Version=12.1.304.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll b05019da-f8f2-4d84-b580-767c9551cbf2 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ZetaHtmlEditControl.dll b0d9d615-7df0-4a62-807e-699ac446b808 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=12.1.304.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 b0ce7ae4-79bb-48b6-9813-dee72fee79bc JiwaEncryption, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaEncryption.dll a43ae8bb-0ade-4793-96f8-cd45f893e85b 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 70819720-9594-4f8a-8fe3-2213be8a62c4 Microsoft.SqlServer.Dac, Version=13.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Dac.dll 7587f945-e404-4969-afc6-ebbfad68057f CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.CrystalReports.Engine.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.2000.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll 4ba0e463-ecdd-4c9f-accd-bf46aada2959 CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Shared.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Shared\13.0.2000.0__692fbea5521e1304\CrystalDecisions.Shared.dll 6877c876-7620-407d-ab1e-49f9460d0bd8 CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ClientDoc.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ClientDoc\13.0.2000.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ClientDoc.dll 186bea94-d8da-4cc2-9495-705e82323ed2 CrystalDecisions.ReportAppServer.Controllers, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.Controllers.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.Controllers\13.0.2000.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.Controllers.dll 6733aac2-922f-4c49-a882-3e25f46e4938 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 b1bee9e4-9236-488c-ae99-751011cd30cb 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 ac487dee-2440-4f06-b213-c9bd7c0ffcd7 JiwaLib, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaLib.dll 0ebeaa5d-5dbe-4733-91d3-d109bbf21bb7 Microsoft.ApplicationInsights, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.ApplicationInsights.dll 59ed97ec-bfd5-4654-afb2-a20c1bb3730f CrystalDecisions.Windows.Forms, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Windows.Forms.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\13.0.2000.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll 790f8d75-d6bc-4055-88ed-4fa636e83585 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 a7488e5a-3858-42bd-9f46-c6277258598c 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 e511e410-0aff-4f5f-ba70-a210271feee2 Microsoft.Office.Interop.Outlook, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c Microsoft.Office.Interop.Outlook.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.Office.Interop.Outlook.dll 1a1e1c18-f54c-480d-86a1-715461f540d4 ActiproSoftware.Shared.WinForms, Version=12.1.304.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.Shared.WinForms.dll 127826cd-2197-45a5-8e33-85345da51a92 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 c57c24e2-eb1b-4d9b-be21-b01e276df7a5 CrystalDecisions.ReportAppServer.ReportDefModel, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ReportDefModel.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ReportDefModel\13.0.2000.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ReportDefModel.dll 996b9a67-1f2f-47b9-9fe3-8a64f768ec5f ServiceStack.Interfaces, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43 ServiceStack.Interfaces.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Interfaces.dll 3cf6f8fd-7610-4c89-8efe-626e9addca24 ServiceStack.Server, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = e06fbc6124f57c43 ServiceStack.Server.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Server.dll fa0daf01-5a50-45a3-8431-143b6368e7f8 ServiceStack.OrmLite, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = e06fbc6124f57c43 ServiceStack.OrmLite.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.OrmLite.dll 5fb55c29-1f06-4285-9460-36f039bd9b93 JiwaCashBookUI, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBookUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaCashBookUI.dll 29ee5efe-f60c-4931-a469-77c6eb56e057 JiwaCashBook, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBook.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaCashBook.dll