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 or debtor name

Uses the bank account of the current cash book receipt.

The default Cash Debtor accountno is defined as a system setting - debtors not matched will use this debtor.

Skips transactions where dates are outside the batch period - if no transactions on batch when importing, then the batch date is set to the earliest date of the transactions in CSV file.

Skips transactions already on current batch, or a prevous batch. true false 0 Superb Software NZ 07.01.00.00 Imports JiwaFinancials.Jiwa Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports System.Data.SqlClient Imports System.Drawing Imports System.Data Imports ServiceStack.Text.CsvSerializer Imports System.Collections.Generic Imports System.Linq 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 AddHandler cashBookForm.CashBook.ReadEnd, AddressOf CashBook_ReadEnd AddHandler cashBookForm.CashBook.CreateEnd, AddressOf CashBook_CreateEnd AddHandler cashBookForm.CashBook.PropertyChanged, AddressOf CashBook_PropertyChanged End If End Sub Private Sub CashBook_ReadEnd(sender As Object, e As System.EventArgs) Dim cashBook As JiwaCashBook.CashBook = DirectCast(sender, JiwaCashBook.CashBook) Dim cashBookForm As JiwaCashBookUI.frmCashBook = DirectCast(cashBook.Client, JiwaCashBookUI.frmCashBook) Dim loadCSVTool As Infragistics.Win.UltraWinToolbars.ButtonTool = cashBookForm.UltraToolbarsManager1.Tools("Load CSV") loadCSVTool.SharedProps.Enabled = Not cashBook.Activated AndAlso cashBookForm.CashBook.BankLedgerID IsNot Nothing AndAlso cashBookForm.CashBook.BankLedgerID.Trim.Length > 0 End Sub Private Sub CashBook_CreateEnd(sender As Object, e As System.EventArgs) Dim cashBook As JiwaCashBook.CashBook = DirectCast(sender, JiwaCashBook.CashBook) Dim cashBookForm As JiwaCashBookUI.frmCashBook = DirectCast(cashBook.Client, JiwaCashBookUI.frmCashBook) Dim loadCSVTool As Infragistics.Win.UltraWinToolbars.ButtonTool = cashBookForm.UltraToolbarsManager1.Tools("Load CSV") loadCSVTool.SharedProps.Enabled = Not cashBook.Activated AndAlso cashBookForm.CashBook.BankLedgerID IsNot Nothing AndAlso cashBookForm.CashBook.BankLedgerID.Trim.Length > 0 End Sub Private Sub CashBook_PropertyChanged(sender As Object, e As System.ComponentModel.PropertyChangedEventArgs) Dim cashBook As JiwaCashBook.CashBook = DirectCast(sender, JiwaCashBook.CashBook) Dim cashBookForm As JiwaCashBookUI.frmCashBook = DirectCast(cashBook.Client, JiwaCashBookUI.frmCashBook) Dim loadCSVTool As Infragistics.Win.UltraWinToolbars.ButtonTool = cashBookForm.UltraToolbarsManager1.Tools("Load CSV") loadCSVTool.SharedProps.Enabled = Not cashBook.Activated AndAlso cashBookForm.CashBook.BankLedgerID IsNot Nothing AndAlso cashBookForm.CashBook.BankLedgerID.Trim.Length > 0 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, cashBookForm) End If End If End Sub Private Sub CSVCashBookImport(ByVal FileName As String, cashBookForm As JiwaCashBookUI.frmCashBook) '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 '======================================================================= Dim transactions As List(Of WestpacCSVTransaction) = ServiceStack.Text.CsvSerializer.DeserializeFromString(Of List(Of WestpacCSVTransaction))(System.IO.File.ReadAllText(FileName)) Dim CashDebtorID As String = cashBookForm.Manager.Database.ReadSysData("Cashbook Bank Import and Debtor Match", "CashDebtor", "") If cashBookForm.CashBook.CashBookTransactions.Count = 0 AndAlso transactions.count > 0 Then ' If the user has not changed the date of the batch, assume they want us to automagically set it If cashBookForm.CashBook.BatchDate.Date = cashBookForm.Manager.SysDateTime.Date Then ' Set the cashbook batch date to be the date of the earliest date in the csv file if there were no existing transactions on the batch cashBookForm.CashBook.BatchDate = transactions.Cast(Of WestpacCSVTransaction).OrderBy(Function(x) x.Date).First().Date.Date End If End If Dim importedTransactions As Integer = 0 Dim skippedTransactionsDueToDate As Integer = 0 Dim skippedTransactionsAlreadyInCurrentBatch As Integer = 0 Dim skippedTransactionsAlreadyInAnotherBatch As Integer = 0 For Each transaction As WestpacCSVTransaction In transactions ' Only include transactions in the same month as the cashbook batch date If transaction.Date >= New Date(cashBookForm.CashBook.BatchDate.Year, cashBookForm.CashBook.BatchDate.Month, 1) AndAlso transaction.Date < New Date(cashBookForm.CashBook.BatchDate.Year, cashBookForm.CashBook.BatchDate.Month, 1).AddMonths(1) Then ' Find debtor based on OtherPartyName - check previous cash book receipt lines then check debtor names Dim debtor As JiwaApplication.Entities.Debtor.Debtor = FindDebtor(transaction, cashBookForm) If debtor Is Nothing Then ' We didn't find a debtor - as this is a cash book receipt, we assume everything is from a debtor (as opposed to payments which may have fees, et cetera - which would be to a GL Account) so fall back to the cash debtor defined by the system setting If CashDebtorID.Trim.Length = 0 Then Throw New System.Exception("The Cash Debtor has not been set - open system settings -> system configuration and on the 'Cashbook Bank Import and Debtor Match' tab, choose a cash debtor account") End If debtor = cashBookForm.Manager.EntityFactory.CreateEntity(Of JiwaApplication.Entities.Debtor.Debtor)() debtor.ReadRecord(CashDebtorID) End If ' Check this transaction is not already on this batch If TransactionExistsInBatch(transaction, cashBookForm, debtor) Then skippedTransactionsAlreadyInCurrentBatch += 1 Else ' Check this transaction is not already on another batch If TransactionExistsInAnotherBatch(transaction, cashBookForm, debtor) Then skippedTransactionsAlreadyInAnotherBatch += 1 Else ' Add the transaction to the cash book receipt Dim newTransactionKey As String = Nothing cashBookForm.CashBook.AddNewTransaction(JiwaCashBook.CashBookTransactionCollection.TransactionTypes.Debtor, debtor.RecID, newTransactionKey) Dim cashBookTransaction As JiwaCashBook.CashBookTransaction = cashBookForm.CashBook.CashBookTransactions(newTransactionKey) cashBookTransaction.TranDate = transaction.Date.Date cashBookTransaction.HomeAmount = transaction.Amount cashBookTransaction.RemitNo = IIf(transaction.Particulars Is Nothing, "" , transaction.Particulars) cashBookTransaction.Remark = IIf(transaction.OtherPartyName Is Nothing, "" , transaction.OtherPartyName) cashBookTransaction.Reference = IIf(transaction.AnalysisCode Is Nothing OrElse transaction.TransactionNotes Is Nothing, "" , String.Format("{0} {1}", transaction.AnalysisCode, transaction.TransactionNotes)) importedTransactions += 1 End If End If Else skippedTransactionsDueToDate += 1 End If Next ' Message user Dim message As String = String.Format("Imported {0} transactions{1}Skipped {2} transactions due to date out of range{1}Skipped {3} transactions already on another batch", importedTransactions, System.Environment.NewLine, skippedTransactionsDueToDate, skippedTransactionsAlreadyInAnotherBatch) System.Windows.Forms.MessageBox.Show(message, "Import Complete", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information, System.Windows.Forms.MessageBoxDefaultButton.Button1) End Sub Private Function FindDebtor(transaction As WestpacCSVTransaction, cashBookForm As JiwaCashBookUI.frmCashBook) As JiwaApplication.Entities.Debtor.Debtor Dim debtor As JiwaApplication.Entities.Debtor.Debtor = Nothing With cashBookForm.Manager.Database Dim SQLParam As SqlClient.SqlParameter = Nothing Dim SQLReader As SqlDataReader = Nothing ' See if a previous receipt has this same remark - if so, use the same debtor Try Dim SQL As String = "SELECT TOP 1 CB_BatchTranLines.DebtorCreditorID" & " FROM CB_BatchTranLines" & " JOIN CB_BatchTrans ON CB_BatchTrans.CBBatchID = CB_BatchTranLines.CBBatchID" & " WHERE CB_BatchTrans.ReceiptPayment = 1" & " AND CB_BatchTranLines.DebtorCreditor = 1" & " AND CB_BatchTranLines.Remark = @Remark" & " ORDER BY CB_BatchTranLines.TranDate DESC" Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@Remark", System.Data.SqlDbType.VarChar) SQLParam.Value = If(transaction.OtherPartyName Is Nothing, System.DBNull.Value, transaction.OtherPartyName) SQLCmd.Parameters.Add(SQLParam) SQLReader = SQLCmd.ExecuteReader() If SQLReader.Read = True Then debtor = cashBookForm.Manager.EntityFactory.CreateEntity(Of JiwaApplication.Entities.Debtor.Debtor)() debtor.ReadRecord(.Sanitise(SQLReader, "DebtorCreditorID")) Return debtor End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try ' Try finding a debtor with the name matching the OtherPartyName Try Dim SQL As String = "SELECT TOP 1 DB_Main.DebtorID" & " FROM DB_Main" & " WHERE DB_Main.Name = @Name" Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@Name", System.Data.SqlDbType.VarChar) SQLParam.Value = If(transaction.OtherPartyName Is Nothing, System.DBNull.Value, transaction.OtherPartyName) SQLCmd.Parameters.Add(SQLParam) SQLReader = SQLCmd.ExecuteReader() If SQLReader.Read = True Then debtor = cashBookForm.Manager.EntityFactory.CreateEntity(Of JiwaApplication.Entities.Debtor.Debtor)() debtor.ReadRecord(.Sanitise(SQLReader, "DebtorID")) Return debtor End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With Return debtor End Function Private Function TransactionExistsInBatch(transaction As WestpacCSVTransaction, cashBookForm As JiwaCashBookUI.frmCashBook, debtor As JiwaApplication.Entities.Debtor.Debtor) As Boolean Dim existingTransaction As JiwaCashBook.CashBookTransaction = cashBookForm.CashBook.CashBookTransactions.Cast(Of JiwaCashBook.CashBookTransaction).FirstOrDefault(Function(x) x.HomeAmount = transaction.Amount AndAlso x.TranDate.Date = transaction.Date.Date AndAlso x.DebtorCreditorAccountID = debtor.RecID AndAlso x.RemitNo = transaction.Particulars AndAlso x.Remark = transaction.OtherPartyName AndAlso x.Reference = String.Format("{0} {1}", transaction.AnalysisCode, transaction.TransactionNotes)) Return existingTransaction IsNot Nothing End Function Private Function TransactionExistsInAnotherBatch(transaction As WestpacCSVTransaction, cashBookForm As JiwaCashBookUI.frmCashBook, debtor As JiwaApplication.Entities.Debtor.Debtor) As Boolean With cashBookForm.Manager.Database Dim SQLParam As SqlClient.SqlParameter = Nothing Dim SQLReader As SqlDataReader = Nothing ' See if a previous receipt has this same transaction Try Dim SQL As String = "SELECT TOP 1 CB_BatchTranLines.DebtorCreditorID" & " FROM CB_BatchTranLines" & " JOIN CB_BatchTrans ON CB_BatchTrans.CBBatchID = CB_BatchTranLines.CBBatchID" & " WHERE CB_BatchTrans.ReceiptPayment = 1" & " AND CB_BatchTranLines.DebtorCreditor = 1" & " AND CB_BatchTrans.BankLedgerID = @BankLedgerID " & " AND CB_BatchTranLines.DebtorCreditorID = @DebtorCreditorID" & " AND CB_BatchTranLines.RemitNo = @RemitNo" & " AND CB_BatchTranLines.Ref = @Ref" & " AND CB_BatchTranLines.Remark = @Remark" & " AND CB_BatchTranLines.HomeAmount = @HomeAmount" & " AND CB_BatchTranLines.TranDate = @TranDate" & " ORDER BY CB_BatchTranLines.TranDate DESC" Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@BankLedgerID", System.Data.SqlDbType.Char) SQLParam.Value = cashBookForm.CashBook.BankLedgerID SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@DebtorCreditorID", System.Data.SqlDbType.Char) SQLParam.Value = debtor.RecID SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@RemitNo", System.Data.SqlDbType.VarChar) SQLParam.Value = IIf(transaction.Particulars Is Nothing, System.DBNull.Value, transaction.Particulars) SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@Ref", System.Data.SqlDbType.VarChar) SQLParam.Value = IIf(transaction.AnalysisCode Is Nothing OrElse transaction.TransactionNotes Is Nothing, System.DBNull.Value, String.Format("{0} {1}", transaction.AnalysisCode, transaction.TransactionNotes)) SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@Remark", System.Data.SqlDbType.VarChar) SQLParam.Value = IIf(transaction.OtherPartyName Is Nothing, System.DBNull.Value, transaction.OtherPartyName) SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@HomeAmount", System.Data.SqlDbType.Decimal) SQLParam.Value = transaction.Amount SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@TranDate", System.Data.SqlDbType.DateTime) SQLParam.Value = transaction.Date SQLCmd.Parameters.Add(SQLParam) SQLReader = SQLCmd.ExecuteReader() If SQLReader.Read = True Then Return True End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With Return False End Function End Class Public Class WestpacCSVTransaction Public Property [Date] As Date Public Property Amount As Decimal Public Property OtherPartyName As String Public Property Description As String Public Property Particulars As String Public Property AnalysisCode As String Public Property Reference As String Public Property TransactionNotes As String 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 If SystemSetting.Contents IsNot Nothing AndAlso SystemSetting.Contents.Trim.Length > 0 Then Dim debtor As JiwaApplication.Entities.Debtor.Debtor = BusinessLogicHost.Manager.EntityFactory.CreateEntity(Of JiwaApplication.Entities.Debtor.Debtor)() Try debtor.ReadRecord(SystemSetting.Contents) SystemSetting.DisplayContents = String.Format("{0} - {1}", debtor.AccountNo, debtor.Name) Catch ex As JiwaApplication.Exceptions.RecordNotFoundException SystemSetting.DisplayContents = "" End Try End If 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 Dim debtor As JiwaApplication.Entities.Debtor.Debtor = BusinessLogicHost.Manager.EntityFactory.CreateEntity(Of JiwaApplication.Entities.Debtor.Debtor)() debtor.Search(FormObject.Form) SystemSetting.Contents = debtor.DebtorID SystemSetting.DisplayContents = String.Format("{0} - {1}", debtor.AccountNo, debtor.Name) 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 05367f4e-b707-44e0-9d3b-eca62626cfc3 JiwaApplication, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\JiwaApplication.dll a3a72421-56a9-48a1-af02-3db266299cb0 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll b3c6111c-951c-439e-b7d7-0f16af42c764 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 e4d4e8a0-a1e1-41d9-a671-8b032328efda 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 3f690f81-232d-4744-ba1d-6d2cf14c9b89 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 cea91e56-1c03-4baa-a656-9d5e034b022e JiwaODBC, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\JiwaODBC.dll d30b735c-744f-413f-8f19-d05d4bc007ad 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 137b1153-51b4-491e-9ca7-435c3123fb7b 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 677ff347-d4ae-4791-ab28-6950f7d9490f 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 666039ce-2d7e-461f-be3e-5591d3da719c 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 63d43050-698d-4a56-b659-9efe021c7a10 JiwaServiceModel, Version=7.1.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\JiwaServiceModel.dll e63eb652-9470-4b49-9d85-d027409f1c1f Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.Misc.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.Misc.v13.1.dll 2bc56519-d092-4557-b60b-e635a60ec5a6 Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinEditors.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinEditors.v13.1.dll d6faa5fc-15f3-4f8b-b45b-387ddc3ab816 Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.v13.1.dll ca1e7e58-f970-4a5f-958f-35ae2567e014 Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\Microsoft.SqlServer.Smo.dll 62db0acf-5af5-4f20-aad5-53f54702c59d Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\Microsoft.SqlServer.ConnectionInfo.dll 724d3f52-e88a-471e-bec6-2a4f108e28d0 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinExplorerBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll d8040058-200d-4177-be9b-b32c8190569c Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTree.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTree.v13.1.dll 2eaaae67-dcaf-4a2d-9ae7-1384a8c62317 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\WINDOWS\assembly\GAC_MSIL\FarPoint.Win.Spread\8.35.20151.0__327c3516b1b18457\FarPoint.Win.Spread.dll 6c5ca000-9c1d-459f-a779-8dae0d32aabd Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTabControl.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTabControl.v13.1.dll 2bd7c2e9-ba54-4575-bc07-3862e81808bc Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Shared.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Shared.v13.1.dll 08dc6095-ba9a-4dba-b1fb-ccf237aeaac4 Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinToolbars.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinToolbars.v13.1.dll 231bc65d-6345-4eda-b4f1-b40ed37cdab2 Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinStatusBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinStatusBar.v13.1.dll 0894b7b0-80da-4e44-ab50-063c711cf409 Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinSchedule.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinSchedule.v13.1.dll 22e5924b-6469-4d10-85d3-26b9cf8ade2b Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinListView.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinListView.v13.1.dll b31b4a7f-4573-421e-b516-d06dc93b9558 ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\ServiceStack.dll bb518862-2a70-42b9-a519-06261ac88f92 EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\EntityFramework.dll a3309e9c-fbae-499d-a616-6a7c24422386 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 bcc94d27-aea2-4951-849f-b35b2daff927 ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll 919716b0-6f82-40df-9f1e-a60876bc7b00 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\ZetaHtmlEditControl.dll 7bc8ce49-228d-4991-bce5-377bfdabede3 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll bbcde1cf-0a1b-4f21-badf-61195b2aa761 JiwaEncryption, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\JiwaEncryption.dll 89e12eed-221f-4163-bd88-2a928c5744e2 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 72e72381-d74c-4760-bd3b-f6fe7b654d24 Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinGrid.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinGrid.v13.1.dll abd67b7a-6e5e-4e9e-90f1-5c39b44704a0 Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\Microsoft.SqlServer.Dac.dll 882bde7c-b298-417b-86ba-9135e7b39ff2 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 3d0a1ec8-6273-4eb2-b1d2-dd175c227b0a 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 de8cc667-0ecb-4e2a-be91-1302ff39bddd Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.AppStylistSupport.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.AppStylistSupport.v13.1.dll e3e5f835-7447-4df5-9d46-6c484121c563 JiwaLib, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\JiwaLib.dll a544aef5-84ef-49dc-a4ff-4ee051f001d7 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\Microsoft.ApplicationInsights.dll eed84eed-8b55-482d-898b-43590c4cf71b 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 04bb0a52-41d3-4595-930d-716b6ccd060d EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\EntityFramework.SqlServer.dll 0574697a-88d6-4dbb-8c18-0fd859586e7e ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll ba5b3847-0d5f-45fb-9524-ff74542795c7 ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\ServiceStack.Text.dll 56f6fb41-b8e1-4474-b456-5da94dc9ae5c FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\WINDOWS\assembly\GAC_MSIL\FarPoint.Win\8.35.20151.0__327c3516b1b18457\FarPoint.Win.dll 4a95a7cb-2d72-44db-b97e-63270db8bdda JiwaServiceModel, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\JiwaServiceModel.dll f87c6f2c-2e72-4616-8d44-21c5c0d13208 JiwaCashBookUI, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBookUI.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\JiwaCashBookUI.dll 26cdc944-1ab4-40b9-bf27-e31aa6bb6914 JiwaCashBook, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBook.dll C:\VSTS\Jiwa 7\Jiwa\Built Files\JiwaCashBook.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.3500.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.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.Controllers.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:\WINDOWS\assembly\GAC_MSIL\Microsoft.Office.Interop.Outlook\15.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Outlook.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.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ReportDefModel.dll b3b8d9515e0549978af5 CashDebtor The Cash debtor account to use 1 Lookup 000000001I00000002C5 000000001I00000002C5