Visual Connect RESTful Web API (DERP) - Release Notes

Visual Connect RESTful Web API (DERP) - Release Notes

1100.1008 - (7/8/2026)
  1. ActivityService
    1. Add new endpoint SaveActivity for Create/Update V_TASK activities
    2. Add new endpoint SearchActivity for retrieving activity records using ActivityData filters
    3. Add new endpoint SearchActivityLike for wildcard/partial activity searches
  1. Update CreateActivity
    1. Support existing activity updates using ActivityID
    2. Add validation logic to verify Activity ID existence before update operation
    3. Update activity save logic to use task.Save(true) for automatic SBO Insert/Modified state handling
    4. Fix duplicate primary key issue during existing activity updates
    5. Improve task.Load() handling by explicitly reassigning Activity ID after load operation
    6. Activity Service models and mappings to support additional activity fields 
    7. Added User Defined Field endpoints (USER_1–USER_10, USER_T1–USER_T5, USER_D1–USER_D3, USER_N1–USER_N5, ACCT_ID, and UDF_LAYOUT_ID)
    8. Updated CreateActivity API to create and update the newly added custom activity fields
    9. Updated SearchActivity API response mapping to return the additional activity fields and verified persistence in SQL Server
1100.1007 - (4/9/2026)
  1. Added support for Oracle 9.0.8
  2. Fixed Backflush to ensure Backflush location is valid for current site_id
1100.1006 - (3/24/2026)
  1. Add the following features
    1. SalesOrderService
      1. When creating a customer order line, the code should now create a work order against the line given the part id
      2. When creating a customer order line, the end user can now enter the height/width/length fields
    2. AccountsPayableService
      1. CreateAPVoucher was not properly using the destination country to create Exchange Rate entries into the PAYABLE_CURR table
    3. ManufacturingService
      1. Add new Endpoint CreateWOFromMaster
      2. Add new Endpoint SaveWorkOrder (copy from WorkOrderService.asmx)
    4. WorkOrderService is obsolete customers should use ManufacturingService instead.
    5. Uses  SynergyBusinessObjects v1100.1100
    6. Updated the CreateContact method to prevent the creation of duplicate primary contacts.
1100.1005 - (Not released to public)
  1. Add the following features:
    1. Inventory
      1. AddPartTrace
      2. GetPartTrace
      3. CreateTraceIds returns List<TraceRecord> 
      4. ProcessInventoryTransaction will now assign TraceIds to a part after an adjusting qty into an inventory location
        1. InventoryTransactionData.AdjustIn now contains List<TraceRecord> TraceRecords, which can be filled in with a pre-call to CreateTraceIds
  2. Remove interop dependency on x86 library for reading the Visual ERP sql.ini file.
  3. Now uses the SynergyBusinessObjectNet (.Net Standard 2.0 library)
1100.1004 (7/2/2025)
  1. AccountPayableService
    1. Identified an issue where sell rate and buy rate were both defaulting to 1 in the AccountPayableService.CreateAPVoucher endpoint
      This caused currency exchange calculations to be skipped, as no actual rate conversion occurred.
In SBO, exchange rates were applied correctly and calculations worked as expected.
Manual testing in Visual Infor also confirmed proper exchange behavior.
Issue resolved by ensuring valid exchange rates are passed during DERP processing.

1100.1003 (4/16/2025)
  1. AccountsPayableService: Added checks in header terms from vendors to only use the vender defaults if the header data was not supplied in the payloadSalesOrderService.  ShipToAddrNo was added to the return object to support change request from client in project (PoliFilm PhaseII). 
  2. SalesOrderService. 
    The CustomerOrderHeader loading of data was changed from using inline SQL code to using the SBO elements for business logic PurchaseOrderService. LoadPurchaseOrderByQuery dates where incorrect begin and end dates were identical. Looks like a copy/paste error from the original code that was never caught.  Pointed out by Cameron at Unilink
1100.1002 (3/17/2025)
Added to accountspayableservice.createAPVoucher
RejectDuplicates property to AccountsPayableHeader
to reject APVoucher creation if already created with same vendor id to AccountsPayableService
added to InventoryService following endpoints
      DiscountPriceByPartCustDiscCode
      MarketPriceByPart
      CustomerPriceByPart
      PartPriceBreakByCustomer

1100.1001 (3/12/2026)
OrderPayment.Designer.cs modify OracleData information to use:  (Oracle visual 7 table)
Oracle.ManagedDataAccess.Client instead of System.Data.OracleClient
Oracle.ManagedDataAccess.Client.OracleDbType instead of Oracle.ManagedDataAccess.Client.OracleDbType.
Oracle.ManagedDataAccess.Client.OracleDbType.VarChar1 instead of Oracle.ManagedDataAccess.Client.OracleDbType.Varchar2
Oracle.ManagedDataAccess.Client.OracleDbType.Decimal instead of Oracle.ManagedDataAccess.Client.OracleDbType.Decimal
Oracle.ManagedDataAccess.Client.OracleDbType.Date instead of Oracle.ManagedDataAccess.Client.OracleDbType.Date
Update nuget
Microsoft.Owin 4.2.0 to 4.2.2
NSwag.AspNet.Owin 13.13.2 to 14.2.0
Microsoft.AspNet.WebApi.Client 5.2.7 to 6.0.0
Microsoft.AspNet.WebApi.Core 5.2.7 to 5.3.0
Microsoft.Bcl.AsynInterfaced 8.0.0 to 9.0.2
Microsoft.Owin.Host.SystemWeb 4.2.0 to 4.2.2.
Microsoft.Web.Infrastructure 1.0.0 to 2.0.0
Namotion.Reflection 3.2.0 to 3.3.0
Newtonsoft.Json.Bson 1.0.2 to 1.0.3
System.Buffers 4.5.1 to 4.6.0
System.Memory 4.5.5 to 4.6.0
System.Text.Encodings.Web 8.0.0 to 9.0.2
System.Text.Json 8.0.5 to 9.0.2
System.Threading.Tasks.Extensions 4.5.4 to 4.6.0

1100.1000 (2/17/2025)
 (Pulls from 1000.2075) Updated for Visual ERP 11

1000.2076 (2/18/2025)
Update From 4.6.1 to Framework 4.8
In an effort to prevent locking of sql server when multiple WORK_ORDERS are being processed the following mods have been added.
The following mods will prevent this from being used with Oracle DBase
  1. AccountsPayableService Add WITH (NoLock) to all SELECT
  2. AccountsReceivable Add WITH (NoLock) to all SELECT
  3. InventoryService Add WITH (NoLock) to all SELECT
  4. OrderStatusService Add WITH (NoLock) to all SELECT
January 2023 Updates
  • Revision 20239 (12th January 2023): Enhanced encryption for user data, improving security and privacy.
  • Revision 20258 (25th January 2023): Updated the API documentation to include new endpoints and parameters for expanded functionality.
February 2023 Updates
  • Revision 20314 (9th February 2023): Optimized database queries to improve application performance and reduce load times.
  • Revision 20345 (28th February 2023): Introduced a new feature for batch processing of transactions, significantly increasing efficiency for bulk operations.
March 2023 Updates
  • Revision 20402 (15th March 2023): Fixed a critical bug affecting the payment processing module, ensuring smoother transactions.
  • Revision 20418 (30th March 2023): Launched a redesigned user interface for the settings page, enhancing usability and accessibility.
April 2023 Updates
  • Revision 20457 (14th April 2023): Added support for additional currencies in the financial reporting tools.
  • Revision 20476 (27th April 2023): Implemented an automated backup system, providing users with regular, secure backups of their data.
May 2023 Updates
  • Revision 20514 (11th May 2023): Updated integration capabilities with third-party analytics tools, offering more comprehensive data insights.
  • Revision 20537 (26th May 2023): Enhanced email notification system with customizable templates and scheduling options.
June 2023 Updates
  • Revision 20601 (20th June 2023): Rolled out a new feature allowing for custom workflow creation, giving users the ability to tailor processes to their specific needs.
July 2023 Updates
  • Revision 20658 (10th July 2023): Improved mobile app performance and added new functionalities for on-the-go access.
  • Revision 20679 (24th July 2023): Updated data export features, supporting a wider range of file formats and export options.
August 2023 Updates
  • Revision 20722 (15th August 2023): Fixed issues with user session management, enhancing security and stability.
  • Revision 20748 (31st August 2023): Launched an advanced analytics dashboard, providing deeper insights into operational metrics.
September 2023 Updates
  • Revision 20789 (14th September 2023): Enhanced the customization options for reports, allowing users to more easily generate reports tailored to their needs.
  • Revision 20804 (29th September 2023): Improved system logging capabilities, offering more detailed and actionable insights for troubleshooting.
October 2023 Updates
  • Revision 20856 (13th October 2023): Introduced a new integration with a leading CRM platform, streamlining customer data management.
  • Revision 20877 (27th October 2023): Enhanced security measures with the addition of two-factor authentication for user logins.
November 2023 Updates
  • Revision 20914 (10th November 2023): Optimized the user interface for tablet devices, improving usability and accessibility.
  • Revision 20937 (24th November 2023): Updated the project management module with new features for task tracking and collaboration.
December 2023 Updates
  • Revision 20978 (8th December 2023): Rolled out improvements to the API, including new endpoints and enhanced security features.
  • Revision 21005 (22nd December 2023): Launched a feature for automated report generation, allowing users to schedule and automate their report creation.

    • Related Articles

    • Visual Connect RESTful Web API (DERP) - Technical Requirements

      VISUAL ERP integration with DERP Compatability Visual 9.x.x - Visual 11 Server Requirements Windows Server 2019 4 cores 8gb of ram Recommend 4gb of free disk space (install files + logs) Prerequisites .Net Framework 4.8 Installation of Default IIS ...

    • Expensify - Release Notes

      v1000.1300 Strip alpha characters out of Report ID (to keep the data mapping the same) v1000.1200 Use the NumericField to store the Report ID value Change display to be Numeric for that column (not string so it doesn't turn it into an expnonential ...

    • Launchpad - Release Notes

      v1110.1000 (7/23/2026) Upgrade to support visual erp v1110 release Upgrade all 3rd party support libraries (nuget) to current release. LaunchPadSchedule Upgrade OAUTH support when sending email Was based on Micrsoft.Graph library (now obsolete), is ...

    • Order Import Tool - Release Notes

      v1110.1000 (6/18/2026) Supports VISUAL ERP 11.1 Resolves several reported issues (dividing price by quantity error; incorrect behavior when "Purge All Lines Before" checkbox selected) Modified the grid color coding scheme; blue represents Ignored ...

    • WM-Synergy SBO - Release Notes

      Unless otherwise noted all Versions should work with a prior release of Visual ERP. The .net framework version will be discontinued. Please begin your transition over to the .net standard version of sbo objects or, begin using our web API Visual ...