00fe0114-98ae-4c3c-9439-0820d27035b7 AERP - 836 - Sales Order Processing UI Adds an "Order No" filter to the Batch Sales Order Processing Screen. If the stored procedure for the selected "Batch Process Filter" contains the string \AERP\, then a custom population function is called which adds an extra parameter \@OrderNo\ to the stored procedure call. Otherwise, JIWA standard behaviour is followed. true false 836 Advanced ERP 20.02.21.1625 Option Explicit On Option Infer On Option Strict On Option Compare Text Imports System Imports System.Data.SqlClient Imports System.Drawing Imports System.Windows.Forms Imports Infragistics.Win.UltraWinEditors Imports JiwaFinancials.Jiwa Imports JiwaFinancials.Jiwa.JiwaApplication Imports JiwaFinancials.Jiwa.JiwaApplication.Exceptions Imports JiwaFinancials.Jiwa.JiwaODBC Imports JiwaFinancials.Jiwa.JiwaSales.BatchProcessing Imports JiwaFinancials.Jiwa.JiwaSalesUI.BatchProcessing Namespace AERP.SalesOrderFormCustomisations Public Class FormPlugin Inherits MarshalByRefObject Implements 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 IJiwaForm, ByVal Plugin As Plugin.Plugin) Implements IJiwaFormPlugin.SetupBeforeHandlers ' Add handler for button click which we want to intercept Dim batchProcessForm = TryCast(JiwaForm, JiwaSalesUI.BatchProcessing.BatchProcess) AddHandler batchProcessForm.GetCandidatesUltraButton.Click, AddressOf GetCandidatesUltraButton_Click End Sub Public Sub Setup(ByVal JiwaForm As IJiwaForm, ByVal Plugin As Plugin.Plugin) Implements IJiwaFormPlugin.Setup ' Add our new editors to the filter panel Dim batchProcessForm = TryCast(JiwaForm, JiwaSalesUI.BatchProcessing.BatchProcess) If batchProcessForm Is Nothing Then Return ' panic End If Dim orderNoLabel = New UltraCheckEditor() With {.Text = "Filter by Order No", .Checked = False, .Name = "orderNoLabel", .Location = New Point(batchProcessForm.FilterByDebtorNameUltraCheckEditor.Left, batchProcessForm.SpecificWarehouseLookup.Top)} Dim orderNoEditor = New UltraTextEditor() With {.[ReadOnly] = True, .Text = "MSP", .Name = "orderNoEditor", .Location = New Point(batchProcessForm.SalesOrderPrintingUltraComboEditor.Left, batchProcessForm.SpecificWarehouseLookup.Top)} batchProcessForm.UltraExpandableGroupBoxPanel4.Controls.AddRange({orderNoLabel, orderNoEditor}) ' batchProcessForm.InvoiceTypeUltraLabel.Enabled = False ' batchProcessForm.BillingTypeUltraLabel.Enabled = False ' batchProcessForm.OrderTypeUltraLabel.Enabled = False ' ' batchProcessForm.InvoiceTypeUltraComboEditor.Enabled = False ' batchProcessForm.BillingTypeUltraComboEditor.Enabled = False ' batchProcessForm.OrderTypeUltraComboEditor.Enabled = False AddHandler orderNoLabel.CheckedChanged, Sub() orderNoEditor.ReadOnly = Not orderNoLabel.Checked End Sub Private Sub GetCandidatesUltraButton_Click(sender As Object, e As EventArgs) Dim batchProcessForm = TryCast(TryCast(sender, Control).FindForm(), JiwaSalesUI.BatchProcessing.BatchProcess) If batchProcessForm Is Nothing Then Return ' panic End If Dim procName As String = batchProcessForm.BatchProcess.Ranges.SelectedBatchProcessFilter.GetListOfSalesOrdersStoredProcedure If Not procName.Contains("AERP") Then Return ' let JIWA carry on as normal End If Dim oldCursor As Cursor = batchProcessForm.Cursor Try batchProcessForm.Cursor = Cursors.WaitCursor AddRange(batchProcessForm) batchProcessForm.CheckEditStatus() Finally batchProcessForm.Cursor = oldCursor End Try batchProcessForm.DisplayCandidates() Throw New ClientCancelledException() End Sub Public Sub AddRange(batchProcessForm As JiwaSalesUI.BatchProcessing.BatchProcess) Dim orderNoEditor = TryCast(batchProcessForm.Controls.Find("orderNoEditor", True)(0), UltraTextEditor) Dim orderNoFilter As String = If(orderNoEditor Is Nothing OrElse String.IsNullOrWhiteSpace(orderNoEditor.Text), Nothing, orderNoEditor.Text) Dim batchProcess = batchProcessForm.BatchProcess Dim mgr As Manager = batchProcessForm.Manager Dim db As database = mgr.Database Dim procName As String = batchProcess.Ranges.SelectedBatchProcessFilter.GetListOfSalesOrdersStoredProcedure Using sqlCommand = New SqlCommand(procName, db.SQLConnection, db.SQLTransaction) sqlCommand.CommandType = System.Data.CommandType.StoredProcedure sqlCommand.Parameters.AddWithValue("@FromInvoiceNo", batchProcess.Ranges.InvoiceNo.From.InvoiceNo) sqlCommand.Parameters.AddWithValue("@ToInvoiceNo", batchProcess.Ranges.InvoiceNo.[To].InvoiceNo) If batchProcess.Options.FilterDebtorsByName Then sqlCommand.Parameters.AddWithValue("@FromDebtor", batchProcess.Ranges.DebtorName.From.Name) sqlCommand.Parameters.AddWithValue("@ToDebtor", batchProcess.Ranges.DebtorName.[To].Name) sqlCommand.Parameters.AddWithValue("@DebtorRangeIsAccountNo", False) Else sqlCommand.Parameters.AddWithValue("@FromDebtor", batchProcess.Ranges.DebtorAccountNo.From.AccountNo) sqlCommand.Parameters.AddWithValue("@ToDebtor", batchProcess.Ranges.DebtorAccountNo.[To].AccountNo) sqlCommand.Parameters.AddWithValue("@DebtorRangeIsAccountNo", True) End If sqlCommand.Parameters.AddWithValue("@FromRecordDate", batchProcess.Ranges.[Date].From) sqlCommand.Parameters.AddWithValue("@ToRecordDate", batchProcess.Ranges.Date.To) sqlCommand.Parameters.AddWithValue("@FromStaffSurname", batchProcess.Ranges.Staff.From.Surname) sqlCommand.Parameters.AddWithValue("@ToStaffSurname", batchProcess.Ranges.Staff.[To].Surname) sqlCommand.Parameters.AddWithValue("@FromBranchDescription", batchProcess.Ranges.Branch.From.Description) sqlCommand.Parameters.AddWithValue("@ToBranchDescription", batchProcess.Ranges.Branch.[To].Description) If (batchProcessForm.BatchProcess.Options.UseSpecificWarehouse) Then sqlCommand.Parameters.AddWithValue("@SpecificWarehouseID", batchProcess.Options.Warehouse.IN_LogicalID) Else sqlCommand.Parameters.AddWithValue("@SpecificWarehouseID", DBNull.Value) End If sqlCommand.Parameters.AddWithValue("@SpecificWarehouseIDIsPhysical", False) sqlCommand.Parameters.AddWithValue("@SpecificB2BType", CShort(batchProcess.Options.OrderTypeSelection)) sqlCommand.Parameters.AddWithValue("@SpecificBOMode", CShort(batchProcess.Options.BackOrderModeSelection)) sqlCommand.Parameters.AddWithValue("@SpecificBillingType", CShort(batchProcess.Options.BillingTypeSelection)) sqlCommand.Parameters.AddWithValue("@SpecificWholesaleInvoiceType", CShort(batchProcess.Options.InvoiceTypeSelection)) If orderNoFilter IsNot Nothing Then sqlCommand.Parameters.AddWithValue("@OrderNumberFilter", orderNoFilter) Else sqlCommand.Parameters.AddWithValue("@OrderNumberFilter", DBNull.Value) End If Using sqlDataReader As SqlDataReader = db.ExecuteReader(sqlCommand) Dim haveOrderno As Boolean = procName.Contains("AERP") While sqlDataReader.Read() Dim candidate As ProcessCandidate = mgr.CollectionItemFactory.CreateCollectionItem(Of ProcessCandidate)() candidate.InvoiceID = CStr(db.Sanitise(sqlDataReader, "InvoiceID")) candidate.InvoiceNo = CStr(db.Sanitise(sqlDataReader, "InvoiceNo")) candidate.CurrentHistoryNo = CInt(db.Sanitise(sqlDataReader, "CurrentHistoryNo")) candidate.InvoiceInitDate = CDate(db.Sanitise(sqlDataReader, "InvoiceInitDate")) candidate.DebtorID = CStr(db.Sanitise(sqlDataReader, "DebtorID")) candidate.AccountNo = CStr(db.Sanitise(sqlDataReader, "AccountNo")) candidate.Name = CStr(db.Sanitise(sqlDataReader, "Name")) If haveOrderno Then candidate.Remark = CStr(db.Sanitise(sqlDataReader, "OrderNo")) End If candidate.Process = True If (batchProcessForm.BatchProcess.ProcessCandidates.Contains(candidate.RecID)) Then Continue While End If batchProcessForm.BatchProcess.ProcessCandidates.Add(candidate) End While sqlDataReader.Close() End Using End Using End Sub End Class End Namespace Report VisualBasic 428efe2e-f05d-4890-b2ed-e69814336177 Process Sales Orders JiwaFinancials.Jiwa.JiwaSalesUI.BatchProcessing.BatchProcess 44493aa5-179d-40a0-bc71-f9607c82d05e JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Jiwa\Jiwa 7\JiwaApplication.dll 766d2024-8541-455a-a17c-37fd199b857c mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 882bb575-c3f4-49b8-a48e-85e0f9410a99 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 72e4208b-cdbe-4396-a0f3-24da4424ec6a 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 65ee9a79-e64a-46a1-9c1e-da8897468b9e 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 54281ec7-81af-4663-a285-7a1ec604522c JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Jiwa\Jiwa 7\JiwaODBC.dll fd76d383-777f-44e4-92a0-e0af2c6e8bd1 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 c3e72381-1f55-4896-985b-641e60225128 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 adc6ad26-63fd-4889-b854-93a99c15e7d8 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 33dbd8e3-221c-404a-8756-50c593c29aa4 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 53a9a9aa-3068-4ea3-b76e-8e5f306cbf05 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Jiwa\Jiwa 7\JiwaServiceModel.dll 31a58fe1-168c-4685-9dfd-a076b99f044d Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.Misc.v13.1.dll d1183140-ddef-471c-8d57-09ca93b4d040 Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinEditors.v13.1.dll 97c9e606-7de7-4eb7-b91b-910184bd432c Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.v13.1.dll 407e4c0e-beb9-475a-8ed9-b1b044051217 Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Jiwa\Jiwa 7\Microsoft.SqlServer.Smo.dll 133b8091-f376-493b-b8aa-ee3be32e4e5d Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Jiwa\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll 88a35b70-aba1-44d3-bc57-bb3dc3216312 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll a852a894-1bbd-4bda-83e1-028abf07605c Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinTree.v13.1.dll a70bb89c-aa7b-4f7e-b059-1b03478c57a7 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Jiwa\Jiwa 7\FarPoint.Win.Spread.dll a279f7ef-116a-4241-9a11-2d0b7cf9c89e Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinTabControl.v13.1.dll 42048655-db5f-4b6c-93fb-f961c6602db8 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Shared.v13.1.dll 751cfc1f-93d5-414b-84ca-b30700781d3c Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinToolbars.v13.1.dll 53edae4c-5d04-4c74-b660-1881dacd7f02 Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinStatusBar.v13.1.dll 081d816c-2bda-44c7-be51-d54afadddb19 Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinSchedule.v13.1.dll ebc2f8fc-0ebc-4198-ad25-380027c71622 Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinListView.v13.1.dll 0b7070d2-f9ea-440a-8aeb-ff54a1ca0773 ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Jiwa\Jiwa 7\ServiceStack.dll 549bd4c1-1730-4847-855f-05d1bd7282de EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll C:\Jiwa\Jiwa 7\EntityFramework.dll 9e97cf01-ea71-45d4-9076-0b8659e6e839 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 a1b7a409-15f3-41db-a36c-dd688813588d ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Jiwa\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll 7ebbc16e-58f4-48c0-935e-4c2ae6da5b0c ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Jiwa\Jiwa 7\ZetaHtmlEditControl.dll c3825f63-56cf-4641-b832-98c166b56766 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\Jiwa\Jiwa 7\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll 33d86dd0-7fa6-4999-b1ef-c324249763ca JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Jiwa\Jiwa 7\JiwaEncryption.dll 744a925a-8d41-46ae-bd33-b0b879e53b70 Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinGrid.v13.1.dll 4e0f57ce-8b74-4bfd-a292-f8161ed8c379 Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Jiwa\Jiwa 7\Microsoft.SqlServer.Dac.dll 5a97f1bc-d105-46ef-83bd-cf30ea72ad7b 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 a6519a80-3238-4216-ba7c-48561e7c2111 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 b93b2d3d-eabe-43ec-92f7-ee172ee65d24 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 f9ef52e0-79c0-49b7-8279-d4e8cd61493b Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\Jiwa\Jiwa 7\Infragistics4.Win.AppStylistSupport.v13.1.dll 01128913-8ccf-4758-ad0e-67455d8287ce JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Jiwa\Jiwa 7\JiwaLib.dll 7fd1ac15-44aa-4d92-94e9-6e60f76798ed Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Jiwa\Jiwa 7\Microsoft.ApplicationInsights.dll 4a7a86c6-7750-4817-a6b9-c580ba7abe22 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 8ac7df85-2c76-4a30-ba9d-53c5a175d969 EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll C:\Jiwa\Jiwa 7\EntityFramework.SqlServer.dll 9af5514d-8ba6-4ecf-bce8-84b23000eb9a ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\Jiwa\Jiwa 7\ServiceStack.Text.dll cae75bd6-3326-4b9d-97b5-a6449aaa2bea ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Jiwa\Jiwa 7\ActiproSoftware.Shared.WinForms.dll 8b6db487-7825-4b51-be1c-e88097b5127e 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 1a5e77e4-8af9-4e1e-bc9b-25193ac946f0 FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Jiwa\Jiwa 7\FarPoint.Win.dll be446e7a-fa5f-4e64-96bc-139048e17916 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 ebdab702-ce2b-4159-b15d-efb4009664d4 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 948cebc0-7203-4707-9355-76b2c3c8730e ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\Jiwa\Jiwa 7\ServiceStack.Interfaces.dll a12e3f37-141d-4917-8609-995dbe6f9160 ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll C:\Jiwa\Jiwa 7\ServiceStack.Server.dll 05095de4-ee6d-4f67-9619-c5756ba9ce37 ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll C:\Jiwa\Jiwa 7\ServiceStack.OrmLite.dll 876a7cad-05ef-44fd-ab79-bc170f519813 JiwaSalesUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSalesUI.dll C:\Jiwa\Jiwa 7\JiwaSalesUI.dll 134e6ffb-f343-4eea-9d95-788398ae036c JiwaSales, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSales.dll C:\Jiwa\Jiwa 7\JiwaSales.dll c53f2794-cdcb-4dd5-81ef-2dc32387e4d1 JiwaPriceSchemes, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaPriceSchemes.dll C:\Jiwa\Jiwa 7\JiwaPriceSchemes.dll 7ee6bd4e-e498-4d9b-9655-8f8b7ee09525 JiwaJobCosting, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaJobCosting.dll C:\Jiwa\Jiwa 7\JiwaJobCosting.dll 2a94625c-3766-4e93-86fe-2146470217e1 JiwaSerialNumbersUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSerialNumbersUI.dll C:\Jiwa\Jiwa 7\JiwaSerialNumbersUI.dll 8551c071-d386-438c-924d-ae3ca6eb18f2 054EC564-5AF3-4734-B410-83166B1A2380 2 Default Plugin Document Type true AERP_GetSalesOrdersToProcess.sql SQL Script to create stored procedure to get orders to process 2020-02-21T16:17:03.957 ZZZZZZZZZZ0000000000 ZZZZZZZZZZ0000000000 Admin