RELEASE 4.50 – QUARTERLY UPDATE HIGHLIGHTS – Q1 2025

RELEASE 4.50 – QUARTERLY UPDATE HIGHLIGHTS

VICINITY 4.50 AVAILABLE

Added Audit Fields to Additional Cost Tables

MRP Regeneration Enhancement

Data Warehouse Service Enhancement for BC Cloud Integrations

Integrations/Add-ons:

Formpak

Good Face Project

Added Audit Fields to Additional Cost Tables

Audit fields were added to the Labor and AdditionalCostRange tables in the Company database. New fields include:

-CreationUser
-CreationDateTime
-LastModifiedUser
-LasModifiedDateTime

Note, these fields are not visible via the UI; however, they are available for reporting. The stock VicinityView, Product Development > Additional Costs, has been updated to include those fields.

Learn more here.

MRP Regeneration Enhancement – Database Level Business Rules Supported

Business rules can now be defined for the MRP regeneration process. Business rules are defined via database stored procedures that are run after MRP regeneration has been completed. With this release, the stored procedure AfterSuccessful_MRPRegen is created. This stored procedure can be customized to run a script or to call other stored procedures. An example of a business rule would be to write the MRP regeneration results to a historical table.

Watch this video here.

Data Warehouse Service Enhancements for BC Cloud Integrations

The Data Warehouse Service was updated to require the Company ID and Group Name to be specified as parameters, allowing control over what endpoints are run at a given time. Previously, all endpoints were run each time the service was initiated.

Check out the video.

Formpak Integration

Vicinity has enhanced the existing integration to Formpak that was released in Version 4.46. Previously, the integration could send formula and component data into Formpak. With this release, Vicinity can now download data from Formpak on a schedule, using the Windows Task Scheduler, through a standalone executable. This integration requires the creation of two tables and updates to the FormpakSync.exe.config file.

Good Face Project Integration

Vicinity now offers an integration to Good Face Project. Good Face Project is a formulation and regulatory compliance software used in the cosmetic industry. This integration is a standalone executable that allows Good Face Project to create new raw material components in Vicinity and for Vicinity to create new formulas and update changes in Good Face Project. The integration is executed with the use of scheduled jobs.