Initial Important Administration

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 Inventory Replenishment Installation guide on this website page.


IMPORTANT NOTE AND ACTION REQUIRED: 

Inventory Replenishment comes with a range of SQL Queries or Statements. There is no need to write them from scratch. We will send them to you!

Please email Support@PlusSoftSolutions.com with the Subject Line: Send SQL Scripts.

The queries you will receive are generic queries to get you started.

From this installed batch of queries, you are able to customise the queries to suit the exact needs of the business. There will be an explanation with each of the queries and some rules to follow.

There are three types of queries:

  1. Grid View Queries. These queries drive the main replenishment system including the calculation of reorder quantity, as shown in the various Replenishment grids.

  2. Enquiry View Queries. These queries create the drill down on an item to provide more detail behind the Supply and Demand totals.


Source Queries. These queries are used in conjunction with some of the grid views. For example, the supplier lookup on the Stock Replenishment screen.


You can import the scripts sent from Plus Software by clicking on ‘Run SQL File’. 


Browse for the file once downloaded and bring into Inventory Replenishment. 

This will populate all the required scripts.



    • Related Articles

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

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

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

    • Inventory Replenishment Introduction

      If you're not on top of your Inventory re-ordering process, you might run out of valuable stock lines, severely impacting the bottom line.  If you have too much inventory, that’s tying up valuable capital. That’s another problem. The Plus Software ...

    • 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