Inventory Policy: Loading Policies from Excel or SQL

Inventory Policy: Loading Policies from Excel or SQL

This article is part of the Inventory Policy series, split from the original Inventory Policy article.

Adding Inventory Policy via Excel or SQL/Enterprise

Users can Upload Inventory Policy Via Excel

NOTE: DDLT is calculated as Demand * Max(Lead Time, Replenishment Frequency).

  1. Use the Starter Template (Excel) given in upload option and fill in all the required details as per format given in template.



  1. Click on Upload Data & select the Microsoft Excel option to upload the data.


  1. We can directly upload the excel file using File Upload or give a link to select the file in Remote File Path.



  1. Once "Upload Completed" pop up, click on Continue.



Adding Inventory Policy using SQL Server or Arkieva Enterprise

  1. Users first Create & update data in tables ([ArkievaSaaSInput].[Inventory Policies], [ArkievaSaaSInput].[Stock Inventory Policy]) in the database.



  1. Next Click on Upload Data & select SQL Server or Arkieva Enterprise to upload the data.




  1. Enter Server Name & Database Name then click on Continue.





Inventory Policy series