Editing the SQL Scripts/Statements in Inventory Replenishment

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, to modify the scripts will require SQL expertise – please discuss with your Partner or Plus Software.


    • Related Articles

    • 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. ...

    • Initial Important Administration

      This training assumes that Inventor Replenishment has been installed and linked to the accounting system.   If you have not installed IR at this time, then download here:    https://www.plussoftsolutions.com/software-downloads/ You will also find the ...

    • 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 ...

    • 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

    • Replenishment for Jobs

      There are 5 easy steps to processing an order into your Accounting system: Modify the SQL Scripts (if needed). This SQL scripts supplied will work immediately. If the User needs to modify the calculation or logic, this will occur before generating ...