Add - Upload to IPS
Enter Inventory Mgt/Inventory Control Management/IPS Upload
User will get a prompt to find the file which they want to upload and then the system will import the data and proceed with validation and saving.
 

Locate XL File to Upload

 
The following Warning will appear:  This message is for user to verify the number of records being loaded from the import sheet.  User may depress "YES" to continue the upload or "NO" to abort the upload.
 
  
If you depress No to Abort Upload the user will be prompted the following message that the Inventory Upload was not complete
If you depress Yes to Continue the user will be prompted the following message that the Inventory Upload complete.
 
 

If the system finds any problems with template the user will be prompted the following message and exception XL file will be created in the Inv Exception XL Sub Directory on the server.

Depress OK and user will receive the message (shown above) that the "Inventory Upload was not complete" and system will abort.
 

During the upload if user has a contract already setup the following message will appear.  If user selects "Yes"  Upload will continue, if user selects "No" Upload will abort.  

During the upload if the pricing on the xl spreadsheet is different than the existing contract prices the following message will appear, giving you the option to overwrite the existing price.  If price is omitted from xl spreadsheet system will use the material price from the Inventory Control screen.  If user has contract pricing already setup for example: Up to qty of  5 = $1.00, Up to qty of  100 = $0.94, Up to qty of 101 = $0.95. When the in-store PO is created it will find the correct price break.   Also if there are multiple records for the same part, which will end up on the same PO, (like multiple serial numbers or lot codes), the qty will be combined in determining the correct price break.
During the upload if the contract number listed on the xl spreadsheet is different than the existing contract number, user will receive the following message and system will abort. 
 
Once the upload is complete the "Transaction Detail Log" report is updated for In-Store location, as displayed below:
 
 
Since these items are being received into a In-Store location there will be no affect on accounting upon receipt/import.