904d4feb-2d6e-40d1-aa84-11145376550f Manual BO Release Batch Extend Ranges Adds 2 ranges to the Manual BO Realse Batch form which are passed to the stored procedure used to return results to the BackOrders grid.

The Documents tab contains a SQL script to create a custom stored procedure which accepts the two extra parameters. true false 0 Jiwa Financialss 7.2.0 Imports System Imports JiwaFinancials.Jiwa Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports System.Data.SqlClient Imports System.Drawing Imports System.Data Imports ServiceStack Imports ServiceStack.DataAnnotations Imports ServiceStack.Model Imports System.Reflection 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 ' Add handler for button click which we want to intercept Dim manualBoReleaseForm As JiwaFinancials.Jiwa.JiwaManualBOBatchUI.MainForm = JiwaForm AddHandler manualBoReleaseForm.GetCandidatesUltraButton.Click, AddressOf GetCandidatesUltraButton_Click End Sub Public Sub Setup(ByVal JiwaForm As JiwaApplication.IJiwaForm, ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaFormPlugin.Setup ' Add our new ranges to the grid Dim manualBoReleaseForm As JiwaFinancials.Jiwa.JiwaManualBOBatchUI.MainForm = JiwaForm manualBoReleaseForm.grdRanges.AddColumn("StockReceivedDate", New FarPoint.Win.Spread.CellType.DateTimeCellType(), "Stock Received Date", 8, False, True, False, False, 255, False, False, 0, False) manualBoReleaseForm.grdRanges.AddColumn("DeliveryZone", New JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), "Delivery Zone", 10, False, True, False, True, 50, False, False, 0, False) manualBoReleaseForm.grdRanges.GridText("StockReceivedDate", 0) = New DateTime(DateTime.Today.Year, DateTime.Today.Month, 1) manualBoReleaseForm.grdRanges.GridText("StockReceivedDate", 1) = DateTime.Today manualBoReleaseForm.grdRanges.GridText("DeliveryZone", 0) = "" manualBoReleaseForm.grdRanges.GridText("DeliveryZone", 1) = "" End Sub Private Sub GetCandidatesUltraButton_Click(sender As Object, e As EventArgs) Dim manualBoReleaseForm As JiwaFinancials.Jiwa.JiwaManualBOBatchUI.MainForm = sender.FindForm() Dim oldCursor As Cursor = manualBoReleaseForm.Cursor Try manualBoReleaseForm.Cursor = Cursors.WaitCursor AddRange(manualBoReleaseForm.OrderByUltraOptionSet.CheckedIndex, manualBoReleaseForm) manualBoReleaseForm.CheckEditStatus() Finally manualBoReleaseForm.Cursor = oldCursor End Try ' Invoke the private method of the form to display the lines 'manualBoReleaseForm.GetType.InvokeMember("DisplayBatchLines", BindingFlags.NonPublic Or BindingFlags.Instance, Nothing, Me, Nothing) Dim dynMethod As MethodInfo = manualBoReleaseForm.GetType().GetMethod("DisplayBatchLines", BindingFlags.NonPublic Or BindingFlags.Instance) dynMethod.Invoke(manualBoReleaseForm, Nothing) ' Now cancel the form handling the click of the button Throw New JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ClientCancelledException() End Sub Public Sub AddRange(ByVal OrderBy As Integer, manualBoReleaseForm As JiwaFinancials.Jiwa.JiwaManualBOBatchUI.MainForm) Dim SQLReader As SqlDataReader = Nothing Dim SQLParam As SqlParameter Try With manualBoReleaseForm.Manager.Database Dim SQL As String = "usp_JIWA_ReadBackOrderDetailsList_Test" 'manualBoReleaseForm.ManualBOBatch.SystemSettings.ReadBackOrderDetailsListStoredProcedureName Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLCmd.CommandType = System.Data.CommandType.StoredProcedure SQLParam = New SqlParameter("@IN_LogicalID", System.Data.SqlDbType.Char) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Warehouse.IN_LogicalID SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_InvoiceNo", System.Data.SqlDbType.VarChar) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.SalesOrder.From.InvoiceNo SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_InvoiceNo", System.Data.SqlDbType.VarChar) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.SalesOrder.To.InvoiceNo SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_ExpectedDeliveryDate", System.Data.SqlDbType.DateTime) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.ExpectedDeliveryDate.From SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_ExpectedDeliveryDate", System.Data.SqlDbType.DateTime) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.ExpectedDeliveryDate.To.Date.AddDays(1).AddMilliseconds(-1) SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_DebtorAccountNo", System.Data.SqlDbType.VarChar) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.Debtor.From.AccountNo SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_DebtorAccountNo", System.Data.SqlDbType.VarChar) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.Debtor.To.AccountNo SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_PartNo", System.Data.SqlDbType.VarChar) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.Inventory.From.PartNo SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_PartNo", System.Data.SqlDbType.VarChar) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.Inventory.To.PartNo SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_BillType", System.Data.SqlDbType.SmallInt) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.BillType.From SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_BillType", System.Data.SqlDbType.SmallInt) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.BillType.To SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_WholesaleInvoice", System.Data.SqlDbType.SmallInt) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.InvoiceType.From SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_WholesaleInvoice", System.Data.SqlDbType.SmallInt) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.InvoiceType.To SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_OrderType", System.Data.SqlDbType.SmallInt) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.OrderType.From SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_OrderType", System.Data.SqlDbType.SmallInt) SQLParam.Value = manualBoReleaseForm.ManualBOBatch.Ranges.OrderType.To SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@OrderBy", System.Data.SqlDbType.SmallInt) SQLParam.Value = OrderBy SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_StockReceivedDate", System.Data.SqlDbType.Date) SQLParam.Value = manualBoReleaseForm.grdRanges.GridText("StockReceivedDate", 0) SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_StockReceivedDate", System.Data.SqlDbType.Date) SQLParam.Value = manualBoReleaseForm.grdRanges.GridText("StockReceivedDate", 1) SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@From_DeliveryZone", System.Data.SqlDbType.VarChar) SQLParam.Value = manualBoReleaseForm.grdRanges.GridText("DeliveryZone", 0) SQLCmd.Parameters.Add(SQLParam) SQLParam = New SqlParameter("@To_DeliveryZone", System.Data.SqlDbType.VarChar) SQLParam.Value = manualBoReleaseForm.grdRanges.GridText("DeliveryZone", 1) SQLCmd.Parameters.Add(SQLParam) SQLReader = .ExecuteReader(SQLCmd) manualBoReleaseForm.ManualBOBatch.BatchLines.RemoveAll() manualBoReleaseForm.ManualBOBatch.InventoryItems.RemoveAll() Dim OrdersOnBackID As String = "" Dim InventoryID As String = "" Dim InvoiceID As String = "" Dim newInventoryItem As JiwaManualBOBatch.InventoryItem = Nothing Dim newSalesOrder As JiwaManualBOBatch.SalesOrder = Nothing Dim newBatchLine As JiwaManualBOBatch.BatchLine = Nothing Do While SQLReader.Read = True OrdersOnBackID = .Sanitise(SQLReader, "OrdersOnBackID").ToString.Trim() If OrdersOnBackID.Trim.Length > 0 And BackOrderExists(manualBoReleaseForm.ManualBOBatch, OrdersOnBackID) = False Then InventoryID = .Sanitise(SQLReader, "InventoryID").ToString.Trim() If manualBoReleaseForm.ManualBOBatch.InventoryItems.Contains(InventoryID) = False Then newInventoryItem = manualBoReleaseForm.Manager.CollectionItemFactory.CreateCollectionItem(Of JiwaManualBOBatch.InventoryItem) newInventoryItem.Inventory.ReadRecord(InventoryID) 'newInventoryItem.QuantityAvailable = .Sanitise(SQLReader, "QuantityAvailable") ' Can't set the private property using above, so we using some reflection inside our SetPrivatePropertyValue static function to set it. SetPrivatePropertyValue(Of JiwaManualBOBatch.InventoryItem)(newInventoryItem, "QuantityAvailable", .Sanitise(SQLReader, "QuantityAvailable")) newInventoryItem.RecID = InventoryID manualBoReleaseForm.ManualBOBatch.InventoryItems.Add(newInventoryItem) End If InvoiceID = .Sanitise(SQLReader, "InvoiceID").ToString.Trim() If manualBoReleaseForm.ManualBOBatch.SalesOrders.Contains(InvoiceID) = False Then newSalesOrder = manualBoReleaseForm.Manager.CollectionItemFactory.CreateCollectionItem(Of JiwaManualBOBatch.SalesOrder) newSalesOrder.SalesOrder.ReadRecord(InvoiceID) 'newSalesOrder.InvoiceHistoryID = .Sanitise(SQLReader, "InvoiceHistoryID").ToString.Trim() ' Can't set the private property using above, so we using some reflection inside our SetPrivatePropertyValue static function to set it. SetPrivatePropertyValue(Of JiwaManualBOBatch.SalesOrder)(newSalesOrder, "InvoiceHistoryID", .Sanitise(SQLReader, "InvoiceHistoryID").ToString.Trim) SetPrivatePropertyValue(Of JiwaManualBOBatch.SalesOrder)(newSalesOrder, "InvoiceHistoryNo", .Sanitise(SQLReader, "HistoryNo")) newSalesOrder.RecID = InvoiceID manualBoReleaseForm.ManualBOBatch.SalesOrders.Add(newSalesOrder) End If newBatchLine = manualBoReleaseForm.Manager.CollectionItemFactory.CreateCollectionItem(Of JiwaManualBOBatch.BatchLine) 'newBatchLine.IN_OnBackOrder_OrdersOnBackID = OrdersOnBackID SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "OrdersOnBackID", OrdersOnBackID) 'newBatchLine.InventoryItemKey = InventoryID SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "InventoryItemKey", InventoryID) 'newBatchLine.BackOrderQuantity = .Sanitise(SQLReader, "BackOrderQuantity") SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "BackOrderQuantity", InventoryID) 'newBatchLine.BackOrderValue = .Sanitise(SQLReader, "BackOrderValue") SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "BackOrderValue", .Sanitise(SQLReader, "BackOrderValue")) 'newBatchLine.SalesOrderItemKey = InvoiceID SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "SalesOrderItemKey", InvoiceID) 'newBatchLine.BackOrderPriority = .Sanitise(SQLReader, "Priority") SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "BackOrderPriority", .Sanitise(SQLReader, "Priority")) 'newBatchLine.BackOrderPriorityWeight = .Sanitise(SQLReader, "PriorityWeight") SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "BackOrderPriorityWeight", .Sanitise(SQLReader, "PriorityWeight")) 'newBatchLine.InvoiceLineID = .Sanitise(SQLReader, "InvoiceLineID").ToString.Trim() SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "InvoiceLineID", .Sanitise(SQLReader, "InvoiceLineID")) 'newBatchLine.KitType = .Sanitise(SQLReader, "KitType") SetPrivatePropertyValue(Of JiwaManualBOBatch.BatchLine)(newBatchLine, "KitType", .Sanitise(SQLReader, "KitType")) manualBoReleaseForm.ManualBOBatch.BatchLines.Add(newBatchLine) manualBoReleaseForm.ManualBOBatch.InventoryItems.RecalculateAvailable(manualBoReleaseForm.ManualBOBatch.InventoryItems(newBatchLine.InventoryItemKey).Inventory.InventoryID) End If Loop SQLReader.Close() End Using End With Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End Sub Private Function BackOrderExists(ManualBOBatch As JiwaManualBOBatch.ManualBOBatch, ByVal BackOrderID As String) As Boolean For Each existingBatchLine As JiwaManualBOBatch.BatchLine In ManualBOBatch.BatchLines If existingBatchLine.IN_OnBackOrder_OrdersOnBackID = BackOrderID Then Return True End If Next Return False End Function Public Shared Sub SetPrivatePropertyValue(Of T)(ByVal objectInstance As T, ByVal propertyName As String, ByVal newValue As Object) For Each fieldInfo As FieldInfo In objectInstance.[GetType]().GetFields(BindingFlags.Instance Or BindingFlags.NonPublic) If fieldInfo.Name.ToLower().Contains(propertyName.ToLower()) Then fieldInfo.SetValue(objectInstance, newValue) Exit For End If Next End Sub End Class Report VisualBasic 93fcca4e-f06a-481d-bdb4-9e54b3e5012e Manual Back Order Release JiwaFinancials.Jiwa.JiwaManualBOBatchUI.MainForm 620607ba-372e-4146-8d0f-1ba8d000552d JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaApplication.dll edc76f37-e549-457a-a695-acbff5feb527 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 8515cd7a-a06e-4c67-9613-3b97c97c98f7 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 045a1d7a-de82-431d-b86d-3877e471d2d2 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 1578da6a-d18c-4c22-bc54-cb5d7460f6b8 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 94158fbf-05dc-43ac-aa9a-2bd279fc6bfd JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaODBC.dll 3a7cba5b-af4b-470d-9ded-3273323cdb1f 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 6fd8b4e7-386d-4fd5-8587-a5de223715fc 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 286f2d50-8b7b-43a2-b334-9a76d6321d3f 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 af2b2d35-6f69-460b-9523-af010ec8f708 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 3025c492-826d-456c-9dd9-b80188e1fc16 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaServiceModel.dll 79e04d54-67ec-4964-9402-e0545d64ffae 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.2.1\Infragistics4.Win.Misc.v13.1.dll 6ee80596-8a3d-4916-8564-96043f056b52 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.2.1\Infragistics4.Win.UltraWinEditors.v13.1.dll 2bdc7ef4-ad43-44bf-9ccc-192c5fdb8bf4 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.2.1\Infragistics4.Win.v13.1.dll d4dbb9be-946d-420a-b1fb-35dd03115c8a Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\Microsoft.SqlServer.Smo.dll aa807d02-fbe8-4838-b6f1-944531c71a37 Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\Microsoft.SqlServer.ConnectionInfo.dll f2487c9f-e454-448c-a16e-80de18a32e6f 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.2.1\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 22931dd0-334f-4140-b635-3c0e41518238 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.2.1\Infragistics4.Win.UltraWinTree.v13.1.dll 329a18dd-460a-426c-b2ae-b18848dca314 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\FarPoint.Win.Spread.dll e278bc76-3988-42d6-8a5b-36a9f9a40ab4 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.2.1\Infragistics4.Win.UltraWinTabControl.v13.1.dll 941a2f17-5b1b-4cb2-8ba7-266a736e20ca 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.2.1\Infragistics4.Shared.v13.1.dll 62295f51-a456-481d-b43d-4af66ee59257 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.2.1\Infragistics4.Win.UltraWinToolbars.v13.1.dll 28ea6d09-8c89-4cdc-adbc-47ee5cf6c267 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.2.1\Infragistics4.Win.UltraWinStatusBar.v13.1.dll 0e20327a-0f9a-41f5-977a-d4f829f44f3c 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.2.1\Infragistics4.Win.UltraWinSchedule.v13.1.dll 11336253-4a99-4193-9ece-a9f668b91620 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.2.1\Infragistics4.Win.UltraWinListView.v13.1.dll fe7c6fdb-189c-4e0a-848a-04d61ea59e1c ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.dll fbb08551-874f-43a8-a51d-5b80088be5bc EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\EntityFramework.dll 02444ef1-bc16-426d-9547-0534b8fc7cb1 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 a4bd500a-ec6a-41cd-802f-8318dc8e991f ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ActiproSoftware.SyntaxEditor.WinForms.dll e2e38b57-035c-4439-ae80-eea9eaab3888 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ZetaHtmlEditControl.dll 56c1af17-c8e1-4879-a432-bc7fffd30d07 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.2.1\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll c2116c0b-5da4-4501-b45c-55861ef1d0c4 JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaEncryption.dll f0aaa01c-74ab-4bbd-8bb2-0670d6f9b05b 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 5b4f5124-d871-4ff6-a748-8c7294b9406d 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.2.1\Infragistics4.Win.UltraWinGrid.v13.1.dll 41842562-ec96-48d7-acce-788804a90701 Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\Microsoft.SqlServer.Dac.dll 8b92af8f-90d4-41a3-93df-d49c387c1bc7 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 7aa77e7e-bdab-4014-bc67-c913ec42c9e7 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 70548e81-4ba0-4b6a-ba17-e2024392b1fc 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 2b225544-b06c-461d-9eae-8f3142317e0f 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 481b1f4c-35e6-4a76-be86-2b4c189335a1 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.2.1\Infragistics4.Win.AppStylistSupport.v13.1.dll 888017fb-5a41-42db-a539-2d4da766e73b JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaLib.dll 7980a020-45de-4da1-9e45-6ea4ac6a4de1 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\Microsoft.ApplicationInsights.dll f07b7389-af80-4f0b-95a6-8f9406355ae6 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 5b4863e7-d7fa-4639-ba09-2cd5f600587a EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\EntityFramework.SqlServer.dll 6e5f8e15-b45c-4dbb-b706-7618ba9bfde3 ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.Text.dll 94014acf-a98a-4eb9-a1c6-493bf660e218 ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ActiproSoftware.Shared.WinForms.dll 37521fa0-ac99-46cf-b436-4021cedea990 FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\FarPoint.Win.dll 5ee564cc-cd69-4533-b2d4-3b25fde143a3 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 e54377ce-c302-4df4-acea-cb85e7757c10 ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.Interfaces.dll 64f9e447-ac49-4c55-9083-ad645ec0f9d1 ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.Server.dll 168d42aa-84b7-42bd-9e60-e99b28cfb056 ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.OrmLite.dll 78d88147-303c-41fb-9ba8-724c2235ab40 JiwaManualBOBatchUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaManualBOBatchUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaManualBOBatchUI.dll 4598507c-4297-409e-9c57-c824e0437857 JiwaManualBOBatch, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaManualBOBatch.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaManualBOBatch.dll 897c1af2-ee24-47a0-9773-419d994eee31 JiwaSales, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSales.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaSales.dll c3ff2eaf-8c78-45d0-80dd-e5c190a5d467 JiwaBOAllocUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaBOAllocUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaBOAllocUI.dll 9fe70124-24a0-4614-a402-02d538bcbbe2 BB6E534C-73E3-4706-851D-80FA3661375C 1 Default Plugin Document Type true usp_JIWA_ReadBackOrderDetailsList_Test.sql SQL Script to create sample custom stored procedure 2020-09-28T22:11:38.95 ZZZZZZZZZZ0000000000 ZZZZZZZZZZ0000000000 Admin