Prepare scripts to import stock from Dallmayr ERP on a daily basis

Issue No: LG-332
Created 12/9/2015 12:19:30 PM
Type Data Fix
Priority Major
Status Closed
Resolution Fixed
Fixed Version 17.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket. [HDTN-184824 - Consumption of inventory -Prepare scripts to import stock from Dallmayr ERP on a daily basis|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-184824]   1. Refer proposed excel format attached   2. We need to apply FIFO logic to cosume stock based on the input data and internally call Adjustment SP to reduce stock.     Need stored procedure to create adjustment programmatically using iProcess.   Example:   !pastedImage_d48692_0.png!