8dbb1037-516b-4b2a-a246-4020a59f2289 Sales Order Set ScanOrders Sets the ScanOrders custom history field for all orders dated on or after Feb 27, 2022 and which has the ScanOrders custom field value currently not set to 'True'&#13;&#10;&#13;&#10;Runs as a scheduled script. true false 0 7.2.1.0 using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using System.Data.SqlClient; #region "ScheduledExecutionPlugin" public class ScheduledExecutionPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin { public void Execute(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin, JiwaFinancials.Jiwa.JiwaApplication.Schedule.Schedule Schedule) { lock (JiwaFinancials.Jiwa.JiwaApplication.Manager.CriticalSectionFlag) { // place processing code in here //Find candidate sales orders Plugin.Manager.LogEvent(String.Format("Executing schedule '{0}'", Schedule.Name), System.Diagnostics.EventLogEntryType.Information, 0, 0, true); SqlDataReader SQLReader = null; SqlParameter SQLParam; List<string> InvoiceIds = new List<string>(); try { string SQL = @"SELECT SO_Main.InvoiceID, SO_Main.InvoiceInitDate, SO_HistoryCustomSettingValues.Contents, SO_HistoryCustomSettingValues.SettingValueID, SO_HistoryCustomSettingValues.SettingID FROM SO_Main INNER JOIN SO_History ON SO_Main.InvoiceID = SO_History.InvoiceID AND SO_Main.CurrentHistoryNo = SO_History.HistoryNo LEFT OUTER JOIN SO_HistoryCustomSettingValues ON SO_History.InvoiceHistoryID = SO_HistoryCustomSettingValues.HistoryID LEFT JOIN SO_HistoryCustomSetting ON SO_HistoryCustomSetting.SettingID = SO_HistoryCustomSettingValues.SettingID AND SO_HistoryCustomSetting.SettingName = 'ScanOrders' WHERE SO_Main.DebtorID = @DebtorID AND (SO_HistoryCustomSettingValues.Contents <> 'True' OR SO_HistoryCustomSettingValues.Contents IS NULL) AND SO_Main.InvoiceInitDate > @InvoiceDateCutoff"; using (SqlCommand SQLCmd = new SqlCommand(SQL, Plugin.Manager.Database.SQLConnection, Plugin.Manager.Database.SQLTransaction)) { SQLParam = new SqlParameter("@DebtorID", System.Data.SqlDbType.Char); SQLParam.Value = "0000000061000000001V"; // <-- This is Brown's Computer Centre in demo data. "0FC4070CEBCC491CA15A" was the provided value by Danny on forums; SQLCmd.Parameters.Add(SQLParam); SQLParam = new SqlParameter("@InvoiceDateCutoff", System.Data.SqlDbType.DateTime); SQLParam.Value = new DateTime(2022, 02, 27); SQLCmd.Parameters.Add(SQLParam); SQLReader = SQLCmd.ExecuteReader(); while (SQLReader.Read()) { InvoiceIds.Add(Plugin.Manager.Database.Sanitise(SQLReader, "InvoiceID").ToString()); } } } catch(System.Exception e) { Plugin.Manager.LogEvent(String.Format("Error '{0}'", e.Message), System.Diagnostics.EventLogEntryType.Information, 0, 0, true); } finally { if (SQLReader != null) { SQLReader.Close(); } } if (InvoiceIds.Count > 0) { JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder salesOrder = Plugin.Manager.BusinessLogicFactory.CreateBusinessLogic<JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder>(null); foreach (string invoiceID in InvoiceIds) { Plugin.Manager.LogEvent(String.Format("Exporting invoice '{0}'", invoiceID), System.Diagnostics.EventLogEntryType.Information, 0, 0, true); salesOrder.Read(invoiceID); JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrderHistory salesHist = salesOrder.SalesOrderHistorys[salesOrder.CurrentHistoryNo]; salesHist.CustomSettingValues.SetValue<bool>("ScanOrders", true); salesOrder.Save(); Plugin.Manager.LogEvent(String.Format("Invoice Saved: '{0}'", salesOrder.InvoiceNo), System.Diagnostics.EventLogEntryType.Information, 0, 0, true); } } } } public void OnServiceStart(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void OnServiceStopping(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion Report CSharp 8194b0b6-89e0-493e-90cf-3aec519b8d41 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaApplication.dll 5f0f827e-b1c3-4466-bdca-165327d4026a mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll dbd69534-6f7d-40f2-aa1c-7afb7f6832d2 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 0f04d6ff-be50-470e-b7cc-c31516e44bf0 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 052a0ec6-b5cd-435b-8428-a1437ff95f77 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaODBC.dll 5a2e0988-740f-41b6-901d-88139015375f 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 b851f173-37f7-4af3-8c4e-e3ec75437268 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 71bb8107-455c-4f16-ad12-099aff9a1efe 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 dec13d42-cb30-4d5d-ac0d-41184ed0c948 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 7b6fe7c7-98ec-43ce-8cb4-a5275fdf35a5 ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.dll 3d89b301-2fa6-4ae9-a12f-b76965c8c139 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 bf5bd453-52db-48b8-ac02-feb491c7fc2a 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 9f950e8d-021c-4198-8e68-75264accc77e JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaLib.dll 1fc02fc3-92b2-43bc-b5df-1103abc7656a JiwaSales, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSales.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaSales.dll 72da8763-a86e-43af-b790-698e3c5daab6 ScanOrders 1 Checkbox Sales Order History 569b737a-ecc3-46bd-bdcf-87c8d0437946 Every Minute true Recurring Daily 1 2022-02-28T15:52:39.5105957+08:00 RepeatsMinutely 1 0 831000000000 1 64 nthDay 1 1 First Monday 2022-02-27T00:00:00 false 2022-02-28T15:31:01.247