SQL

SQL


Run SQL File

This option allows the user to select a .SQL file from their desktop and Inventory Replenishment will run this file on the SQL server. 

Remember that the SQL template file will be sent to the User when they are first setting up the app. You will have ordered this from Support@PlusSoftSolutions.com


The file will contain SQL statements for each of the grids in the app.

After this initial install the User can change each grid SQL individually to suit their needs.

    • Related Articles

    • Requirements to run Inventory Replenishment

      Windows Installer 3.1 or later Microsoft .NET Framework 4.5.2 or later Microsoft SQL Server 2012 or later + login details Valid Inventory Replenishment license file

    • Editing the SQL Scripts/Statements

      All of the SQL scripts for the grids, enquiry screens and some source data can be edited by the user from the settings tab.  When clicking on the appropriate queries dropdown the user will see the SQL script for the grids that they can modify. Note, ...

    • Vendors that Inventory Replenishment integrates with

      Inventory Replenishment currently works with Sage 100/200 (Evolution) and with Sybiz Vision but will work with any SQL solution as the architecture has been built for such technology. The various Vendor connections still have to be developed and this ...

    • Calculating re-order within Inventory Replenishment

      Inventory replenishment can be customised to your specific inventory re-order requirements. The reason a User can customise Suggested Orders to the exact needs of the business is that the software includes SQL scripts which can be modified to take ...

    • Different ways to forecast within Inventory Replenishment

      As Inventory Replenishment can be programmed to include any SQL source data there are numerous ways to forecast, depending on the needs of the business. For example, you could connect the product data to a historical orders database. It would then be ...